PC_JOBCD_EMP_LG

(SQL View)
 Index Back

View of Employees by Jobcode

Language record view of Employees by Jobcode

SELECT SCR.SETID , J.JOBCODE , JCT.LANGUAGE_CD , JCT.DESCR , J.EMPLID , J.EMPL_RCD , PD.NAME FROM PS_JOB J , PS_JOBCODE_LANG JCT , PS_PERSONAL_DATA PD , PS_SET_CNTRL_REC SCR WHERE J.BUSINESS_UNIT = SCR.SETCNTRLVALUE AND SCR.RECNAME = 'JOBCODE_TBL' AND JCT.SETID = SCR.SETID AND JCT.JOBCODE = J.JOBCODE AND JCT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOBCODE_TBL JCT2 WHERE JCT.SETID = JCT2.SETID AND JCT.JOBCODE = JCT2.JOBCODE AND JCT2.EFF_STATUS = 'A' AND JCT2.EFFDT <= %CurrentDateIn ) AND J.EFFDT = ( SELECT MAX(EFFDT) FROM PS_JOB J2 WHERE J.EMPLID = J2.EMPLID AND J.EMPL_RCD = J2.EMPL_RCD AND J2.EFFDT <= %CurrentDateIn ) AND J.EFFSEQ = ( SELECT MAX(EFFSEQ) FROM PS_JOB J3 WHERE J.EMPLID = J3.EMPLID AND J.EMPL_RCD = J3.EMPL_RCD AND J.EFFDT <= J3.EFFDT ) AND J.EMPLID = PD.EMPLID AND J.EMPL_STATUS = 'A'

  • Related Language Record for PC_JOBCD_EMP_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    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
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name