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
| 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 |