BENEFITS RECIPIENT Table
A record exists in this table for each person who receives health, insurance, or flexible spending account benefits at MIT. Therefore, there are records not just for employees, but for their dependents.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
AGE |
*** In HR tables, this field contains the person's age in years as calculated by the HR System's Age Calculating Device. *** In STUDENT tables, this field contains the age of the person. |
NUMBER |
3 |
BENEFITS_RECIPIENT_KEY |
Key field used to join to the BENEFITS_RECIPIENT table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
14 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DEPENDENT_DOCS_REQUIRED_FLAG |
XXX |
VARCHAR2 |
1 |
FAMILY_RELATIONSHIP |
Relationship between employee and the recipient under the same health plan. E.g.: Child, Spouse, Self, Spousal Equivalent, Divorced spouse. |
VARCHAR2 |
40 |
FIRST_NAME |
The person's first name. |
VARCHAR2 |
30 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
GENDER_CODE |
Gender code. |
VARCHAR2 |
1 |
HEALTH_INSURANCE_CLAIM_NUMBER |
XXX |
VARCHAR2 |
20 |
INITIAL_PCP_ID |
Used by some medical plans: primary care provider ID number at the time of the enrollment in the plan |
VARCHAR2 |
20 |
INITIAL_PCP_NAME |
Used by some medical plans: primary care provider name at the time of the enrollment in the plan |
VARCHAR2 |
30 |
IS_DISABLED_DEPENDENT |
XXX |
VARCHAR2 |
1 |
IS_STUDENT |
In the STUDENT and STUDENT_ALL table, this flag indicates whether the person has ever been a student at MIT. In the WTW_INSTRUCTOR and WTW_OLD_INSTRUCTOR tables, this flag indicates whether this instructor was a current student, Y or N, for the specific term. In Payroll Person, indicates whether the person is currently a student, Y or N (i.e., the person may or may not have been a student in a past payroll period). |
VARCHAR2 |
1 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
LAST_UPDATE_DATE |
Date the description was created or last altered. |
DATE |
8 |
LAST_UPDATE_USER |
Last person that changed this record. |
VARCHAR2 |
12 |
MIDDLE_NAME |
The person's middle name (where available). |
VARCHAR2 |
30 |
RECORD_COUNTER |
Used to count records within a group on a report. Always contains a value of 1. |
NUMBER |
1 |
SOCIAL_SECURITY_NUMBER |
The person's Social Security Number |
VARCHAR2 |
15 |
SUFFIX |
Name suffix (e.g., "III", "Jr.", "Sr", etc. |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |