HR_SPHDR_LNG_VW

(SQL View)
Index Back

SP Header, No Pcode View

This view is based on HR_SUCC_PLN_LNG. It selects directly from the table with no joins and no PeopleCode. HR_SUCC_PLN_LNG is the related language header record which contains the effective date of the Succession Plan for this position. There would be one record for each effective-dated plan.

SELECT HR_SUCC_PLAN_ID , HR_SUCC_PLAN_TYPE , HR_SUCC_PLAN_CTL , EFFDT , LANGUAGE_CD , DESCR FROM PS_HR_SUCC_PLN_LNG

  • Related Language Record for HR_SPHDR_NPC_VW
  • # 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