HR_SUCC_RANK_VW

(SQL View)
 Index Back

Succession Plan Candidates

SUCCESSION_PLAN contains the list of employees or external candidates who are likely successors for a position. It also captures their readiness and whether or not they are blocked by the current incumbent. This is the main record in the Succession Planning application.

SELECT A.HR_SUCC_PLAN_ID , A.HR_SUCC_PLAN_TYPE , A.HR_SUCC_PLAN_CTL , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.STATUS , A.HR_SP_CAND_TYPE , A.RANK , A.HR_SP_READINESS , A.TARGETED_READY_DT , A.BLOCKED , A.HR_SP_IMP_OF_LOSS FROM PS_HR_SUCC_PLN_DTL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_HR_SUCC_PLN_DTL B WHERE A.HR_SUCC_PLAN_ID = B.HR_SUCC_PLAN_ID AND A.HR_SUCC_PLAN_TYPE = B.HR_SUCC_PLAN_TYPE AND A.HR_SUCC_PLAN_CTL = B.HR_SUCC_PLAN_CTL AND B.EFFDT <= %CurrentDateIn) AND A.STATUS = 'A' AND A.RANK <> 0

  • Parent record: HR_SUCC_PLN_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_SUCC_PLAN_ID Character(11) VARCHAR2(11) NOT NULL Succession Plan ID

    Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_ID

    2 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
    1=Job Code
    2=Person
    3=Position

    Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_TYPE

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

    Default Value: HR_SUCC_PLN_HDR.HR_SUCC_PLAN_CTL

    Prompt Table: %EDITTABLE

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: HR_SUCC_PLN_HDR.EFFDT

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

    Prompt Table: %EDITTABLE3

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    7 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    8 HR_SP_CAND_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Candidate Type
    A=Applicant
    P=Person

    Default Value: P

    9 RANK Number(3,0) SMALLINT NOT NULL Rank
    10 HR_SP_READINESS Character(1) VARCHAR2(1) NOT NULL Displays Readiness of a Succession Plan Candidate.
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    11 TARGETED_READY_DT Date(10) DATE Targeted Ready Date

    Default Value: READINESS_VW.TARGETED_READY_DT

    12 BLOCKED Character(1) VARCHAR2(1) NOT NULL Blockage for Succession Planning

    Y/N Table Edit

    13 HR_SP_IMP_OF_LOSS Character(1) VARCHAR2(1) NOT NULL Impact of Loss: indicates the impact to an organization if an employee terminates. Used on Succession Planning and Talent Pool
    1=High
    2=Medium
    3=Low