FO_ACT_EMPL_VW

(SQL View)
 Index Back

Agreement Item Employees


SELECT A.EMPLID ,A.NAME ,A.LAST_NAME_SRCH ,A.PER_STATUS FROM PS_PERSONAL_DATA A , PS_JOB B WHERE A.EMPLID = B.EMPLID AND B.EMPL_RCD = 0 AND B.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB B2 WHERE B.EMPLID = B2.EMPLID AND B.EMPL_RCD = B2.EMPL_RCD AND B2.EFFDT <= %CurrentDateIn ) AND B.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB B3 WHERE B.EMPLID = B3.EMPLID AND B.EMPL_RCD = B3.EMPL_RCD AND B.EFFDT = B3.EFFDT ) AND B.EMPL_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
4 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee