Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Graduate Awards


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

GRADUATE_AWARDING_DEPARTMENT

The dimension table consists of all the academic departments and their schools at MIT. Limit on the awarding department fields in this table, and join it to the GRADUATE AWARD TERM DETAIL table for graduate awards that are awarded by the specific department.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

GRADUATE_AWARD_TERM_DETAIL

This table contains information about graduate awards and appointments, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship). Each graduate appointment/award includes information about the student, the amount, the status of the award, the fund type (Tuition, Stipend, Insurance), the cost object and GL which the award is charged to, and the awarding department. Each of the graduate award/appointment is set up by academic terms (Summer, Fall, Spring) for the financial aid year. This table may be joined together with the GRADUATE_AWARD_WORK_AREA table to get more information about the supervisor for which the graduate student is a TA or RA.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

GRADUATE_AWARD_WORK_AREA

This table contains work area information (such as the the supervisor/faculty for which the graduate student is a TA or RA) about a graudate award.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

GRADUATE_APPOINTMENT_TYPE

This dimension table contains the definitions for the various types of graduate student appointment (e.g. Fellowship, Reseach Assistant, Teaching Assistant) and the associated fund type (Tuition, Stipend, Insurance) and fund/award status (Actual, Cancelled, etc.)

Dimension

MIT Student Information System

SENSITIVE

As Needed

28-MAR-2002

STUDENT_TERM_ENROLLMENT

Contains data about the student's registration status, by academic term. There is one enrollment record for a student per academic term.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

GRADUATE_AWARD_APPOINTMENT

This dimension table consists of all the graduate appointments/awards, ie. RA (Research Assistant), TA (Teaching Assistant), and FE (Fellowship) created for the graduate students. There is one record per appointment.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020