DW_ABS_PLAN_ENROLLMENT_D

Stores Absence Plan Enrollment Details

Details

Module: Absence Management

Key Columns

PLAN_ENRT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_ENRT_ID NUMBER 38 0 True Plan Enrollment Identifier    
SOURCE_RECORD_ID VARCHAR2 512     Functional key of records. Plan Enrollment Id    
WORK_TERM_ASG_ID NUMBER 38 0   Work Term Assignment Identifier    
LAST_ACCRUAL_RUN_DATE DATE       Last Accrual Run Date    
ENTERPRISE_ID NUMBER 38 0   Enterprise Identifier    
PERSON_ID NUMBER 38 0   Person Identifier    
PERIOD_OF_SERVICE_ID NUMBER 38 0   Period of Service Identifier    
PLAN_ID NUMBER 38 0   Plan Identifier    
ENRT_ST_DT DATE       Enrollment Start Date    
ENRT_END_DT DATE       Enrollment End Date    
WAIT_PERIOD_DUR_UOM VARCHAR2 32     Wait Period Duration Unit of Measure    
WAIT_PERIOD_DUR_UNITS NUMBER       Wait Period Duration Units    
STATUS_CODE VARCHAR2 32     Status