DW_BEN_PLAN_YEAR_PERIOD_D (Preview)

This table requires activation of Benefits functional area. Table stores details of plan year periods

Details

Module: Benefits

Key Columns

PLAN_YEAR_PERIOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_YEAR_PERIOD_ID NUMBER 38 0 True Plan Year Period Indentifier
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. Unique Source Record Identifier
PLAN_ID NUMBER 38 0 Plan identifier
PERIOD_TYP_CD VARCHAR2 32 Plan Period Type
START_DATE DATE Plan Period Start Date
END_DATE DATE Plan Period End Date