OPR_ROWS_VW

(SQL View)
 Index Back

SELECT OPR.OPRID ,OPR.EMPLID ,OPRJOB.SETID_DEPT ,OPRJOB.DEPTID ,OPRJOB.POSITION_NBR ,OPRJOB.JOBCODE FROM PSOPRDEFN OPR , PS_JOB OPRJOB WHERE OPRJOB.EMPLID= OPR.EMPLID AND OPRJOB.EFFDT= ( SELECT MAX(OPRJOB2.EFFDT) FROM PS_JOB OPRJOB2 WHERE OPRJOB.EMPLID=OPRJOB2.EMPLID AND OPRJOB.EMPL_RCD=OPRJOB2.EMPL_RCD AND OPRJOB2.EFFDT<=%CurrentDateIn) AND OPRJOB.EFFSEQ= ( SELECT MAX(OPRJOB3.EFFSEQ) FROM PS_JOB OPRJOB3 WHERE OPRJOB.EMPLID=OPRJOB3.EMPLID AND OPRJOB.EMPL_RCD=OPRJOB3.EMPL_RCD AND OPRJOB.EFFDT=OPRJOB3.EFFDT )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
5 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code