TL_TR_TRC_VW

(SQL View)
Index Back

TRC Prompt View

This record is used as a dynamic prompt view for the elapsed time processes.

SELECT DISTINCT AA.EMPLID ,AA.EMPL_RCD ,A.WORKGROUP ,A.EFFDT ,D.TRC ,B.TRC_PROGRAM ,A.COMP_TIME_PLAN ,D.DESCR ,D.COMP_LEAV_IND ,D.TRC_TYPE FROM PS_TL_EMPL_DATA AA ,PS_TL_WRKGRP_TBL A ,PS_TL_TRC_PGM_TBL B ,PS_TL_TRCPGELE_TBL C ,PS_TL_TRC_TBL D WHERE AA.TIME_RPTG_STATUS = 'A' AND AA.WORKGROUP = A.WORKGROUP AND A.TRC_PROGRAM = B.TRC_PROGRAM AND A.TRC_PROGRAM = C.TRC_PROGRAM AND C.TRC = D.TRC AND B.EFFDT=C.EFFDT AND (D.COMP_LEAV_IND IN ('NO','LTKN') OR D.COMP_LEAV_IND IN ('CERN','CTKN') AND ( EXISTS ( SELECT 'X' FROM PS_TL_EMPL_COMP S2 , PS_TL_COMP_TRC S3 WHERE S2.EMPLID = AA.EMPLID AND S2.EMPL_RCD = AA.EMPL_RCD AND S2.EFF_STATUS = 'A' AND S3.COMP_TIME_PLAN = S2.COMP_TIME_PLAN AND S3.EFF_STATUS = 'A' AND S3.TRC = C.TRC) OR A.COMP_TIME_PLAN <> ' ' AND EXISTS ( SELECT 'X' FROM PS_TL_COMP_TRC S4 WHERE S4.COMP_TIME_PLAN =A.COMP_TIME_PLAN AND S4.EFF_STATUS = 'A' AND S4.TRC = C.TRC) )) AND A.EFF_STATUS = 'A' AND D.EFF_STATUS = 'A'

  • Related Language Record: TL_TR_TRCVW_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    3 WORKGROUP Character(10) VARCHAR2(10) NOT NULL Workgroup
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 TRC Character(5) VARCHAR2(5) NOT NULL Time Reporting Code used to report time in Time and Labor
    6 TRC_PROGRAM Character(5) VARCHAR2(5) NOT NULL TRC Program ID
    7 COMP_TIME_PLAN Character(10) VARCHAR2(10) NOT NULL Compensatory Time Off Plan
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    9 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
    10 TRC_TYPE Character(1) VARCHAR2(1) NOT NULL This defines TRC Type of Hours,Amounts ,Units
    A=Amount
    H=Hours
    U=Units