# DW_ABS_PLAN_ENTRY_D

Stores Absence Plan and Type Mapping Details

## Details

Module: Absence Management

## Key Columns

ABS_PLAN_ENTRY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ABS_PLAN_ENTRY_ID | NUMBER | 38 | 0 | True | Absence Plan Entry Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 512 |  |  | This column is for Oracle Internal use only. Functional key of records. Absence Plan Entry Identifier |  |
START_DATETIME | DATE |  |  |  | Start Date |  |
END_DATETIME | DATE |  |  |  | End Date |  |
ABS_TYPE_ENTRY_ID | NUMBER | 38 | 0 |  | Absence Type Entry Identifier |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise Identifier |  |
ABSENCE_PLAN_ID | NUMBER | 38 | 0 |  | Absence Plan Identifier | DW_ABS_PLAN_D_TL | ABSENCE_PLAN_ID
ASSIGNMENT_ID | NUMBER | 38 | 0 |  | Assignment Identifier |  |
START_DATE | DATE |  |  |  | Start Date |  |
END_DATE | DATE |  |  |  | End Date |  |
UOM_CODE | VARCHAR2 | 32 |  |  | Unit of Measure |  |
SCHEDULED_UNITS | NUMBER |  |  |  | Scheduled Units |  |
ABS_UNITS | NUMBER |  |  |  | Absence Units |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
ABSENCE_ENTRY_ID | NUMBER | 38 | 0 |  | Absence Entry Identifier |  |
ABSENCE_PLAN_SUMMARY_ENTRY_ID | NUMBER | 38 | 0 |  | Plan summary Identifier |  |
QUALIFICATION_DATE | DATE |  |  |  | Qulification Date |  |
ENTITLEMENT_DATE | DATE |  |  |  | Entitlement Date |  |
ABSENCE_PAY_FACTOR | NUMBER | 38 | 0 |  | Absence Pay Factor |  |
ABS_PAY_FACTOR | NUMBER |  |  |  | Absence Pay Factor |  |

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