TRN_DEF_JOB_VW

(SQL View)
 Index Back

Employee job information

Administer Training view providing employee job information.

SELECT A.EMPLID , A.BUSINESS_UNIT , A.DEPTID FROM PS_JOB A WHERE A.EMPL_RCD = ( SELECT MAX(EMPL_RCD) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EFFDT <= %CurrentDateIn AND EMPL_STATUS IN ('A','L','P','S','W')) AND A.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT <= %CurrentDateIn AND EMPL_STATUS IN ('A','L','P','S','W')) AND A.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB WHERE EMPLID = A.EMPLID AND EMPL_RCD = A.EMPL_RCD AND EFFDT = A.EFFDT) AND EMPL_STATUS IN ('A','L','P','S','W')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department