DW_ABS_CATEGORY_D

This table stores the categories creted for absence classification

Details

Module: Absence Management

Key Columns

EFFECTIVE_END_DATE, 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 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 This column is for Oracle Internal use only. 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