SUCCESS_RANK1

(SQL View)
 Index Back

Succession-First-Ranked Cands

SUCCESS_RANK1 is a view which selects the first-ranked candidate for each key position for each Succession Plan. This view is used to display the slate of candidates below each successor in the Succession Slate panel. The readiness of each top candidate is also used to determine if they are blocking the candidate below them in the slate.

SELECT B.POSITION_NBR ,A.HR_SUCC_PLAN_ID ,A.HR_SUCC_PLAN_TYPE ,A.EFFDT ,A.EMPLID ,A.EMPL_RCD ,A.HR_SP_READINESS ,A.TARGETED_READY_DT ,A.BLOCKED FROM PS_HR_SUCC_PLN_DTL A , PS_POSITION_DATA B WHERE A.RANK = 1 AND A.HR_SUCC_PLAN_CTL = B.POSITION_NBR AND B.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_POSITION_DATA C WHERE B.POSITION_NBR = C.POSITION_NBR AND C.EFFDT <= A.EFFDT)

  • Parent record: SUCC_PLAN_POSN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    2 HR_SUCC_PLAN_ID Character(11) VARCHAR2(11) NOT NULL Succession Plan ID
    3 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
    1=Job Code
    2=Person
    3=Position
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    7 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
    8 TARGETED_READY_DT Date(10) DATE Targeted Ready Date
    9 BLOCKED Character(1) VARCHAR2(1) NOT NULL Blockage for Succession Planning