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 This column is for Oracle Internal use only. 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