PENSION MIT MEDICAL PERSON Table
This view includes pension annuitants personal data if they subscribe for MIT Medical 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 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
EB_ELIGIBILITY |
Employee benefits eligibility (eg. Standard, Ineligible, Dental Only) |
VARCHAR2 |
30 |
ELIGIBILITY_END_DATE |
Expiration (end) date of the employee's benefits eligibility. |
DATE |
8 |
ELIGIBILITY_START_DATE |
Effective (start) date of the employee's benefits eligibility. |
DATE |
8 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
FULL_NAME |
The full name of the person. |
VARCHAR2 |
90 |
GENDER |
The person's gender. |
VARCHAR2 |
30 |
HOME_ADDR_CARE_OF |
"Care of" in the person's home address |
VARCHAR2 |
40 |
HOME_ADDR_CITY |
The city of the person's home address. |
VARCHAR2 |
40 |
HOME_ADDR_COUNTRY |
The country of the person's home address. |
VARCHAR2 |
30 |
HOME_ADDR_STATE |
The U.S. state code of the student's home address. |
VARCHAR2 |
2 |
HOME_ADDR_STREET1 |
Home address, street line 1. |
VARCHAR2 |
60 |
HOME_ADDR_STREET2 |
Home address, street line 2. |
VARCHAR2 |
40 |
HOME_ADDR_ZIP |
Zip code in home address |
VARCHAR2 |
10 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
MEDICAL_PERSON_TYPE |
The types of employees included in this table: Employee-MIT Health Plans, Employee-Not MIT Health Plans, Affiliate-Postdoc/Fellow, Affiliate-Visiting |
VARCHAR2 |
30 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
9 |
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 |