Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Degrees


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

STUDENT_DEGREE

This table contains information of MIT degrees that have been awarded to students and degrees that are expected to be received by students. There is one record for a degree a student was awarded or is expected. Each record contains information such as the type of degree (eg. SB, MS, PHD), the term and date as well as the department (Course of major) of the degree awarded/expected. The DEGREE STATUS DESC field (which contains values such as 'Degree awarded', 'Degree candidate', 'Degree applicant') differentiates between an awarded and an expected degree. For an awarded degree, there are also various indicators showing if the particular degree was the first undergraduate degree, the first MIT degree, or the highest MIT degree the student received.

Dimension

MIT Student Information System

SENSITIVE

Weekly

08-JAN-2020

STUDENT_DEGREE_AWARDED

This table contains one record for a degree a student was awarded by MIT. A record contains information such as the the type of the degree (eg. SB, MS, PHD), the term and date as well as the department from which the degree was awarded.

Dimension

MIT Student Information System

SENSITIVE

Weekly

08-JAN-2020

STUDENT_DEGREE_CANDIDATE

This table contains MIT degree candidates and applicants for the upcoming degree-award term.

Dimension

MIT Student Information System

SENSITIVE

Weekly

08-JAN-2020