SPB_OT_TRC_VW

(SQL View)
 Index Back

SPA TRC Codes for Overtime


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

  • Related Language Record: SPB_OTTRC_LG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 FACTOR_MULT Signed Number(11,4) DECIMAL(9,4) NOT NULL Multiplication Factor