Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse 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