# DW_ABS_PLAN_SUMMARY_D

This table stores the absence plan summary details

## Details

Module: Absence Management

## Key Columns

ABSENCE_PLAN_SUMMARY_ENTRY_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ABSENCE_PLAN_SUMMARY_ENTRY_ID | NUMBER | 38 | 0 | True | Plan summary Identifier |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Source Record Identifier consisting of ABSENCE_PLAN_SUMMARY_ENTRY_ID |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise identifier |  |
ABSENCE_ENTRY_ID | NUMBER | 38 | 0 |  | Absence header identifier |  |
PERSON_ID | NUMBER | 38 | 0 |  | Person Identifier |  |
PLAN_ID | NUMBER | 38 | 0 |  | Plan identifier |  |
ABSENCE_END_DATETIME | DATE |  |  |  | Absence end date |  |
ABSENCE_START_DATETIME | DATE |  |  |  | Absence start date |  |
CALCULATION_DATE | DATE |  |  |  | Date of calculation |  |
ENTITLEMENT_DATE | DATE |  |  |  | Date of entitlement |  |
PLAN_PERIOD_START_DATE | DATE |  |  |  | plan perios start date |  |
QUALIFICATION_DATE | DATE |  |  |  | date of qulaification |  |
PAY_FACTOR | NUMBER |  |  |  | Pay factor |  |
UNITS | NUMBER |  |  |  | Units qualified |  |
UOM_CODE | VARCHAR2 | 32 |  |  | Unit of measurement code |  |
ACTIVITY_CODE | VARCHAR2 | 256 |  |  | Activity code |  |
OVERRIDE_REASON_CODE | VARCHAR2 | 256 |  |  | Override reason code |  |
SOURCE | VARCHAR2 | 256 |  |  | Source |  |

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