# DW_ABS_ENTRY_DETAIL_F

Stores Absence Entry Details

## Details

Module: Absence Management

## Key Columns

ENTERPRISE_ID, ABS_ENTRY_DTL_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ABS_ENTRY_DTL_ID | NUMBER | 38 | 0 | True | Absence Entry Detail Identifier |  |
ENTERPRISE_ID | NUMBER | 38 | 0 | True | Enterprise Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Functional key of records. Combination of Absence Entry Detail Identifier and Enterprise Identifier |  |
ABSENCE_ENTRY_ID | NUMBER | 38 | 0 |  | Absence Entry Identifier | DW_ABS_ENTRY_D | ABSENCE_ENTRY_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
ABSENCE_DATE | DATE |  |  |  | Absence Date |  |
ABSENCE_DATETIME | TIMESTAMP |  |  |  | Absence Date Time |  |
ABSENCE_END_DATETIME | TIMESTAMP |  |  |  | Absence End Date Time |  |
ABSENCE_START_TIME | VARCHAR2 | 32 |  |  | Absence Start Time |  |
ABSENCE_END_TIME | VARCHAR2 | 32 |  |  | Absence End Time |  |
ABSENCE_DURATION | NUMBER |  |  |  | Absence Duration |  |

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