HR_SP_RB_SEL_VW

(SQL View)
Index Back

Succ Plan Ratings Boxes View

Succession Plan Ratings Boxes joined to the Ratings Box definition table, HR_RATINGS_BOX. Only returns rows where the ratings box is assigned to a succession plan and active on HR_RATINGS_BOX as of the succession plans EFFDT.

SELECT A.HR_SUCC_PLAN_ID , A.HR_SUCC_PLAN_TYPE , A.HR_SUCC_PLAN_CTL , A.EFFDT , A.HR_RATINGS_BOX_ID FROM PS_HR_SP_RB_SELECT A , PS_HR_RATINGS_BOX B WHERE A.HR_RATINGS_BOX_ID = B.HR_RATINGS_BOX_ID AND B.EFF_STATUS = 'A' AND %EffdtCheck(HR_RATINGS_BOX sub,B,A.EFFDT)

  • 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
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 HR_RATINGS_BOX_ID Character(11) VARCHAR2(11) NOT NULL Ratings Box ID

    Prompt Table: HR_SP_RB_VW