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 REVW_RATING_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL RATING_MODEL field used in the HCM/ CRM sync Application Messages.
    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 GVT_OPM_PATTERN field used in the HCM/ CRM RATING_MODEL_SYNC Application Messages.
    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