Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SIS SUBJECT CODE Table


Descriptions of subject codes (or course numbers) with their associated departments, and schools. (SIS=Student Information Sytems)


Field Name

Description

Data Type

Length

COURSE_NUMBER

Course number or first part of the Subject ID (such as 6, 15, 18, 21W).

VARCHAR2

3

DEPARTMENT_CODE

Code identifying an academic department, eg. 18 for "Mathematics", 6 for "Electrical Eng & Computer Sci". In the Alumni's tables, the department codes used are different from those used in MITSIS.

VARCHAR2

4

DEPARTMENT_NAME

The name of the department, school, center, or lab.

VARCHAR2

50

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

SCHOOL_NAME

The descriptive text for SCHOOL_CODE.

VARCHAR2

30

SUBJECT_CODE

The first part of a subject ID or the course number

VARCHAR2

3

SUBJECT_CODE_DESC

The descriptive text of the course number or the first part of the subject ID (eg. "6" in "6.001" or "ESD" in "ESD.523)

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

8