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 GROUP_ID Character(5) VARCHAR2(5) NOT NULL Group ID
    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 LAST_REFRESH_DTTM DateTime(26) TIMESTAMP Last group refresh datetime: this is only applicable to dynamic groups
    7 ASOFDATE Date(10) DATE As of Date
    8 GROUP_SEL_1 Character(5) VARCHAR2(5) NOT NULL First choice of group for group addition/subtraction

    Prompt Table: TL_GROUP_S_VW

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

    Prompt Table: TL_GROUP_S_VW

    10 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
    11 TL_COMMENTS Character(254) VARCHAR2(254) NOT NULL Comments
    12 GRP_WHERE_CLS Long Character(4096) CLOB Where Clause for Groups