TL_EMPL_RCD1_VW (SQL View)	Index Back
TL Distinct Empl ID and Rcd This view will give Emplid and Empl Rcd

TL_EMPL_RCD1_VW

(SQL View)

TL Distinct Empl ID and Rcd

This view will give Emplid and Empl Rcd

SELECT DISTINCT A.EMPL_RCD FROM PS_JOB A WHERE A.EFFDT = ( SELECT MAX(J.EFFDT) FROM PS_JOB J WHERE A.EMPLID = J.EMPLID AND J.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(J2.EFFSEQ) FROM PS_JOB J2 WHERE J2.EMPLID = A.EMPLID AND J2.EMPL_RCD = A.EMPL_RCD AND J2.EFFDT = A.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr