SUBJECT OFFERED Table
Contains all enrollable offered subjects in each academic term, since Fall Term of 1994-1995 (1995FA), as maintained on MITSIS. Data items include master subject number, subject number, section ID, and subject title. There is one record for each section (eg. Lecture, Recitation, Lab) of a subject in an academic term. Each of the subjects in this table has a record with section ID '000' that serves as the default record for the subject regardless of whether there is section information in the table for the subject.
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 |
COURSE_NUMBER_DESC |
The descriptive text for COURSE_NUMBER. Eg. "Urban Studies and Planning" for COURSE_NUMBER 11. |
VARCHAR2 |
30 |
COURSE_NUMBER_SORT |
This field is used for sorting the records by Course Number in numeric order. |
VARCHAR2 |
3 |
EVALUATE_THIS_SUBJECT |
Whether this (master) subject is to be included in the subject evaluation process. Y=Yes, N=No |
VARCHAR2 |
1 |
FORM_TYPE |
This field is used in queries for Instructor Role. Form type can have two values: E=Sci/Eng, H=Hass. |
VARCHAR2 |
1 |
FORM_TYPE_DESC |
The descriptive text for the codes in FORM TYPE. |
VARCHAR2 |
12 |
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 |
IS_CREATED_BY_DATA_WAREHOUSE |
A 'Y' in this field indicates that the subject/section record is created by the Data Warehouse to maintain data integrity between the SUBJECT ENROLLMENT DETAIL and SUBJECT OFFERED tables -- there are enrollment records in the SUBJECT ENROLLMENT DETAIL table for this subject/section, however, the subject/section record does not exist in MITSIS. |
VARCHAR2 |
1 |
IS_DESIGN_SECTION |
A flag indicating whether this subject record is a Design section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_LAB_SECTION |
A flag indicating whehter this subject record is a Lab section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_LECTURE_SECTION |
A flag indicating whether this subject record is a Lecture section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_MASTER_SECTION |
A 'Y' in this field indicates that this subject record is the "master" or the "main" record of the subject. It is not a section of the subject. It has a section ID of "000". |
VARCHAR2 |
1 |
IS_OSE_SUBJECT |
XXX |
VARCHAR2 |
1 |
IS_RECITATION_SECTION |
A flag indicating whether this subject is a Recitation section. Y=Yes, N=No |
VARCHAR2 |
1 |
IS_REPEATABLE_SUBJECT |
XXX |
VARCHAR2 |
1 |
MASTER_COURSE_NUMBER |
Course number or the first part of the Master Subject ID (such as 6, 15, 18, 21W). |
VARCHAR2 |
3 |
MASTER_COURSE_NUMBER_DESC |
The descriptive text for MASTER_COURSE_NUMBER, eg. "Urban Studies and Planning" for MASTER_COURSE_NUMBER 11. |
VARCHAR2 |
30 |
MASTER_COURSE_NUMBER_SORT |
This field is used for sorting the Master Course Number in numeric order. |
VARCHAR2 |
3 |
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 |
MASTER_SUBJECT_KEY |
A special field created in the SUBJECT OFFERED table used for joining records in SUBJECT OFFERED to records in the INSTRUCTOR ROLE DETAIL table. This field is NOT for reporting. |
VARCHAR2 |
16 |
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 |
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 |
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 |
SECTION_ENROLLMENT_NUMBER |
Number of students registered in the specific section(s) of a subject. |
VARCHAR2 |
5 |
SECTION_ID |
The section code or number of the subject. Eg. L01, L02, R01, B01. |
VARCHAR2 |
3 |
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_KEY |
Key identifying an entry in the SUBJECT OFFERED table. This field should only be used for linking tables together, NOT for reporting. |
VARCHAR2 |
16 |
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 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |