TL_GROUP_TBL

(SQL Table)
 Index Back

Time Employees Group Table

This record defines the criteria used to define a group, whether it is a Static group (a fixed set of employees) or a Dynamic group (a selection of employees based on criteria at the time of use). Dynamic groups can only be used in Batch processing within Time & Labor.

  • Related Language Record: TL_GROUP_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TL_GROUP_ID Character(7) VARCHAR2(7) NOT NULL Time and Labor Groups
    2 GROUP_TYPE_IND Character(1) VARCHAR2(1) NOT NULL Type of Group: Static or Dynamic
    D=Dynamic
    S=Static
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_GROUP_TBL.DESCR

    5 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup

    Prompt Table: TL_TASKGRP_TBL

    6 TL_APPR_GRP_IND Character(1) VARCHAR2(1) NOT NULL T&L approval group indicator

    Y/N Table Edit

    Default Value: N

    7 LAST_REFRESH_DTTM DateTime(26) TIMESTAMP Last group refresh datetime: this is only applicable to dynamic groups
    8 ASOFDATE Date(10) DATE As of Date
    9 GROUP_SEL_1 Character(5) VARCHAR2(5) NOT NULL First choice of group for group addition/subtraction

    Prompt Table: TL_GROUP_S_VW

    10 GROUP_SEL_2 Character(5) VARCHAR2(5) NOT NULL Second choice of group for group addition/subtractionq

    Prompt Table: TL_GROUP_S_VW

    11 GRP_CONCAT_1 Character(1) VARCHAR2(1) NOT NULL Indication whether you want to add two groups together or subtract on group from another.
    M=Minus
    P=Plus
    12 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
    13 GRP_WHERE_CLS Long Character(4096) CLOB Where Clause for Groups