PENSION MIT MEDICAL RECIPIENT Table
Pension annuitants who subscribe to MIT Medical health plan, and 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 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |