FO_ELIG_ADD_VW (SQL View)	Index Back
Job Eligibility Add view The eff date in RS_WRKR_EFFDT is not really necessary since we will always have one row per employee. I'm selecting the MIN effdt just in case there is an inconsistency. I'm not using the regular eff date logic since any future date will still be valid

FO_ELIG_ADD_VW

(SQL View)

Job Eligibility Add view

The eff date in RS_WRKR_EFFDT is not really necessary since we will always have one row per employee. I'm selecting the MIN effdt just in case there is an inconsistency. I'm not using the regular eff date logic since any future date will still be valid

SELECT W.EMPLID FROM PS_RS_WRKR_EFFDT W WHERE W.SYSTEM_SOURCE = 'STF' AND W.EFFDT=( SELECT MIN(EFFDT) FROM PS_RS_WRKR_EFFDT B WHERE B.EMPLID=W.EMPLID AND B.SYSTEM_SOURCE=W.SYSTEM_SOURCE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSONAL_DATA