Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Grad Adm Test and Application


Tables are listed by alphabetical order. Clicking on a table name will display the fields/columns found in that table.


Table Name

Description

Type

Primary Provider

Sensitivity

Load Frequency

Last Load Date

ADM_GRAD_DECISION

This table contains all the decision status (e.g. 'Admitted','Not Admitted','Wait Listed') of the graduate admissions application.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_CITIZENSHIP

This is a dimension table used for querying the graduate admissions application data. This table contains the nationality and citizenship status of the applicants as recorded in the admissions system when the decision to the application is made official.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_APPLICANT

Graduate admissions applicants.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_DEMOGRAPHIC

This table contains the gender and ethnicity of the graduate admissions applicants which are recorded in the admissions system when the decision to the application is made official.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_TEST_TAKEN_TIME

Information about time (month and year) when the graduate admissions tests were taken.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_PROGRAM

This table contains information about graduate admissions programs, including joint programs and research areas.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_APPLICATION_DETAIL

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.

Fact

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_TIME

This table is used as a time dimension for querying the graduate admissions data. Included in this table are fields such as the expected entry term, expected entry year, expected entry month, corresponding to the academic year.

Dimension

Graduate Admissions

SENSITIVE

As Needed

03-JUL-2001

ADM_GRAD_REPLY

This table contains all the reply status (e.g. 'Accepts offer','Not enrolling','Defer Enrollment') of the graduate admissions application.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

ADM_GRAD_TEST_SCORE_DETAIL

This is a fact table which contains a record for a test score of a standardized graduate admissions test (e.g. GRE, TOEFL). The record also includes the date the test was taken and the source of the test score.

Fact

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020