HR_SP_SRCH

(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.DESCR ,SP.DESCRLONG FROM PS_HR_SUCC_PLN_HDR SP WHERE (SP.EFFDT = ( SELECT MAX(SP1.EFFDT) FROM PS_HR_SUCC_PLN_HDR 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 SP1.EFFDT <= %CurrentDateIn) OR SP.EFFDT = ( SELECT MAX(SP2.EFFDT) FROM PS_HR_SUCC_PLN_HDR 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 SP2.EFFDT > %CurrentDateIn))

  • Related Language Record: HR_SP_SRCH_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
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRLONG Long Character CLOB Long Description