EECS STUDENT PERSONAL Table
Student biographic and address information specific to EECS students. For use by EECS users only. Included in this table are terms from the current and prior academic years.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ATHENA_ID |
Kerberos name. |
VARCHAR2 |
8 |
CITIZENSHIP_IND |
Status of US Citizenship. Values are: US Citizen, US Permanent Resident, International, and Unknown. |
VARCHAR2 |
30 |
COUNTRY_OF_ORIGIN |
Country of origin |
VARCHAR2 |
40 |
DATE_OF_BIRTH |
The person's date of birth. |
DATE |
8 |
DORM_ADDRESS |
The student's on-campus dormitory name and street address. |
VARCHAR2 |
30 |
DORM_PHONE |
The student's on-campus dormitory phone number. |
VARCHAR2 |
20 |
DORM_ROOM |
The student's on-campus dormitory room number. |
VARCHAR2 |
10 |
EMAIL_ADDRESS |
A person's complete electronic mail address including user name and node name, for example, username@school.edu. |
VARCHAR2 |
60 |
ETHNICITY |
Ethnicity |
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 |
HOME_ADDRESS1 |
Street number and street name. |
VARCHAR2 |
30 |
HOME_ADDRESS2 |
Additional address information. |
VARCHAR2 |
30 |
HOME_CITY |
The person's home city. |
VARCHAR2 |
30 |
HOME_COUNTRY |
The person's home country. |
VARCHAR2 |
30 |
HOME_PHONE |
The person's home telephone number. |
VARCHAR2 |
20 |
HOME_STATE |
The person's home state. |
VARCHAR2 |
2 |
HOME_ZIP_CODE |
The person's home zip code. |
VARCHAR2 |
9 |
I9_CODE |
Codes represent the status of the I9 (Employment Eligibility Verification) form. |
VARCHAR2 |
1 |
I9_DESCRIPTION |
Descriptive text for the codes represent the status of the I9 Form. |
VARCHAR2 |
50 |
ILG |
The Independent Living Group the student is associated with |
VARCHAR2 |
3 |
IS_BIRTHDATE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her date of birth information kept confidential. |
VARCHAR2 |
1 |
IS_DORM_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her dorm address kept confidential. |
VARCHAR2 |
5 |
IS_DORM_PHONE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her dorm phone kept confidential. |
VARCHAR2 |
5 |
IS_E_MAIL_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her email address kept confidential. |
VARCHAR2 |
5 |
IS_HOME_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her home address kept confidential. |
VARCHAR2 |
5 |
IS_HOME_PHONE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her home phone information kept confidential. |
VARCHAR2 |
1 |
IS_OFFICE_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her office address kept confidential. |
VARCHAR2 |
5 |
IS_OFFICE_PHONE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her office phone kept confidential. |
VARCHAR2 |
5 |
IS_TERM_ADDR_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her term address kept confidential. |
VARCHAR2 |
5 |
IS_TERM_PHONE_CONFIDENTIAL |
A "Y" or "S" in this field indicates that the student wants his/her term phone kept confidential. |
VARCHAR2 |
5 |
LAST_NAME |
The person's last name. |
VARCHAR2 |
30 |
MIDDLE_NAME |
The person's middle name (where available). |
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 |
NAME_SUFFIX |
Contains suffixes that may be appended to the last name, examples include: Jr., Sr., II, III, IV, etc. It is not used for honorifics such as "MD, Esq, PhD" etc. |
VARCHAR2 |
15 |
OFFICE_LOCATION |
The person's primary office address at MIT. |
VARCHAR2 |
30 |
OFFICE_PHONE |
The person's primary office telephone number at MIT. |
VARCHAR2 |
20 |
TERM_ADDR_CATEGORY |
The address category of the student's current term address. For students who live in dormitories or housing facilities of the Independent Living Groups (ILG), this field contains their dormitory codes (eg. RAN, SID, SH) and ILG codes (eg. WILG, PKT), respectively. For others, the category codes may be: OFF (for Off campus), ONC (for on-campus office/lab), etc. |
VARCHAR2 |
3 |
TERM_CITY |
The student's home city for a term. |
VARCHAR2 |
40 |
TERM_PHONE1 |
The student's home telephone number for the current term. |
VARCHAR2 |
20 |
TERM_PHONE2 |
The student's home telephone number for the current term. |
VARCHAR2 |
20 |
TERM_STATE |
The student's home state for the current term. |
VARCHAR2 |
2 |
TERM_STREET1 |
The student's home street address for the current term. Line 1. |
VARCHAR2 |
30 |
TERM_STREET2 |
The student's home street address for the current term. Line 2. |
VARCHAR2 |
30 |
TERM_STREET3 |
The student's home street address for the current term. Line 3. |
VARCHAR2 |
30 |
TERM_ZIP |
The student's home zip code for the current term. |
VARCHAR2 |
9 |
VISA_TYPE |
A description of the type of visa a person holds. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |