# DW_ABS_TYPE_ENTRY_D

This table stores the header details of absences which have not been rejected or wihdrawn

## Details

Module: Absence Management

## Key Columns

ABSENCE_TYPE_ENTRY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ABSENCE_TYPE_ENTRY_ID | NUMBER | 38 | 0 | True | Absence type entry identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier consisting of ABSENCE_TYPE_ENTRY_ID |  |
ABSENCE_TYPE_ID | NUMBER | 38 | 0 |  | Absence type identifier |  |
ABSENCE_ENTRY_ID | NUMBER | 38 | 0 |  | Absence header identifier |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise Identifier |  |
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
START_DATE | DATE |  |  |  | Absence start date |  |
END_DATE | DATE |  |  |  | Absence end date |  |
LEAVE_DURATION | NUMBER |  |  |  | duration of leaves |  |
UOM_CODE | VARCHAR2 | 32 |  |  | unit of measurement code |  |
START_DATE_DURATION | NUMBER |  |  |  | start date duration |  |
END_DATE_DURATION | NUMBER |  |  |  | end date duration |  |
END_DATETIME | TIMESTAMP |  |  |  | end date time |  |
START_DATETIME | TIMESTAMP |  |  |  | start date time |  |
ABSENCE_STATUS_CD | VARCHAR2 | 32 |  |  | status of absence |  |
COMMENTS | VARCHAR2 | 999 |  |  | comments |  |

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