HR_JOBCD_INCUMB

(SQL View)
 Index Back

Job Code Incumbents

Job Code Incumbents - Used for Succession Planning.

SELECT A.SETID_JOBCODE , A.JOBCODE , A.EMPLID , A.EMPL_RCD , B.NAME , A.COMPANY , A.BUSINESS_UNIT , A.DEPTID FROM PS_JOB A , PS_PERSON_NAME B WHERE A.EMPLID = B.EMPLID AND A.HR_STATUS = 'A' AND A.JOB_INDICATOR = 'P' AND A.JOBCODE <> ' ' AND A.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_JOB C WHERE C.EMPLID = A.EMPLID AND C.EMPL_RCD = A.EMPL_RCD AND C.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(D.EFFSEQ) FROM PS_JOB D WHERE D.EMPLID = A.EMPLID AND D.EMPL_RCD = A.EMPL_RCD AND D.EFFDT = A.EFFDT) AND A.EMPL_RCD = ( SELECT MIN(E.EMPL_RCD) FROM PS_JOB E WHERE E.EMPLID = A.EMPLID)

  • Related Language Record: HR_JOBCD_INC_L

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: DERIVED_HR_SUCC.SETID

    2 HR_SUCC_PLAN_CTL Character(11) VARCHAR2(11) NOT NULL Succession Plan Control Value

    Default Value: DERIVED_HR_SUCC.HR_SUCC_PLAN_CTL

    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 NAME Character(50) VARCHAR2(50) NOT NULL Name
    6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    7 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    8 DEPTID Character(10) VARCHAR2(10) NOT NULL Department