DW_BEN_PLAN_TYPE_D (Preview)

This table requires activation of Benefits functional area. Table stores details of benefit plan types

Details

Module: Benefits

Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, PLAN_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_TYPE_ID NUMBER 38 0 True Plan Type Identifier    
EFFECTIVE_START_DATE DATE     True Indicates the date at the beginning of the date range within which the row is effective    
EFFECTIVE_END_DATE DATE     True Indicates the date at the end of the date range within which the row is effective    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier    
NAME VARCHAR2 256     Plan Type Name    
OPT_TYP_CD VARCHAR2 32     Option Type    
SELF_SERVICE_CATEGORY_CD VARCHAR2 32     Self Service Grouping    
PLAN_TYPE_STAT_CD VARCHAR2 32     Plan Type Status    
BNFT_EXTRCT_PLAN_TYPE_NAME VARCHAR2 256     Benefits Extract Plan Type Name    
GLOBAL_FLAG VARCHAR2 32     Plan Type Global Flag    

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