DW_BEN_PLAN_TYPE_CURRENT_D (Preview)

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

Details

Module: Benefits

Key Columns

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
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