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, CATEGORY_ID, RATING_MODEL_ID

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.    
RATING_MODEL_ID NUMBER 38 0 True ID of Model generated in transaction system.    
CATEGORY_ID NUMBER 38 0 True ID of category 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     Unique Source Record Identifier.This column contains RATING_LEVEL_ID,RATING_MODEL_ID and CATEGORY_ID.    
RATING_LEVEL_NAME VARCHAR2 2048     Name for Rating level    
RATING_LEVEL_DESCRIPTION VARCHAR2 4000     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 4000     Description of Rating Model    
CATEGORY_NAME VARCHAR2 256     Name for Rating Category    
CATEGORY_DESCRIPTION VARCHAR2 2048     Description of Rating Category