DW_BEN_PLAN_D (Preview)

This table requires activation of Benefits functional area. Benefits plan details

Details

Module: Benefits

Key Columns

EFFECTIVE_END_DATE, PLAN_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PLAN_ID NUMBER 38 0 True Plan 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 Name
PLAN_CD VARCHAR2 32 Plan Usage
FUNCTION_CODE VARCHAR2 32 Plan Function
PLAN_STAT_CD VARCHAR2 32 Plan Status
SHORT_NAME VARCHAR2 32 Plan Short Name
SHORT_CODE VARCHAR2 32 Plan Short Code
GLOBAL_FLAG VARCHAR2 32 Plan Global Flag
ALWS_UNRSTRCTD_ENRT_FLAG VARCHAR2 32 Allows Unrestricted Enrollment
RATE_LEVEL VARCHAR2 256 Rate Level
NOT_IN_PROGRAM_PLAN_UOM VARCHAR2 32 Not In Program Plan Currency
NOT_IN_PROGRAM_DEFINED_RT_FREQ VARCHAR2 32 Not In Program Defined Rate Frequency
NOT_IN_PROGRAM_COMMUNICATED_RT_FREQ VARCHAR2 32 Not In Program Communicated Rate Frequency
SUBJ_TO_IMPTD_INCM_TYP_CD VARCHAR2 32 Subject To Imputed Income
INCPTN_DT DATE Plan Inception Date
BNFT_EXTRCT_PLAN_NAME VARCHAR2 256 Benefits Extract Plan Code
CARRIER_ID NUMBER 38 0 Carrier Identifier