HR_VT_RATEBX_VW

(SQL View)
 Index Back

SP360 Ratings Box Candidates

Fetches active candidates with and without ratings box ratings using a LEFT OUTER JOIN.

SELECT DISTINCT A.HR_SUCC_PLAN_ID , A.HR_SUCC_PLAN_TYPE , A.HR_SUCC_PLAN_CTL , B.HR_RATINGS_BOX_ID , A.EFFDT , A.EMPLID , A.EMPL_RCD , A.STATUS , 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HR_SP_PERS_SRCH

    7 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    8 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    9 HR_SP_CAND_TYPE Character(1) VARCHAR2(1) NOT NULL Succession Plan Candidate Type
    A=Applicant
    P=Person
    10 RANK Number(3,0) SMALLINT NOT NULL Rank
    11 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
    12 HR_RB_XAXISRANK Number(3,0) SMALLINT NOT NULL X-Axis Rank

    Prompt Table: HR_RB_X_RANK_VW

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

    Prompt Table: HR_RB_Y_RANK_VW