# DW_ABS_ENTRY_D

This table stores the header details of the absence transactions

## Details

Module: Absence Management

## Key Columns

ENTERPRISE_ID , ABSENCE_ENTRY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ABSENCE_ENTRY_ID | NUMBER | 38 | 0 | True | Primary key of Absence header |  |
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 absnec_entry_id and enterprise_id |  |
LEGAL_EMPLOYER_ID | NUMBER | 38 | 0 |  | Legal Entity identifier |  |
LEGISLATIVE_DATA_GROUP_ID | NUMBER | 38 | 0 |  | Legislative data group identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person identifier |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment identifier |  |
ABSENCE_TYPE_ID | NUMBER | 38 | 0 |  | Absence type identifier |  |
ABSENCE_TYPE_REASON_ID | NUMBER | 38 | 0 |  | Absence reason identifier |  |
START_DATE_DURATION | NUMBER |  |  |  | Duration on the start date |  |
END_DATE_DURATION | NUMBER |  |  |  | Duration on the end date |  |
UOM_CODE | VARCHAR2 | 32 |  |  | Unit of measurement code |  |
DURATION | NUMBER |  |  |  | Total Duration |  |
ABSENCE_PATTERN_CD | VARCHAR2 | 32 |  |  | Code for absence pattern |  |
ABSENCE_STATUS_CD | VARCHAR2 | 32 |  |  | Code for Absence status |  |
APPROVAL_STATUS_CD | VARCHAR2 | 32 |  |  | Code for approval status |  |
SINGLE_DAY_FLAG | VARCHAR2 | 16 |  |  | Determines whether the absence applied is for single day |  |
START_TIME | VARCHAR2 | 32 |  |  | Absence Starting time |  |
END_TIME | VARCHAR2 | 32 |  |  | Absence Ending time |  |
OPEN_ENDED_FLAG | VARCHAR2 | 16 |  |  | Determines if the absence is open ended |  |
COMMENTS | VARCHAR2 | 999 |  |  | Comments |  |
LATE_NOTIFY_FLAG | VARCHAR2 | 32 |  |  | Determines whther the notification for absence was late |  |
ABSENCE_SOURCE | VARCHAR2 | 16 |  |  | Source |  |
START_DATETIME | TIMESTAMP |  |  |  | Absence Start Date time and start time |  |
END_DATETIME | TIMESTAMP |  |  |  | Absence End date and end time |  |
START_DATE | DATE |  |  |  | Absence start date |  |
END_DATE | DATE |  |  |  | Absence End date |  |
PLANNED_END_DATE | DATE |  |  |  | For open absence planned end date |  |
SUBMITTED_DATE | DATE |  |  |  | Absence submitted date |  |
CONDITION_START_DATE | DATE |  |  |  | Condition start date |  |
NOTIFICATION_DATE | DATE |  |  |  | Notification date |  |
ABSENCE_ENTRY_BASIC_FLAG | VARCHAR2 | 32 |  |  | Determines whether absence was entered in basic or advanced mode |  |
BLOCKED_LEAVE_CANDIDATE | VARCHAR2 | 32 |  |  | Determines whether it is a mandatory absence |  |
DW_START_DATE | DATE |  |  |  | Warehouse Absence start date |  |

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