EECS STUDENT PERSONAL Table
View exposing EECS student personal and contact information including names, demographic attributes, citizenship and visa indicators, directory contact information, dorm and term addresses, and confidentiality indicators.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ATHENA_ID |
Business identifier for the athena. |
VARCHAR2 |
8 |
CITIZENSHIP_IND |
Citizenship ind associated with the record. |
VARCHAR2 |
18 |
COUNTRY_OF_ORIGIN |
Country of origin associated with the record. |
VARCHAR2 |
100 |
DATE_OF_BIRTH |
Date of birth associated with the person. |
DATE |
|
DORM_ADDRESS |
Dorm address associated with the record. |
VARCHAR2 |
30 |
DORM_PHONE |
Dorm phone associated with the record. |
VARCHAR2 |
9 |
DORM_ROOM |
Dorm room associated with the record. |
VARCHAR2 |
30 |
EMAIL_ADDRESS |
Email address associated with the record. |
VARCHAR2 |
60 |
ETHNICITY |
Ethnicity associated with the record. |
VARCHAR2 |
100 |
FIRST_NAME |
First name associated with the record. |
VARCHAR2 |
15 |
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
93 |
GENDER |
Gender associated with the record. |
VARCHAR2 |
100 |
HOME_ADDRESS1 |
Home address1 associated with the record. |
VARCHAR2 |
60 |
HOME_ADDRESS2 |
Home address2 associated with the record. |
VARCHAR2 |
60 |
HOME_CITY |
Home city associated with the record. |
VARCHAR2 |
80 |
HOME_COUNTRY |
Home country associated with the record. |
VARCHAR2 |
100 |
HOME_PHONE |
Home phone associated with the record. |
VARCHAR2 |
12 |
HOME_STATE |
Home state associated with the record. |
VARCHAR2 |
2 |
HOME_ZIP_CODE |
Home zip code associated with the record. |
VARCHAR2 |
9 |
I9_CODE |
Code identifying i9. |
VARCHAR2 |
1 |
I9_DESCRIPTION |
Description of i9. |
VARCHAR2 |
100 |
ILG |
Ilg associated with the record. |
VARCHAR2 |
3 |
IS_BIRTHDATE_CONFIDENTIAL |
Indicator identifying whether birthdate confidential (Y/N). |
VARCHAR2 |
1 |
IS_DORM_ADDR_CONFIDENTIAL |
Indicator identifying whether dorm addr confidential (Y/N). |
VARCHAR2 |
1 |
IS_DORM_PHONE_CONFIDENTIAL |
Is dorm phone confidential associated with the record. |
VARCHAR2 |
1 |
IS_E_MAIL_CONFIDENTIAL |
Indicator identifying whether e mail confidential (Y/N). |
VARCHAR2 |
1 |
IS_HOME_ADDR_CONFIDENTIAL |
Indicator identifying whether home addr confidential (Y/N). |
VARCHAR2 |
1 |
IS_HOME_PHONE_CONFIDENTIAL |
Is home phone confidential associated with the record. |
VARCHAR2 |
1 |
IS_OFFICE_ADDR_CONFIDENTIAL |
Indicator identifying whether office addr confidential (Y/N). |
VARCHAR2 |
1 |
IS_OFFICE_PHONE_CONFIDENTIAL |
Is office phone confidential associated with the record. |
VARCHAR2 |
1 |
IS_TERM_ADDR_CONFIDENTIAL |
Indicator identifying whether term addr confidential (Y/N). |
VARCHAR2 |
1 |
IS_TERM_PHONE_CONFIDENTIAL |
Is term phone confidential associated with the record. |
VARCHAR2 |
1 |
LAST_NAME |
Last name associated with the record. |
VARCHAR2 |
60 |
MIDDLE_NAME |
Middle name associated with the record. |
VARCHAR2 |
15 |
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 |
Name suffix associated with the record. |
VARCHAR2 |
20 |
OFFICE_LOCATION |
Office location associated with the record. |
VARCHAR2 |
30 |
OFFICE_PHONE |
Office phone associated with the record. |
VARCHAR2 |
9 |
TERM_ADDR_CATEGORY |
Term addr category associated with the record. |
VARCHAR2 |
3 |
TERM_CITY |
Term city associated with the record. |
VARCHAR2 |
80 |
TERM_PHONE1 |
Term phone1 associated with the record. |
VARCHAR2 |
12 |
TERM_PHONE2 |
Term phone2 associated with the record. |
VARCHAR2 |
1 |
TERM_STATE |
Term state associated with the record. |
VARCHAR2 |
2 |
TERM_STREET1 |
Term street1 associated with the record. |
VARCHAR2 |
60 |
TERM_STREET2 |
Term street2 associated with the record. |
VARCHAR2 |
60 |
TERM_STREET3 |
Term street3 associated with the record. |
VARCHAR2 |
60 |
TERM_ZIP |
Term zip associated with the record. |
VARCHAR2 |
9 |
VISA_TYPE |
Visa type associated with the record. |
VARCHAR2 |
2 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |