Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT REG PREREG COURSE8 Table


XXX


Field Name

Description

Data Type

Length

PRE_REGISTERED

XXX

NUMBER

REGISTERED_COMPLETED

XXX

NUMBER

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