DW_RATING_CATEGORY_D
It holds Rating categories and boundaries
Details
Module: Global Human Resources
Key Columns
BUSINESS_GROUP_ID, CATEGORY_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| CATEGORY_ID | NUMBER | 38 | 0 | True | Transaction system generated primary key column. | ||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | True | Business group identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. Unique Source Record Identifier.This column contains BUSINESS_GROUP_ID and CATEGORY_ID . | ||||
| RATING_MODEL_ID | NUMBER | 38 | 0 | Transaction system generated primary key column.For translation refer table DW_RATING_LEVEL_D_TL for Model name and description and join with RATING_LEVEL_ID. | |||
| LOWER_BOUNDARY | NUMBER | Code of the job | |||||
| UPPER_BOUNDARY | NUMBER | Transaction system generated primary key column.For translation refer table DW_RATING_LEVEL_D_TL for Category name and description and join with RATING_LEVEL_ID. |