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