TL_COMPTRC_VW

(SQL View)
Index Back

Valid TRC's for Comp Ern/Tkn

This is a view of TL_TRC_TBL with only TRC_TYPE= Hours and with COMP_LEAVE_IND = Comp Earned or Comp Taken

SELECT V.TRC ,V.EFFDT ,V.DESCR ,V.DESCRSHORT ,V.TRC_TYPE ,V.COMP_LEAV_IND FROM PS_TL_TRC_TBL V WHERE V.EFF_STATUS='A' AND V.TRC_TYPE='H' AND (V.COMP_LEAV_IND='CERN' OR V.COMP_LEAV_IND='CTKN')

  • Related Language Record: TL_TRC_VW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
    2 EFFDT Date(10) DATE NOT NULL Effective Date
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
    A=Amount
    H=Hours
    U=Units
    6 COMP_LEAV_IND Character(4) VARCHAR2(4) NOT NULL Comp Leave Indiactor indicates whether a TRC has any effect on Leave and Compensatory time Off
    CERN=Comp Time Earned
    CTKN=Comp Time Taken
    LTKN=Leave Taken
    NO=No Comp Time Effect
    RULE=Avoid Replacing by Rules