MIT MEDICAL RECIPIENT Table
This table is created for use by the Medical Department. It contains basic biographic and health plan converage information for all current recipients of the MIT Health Plans (both the MITT, Traditional, and the MITF, Flexible, Health Plans).
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 |
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 |
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 |