UX_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 Manager Dashboard DirectReports employee record dropdown

SELECT A.EMPLid , A.EMPL_RCD , B.DESCR , A.JOB_INDICATOR 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: UX_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 Select Your Job
    3 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
    4 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