SUBJECT OFFERED EHS Table
The version of subject_offered table tailored for the EH&S Office. It contains all subjects offered by the School of Engineering, the School of Science, and Whitaker College in the most recent 3 years.
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 |
HAS_A_LAB_SECTION |
"Y" indicates that this subject has a lab section, "N" otherwise. |
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_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 |
MOST_RECENT_TERM_OFFERED |
The most recent academic term, within the latest 3 academic years, when the subject has been offered. |
VARCHAR2 |
6 |
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 |
SUBJECT_ID |
The subject ID (eg.18.01, 15.012, 21W.731) |
VARCHAR2 |
8 |
SUBJECT_TITLE |
The title of the subject |
VARCHAR2 |
100 |
WAREHOUSE_LOAD_DATE |
The date the record was loaded into the Data Warehouse from the source system. |
DATE |
8 |