Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse PRE REG LOADED SED STELLAR Table


View exposing loaded pre-registration selection records from Stellar-related processes including student enrollment demand attributes.


Field Name

Description

Data Type

Length

ENROLLMENT_KEY

Surrogate key identifying the enrollment.

VARCHAR2

15

MASTER_SUBJECT_ID

Business identifier for the master subject.

VARCHAR2

8

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

PRE_REG_SECTION_KEY

Surrogate key identifying the pre reg section.

VARCHAR2

15

PRE_REG_STUDENT_STATUS_KEY

Surrogate key identifying the pre reg student status.

VARCHAR2

15

PRE_REG_SUBJECT_KEY

Surrogate key identifying the pre reg subject.

VARCHAR2

15

SED_REG_STATUS

Sed reg status associated with the record.

VARCHAR2

40

SED_REG_STATUS_DATE

Date associated with sed reg status.

DATE

SED_SUBJECT_KEY

Surrogate key identifying the sed subject.

VARCHAR2

16

SUBJECT_ID

Business identifier for the subject.

VARCHAR2

8

TERM_CODE

Term code associated with the record.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE