HR_DR_USER_MJ

(SQL View)
 Index Back

User Multiple Jobs

This view returns all currently active jobs held for an employee. This is used in the DirectReports UI framework.

SELECT A.EMPLid , A.EMPL_RCD , B.DESCR FROM PS_JOB A , PS_JOBCODE_TBL_VW B WHERE A.SETID_JOBCODE = B.SETID AND A.JOBCODE = B.JOBCODE AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_JOB A1 WHERE A1.EMPLID = A.EMPLID AND A1.EMPL_RCD = A.EMPL_RCD AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_JOB A2 WHERE A2.EMPLID = A.EMPLID AND A2.EMPL_RCD = A.EMPL_RCD AND A2.EFFDT = A.EFFDT) AND A.HR_STATUS = 'A'

  • Related Language Record: HR_DR_MJ_JC_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    3 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description