RATING_MDL_TBL

(SQL Table)
 Index Back

Rating Model for Reviews

This table groups different ratings together in order to form one rating model. An example could be school grades 'A' to 'F' as a rating model.

  • Related Language Record: RATING_MDL_LANG

  • Parent Record Of JPM_RATING_LVW1 JPM_RATING_LVW2 JPM_RATING_VW1 JPM_RATING_VW2 REVW_RATING_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL Rating Model
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 GVT_OPM_PATTERN Character(1) VARCHAR2(1) NOT NULL OPM Rating of Record Pattern
    A=Summary Levels 1 and 3
    B=Summary Levels 1,3 and 5
    C=Summary Levels 1,3 and 4
    D=Summary Levels 1,2 and 3
    E=Summary Levels 1,3,4 and 5
    F=Summary Levels 1,2,3 and 5
    G=Summary Levels 1,2,3 and 4
    H=Summary Levels 1,2,3,4 and 5
    Z=Exclusion
    7 REVIEW_BAND_SW Character(1) VARCHAR2(1) NOT NULL Yes/No switch to determine if the rating model is a Review Band.

    Y/N Table Edit

    Default Value: N