HR_I9_HIRDT_VW (SQL View)	Index Back
Current Primary Job VW Current Primary Job view of employees for Career Planning Self Service

HR_I9_HIRDT_VW

(SQL View)

Current Primary Job VW

Current Primary Job view of employees for Career Planning Self Service

SELECT A.EMPLID , A.EFFDT , A.ACTION , A.ACTION_REASON FROM PS_JOB A WHERE A.JOB_INDICATOR = 'P' AND A.HR_STATUS = 'A' AND A.ACTION IN('HIR','REH') AND A.EFFDT = ( SELECT MAX (C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.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 NOT NULL Effective Date
Default Value: %date

3 ACTION Character(3) VARCHAR2(3) NOT NULL Action
Prompt Table: ACTION_TBL

4 ACTION_REASON Character(3) VARCHAR2(3) NOT NULL Reason Code

#	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 NOT NULL	Effective Date Default Value: %date
3	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
4	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code