Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Subject Enrollment with Grades


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

SUBJECT_OFFERED

Contains all enrollable offered subjects in each academic term, since Fall Term of 1994-1995 (1995FA), as maintained on MITSIS. Data items include master subject number, subject number, section ID, and subject title. There is one record for each section (eg. Lecture, Recitation, Lab) of a subject in an academic term. Each of the subjects in this table has a record with section ID '000' that serves as the default record for the subject regardless of whether there is section information in the table for the subject.

Dimension

MIT Student Information System

MIT ONLY

Daily

08-JAN-2020

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

SUBJECT_ENROLL_GRADED_DETAIL

Subject enrollment records (or class lists) with grades.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

SUBJECT_REG_STATUS

Subject registration status codes and descriptions

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020