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     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