HR_SP_RATEBX_VW

(SQL View)
 Index Back

SP Active Candidate Box Rating

This view fetches all active candidates that may or may not have ratings box ratings. If the candidate has ratings box ratings, then the ratings are fetched with the candidate. If not, a row is still returned for the candidates with empty ratings box information. This view joins HR_SUCC_PLN_DTL to HR_SP_RB_DATA using a LEFT OUTER JOIN.

SELECT A.HR_SUCC_PLAN_ID , A.HR_SUCC_PLAN_TYPE , A.HR_SUCC_PLAN_CTL , B.HR_RATINGS_BOX_ID , A.EMPLID , A.EMPL_RCD , A.EFFDT , A.HR_SP_CAND_TYPE , A.RANK , A.HR_SP_READINESS , B.HR_RB_XAXISRANK , B.HR_RB_YAXISRANK FROM PS_HR_SUCC_PLN_DTL A LEFT OUTER JOIN PS_HR_SP_RB_DATA B ON (A.HR_SUCC_PLAN_ID = B.HR_SUCC_PLAN_ID AND A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.EFFDT = B.EFFDT) WHERE A.STATUS = 'A'

  • 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

    Prompt Table: %EDITTABLE

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

    Prompt Table: HR_SP_PERS_SRCH

    6 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    7 EFFDT Date(10) DATE NOT NULL Effective Date
    8 HR_SP_CAND_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Candidate Type
    A=Applicant
    P=Person
    9 RANK Number(3,0) SMALLINT NOT NULL Rank
    10 HR_SP_READINESS Character(1) VARCHAR2(1) NOT NULL Displays Readiness of a Succession Plan Candidate.
    0=Ready Now
    1=1 - 2 Years
    2=3 - 5 Years
    E=Emergency
    11 HR_RB_XAXISRANK Number(3,0) SMALLINT NOT NULL X-Axis Rank

    Prompt Table: HR_RB_X_RANK_VW

    12 HR_RB_YAXISRANK Number(3,0) SMALLINT NOT NULL Y-Axis Rank

    Prompt Table: HR_RB_Y_RANK_VW