DW_ABS_DAILY_DETAIL_F

This table stores the day wise details of the absence transactions

Details

Module: Absence Management

Key Columns

ABSENCE_DETAIL_ID, ENTERPRISE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ABSENCE_DETAIL_ID NUMBER 38 0 True Primary key of Absence detail    
ENTERPRISE_ID NUMBER 38 0 True Enterprise identifier    
SOURCE_RECORD_ID VARCHAR2 64     Unique Source Record Identifier consisting of absenec_detail_id and enterprise_id    
ABSENCE_ENTRY_ID NUMBER 38 0   Absence header identifier DW_ABS_ENTRY_D ABSENCE_ENTRY_ID
ASSIGNMENT_ID NUMBER 38 0   Assignment Identifier    
ABSENCE_TYPE_ID NUMBER 38 0   Absence type identifier DW_ABS_TYPE_D ABSENCE_TYPE_ID
PERSON_ID NUMBER 38 0   Person identifier DW_PERSON_D PERSON_ID
ABSENCE_PLAN_ID NUMBER 38 0   Absence plan identifier, it is not populated if concurrent plans are enabled DW_ABS_PLAN_D ABSENCE_PLAN_ID
ABSENCE_TYPE_REASON_ID NUMBER 38 0   Absence reason identifier DW_ABS_TYPE_REASON_D ABSENCE_TYPE_REASON_ID
ABSENCE_DATE DATE       Date of absence    
ABSENCE_HOURS NUMBER       Hours of absence    
ABSENCE_DAYS NUMBER       Days of absence    
SCHEDULED_UNITS NUMBER       Scheduled units    
UOM_CODE VARCHAR2 32     Unit of measurement code