Resources with inactive Supervisor

RS_WC_EMP_EXP1

(SQL View)
 Index Back

SELECT J.EMPLID ,J.EMPL_RCD ,J.EFFDT ,J.EFFSEQ ,J.BUSINESS_UNIT ,J.DEPTID ,W.REGION_CD ,J.SUPERVISOR_ID FROM PS_JOB J , PS_JOB B , PS_RS_WORKER_TBL W WHERE J.SUPERVISOR_ID = B.EMPLID AND J.EMPLID = W.EMPLID AND J.EFFDT = ( SELECT MAX(J1.EFFDT) FROM PS_JOB J1 WHERE J.EMPLID = J1.EMPLID AND J.EMPL_RCD = J1.EMPL_RCD AND J1.EFFDT <= %CurrentDateIn) AND J.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J.EMPLID = J2.EMPLID AND J.EMPL_RCD = J2.EMPL_RCD AND J.EFFDT = J2.EFFDT) AND J.EMPL_STATUS IN ('A','L','P','W') AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_JOB B1 WHERE B.EMPLID = B1.EMPLID AND B.EMPL_RCD = B1.EMPL_RCD AND B1.EFFDT <= %CurrentDateIn) AND B.EFFSEQ = ( SELECT MAX(B2.EFFSEQ) FROM PS_JOB B2 WHERE B.EMPLID = B2.EMPLID AND B.EMPL_RCD = B2.EMPL_RCD AND B.EFFDT = B2.EFFDT) AND B.EMPL_STATUS IN ('I', 'T', 'D', 'U', 'V', 'R', 'Q', 'X')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT_MAX Date(10) DATE 03/30/99 laj...CN#EN800-1.0 This field was "cloned" for BOM mass maintenance. Any field attribute changes here need also to be to done to en_new_effdt_from.
4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
7 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
8 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID