Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PRE REG SECTION Table


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.


Field Name

Description

Data Type

Length

ASSIGNED_DESIGN_SECTION

The scheduled or assigned design section for the subject.

VARCHAR2

3

ASSIGNED_LAB_SECTION

The scheduled or assigned lab section for the subject.

VARCHAR2

3

ASSIGNED_LECTURE_SECTION

The scheduled or assigned lecture section for the subject.

VARCHAR2

3

ASSIGNED_RECITATION_SECTION

The scheduled or assigned recitation section for the subject.

VARCHAR2

3

PRE_REG_SECTION_KEY

Use this field to join between the PRE REG DETAIL and the PRE REG SECTION tables.

VARCHAR2

15

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8