TL_TASKGRP_TBL

(SQL Table)
 Index Back

Time & Labor Taskgroup Table

This record is used to define common task reporting attributes, which are shared by the time reporters assigned to the task group. These attributes control what items of information time reporters are eligible to report and/or required to report.

  • Related Language Record: TL_TASKGRP_LNG

  • Parent Record Of TL_TASKGRP_PRFL TL_TSKGRP_PRF_V TL_TSKGRP_PRF_W TL_TSK_PRF_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TASKGROUP Character(10) VARCHAR2(10) NOT NULL Taskgroup
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: TL_TASKGRP_TBL.DESCR

    6 TASK_PRFL_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Task Template ID

    Prompt Table: %RECNAME_EDIT

    7 TASK_PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Task Profile ID

    Prompt Table: TL_TASKGRP_PRFL

    8 ELP_TR_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Elapsed Reporting Template

    Prompt Table: TL_ELP_TMPLT_VW

    9 PCH_TR_TMPLT_ID Character(10) VARCHAR2(10) NOT NULL Punch Reporting Template

    Prompt Table: TL_PCH_TMPLT_VW

    10 COMMIT_ACCTG_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Accounting

    Y/N Table Edit

    Default Value: N