ADM GRAD APPLICANT Table
View exposing graduate applicant data including applicant identifiers, names, demographic attributes, citizenship, veteran status, and contact information used for graduate admissions reporting and analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_APPLICANT_KEY |
Surrogate key identifying the adm grad applicant. |
VARCHAR2 |
8 |
CITIZENSHIP_STATUS |
Citizenship status as provided by the source. |
VARCHAR2 |
22 |
DATE_OF_BIRTH |
Date of birth associated with the applicant. |
DATE |
|
EMAIL_ADDRESS |
Email address as provided by the source. |
VARCHAR2 |
60 |
ETHNICITY |
Ethnicity as provided by the source. |
VARCHAR2 |
100 |
FIRST_NAME |
First name as provided by the source. |
VARCHAR2 |
30 |
FULL_NAME |
Full name as provided by the source. |
VARCHAR2 |
123 |
GENDER |
Gender as provided by the source. |
VARCHAR2 |
100 |
IPEDS_ETHNICITY |
Ipeds ethnicity as provided by the source. |
VARCHAR2 |
100 |
LAST_NAME |
Last name as provided by the source. |
VARCHAR2 |
60 |
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 |
Pronouns as provided by the source. |
VARCHAR2 |
100 |
VETERAN_CODE |
Code identifying veteran. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |