DW_ABS_CATEGORY_D_TL

Stores Absence Category Translation Details

Details

Module: Absence Management

Key Columns

EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ABSENCE_CATEGORY_ID, LANGUAGE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_CATEGORY_ID NUMBER 38 0 True Absence Category Identifier    
LANGUAGE VARCHAR2 16   True Code of the Language to which contents are translated    
EFFECTIVE_START_DATE DATE     True Effective Start Date    
EFFECTIVE_END_DATE DATE     True Effective End Date    
SOURCE_RECORD_ID VARCHAR2 512     Functional key of records. Combination of Absence Category ID , Language, Effective Start Date and Effective End Date    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
ABSENCE_CATEGORY_NAME VARCHAR2 256     Name of the Absence Category    
ABSENCE_CATEGORY_DESCRIPTION VARCHAR2 2048     Description of Absence Category