This table stores absence plan information.
Module: Absence Management
EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, ABSENCE_PLAN_ID
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 | 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, 2022, Oracle and/or its affiliates.