HRBP_CUR_JOBS (SQL View)	Index Back
Current Job for Direct Reports This is a view that returns the current row for all active job records

HRBP_CUR_JOBS

(SQL View)

Current Job for Direct Reports

This is a view that returns the current row for all active job records

SELECT A.EMPLID , A.EMPL_RCD , A.EFFDT , A.EFFSEQ FROM PS_JOB A WHERE 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) AND HR_STATUS = 'A'

Parent record: PER_ORG_ASGN

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
Prompt Table: PERSON

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

3 EFFDT Date(10) DATE NOT NULL Effective Date

4 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date
4	EFFSEQ	Number(3,0)	SMALLINT NOT NULL	Effective Sequence