BENEFITS ELIGIBILITY HISTORY Table
View exposing historical employee benefits eligibility detail including eligibility date ranges, program groups, percentage values, and audit attributes used for benefits reporting and trend analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
BENEFITS_PERCENTAGE |
Benefits percentage as provided by the source. |
NUMBER |
7,4 |
ELIGIBILITY_END_DATE |
Date associated with eligibility end. |
DATE |
|
ELIGIBILITY_START_DATE |
Date associated with eligibility start. |
DATE |
|
ELIG_PROGRAM_GROUP_1 |
Elig program group 1 as provided by the source. |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_1_CODE |
Code identifying elig program group 1. |
VARCHAR2 |
4 |
ELIG_PROGRAM_GROUP_2 |
Elig program group 2 as provided by the source. |
VARCHAR2 |
30 |
ELIG_PROGRAM_GROUP_2_CODE |
Code identifying elig program group 2. |
VARCHAR2 |
4 |
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 |
RECORD_COUNTER |
Record counter as provided by the source. |
NUMBER |
1 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |