DW_ABS_DAILY_DETAIL_F

This table stores the day wise details of the absence transactions

Details

Module: Absence Management

Key Columns

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