GPES_ADLNJOB_VW

(SQL View)
 Index Back

Adv/Loan Job data status

This view returns the employees job rows along with the status

SELECT J.EMPLID ,J.EMPL_RCD ,J.EFFDT ,J.HR_STATUS FROM PS_JOB J WHERE J.EFFSEQ = ( SELECT MAX (EFFSEQ) FROM PS_JOB WHERE EMPLID = J.EMPLID AND EMPL_RCD = J.EMPL_RCD AND EFFDT = J.EFFDT)

# 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 Rcd Nbr
3 EFFDT_NEW Date(10) DATE New Effective Date
4 HR_STATUS Character(1) VARCHAR2(1) NOT NULL HR Status
A=Active
I=Inactive