RS_ST_WRKR_DEL

(SQL View)
 Index Back

SF Staffing Ineligible Worker

Ineligible workers to be removed from the PTSF index

SELECT A.EMPLID , CASE WHEN B.DTTM_MODIFIED > %Dttm(A.EFFDT, %TIMEIN('23.59.00.000000')) THEN B.DTTM_MODIFIED ELSE %Dttm(A.EFFDT, %TIMEIN('23.59.00.000000')) END FROM %Table(RS_WRKR_EFFDT) A LEFT OUTER JOIN PS_RS_SRCH_LOG B ON B.DOCUMENT = A.EMPLID AND B.ACTION_FLG = 'D' WHERE A.SYSTEM_SOURCE = 'STF' AND %EffdtCheck(RS_WRKR_EFFDT Z, A, %CurrentDateIn) AND A.WRKR_INELIGIBLE = 'Y' UNION SELECT A.APPLID , B.DTTM_MODIFIED FROM %Table(APPLICANT) A , PS_RS_SRCH_LOG B WHERE B.DOCUMENT = A.APPLID AND B.ACTION_FLG = 'D'

# 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.