GPNZ_EE_JOB_VW

(SQL View)
 Index Back

GPNZ - Dept Setid

This view is used to retrieve the deparment setid for the employee

SELECT A.EMPLID ,A.EMPL_RCD ,A.SETID_DEPT FROM PS_JOB A WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT)

# 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 SETID Character(5) VARCHAR2(5) NOT NULL SetID