BENEFITS DETAIL Table
View exposing employee benefits enrollment detail including benefit recipient, plan, adjustment reason, effective dates, enrollment attributes, cost amounts, and tax indicators used for benefits reporting and administration.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ALTERNATE_PLAN_ID |
Business identifier for the alternate plan. |
VARCHAR2 |
20 |
ALTERNATIVE_COST |
Alternative cost as provided by the source. |
NUMBER |
|
BENEFITS_ADJUSTMENT_REASON_KEY |
Surrogate key identifying the benefits adjustment reason. |
VARCHAR2 |
4 |
BENEFITS_PLAN_KEY |
Surrogate key identifying the benefits plan. |
VARCHAR2 |
12 |
BENEFITS_RECIPIENT_KEY |
Surrogate key identifying the benefits recipient. |
VARCHAR2 |
14 |
BENEFIT_COST_RULE_VARIANT |
Benefit cost rule variant as provided by the source. |
VARCHAR2 |
4 |
EFFECTIVE_DATE |
Date associated with effective. |
DATE |
|
ER_NOTAX_SUB |
Er notax sub as provided by the source. |
NUMBER |
|
EXPIRATION_DATE |
Date associated with expiration. |
DATE |
|
FSA_AMOUNT |
Fsa amount as provided by the source. |
NUMBER |
|
HAS_PCCS_TAXABLE |
Has pccs taxable as provided by the source. |
VARCHAR2 |
1 |
IS_INSURABILITY_PROVEN |
Indicator identifying whether insurability proven (Y/N). |
VARCHAR2 |
1 |
IS_INSURABILITY_STATEMENT_REQD |
Indicator identifying whether insurability statement reqd (Y/N). |
VARCHAR2 |
1 |
IS_PRE_TAX |
Indicator identifying whether pre tax (Y/N). |
VARCHAR2 |
1 |
LAST_UPDATE_DATE |
Date associated with last update. |
DATE |
|
LAST_UPDATE_USER |
Last update user as provided by the source. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
PERSONNEL_KEY |
Surrogate key identifying the personnel. |
VARCHAR2 |
8 |
PLAN_ENROLLMENT_TYPE |
Plan enrollment type as provided by the source. |
VARCHAR2 |
30 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |