PC_EMPLJOB_LVW

(SQL View)
 Index Back

Employees and current job

Language view for all employees and their current job

SELECT A.EMPLID , A.JOBCODE , B.LANGUAGE_CD , B.DESCR FROM PS_JOB A , PS_JOBCODE_LANG B WHERE (A.EFFDT IS NULL OR A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_JOB A_ED WHERE A.EMPLID = A_ED.EMPLID AND A.EMPL_RCD = A_ED.EMPL_RCD AND A_ED.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A_ES.EFFSEQ) FROM PS_JOB A_ES WHERE A.EMPLID = A_ES.EMPLID AND A.EMPL_RCD = A_ES.EMPL_RCD AND A.EFFDT = A_ES.EFFDT) AND B.JOBCODE = A.JOBCODE AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_JOBCODE_LANG B_ED WHERE B.SETID = B_ED.SETID AND B.JOBCODE = B_ED.JOBCODE AND B_ED.EFFDT <= %CurrentDateIn))

  • Related Language Record for PC_EMPLJOB_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description