Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Grad Adm Schools Attended


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_APPLICANT

Graduate admissions applicants.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-JAN-2020

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_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_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_ATTENDED_SCHOOL

This table contains information about all the previously attended schools of the graduate admissions applicant. There is one record for a school attended. Join this table with ADM_GRAD_APPLICANT by adm_grad_applicant_key to get all the schools previously attended by the applicant.

Fact

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