HR_SPDTL_NPC_VW

(SQL View)
 Index Back

SP Candidates, No Pcode View

Selects from HR_SUCC_PLN_DTL

SELECT HR_SUCC_PLAN_ID , HR_SUCC_PLAN_TYPE , HR_SUCC_PLAN_CTL , EFFDT , EMPLID , EMPL_RCD , STATUS , HR_SP_CAND_TYPE , RANK , HR_SP_READINESS , TARGETED_READY_DT , BLOCKED , HR_SP_IMP_OF_LOSS FROM PS_HR_SUCC_PLN_DTL

  • 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
    2 HR_SUCC_PLAN_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Type
    1=Job Code
    2=Person
    3=Position
    3 HR_SUCC_PLAN_CTL Character(11) VARCHAR2(11) NOT NULL Succession Plan Control Value

    Prompt Table: %EDITTABLE

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Prompt Table: HR_SP_DRPT_VW

    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
    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