DW_ABS_CATEGORY_D

This table stores the categories creted for absence classification

Details

Module: Absence Management

Key Columns

ABSENCE_CATEGORY_ID, EFFECTIVE_END_DATE, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_CATEGORY_ID NUMBER 38 0 True Category Identifier DW_ABS_CATEGORY_D_TL ABSENCE_CATEGORY_ID
EFFECTIVE_START_DATE DATE     True Effective start date    
EFFECTIVE_END_DATE DATE     True Effective end date    
SOURCE_RECORD_ID VARCHAR2 128     Unique Source Record Identifier consisting of absence_category_id effective_start_date and effective_end_date    
ENTERPRISE_ID NUMBER 38 0   Enterprise identifier    
LEGISLATION_CODE VARCHAR2 32     Legislation Code    
STATUS_CODE VARCHAR2 32     Category Status