BENEFITS PLAN Table
Benefits Plans: health, insurance and flexible benefits accounts.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFITS_PLAN_KEY |
Key field used to join to the BENEFITS_PLAN table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
12 |
COVERAGE_TYPE |
Type of benefits coverage. |
VARCHAR2 |
20 |
COVERAGE_TYPE_CODE |
Code for type of benefits coverage. |
VARCHAR2 |
4 |
PLAN_CARRIER_NAME |
XXX |
VARCHAR2 |
25 |
PLAN_CATEGORY |
XXX |
VARCHAR2 |
30 |
PLAN_CATEGORY_CODE |
XXX |
VARCHAR2 |
1 |
PLAN_CODE |
MIT Health Plan code: MITT (MIT Traditional Health Plan) or MITF (MIT Flexible Health Plan) |
VARCHAR2 |
4 |
PLAN_GROUP_NUMBER |
XXX |
VARCHAR2 |
20 |
PLAN_NAME |
MIT Health Plan name. |
VARCHAR2 |
30 |
PLAN_OPTION |
XXX |
VARCHAR2 |
30 |
PLAN_OPTION_CODE |
XXX |
VARCHAR2 |
4 |
PLAN_STATUS |
XXX |
VARCHAR2 |
10 |
PLAN_TYPE |
XXX |
VARCHAR2 |
30 |
PLAN_TYPE_CODE |
XXX |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |