PA_PRIMDTL_VW

(SQL View)

SELECT A.EMPLID , A.EFFDT , B.EMPL_RCD FROM PS_JOB A , PS_JOB B WHERE A.EMPLID = B.EMPLID AND B.EMPL_RCD = ( SELECT MIN(C.EMPL_RCD) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EFFDT <= A.EFFDT AND C.EMPL_STATUS IN ('A','L','P','S','W') AND NOT EXISTS ( SELECT 'X' FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = C.EMPL_RCD AND D.EFFDT > C.EFFDT AND D.EFFDT <= A.EFFDT AND D.EMPL_STATUS NOT IN ('A','L','P','S','W'))) AND B.EFFDT = ( SELECT MAX(E.EFFDT) FROM PS_JOB E WHERE E.EMPLID = A.EMPLID AND E.EMPL_RCD = B.EMPL_RCD AND E.EFFDT <= A.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record