RS_XS_WRKR_DEL

(SQL View)
 Index Back

PTSF RM Ineligible Worker

Query view to delete inactive workers from the index. Ineligible workers are retained in the index and only their availability score is affected.

SELECT A.EMPLID , %Dttm(A.EFFDT, %TIMEIN('23.59.00.000000')) FROM %Table(JOB) A , %Table(RS_WRKR_EFFDT) B WHERE A.EMPLID = B.EMPLID AND B.SYSTEM_SOURCE = 'RS' 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 %EffdtCheck(JOB E, A, %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 IN ('I','T','S','D','U','V')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.