TIP SUBJECT OFFERED Table
Subjects Offered offered for a particular academic Term
Field Name |
Description |
Data Type |
Length |
---|---|---|---|
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 |
IS_NO_COURSE_MATERIAL |
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 |
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 |
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 |
TIP_SUBJECT_OFFERED_KEY |
A Unique Identifier for Subject Offered (combination of subject and academic term) |
VARCHAR2 |
16 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |