TL_MASS_TRC_VW

(SQL View)
Index Back

TRC View for all TRCs used

Joins Workgroup and TRC Programs

SELECT DISTINCT B.TRC , C.DESCR , C.DESCRSHORT FROM PS_TL_WRKGRP_TBL A , PS_TL_TRCPGELE_TBL B ,PS_TL_TRC_TBL C WHERE A.TRC_PROGRAM = B.TRC_PROGRAM AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_TL_WRKGRP_TBL A2 WHERE A2.WORKGROUP = A.WORKGROUP AND A2.EFFDT <= %CurrentDateIn) AND A.EFF_STATUS = 'A' AND B.EFFDT = ( SELECT MAX(B2.EFFDT) FROM PS_TL_TRCPGELE_TBL B2 WHERE B2.TRC_PROGRAM = B.TRC_PROGRAM AND B2.EFFDT <= %CurrentDateIn) AND B.TRC = C.TRC AND C.EFFDT = ( SELECT MAX(C2.EFFDT) FROM PS_TL_TRC_TBL C2 WHERE C2.TRC = B.TRC AND C2.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND C.GP_ABSENCE_FLG <> 'Y' AND C.TRC_FILTER = 'N'

  • Related Language Record: TL_MASS_TRC_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description