RS_WRKR_ELGBL_V (SQL View)	Index Back
Wrkr Elgbl View This is a view to get the EMPLID of all resource whose status in not in ('I','D','S','T','U','V').

RS_WRKR_ELGBL_V

(SQL View)

Wrkr Elgbl View

This is a view to get the EMPLID of all resource whose status in not in ('I','D','S','T','U','V').

SELECT A.EMPLID FROM %Table(JOB) A , %Table(RS_WRKR_EFFDT) B , %Table(PERSONAL_DATA) C WHERE A.EMPLID = B.EMPLID AND B.SYSTEM_SOURCE = 'RS' AND B.EMPLID = C.EMPLID AND B.EFFDT = ( SELECT MAX(D.EFFDT) FROM %Table(RS_WRKR_EFFDT) D WHERE D.EMPLID = B.EMPLID AND D.SYSTEM_SOURCE = B.SYSTEM_SOURCE) AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = ( SELECT MAX(E.EFFDT) FROM %Table(JOB) E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = A.EMPL_RCD AND E.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(F.EFFSEQ) FROM %Table(JOB) F WHERE F.EMPLID = A.EMPLID AND F.EMPL_RCD = A.EMPL_RCD AND F.EFFDT = A.EFFDT) AND A.EMPL_STATUS NOT IN ('I','T','S','D','U','V','Q','R','X')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID