PA_TERMDT_VW

(SQL View)
 Index Back

Termination Date view


SELECT EMPLID, EFFDT FROM PS_JOB A WHERE EMPL_STATUS = 'T' AND EFFDT = (SELECT MAX(EFFDT) FROM PS_JOB B WHERE A.EMPLID = B.EMPLID AND B.EMPL_STATUS = 'T')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACTION_DT Date(10) DATE Action Date