WTW SUBJECT SECTION Table
This is a dimension table used in the Who-is-Teaching-What data model. The table contains information about the subjects and sections for the teaching data. There is one record per academic term per subject per section in this table.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
CLUSTER_LIST |
A list that contains all the subjects in a cluster group. Cluster groups include subjects that are joint or meet together. For example, 7.02 and 10.702 are subjects in a cluster. So are: 7.10, 20.111; 6.265, 15.070; 2.111, 8.411, 18.435; etc. |
VARCHAR2 |
3000 |
CLUSTER_TYPE |
The type of a cluster subject. Valid cluster_type are: J (joint subjects), M (subjects that meet together), S (SWE - School-Wide Electives) |
VARCHAR2 |
1 |
CLUSTER_TYPE_DESC |
The description of a cluster type |
VARCHAR2 |
30 |
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 |
MASTER_SUBJECT_ID |
The subject ID of a cluster subject group that indicates the administrative home of the subject. Cluster groups include joint, meets-with, and School-Wide Elective subjects. For example, 15.070 and 6.265 "Adv Stochastic Processes" are two joint subjects, Master Subject ID of these two subjects is 15.070 as Course 15 (Sloan School of Management) is the home department of this subject. |
VARCHAR2 |
8 |
MASTER_SUBJECT_ID_SORT |
This field is used for sorting the Master Subject ID in numeric order. |
VARCHAR2 |
8 |
MEET_PLACE |
Place (classroom) where the section/class of this subject meets |
VARCHAR2 |
15 |
MEET_TIME |
Scheduled times when the section/class of this subject meets |
VARCHAR2 |
30 |
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 |
SECTION_ENROLLMENT_NUMBER |
Number of students registered in the specific section(s) of a subject. |
VARCHAR2 |
5 |
SECTION_FORMAT |
Format of a subject section. Eg. Lecture, Lab, Design, Discussion, Recitation, Tutorial, Large Ensemble, etc. |
VARCHAR2 |
15 |
SECTION_ID |
The section code or number of the subject. Eg. L01, L02, R01, B01. |
VARCHAR2 |
3 |
SECTION_NAME |
Description associated with the Section Code. |
VARCHAR2 |
60 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_ID_SORT |
This field is used for sorting the Subject ID in numeric order. |
VARCHAR2 |
8 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
TERM_CODE |
** For FINANCIAL DATA: the Term Code identifies the status of the cost collector. Blank - open for charges between start and end dates. Term Code = 1 - Closed. Pre-end date charges allowed. Term Code = 2 - No longer in use. Term Code = 3 - Terminated. Charges not allowed. ** For STUDENT DATA: the Term Code identifies one of the terms in an academic year; for example: 1999FA==>Fall Term of the 1998-99 academic year, and 1999SP==>Spring Term of the 1998-99 academic year. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WTW_SUBJECT_GROUPING_KEY |
Use this field to join together tables WTW_SUBJECT_SECTION and WTW_SUBJECT_GROUPING to pick up all the subjects (regardless of departments) in a cluster. Example: 7.02, 10.702; 7.10, 20.111, 4.252, 11.201. |
VARCHAR2 |
32 |
WTW_SUBJECT_SECTION_KEY |
Use this field to join together tables WTW_TEACHING_DETAIL and WTW_SUBJECT_SECTION to get information about the subjects and sections for the teaching data. |
VARCHAR2 |
16 |
WTW_SUBJECT_SUMMARY_KEY |
Use this field to join together tables WTW_SUBJECT_SECTION and WTW_SUBJECT_SUMMARY. WTW_SUBJECT_SUMMARY contains data items specific to the subjects (ie. at subject level) that do not exist in WTW_SUBJECT_SECTION. |
VARCHAR2 |
14 |