UPG_TL_TRC_VW

(SQL View)
 Index Back

TL TRC View

Time and Labor Upgrade to 8.0 TRC View

SELECT DISTINCT A.TRC , A.DESCR FROM PS_TL_TRC_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_TL_TRC_TBL B WHERE B.TRC = A.TRC AND B.EFFDT <= %CurrentDateIn ) AND A.EFF_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 UPG_TRC Character(5) VARCHAR2(5) NOT NULL Time and Labor Upgrade to 8.0 Time Reporting Code
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description