Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse WTW SUBJECT SUMMARY Table


This is a dimension table used in the Who-is-Teaching-What data model. The table contains information about the subjects for the teaching data. Unlike WTW_SUBJECT_SECTION, this table DOES NOT contain section information of the subjects. There is one subject per term in this table.


Field Name

Description

Data Type

Length

CLUSTER_ENROLLMENT_NUMBER

Number of students registered in the cluster which contains 2 or more subjects. (Eg. 7.02, 10.702; 4.252, 11.201; 6.580, 20.305, 20.405; 2.050, 12.006, 18.353.)

NUMBER

5

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

DESIGN_UNITS

Engineering design points

NUMBER

2

LAB_UNITS

The number of credit units assigned for laboratory, design, or fieldwork of a subject

NUMBER

2

LECTURE_UNITS

The number of credit units assigned for lecture and recitation of a subject.

NUMBER

2

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

PREP_UNITS

Total units for preparation of the course

NUMBER

5

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_ENROLLMENT_NUMBER

Number of students registered in the subject, regardless of which section(s) the students are sectioned in.

NUMBER

5

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

TOTAL_UNITS

Total number of credit units of a subject.

NUMBER

2

ULT_MASTER_SUBJECT_ID

Ultimate master subject id. The master subject of a cluster of subjects of which one or more of these subjects can also be a master subject of another subject. Master subject is the member of a cluster subject group that indicates the administrative home of the subject.

VARCHAR2

8

ULT_MASTER_SUBJECT_ID_SORT

XXX

VARCHAR2

12

WAREHOUSE_LOAD_DATE

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

DATE

8

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