HCSC_RTG_CDEFFDTHCSC_RTG_RATINGLANGUAGE_CDHCSC_RTG_VAL_LG(SQL Table) |
Index Back |
|---|---|
Ratings Values Rel LanguageStore all the valid rating values on this table. The numeric value on the Ratings Value field determines the weigh of the ratings. If the ratings value is higher then weight of this rating is higher. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCSC_RTG_CD |
Character(30) | VARCHAR2(30) NOT NULL | Ratings Identification |
| 2 | EFFDT |
Date(10) | DATE | Effective Date |
| 3 | HCSC_RTG_RATING |
Number(3,0) | SMALLINT NOT NULL | Ratings value |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | HCSC_RTG_DESCR | Character(254) | VARCHAR2(254) NOT NULL | Ratings Description |