ADM GRAD APPLICATION DETAIL Table
Each record in this table represents an application to a graduate program at MIT. Information included in the record: entry term, entry date, graduate program applied, degree objective, decision and reply status of the application, and name, demographic, geographical region and previously attended schools of the applicant.
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 |
ADM_GRAD_APPLICATION_KEY |
XXX |
VARCHAR2 |
10 |
ADM_GRAD_ATTD_SCH_1_KEY |
Use this field to join the ADM GRAD ATTD SCH 1 table to the ADM GRAD APPLICATION DETAIL table to get the last school attended by the applicant to attain a Bachelor Degree |
VARCHAR2 |
20 |
ADM_GRAD_ATTD_SCH_2_KEY |
Use this field to join the ADM GRAD ATTD SCH 2 table to the ADM GRAD APPLICATION DETAIL table to get the last school attended by the applicant. |
VARCHAR2 |
20 |
ADM_GRAD_CITIZENSHIP_KEY |
Graduate Admissions Citizenship Key. Use this field to join the ADM GRAD CITIZENSHIP table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
4 |
ADM_GRAD_DECISION_KEY |
Graduate Admissions Decision Status Key. Use this field to join the ADM GRAD DECISION table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
7 |
ADM_GRAD_DEGREE_OBJECTIVE_KEY |
Graduate Admissions Degree Objective Key. Use this field to join the ADM GRAD DEGREE OBJECTIVE table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
6 |
ADM_GRAD_DEMOGRAPHIC_KEY |
Graduate Admissions Demographic Key. Use this field to join the ADM GRAD DEMOGRAPHIC table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
3 |
ADM_GRAD_ENROLL_SCHOOL_KEY |
Key field used to join to the ADM_GRAD_ENROLL_SCHOOL table. This field should only be used for joining data, NOT for reporting. |
VARCHAR2 |
8 |
ADM_GRAD_FEE_STATUS_KEY |
Graduate Admissions Fee Status Key. Use this field to join the ADM GRAD FEE STATUS table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
2 |
ADM_GRAD_HOME_ADDR_GEO_KEY |
Graduate Admissions Home Address Geo Key. Use this field to join the ADM GRAD HOME ADDR GEO table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
12 |
ADM_GRAD_PROGRAM_KEY |
Graduate Admissions Program Key. Use this field to join the ADM GRAD PROGRAM table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
20 |
ADM_GRAD_REPLY_ADDR_GEO_KEY |
Graduate Admissions Reply Address Geo Key. Use this field to join the ADM GRAD REPLY ADDR GEO table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
12 |
ADM_GRAD_REPLY_KEY |
Graduate Admissions Reply Status Key. Use this field to join the ADM GRAD REPLY table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
3 |
ADM_GRAD_SURVEY_KEY |
Use this field to join together the ADM_GRAD_SURVEY and ADM_GRAD_APPLICATION_DETAIL tables for graduate admissions survey data. |
VARCHAR2 |
10 |
ADM_GRAD_TIME_KEY |
Graduate Admissions Time Key. Use this field to join the ADM GRAD TIME table to the Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL). |
VARCHAR2 |
6 |
APPLICATION_COUNT |
A counter, always contains a value of 1, used to count application. |
NUMBER |
1 |
APPLICATION_CREATED_BY |
The person who created the application record in the Graduate Admissions system. |
VARCHAR2 |
20 |
APPLICATION_CREATED_DATE |
Date when the application record was created in the Graduate Admissions system. |
DATE |
8 |
APPLICATION_RECEIVED_DATE |
Date when the application was received. |
DATE |
8 |
APPLICATION_SOURCE |
The source of origination of this application. Eg.: "Paper Form", "Collegenet online application", "WWW PDF Downloadable Form". |
VARCHAR2 |
30 |
APPLICATION_UPDATED_BY |
The person who last modified the application record in the Graduate Admissions system. |
VARCHAR2 |
20 |
APPLICATION_UPDATED_DATE |
Date when the application record was last modified in the Graduate Admissions system. |
DATE |
8 |
DECISION_MADE_OFFICIAL_BY |
The person who approves of the decision of the graduate admissions application. |
VARCHAR2 |
20 |
DECISION_OFFICIAL_DATE |
The date when the decision of the application becomes official. |
DATE |
8 |
LATEST_DECISION_DATE |
The latest date when a decision was made on the application. |
DATE |
8 |
LATEST_REPLY_DATE |
The latest date when a reply was sent in for the application. |
DATE |
8 |
ONLINE_APPLICATION_ID |
XXX |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |