This table stores the day wise details of the absence transactions
Module: Absence Management
ABSENCE_DETAIL_ID, ENTERPRISE_ID
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 |