Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Grad Adm 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_DEGREE_OBJECTIVE

Initial and final degree objectives of the graduate admissions application.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

ADM_GRAD_ATTD_SCH_2

This table contains information about the previously school/college attended by the graduate admissions applicant. Usually this is the last/latest school attended by the applicant, and most probably from which the applicant received an advanced (or post-undergraduate) degree.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

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-NOV-2024

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-NOV-2024

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_FEE_STATUS

Application fee status of the graduate admissions application.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

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-NOV-2024

ADM_GRAD_HOME_ADDR_GEO

The geographical region of the applicant's home address.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

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-NOV-2024

ADM_GRAD_PROGRAM

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

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

ADM_GRAD_APPLICANT

Graduate admissions applicants.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

ADM_GRAD_ATTD_SCH_1

This table contains information about the previously school/college attended by the graduate admissions applicant. Usually this is the school from which the applicant received a bachelor degree.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024

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-NOV-2024

ADM_GRAD_REPLY_ADDR_GEO

The geographical region of the applicant's reply address.

Dimension

Graduate Admissions

SENSITIVE

Weekly

08-NOV-2024