CIS COURSE CATALOG Table
Curricular Information System (CIS) Course Catalog. This table contains the final version of each active subject for each academic year, whether or not it is enrollable.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ACADEMIC_YEAR |
Academic year |
VARCHAR2 |
4 |
COMM_REQ_ATTRIBUTE |
Communication INtensive GIRs (General Institute Requirement). |
VARCHAR2 |
4 |
COMM_REQ_ATTRIBUTE_DESC |
Descriptive text for COMM REQ ATTRIBUTE |
VARCHAR2 |
40 |
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 |
EFFECTIVE_TERM_CODE |
Term when latest changes to subject became effective. |
VARCHAR2 |
6 |
EQUIVALENT_SUBJECTS |
Equivalent ('credit cannot also be received for') subjects (other than Joint and SWE subjects which are always equivalent) |
VARCHAR2 |
120 |
FALL_INSTRUCTORS |
The fall term instructors of this subject as shown in bulletin. |
VARCHAR2 |
180 |
GIR_ATTRIBUTE |
General Institute Requirement (excluding communications requirement). |
VARCHAR2 |
4 |
GIR_ATTRIBUTE_DESC |
Descriptive text for GIR ATTRIBUTE |
VARCHAR2 |
40 |
GLOBAL_COUNTRIES |
Information used in the "Global Database" |
VARCHAR2 |
90 |
GLOBAL_REGIONS |
Information used in the "Global Database", eg. Africa, Asia, Europe. |
VARCHAR2 |
90 |
GRADE_RULE |
J='J'/'U' grading allowed (Continuing and Repeatable). N=Not repeatable for credit. R=Can be repeated for credit. T='T' grading allowed. |
VARCHAR2 |
1 |
GRADE_RULE_DESC |
Descriptive text for GRADE_RULE |
VARCHAR2 |
30 |
GRADE_TYPE |
L=Letter graded. P=P/D/F |
VARCHAR2 |
1 |
GRADE_TYPE_DESC |
Descriptive text of GRADE_TYPE |
VARCHAR2 |
20 |
HASS_ATTRIBUTE |
HASS attributes in use since academic year 2011. Eg. "HA", "HH", "HS", "HE", "HA,HH", etc. |
VARCHAR2 |
8 |
HASS_ATTRIBUTE_DESC |
Descriptive text for HASS Attribute |
VARCHAR2 |
40 |
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_DESC |
Descriptive text for HGN codes: U=Undergraduate, G=Graduate, H=High graduate. This IS NOT the same as HGN_CODE in SUBJECT_OFFERED. |
VARCHAR2 |
15 |
HGN_EXCEPT |
HGN Exceptions. |
VARCHAR2 |
90 |
IS_OFFERED_FALL_TERM |
Does department plan to offer this subject in fall term (of the year offered)? |
VARCHAR2 |
1 |
IS_OFFERED_IAP |
Does department plan to offer this subject in IAP (of the year offered)? |
VARCHAR2 |
1 |
IS_OFFERED_SPRING_TERM |
Does department plan to offer this subject in spring term (of the year offered)? |
VARCHAR2 |
1 |
IS_OFFERED_SUMMER_TERM |
Does department plan to offer this subject in summer term (of the year offered)? |
VARCHAR2 |
1 |
IS_OFFERED_THIS_YEAR |
Does department plan to offer this subject this year? |
VARCHAR2 |
1 |
IS_PRINTED_IN_BULLETIN |
Y/N indicates whether normally printed in the bulletin. |
VARCHAR2 |
1 |
IS_VARIABLE_UNITS |
If 'Y'=units are arranged and other units are 0; else 'N'=units are fixed. |
VARCHAR2 |
1 |
JOINT_SUBJECTS |
Joint ('same subject as') subjects. |
VARCHAR2 |
120 |
LAB_UNITS |
The number of credit units assigned for laboratory, design, or fieldwork of a subject |
NUMBER |
2 |
LAST_ACTIVITY_DATE |
Date when information in the record was last updated. |
DATE |
8 |
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 |
MEETS_WITH_SUBJECTS |
Meets-with-subjects. |
VARCHAR2 |
120 |
ON_LINE_PAGE_NUMBER |
URL or file name (eg. http://student.mit.edu/catalog/m12a.html) where subject in the On-line Listing. |
VARCHAR2 |
60 |
PREPARATION_UNITS |
The number of credit units assigned for preparatory work for a lecture of a subject. |
NUMBER |
2 |
PREREQUISITES |
Prerequisites of the subject. Co-requisites are in []. Co-requisites are subjects that a student must take at the same time as the subject. |
VARCHAR2 |
100 |
PRINT_SUBJECT_ID |
Subject number as printed in bulletin. May include 'J' indicating joint subject. |
VARCHAR2 |
50 |
SCHOOL_WIDE_ELECTIVES |
Engineering School-wide-elective (SWE) subjects. |
VARCHAR2 |
120 |
SOURCE_SUBJECT_ID |
Source of bulleetin data. Usually same as subject id or master subject number. |
VARCHAR2 |
8 |
SPRING_INSTRUCTORS |
The spring term instructors of this subject as shown in bulletin. |
VARCHAR2 |
180 |
STATUS_CHANGE |
Changes to subject. Values for activity happening th is year: New Subject/Joint Child -- subject is new this year. Reinstated Subject -- previously inactive subject, reinstated this year. Old Number: nnn.nnnn -- subject renumbered this year. Old number is shown in status change. Values for activity happening next year: YYYY: New number nnn.nnnn -- subject renumbered after this academic year. New number is shown in status change. YYYY: Removed subject/joint child -- subject removed after this academic year (ie. this is last active year). |
VARCHAR2 |
60 |
SUBJECT_CODE |
The first part of a subject ID or the course number |
VARCHAR2 |
3 |
SUBJECT_DESCRIPTION |
Description of the subject. This may not be shown at all or source may be master subject. (Enrollmenmt Limits are appended to content.) |
VARCHAR2 |
2000 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_NUMBER |
Subject Number. The right half of the Subject ID, eg. 731 of Subject ID 21W.731. 'J' is never included. |
VARCHAR2 |
4 |
SUBJECT_SHORT_TITLE |
Transcript title of the subject. |
VARCHAR2 |
30 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
SUPERVISOR_ATTRIBUTE |
Supervisor tracked attributes. |
VARCHAR2 |
4 |
SUPERVISOR_ATTRIBUTE_DESC |
Descriptive text for SUPERVISOR ATTRIBUTE |
VARCHAR2 |
40 |
TERM_DURATION |
Half term information, starting from academic year 2011. Eg. Second Half Term Subject, First Half Term Subject, Partial Term Subject, Full Term Subject |
VARCHAR2 |
30 |
TOTAL_UNITS |
Total number of credit units of a subject. |
NUMBER |
2 |
TUITION_ATTRIBUTE |
Tuition attributes. |
VARCHAR2 |
4 |
TUITION_ATTRIBUTE_DESC |
Descriptive text for TUITION ATTRIBUTE |
VARCHAR2 |
40 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |
WRITE_REQ_ATTRIBUTE |
Writing Requirement attributes. |
VARCHAR2 |
4 |
WRITE_REQ_ATTRIBUTE_DESC |
Descriptive text for WRITE REQ ATTRIBUTE |
VARCHAR2 |
40 |