Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse Pre Registration


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

PRE_REG_STUDENT_STATUS

This is a dimension table for the Pre Registration Data. There is one record for an academic term that a student has pre-registered. The record contains the status information of the pre-registration process.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

PRE_REG_SUBJECT

This is a dimension table for the Pre Registration Data. It contains all the subjects that students have pre-registered for the academic term.

Dimension

MIT Student Information System

SENSITIVE

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

PRE_REG_SECTION

This is a dimension table for the Pre Registration Data. It contains all the possible sections for Lecture, Lab, Recitation, and Design that a student has pre-registered for.

Dimension

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020

PRE_REG_DETAIL

This table contains Student's Pre Registration information for the upcoming academic term. There is one record per subject a student pre-registers for the term. Pre-registration information about the subject includes the specific sections (Lecture, Recitation, Lab, Design), number of units (for a variable unit subject) the student pre-registers for, and also whether the student pre-registers the subject as a Listener, Pass/Fail, Doctor or Master Thesis, or at a Graduate Level or a Higher Level Graduate.

Fact

MIT Student Information System

SENSITIVE

Daily

08-JAN-2020