RF_PRD_RATE_MDL

(SQL Table)
Index Back

Product Rating Model

Stores the rating model to be used when assigning proficiencies to products.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

Default Value: OPR_DEF_TBL_RB.SETID

Prompt Table: SP_SETID_NONVW

2 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL RATING_MODEL field used in the HCM/ CRM sync Application Messages.

Prompt Table: RATING_MDL_TBL

3 ASSIGN_DFLT_PAGE Character(1) VARCHAR2(1) NOT NULL Stores the default page when displaying the results from the assignment engine.
D=Detail Assignment Page
S=Summary Assignment Page

Default Value: S

4 DISPLAY_FLAG Character(1) VARCHAR2(1) NOT NULL Display on Chart

Y/N Table Edit

Default Value: N

5 MARKET Character(3) VARCHAR2(3) NOT NULL Market