DW_ABS_CATEGORY_D_TL

Stores Absence Category Translation Details

Details

Module: Absence Management

Key Columns

EFFECTIVE_END_DATE, LANGUAGE, EFFECTIVE_START_DATE, ABSENCE_CATEGORY_ID

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 This column is for Oracle Internal use only. 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 999 Description of Absence Category