ADP_JOBCD_VW

(SQL View)
Index Back

ADP Jobcode View

This view is used by ADP Connection via ODBC to facilitate the mapping of jobcodes

SELECT A.JOBCODE , A.SETID , A.DESCR , A.DESCRSHORT FROM PS_JOBCODE_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_JOBCODE_TBL B WHERE B.EFFDT <= %CurrentDateIn AND A.JOBCODE = B.JOBCODE AND A.SETID = B.SETID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
2 SETID Character(5) VARCHAR2(5) NOT NULL SetID
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description