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 |
PRONOUNS |
XXX |
VARCHAR2 |
100 |
VETERAN_CODE |
XXX |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |