BENEFITS FULL DETAIL Table
View exposing comprehensive employee benefits enrollment detail including plan enrollment attributes, cost amounts, insurance-related values, tax indicators, and audit attributes 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 |
17,2 |
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 |
14,2 |
EXPIRATION_DATE |
Date associated with expiration. |
DATE |
|
FSA_AMOUNT |
Fsa amount as provided by the source. |
NUMBER |
14,2 |
HAS_PCCS_TAXABLE |
Has pccs taxable as provided by the source. |
VARCHAR2 |
1 |
INS_ALT_COVERAGE_AMOUNT |
Ins alt coverage amount as provided by the source. |
NUMBER |
17,2 |
INS_SALARY_OVERRIDE_AMOUNT |
Ins salary override amount as provided by the source. |
NUMBER |
17,2 |
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 |
IS_RECORD_LOCKED |
Indicator identifying whether record locked (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 |
PERCENT_401K_DEDUCTION |
Percent 401k deduction as provided by the source. |
NUMBER |
7,2 |
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 |
|
SUPP_INS_BASIC_COVERAGE_AMOUNT |
Supp ins basic coverage amount as provided by the source. |
NUMBER |
17,2 |
SUPP_INS_BENEFIT_SALARY_AMOUNT |
Supp ins benefit salary amount as provided by the source. |
NUMBER |
17,2 |
SUPP_INS_COVERAGE_AMOUNT |
Supp ins coverage amount as provided by the source. |
NUMBER |
17,2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |