HR_EC_JOB_VW (SQL View)	Index Back
Current Primary Job VW Current Primary Job view for eCompensation Manager Self Service.

HR_EC_JOB_VW

(SQL View)

Current Primary Job VW

Current Primary Job view for eCompensation Manager Self Service.

SELECT JB.EMPLID , JB.JOB_INDICATOR , JB.HR_STATUS , JB.EMPL_RCD FROM PS_JOB JB WHERE JB.JOB_INDICATOR = 'P' AND JB.HR_STATUS = 'A' AND JB.EFFDT = ( SELECT MAX (ED.EFFDT) FROM PS_JOB ED WHERE ED.EMPLID = JB.EMPLID AND ED.EMPL_RCD = JB.EMPL_RCD AND ED.EFFDT <= %CurrentDateIn) AND JB.EFFSEQ = ( SELECT MAX(ES.EFFSEQ) FROM PS_JOB ES WHERE ES.EMPLID = JB.EMPLID AND ES.EMPL_RCD = JB.EMPL_RCD AND ES.EFFDT = JB.EFFDT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 JOB_INDICATOR Character(1) VARCHAR2(1) NOT NULL This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned.
N=Not Applicable
P=Primary Job
S=Secondary Job

3 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive

4 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	JOB_INDICATOR	Character(1)	VARCHAR2(1) NOT NULL	This Indicator is used on JOB to specify which employment record is considered to be the primary one for an employee. In case of Multiple Jobs per Employee, this property is being used to make a conscious decision in related features where only 1 Employment Record per Employee needs to be returned. N=Not Applicable P=Primary Job S=Secondary Job
3	HR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	HR Status A=Active I=Inactive
4	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record