HR_VT_SPLNG_VW

(SQL View)
 Index Back

SP360 Succ Plan Srch Lang View

HR_SUCC_PLN_HDR is the header record which contains the effective date of the Succession Plan for this position. This view retrieves official and succession paln drafts for the dashboard

SELECT SP.HR_SUCC_PLAN_ID , SP.HR_SUCC_PLAN_TYPE , SP.HR_SUCC_PLAN_CTL , SP.EFFDT , L.LANGUAGE_CD , L.DESCR , SP.DESCR FROM PS_HR_SUCC_PLN_HDR SP , PS_HR_SUCC_PLN_LNG L WHERE SP.HR_SUCC_PLAN_STS IN ('D','O') AND SP.HR_SUCC_PLAN_ID = L.HR_SUCC_PLAN_ID AND SP.HR_SUCC_PLAN_TYPE = L.HR_SUCC_PLAN_TYPE AND SP.HR_SUCC_PLAN_CTL = L.HR_SUCC_PLAN_CTL AND L.EFFDT = ( SELECT MAX(C.EFFDT) FROM PS_HR_SUCC_PLN_LNG C WHERE C.HR_SUCC_PLAN_ID = L.HR_SUCC_PLAN_ID AND C.HR_SUCC_PLAN_TYPE = L.HR_SUCC_PLAN_TYPE AND C.HR_SUCC_PLAN_CTL = L.HR_SUCC_PLAN_CTL AND C.LANGUAGE_CD = L.LANGUAGE_CD AND C.EFFDT <= SP.EFFDT)

  • Related Language Record: HR_SP_DESCR_LNG

    • # 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: NEW

    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR30 Character(30) VARCHAR2(30) NOT NULL Description