DW_ABS_TYPE_CATEGORY_D

Stores Absence Type and Category Mapping Details

Details

Module: Absence Management

Key Columns

EFFECTIVE_END_DATE, ABSENCE_TYPE_CATE_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_TYPE_CATE_ID NUMBER 38 0 True Absence Type Category Identifier
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 Type Category Identifier, Effective Start Date and Effective End Date
ENTERPRISE_ID NUMBER 38 0 Enterprise Identifier
ABSENCE_TYPE_ID NUMBER 38 0 Absence Type Identifier DW_ABS_TYPE_D_TL ABSENCE_TYPE_ID
ABSENCE_CATEGORY_ID NUMBER 38 0 Absence Category Identifier DW_ABS_CATEGORY_D_TL ABSENCE_CATEGORY_ID
STATUS_CODE VARCHAR2 32 Status Code