# DW_ABS_PLAN_D

This table stores absence plan information.

## Details

Module: Absence Management

## Key Columns

EFFECTIVE_END_DATE, ABSENCE_PLAN_ID, EFFECTIVE_START_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
ABSENCE_PLAN_ID | NUMBER | 38 | 0 | True | Absence Plan Identifier | DW_ABS_PLAN_D_TL | ABSENCE_PLAN_ID
EFFECTIVE_START_DATE | DATE |  |  | True | Start date of Absence Plan |  |
EFFECTIVE_END_DATE | DATE |  |  | True | End date of Absence Plan |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. Unique Identifier |  |
LEGISLATIVE_DATA_GROUP_ID | NUMBER | 38 | 0 |  | Legislative data group identifier |  |
PLAN_TYPE | VARCHAR2 | 32 |  |  | Type of Plan |  |
PLAN_UOM | VARCHAR2 | 32 |  |  | Plan Unit of Measurement |  |
PLAN_PERIOD_TYPE | VARCHAR2 | 32 |  |  | Type of Plan period |  |
PERIOD_UOM | VARCHAR2 | 32 |  |  | Plan period unit of measurement |  |
PLAN_STATUS | VARCHAR2 | 32 |  |  | Plan Status |  |
VESTING_PERIOD_DURATION | NUMBER |  |  |  | Vesting period duration |  |
VESTING_PERIOD_UOM | VARCHAR2 | 32 |  |  | Vesting period unit of measurement |  |
ACCRUAL_VESTING_CD | VARCHAR2 | 32 |  |  |  |  |
ACCRUAL_METHOD_CD | VARCHAR2 | 32 |  |  |  |  |
WAIT_PERIOD_DUR_UNITS | NUMBER |  |  |  |  |  |
WAIT_PERIOD_DUR_UOM | VARCHAR2 | 32 |  |  |  |  |
CARRY_OVER_FLAT_AMT | NUMBER |  |  |  |  |  |
CARRY_OVER_EXPIRED_UOM | VARCHAR2 | 32 |  |  |  |  |
CEIL_LIMIT_FLAT_AMT | NUMBER |  |  |  |  |  |
LEGISLATION_CODE | VARCHAR2 | 32 |  |  | Legislation code |  |
ENTERPRISE_ID | NUMBER | 38 | 0 |  | Enterprise Identifier |  |
CARRY_OVER_EXPIRED_UNITS | NUMBER |  |  |  | Carry Over Expired Units |  |
PERIOD_FREQUENCY | VARCHAR2 | 32 |  |  | Plan period frequency |  |
CALENDAR_ID | NUMBER | 38 | 0 |  | Accrual calendar identifier |  |

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