SUBJECT OFFERED SUMMARY Table
Contains all enrollable offered subjects in each academic term, since Fall Term of 1994-95 (1995FA), as maintained on MITSIS. Data items include master subject number, subject number, subject title, offer department, and number of units. There is one record for a subject in an academic term. The table does not contain any section information.
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 |
COMPOSITE_SUBJECT_KEY |
XXX |
VARCHAR2 |
14 |
COURSE_NUMBER |
Course number or first part of the Subject ID (such as 6, 15, 18, 21W). |
VARCHAR2 |
3 |
HGN_CODE |
Code indentifies whether the subject can be taken at a graduate level: H (Higher level graduate program), G (Graduate program), N (Not for Graduate Credit). |
VARCHAR2 |
1 |
HGN_CODE_DESC |
Descriptive text for HGN_CODE which identifies whether the subject can be taken at a graduate level. H=Highler level graduate program; G=Graduate program; N=Not for graduate credit. |
VARCHAR2 |
30 |
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 |
NUM_ENROLLED_STUDENTS |
Number of students enrolled in the section of the subject |
NUMBER |
5 |
OFFER_DEPT_CODE |
The academic department which offers the subject/course |
VARCHAR2 |
4 |
OFFER_DEPT_NAME |
The name of the academic department which offers the subject/course |
VARCHAR2 |
30 |
OFFER_SCHOOL_NAME |
The school, for example "Architecture and Planning", which offers the subject. |
VARCHAR2 |
30 |
PREPARATION_UNITS |
The number of credit units assigned for preparatory work for a lecture of a subject. |
NUMBER |
2 |
RESPONSIBLE_FACULTY_MIT_ID |
MIT ID of a faculty member/administrator who is responsible for the subject/class. |
VARCHAR2 |
9 |
RESPONSIBLE_FACULTY_NAME |
The name of a faculty member/administrator who is responsible for the subject/class |
VARCHAR2 |
60 |
SUBJECT_ENROLLMENT_NUMBER |
Number of students registered in the subject, regardless of which section(s) the students are sectioned in. |
NUMBER |
5 |
SUBJECT_GROUPING_KEY |
Use this field to join together the Subject Grouping, Subject, Subject Enrollment tables. |
VARCHAR2 |
32 |
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_OFFERED_SUMMARY_KEY |
Use this field to join together the Subject and Subject Enrollment tables. |
VARCHAR2 |
14 |
SUBJECT_SUMMARY_KEY |
Use this field to join together the Subject and Subject Enrollment tables. |
VARCHAR2 |
14 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |