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

Copyright © 2019, 2025, Oracle and/or its affiliates.