Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SIS MINOR DESCRIPTION Table


Descriptions for student's minor programs


Field Name

Description

Data Type

Length

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

MINOR_CODE

Code for a minor program

VARCHAR2

4

MINOR_CODE_FOR_SORT

XXX

VARCHAR2

4

MINOR_DESCRIPTION

Description for Minor Code

VARCHAR2

60

SCHOOL_CODE

The school code for Schools at MIT, eg.: E (School of Engineering), S (Science) H (Humanities, Arts, and Social Sciences), M (Management)

VARCHAR2

2

WAREHOUSE_LOAD_DATE

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

DATE

8