HR_RATINGS_BOX

(SQL Table)
 Index Back

Ratings Box Configuration

Ratings Box Configuration

  • Related Language Record: HR_RTNGS_BX_LNG

  • Parent Record Of HR_RB_XAXIS_VW HR_RB_X_RANK_VW HR_RB_X_RATINGS HR_RB_X_RAT_VW HR_RB_X_RNK_LNG HR_RB_X_RTG_LNG HR_RB_X_RTNG_VW HR_RB_X_VW_LNG HR_RB_Y_RANK_VW HR_RB_Y_RATINGS HR_RB_Y_RNK_LNG HR_RB_Y_RTG_LNG HR_RB_Y_RTNG_VW HR_RB_Y_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_RATINGS_BOX_ID Character(11) VARCHAR2(11) NOT NULL Ratings Box ID
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 HR_RB_MAINTITLE Character(35) VARCHAR2(35) NOT NULL Ratings Box Main Title
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    7 DESCRLONG Long Character CLOB Long Description
    8 HR_RB_TPOOL_IND Character(1) VARCHAR2(1) NOT NULL Used for Succession Planning Search Filter

    Y/N Table Edit

    Default Value: N

    9 HR_RB_XAXISBOXNUM Character(1) VARCHAR2(1) NOT NULL X-Axis Box Number
    0=0
    1=1
    2=2
    3=3
    4=4
    5=5

    Default Value: 0

    10 HR_RB_YAXISBOXNUM Character(1) VARCHAR2(1) NOT NULL Y-Axis Box Number
    0=0
    1=1
    2=2
    3=3
    4=4
    5=5

    Default Value: 0

    11 HR_RB_XAXISTITLE Character(30) VARCHAR2(30) NOT NULL X-Axis Title
    12 HR_RB_YAXISTITLE Character(30) VARCHAR2(30) NOT NULL Y-Axis Title
    13 HR_RB_XRATINGINTG Character(1) VARCHAR2(1) NOT NULL Rating Integration
    C=Career Potential
    N=None
    P=Performance Integration

    Default Value: N

    14 HR_RB_YRATINGINTG Character(1) VARCHAR2(1) NOT NULL Rating Integration
    C=Career Potential
    N=None
    P=Performance Integration

    Default Value: N

    15 HR_RB_POTFLD_VAL Character(30) VARCHAR2(30) NOT NULL Field Value
    16 HR_RB_XAUTOLOAD Character(1) VARCHAR2(1) NOT NULL Auto Load Ratings

    Y/N Table Edit

    Default Value: N

    17 HR_RB_YAUTOLOAD Character(1) VARCHAR2(1) NOT NULL Auto Load Ratings

    Y/N Table Edit

    Default Value: N