Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT PROCUREMENT Table


View exposing student procurement data.


Field Name

Description

Data Type

Length

CURRENT_TERM_CODE

Code identifying current term.

VARCHAR2

6

IS_ELIGIBLE_TO_REGISTER

Indicator identifying whether eligible to register (Y/N).

VARCHAR2

1

LATEST_TERM_CODE

Code identifying latest term.

VARCHAR2

6

MIT_ID

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

VARCHAR2

9

STUDENT_YEAR

Student year associated with the record.

VARCHAR2

1

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE