Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD APPLICANT Table


Graduate admissions applicants.


Field Name

Description

Data Type

Length

ADM_GRAD_APPLICANT_KEY

Graduate admissions applicant key. This field is used to join ADM GRAD APPLICANT table and a Graduate Admissions fact table (e.g. ADM GRAD APPLICATION DETAIL, ADM GRAD TEST SCORE DETAIL and ADM GRAD ATTENDED SCHOOL).

VARCHAR2

8

CITIZENSHIP_STATUS

Citizenship status of the applicant. Possible values are: International, Permanent Resident, US Citizen, Unknown.

VARCHAR2

30

DATE_OF_BIRTH

The person's date of birth.

DATE

8

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

IPEDS_ETHNICITY

Ethnicity as defined by IPEDS

VARCHAR2

50

LAST_NAME

The person's last name.

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

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8