DW_BEN_PROGRAM_HIERARCHY_CURRENT_DH (Preview)

This table requires activation of Benefits functional area. Table stores current program hierarchy details. Three Levels - program,plan and option.

Details

Module: Benefits

Key Columns

CALENDAR_DATE, PLAN_ID, PROGRAM_ID, PLAN_TYPE_ID, OPTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROGRAM_ID NUMBER 38 0 True Program Identifier    
PLAN_TYPE_ID NUMBER 38 0 True Plan Type identifier    
PLAN_ID NUMBER 38 0 True Plan Identifier    
OPTION_ID NUMBER 38 0 True Option Identifer    
CALENDAR_DATE DATE     True Calendar Date    
SOURCE_RECORD_ID VARCHAR2 256     This column is for Oracle Internal use only. Unique source record Identifier    

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