|
| |
Related Links: |
|---|---|
| |
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 |
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 |
INITIAL_PCP_ID |
XXX |
VARCHAR2 |
20 |
INITIAL_PCP_NAME |
XXX |
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 INSTRUCTOR ROLE DETAIL table, this flag indicates whether this instructor is a current student: Y or N |
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 |
XXX |
VARCHAR2 |
15 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
