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 |