SPB_OTTRC_LG_VW

(SQL View)
 Index Back

SPA TRC Codes for Overtime


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

  • Related Language Record for SPB_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