# DW_BEN_PLAN_D (Preview)

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

## Details

Module: Benefits

## Key Columns

EFFECTIVE_END_DATE, EFFECTIVE_START_DATE, PLAN_ID

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

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