Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse SUBJECT ENROLLABLE Table


Enrollable subjects by academic terms. No section information, and not including non-MIT subjects. This table contains a small number of fields, and it does not include descriptive fields. For a more complete listing, see the SUBJECT_OFFERED_SUMMARY or the SUBJECT_OFFERED tables. The ULT_MASTER_SUBJECT_ID in this table maybe helpful in tracking clusters of subjects that contain both "Joint" and "Meet with" subjects.


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

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

OFFER_DEPT_CODE

The academic department which offers the subject/course

VARCHAR2

4

OFFER_SCHOOL_CODE

The school which offers the subject -- eg. 'E' for the School of Engineering, 'S' for the School of Science, 'H' for the School of Humanities, Arts, and Social Sciences, 'M' for the Sloan School of Management, 'A' for the School of Architecture and Planning.

VARCHAR2

2

SUBJECT_GROUP_ID

System generated ID. Subjects in the same cluster for the academic term have the same ID.

VARCHAR2

32

SUBJECT_ID

The subject ID (eg.18.01, 15.012, 21W.731)

VARCHAR2

8

SUBJECT_TITLE

The title of the subject

VARCHAR2

100

SUBJECT_TITLE_LONG

A slightly longer subject title.

VARCHAR2

150

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

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

WAREHOUSE_LOAD_DATE

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

DATE

8