SPA_OT_TRC_LVW

(SQL View)
 Index Back

SPA TRC Codes for Overtime


SELECT A.TRC ,B.LANGUAGE_CD ,B.DESCR FROM PS_TL_TRC_TBL A ,PS_TL_TRC_LANG B WHERE A.TRC_TYPE = 'H' AND %EffdtCheck(TL_TRC_TBL B, A, %CurrentDateIn) AND A.EFF_STATUS = 'A' AND A.TRC = B.TRC

  • Related Language Record for SPA_OT_TRC_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description