EX_TRC_MAP_VW1

(SQL View)
 Index Back

TRC Map Table

This table maps Time Reporting Codes to user definable positions on the Time Sheet for items such as Vacation, Sick Leave, etc...This gives the Time Sheet a much more customizable User Interface, especially for the Traveler Professional.

SELECT SETID , GRID_ROW_NUM , TRC , DESCR , BUS_HOL_FLG , FUTURE_ENTRY_FLG FROM PS_EX_TRC_MAP_TBL WHERE EXISTS ( SELECT 'X' FROM %Table(TL_TRC_TBL) WHERE TRC=PS_EX_TRC_MAP_TBL.TRC)

  • Related Language Record: EX_TRC_MAP_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 GRID_ROW_NUM Number(3,0) SMALLINT NOT NULL Grid Row Number

    Default Value: 1

    3 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code

    Prompt Table: TL_TRC_TBL

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 BUS_HOL_FLG Character(1) VARCHAR2(1) NOT NULL This field defines the TRC code that is the default business holiday code.
    N=No
    Y=Yes

    Default Value: N

    6 FUTURE_ENTRY_FLG Character(1) VARCHAR2(1) NOT NULL Disable Future Entry

    Y/N Table Edit