DW_RATING_LEVEL_D_TL

It stores translation of rating level, model and its categories.

Details

Module: Global Human Resources

Key Columns

RATING_LEVEL_ID, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATING_LEVEL_ID NUMBER 38 0 True ID of rating level generated in transaction system.
LANGUAGE VARCHAR2 16 True Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Source Record Identifier.This column contains RATING_LEVEL_ID,RATING_MODEL_ID and CATEGORY_ID.
RATING_MODEL_ID NUMBER 38 0 ID of Model generated in transaction system.
CATEGORY_ID NUMBER 38 0 ID of category generated in transaction system.
RATING_LEVEL_NAME VARCHAR2 999 Name for Rating level
RATING_LEVEL_DESCRIPTION VARCHAR2 999 Description of Rating level
RATING_LEVEL_SHORT_DESCRIPTION VARCHAR2 256 Short description of Rating level
MODEL_NAME VARCHAR2 256 Name for Rating Model
MODEL_DESCRIPTION VARCHAR2 999 Description of Rating Model
CATEGORY_NAME VARCHAR2 256 Name for Rating Category
CATEGORY_DESCRIPTION VARCHAR2 999 Description of Rating Category