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    

Copyright © 2019, 2025, Oracle and/or its affiliates.