HR_SP_SRCH_LNG

(SQL View)
 Index Back

Succession Plan Search

Succession Planning Search record used to access the main SP components.

SELECT SP.HR_SUCC_PLAN_ID ,SP.HR_SUCC_PLAN_TYPE ,SP.HR_SUCC_PLAN_CTL ,SP.EFFDT ,SP.LANGUAGE_CD ,SP.DESCR ,SP.DESCRLONG FROM PS_HR_SUCC_PLN_LNG SP WHERE (SP.EFFDT = ( SELECT MAX(SP1.EFFDT) FROM PS_HR_SUCC_PLN_LNG SP1 WHERE SP.HR_SUCC_PLAN_ID = SP1.HR_SUCC_PLAN_ID AND SP.HR_SUCC_PLAN_TYPE = SP1.HR_SUCC_PLAN_TYPE AND SP.HR_SUCC_PLAN_CTL = SP1.HR_SUCC_PLAN_CTL AND SP.LANGUAGE_CD = SP1.LANGUAGE_CD AND SP1.EFFDT <= %CurrentDateIn) OR SP.EFFDT = ( SELECT MAX(SP2.EFFDT) FROM PS_HR_SUCC_PLN_LNG SP2 WHERE SP.HR_SUCC_PLAN_ID = SP2.HR_SUCC_PLAN_ID AND SP.HR_SUCC_PLAN_TYPE = SP2.HR_SUCC_PLAN_TYPE AND SP.HR_SUCC_PLAN_CTL = SP2.HR_SUCC_PLAN_CTL AND SP.LANGUAGE_CD = SP2.LANGUAGE_CD AND SP2.EFFDT > %CurrentDateIn))

  • Related Language Record for HR_SP_EFFDT_VW HR_SP_SRCH

    • # 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
    4 EFFDT Date(10) DATE 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 DESCRLONG Long Character CLOB Long Description