Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse STUDENT MINOR Table


View exposing student minor data.


Field Name

Description

Data Type

Length

DEPARTMENT_CODE

Code identifying department.

VARCHAR2

4

MINOR_DEPARTMENT_CODE

Code identifying minor department.

VARCHAR2

4

MINOR_FIELD_CODE

Code identifying minor field.

VARCHAR2

4

MINOR_FIELD_DESC

Description of minor field.

VARCHAR2

60

MIT_ID

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

VARCHAR2

9

SCHOOL

School associated with the record.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE