This table requires activation of Benefits functional area. Benefits plan details
Module: Benefits
EFFECTIVE_END_DATE, PLAN_ID, EFFECTIVE_START_DATE
| 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.