This table stores absence plan information.
Module: Absence Management
EFFECTIVE_END_DATE, ABSENCE_PLAN_ID, EFFECTIVE_START_DATE
| 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.