Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Student Minors


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

STUDENT_CURRENT_ENROLLMENT

This table contains the current academic term enrollment/registration information. It is a simplified version of STUDENT_TERM_ENROLLMENT.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

STUDENT_MINOR_FIELD

A dimension table used together with fact table STUDENT_MINOR_DETAIL. It contains the characteristics of a minor field, including the minor field (eg. Music, Compartive Media Studies, Architecture, Biomedical Engineering, Chinese, Economics), minor type (Proposed, Completed), minor sequence (Minor 1 or Minor 2), the department offers the minor (eg. HASS, Sloan, Physics, etc.)

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

ACADEMIC_TERMS

Information pertaining to academic terms

Dimension

MIT Student Information System

PUBLIC

Daily

08-JAN-2020

STUDENT_MINOR_DETAIL

This fact table contains all the proposed and completed minors of the students. It also includes the minor start term and expected graduation term.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020