Data Warehouse

ENROLLMENT_KEY

Use this field to join the STUDENT TERM ENROLLMENT table with another student table which contains the same-name KEY field. This field should only be used for joining tables, not for reporting.

VARCHAR2

15

MASTER_SUBJECT_ID

The subject ID of a cluster subject group that indicates the administrative home of the subject. Cluster groups include joint, meets-with, and School-Wide Elective subjects. For example, 15.070 and 6.265 "Adv Stochastic Processes" are two joint subjects, Master Subject ID of these two subjects is 15.070 as Course 15 (Sloan School of Management) is the home department of this 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

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

VARCHAR2

15

PRE_REG_STUDENT_STATUS_KEY

Use this field to join between the PRE REG DETAIL table and the PRE REG STUDENT STATUS table.

VARCHAR2

15

PRE_REG_SUBJECT_KEY

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

VARCHAR2

15

SED_REG_STATUS

XXX

VARCHAR2

40

SED_REG_STATUS_DATE

XXX

DATE

SED_SUBJECT_KEY

XXX

VARCHAR2

16

SUBJECT_ID

The subject ID (eg.18.01, 15.012, 21W.731)

VARCHAR2

8

TERM_CODE

** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year.

VARCHAR2

6

WAREHOUSE_LOAD_DATE

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

DATE