Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Subject Enrollment


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

23-APR-2024

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

23-APR-2024

SUBJECT_REG_STATUS

Subject registration status codes and descriptions

Dimension

MIT Student Information System

SENSITIVE

Daily

23-APR-2024

SUBJECT_ENROLLMENT_DETAIL

Contains subject registration/enrollment information, ie. The "Class List". In this table, there is one record for a section of a subject which a student has registered for the academic term. For subjects that do not "section" the enrollment of student, the enrollment records are marked with a section ID of '000'.

Fact

MIT Student Information System

SENSITIVE

Daily

23-APR-2024

ACADEMIC_TERMS

Information pertaining to academic terms

Dimension

MIT Student Information System

PUBLIC

Daily

23-APR-2024