tbl1_Instructors_ClassesTaught¶
- Description
This table holds the saved schedule data for semesters. It is used to generate course schedule HTML that appears on math department website’s Teaching Schedule page and drives many Solutions processes and reports.
- Relation
many-to-one relation of tbl1_Instructors_ClassesTaught.Instructor_Personid to tbl1_People.PersonID many-to-one relation of tbl1_Instructors_ClassesTaught.CourseID to tbl1_Courses.CourseID many-to-one relation of all of the tbl1_Instructors_ClassesTaught.<role_name>_PersonID fields to tbl1_People.PersonID (HOWEVER: these usages might be obsolete)
- Source
Schedule data comes from CSS and lands in Solutons via synchronize process, filling tbl1_Schedule_Data table SAVE on the course schedule window saves data from tbl1_Schedule_Data into this table Please see important footnote related to this table.
- Footnote
Over time this table has become mostly functionally redundant with the tbl1_Schedule_Data table. Rewrite of Solutions to obsolete this table and rely exclusively on tbl1_Schedule_Data should be considered; however this is a large effort since this table is used all over Solutions. Please read table_transition_notes.txt in solutions_access repository for more thoughts on this.
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
Instructor varchar(255) DEFAULT NULL
- Description
Full name (last,first) of primary instructor for this row
- Options
display="true", null="true", search="false", type=""
Instructor_PersonID int(11) DEFAULT NULL
- Description
PersonID from tbl1_People table of primary instructor for this row
- Relation
many-to-one relation of tbl1_Instructors_ClassesTaught.Instructor_Personid to tbl1_People.PersonID
- Options
display="true", null="true", search="false", type=""
CourseCode varchar(255) DEFAULT NULL
- Description
8-digit course code, for example 01640115
- Options
display="true", null="true", search="false", type=""
CourseYear int(11) DEFAULT NULL
- Description
Year of semester row applies to
- Options
display="true", null="true", search="false", type=""
CourseSession varchar(255) DEFAULT NULL
- Description
Session of semester row applies to, Fall, Spring or Summer
- Options
display="true", null="true", search="false", type=""
CourseIndex varchar(255) DEFAULT NULL
- Description
5-digit index number for course
- Footnote
Lecture header rows represent more than one section. This field will be empty for these types of rows.
- Options
display="true", null="true", search="false", type=""
CourseSection varchar(255) DEFAULT NULL
- Description
Two-digit section number for the row
- Footnote
Lecture header rows represent more than one section. For these rows the field will contain either a range of sections like “01-03” or a comma-separated list in cases where the sections are non-contiguous, for example “01,03,05”
- Options
display="true", null="true", search="false", type=""
CourseCrse varchar(255) DEFAULT NULL
- Description
This is the 3-digit course code (last 3 digits of CourseCode field)
- Options
display="true", null="true", search="false", type=""
CourseUnit varchar(2) DEFAULT NULL
- Description
School code for the course
- Footnote
in Math this is 01 for undergraduate, 16 for graduate
- Options
display="true", null="true", search="false", type=""
CourseSubject varchar(3) DEFAULT NULL
- Description
3-digit subject code for course
- Footnote
in Math this is always 640 for undergraduate courses, 640, 642 or 643 for grad courses
- Options
display="true", null="true", search="false", type=""
CourseSubtitle varchar(75) DEFAULT NULL
- Description
Course Subtitle
- Footnote
This isn’t used frequently in math, but on rare occassions it is. This might be used when a course title is something general like “Selected topics in…”, and each semester a specific topic can be indicated using the subtitle field. This is entered in CSS.
- Options
display="true", null="true", search="false", type=""
CourseLR varchar(255) DEFAULT NULL
- Description
This is analogous to the mode field in tbl1_Schedule_Data and refers to the meeting type of the row. In most cases this will be “L” for lecture, “R” for recitation or “W” for workshop
- Options
display="true", null="true", search="false", type=""
CourseCounter float DEFAULT NULL
- Description
possibly obsolete. This field is assigned an amount like “1” or “.33” that was intended indicate how much each row should be counted towards an instructor’s teaching load.
- Footnote
I think this was used for the original version of the teaching load reports, but may have since been obsoleted. Need to look closer.
- Options
display="true", null="true", search="false", type=""
CourseID int(11) DEFAULT NULL
- Description
relates to CourseID in the tbl1_Courses table
- Relation
many-to-one relation of tbl1_Instructors_ClassesTaught.CourseID to tbl1_Courses.CourseID
- Options
display="true", null="true", search="false", type=""
CourseSection2 varchar(255) DEFAULT NULL
- Description
obsolete?
- Options
display="true", null="true", search="false", type=""
CourseBuildingRoom varchar(255) DEFAULT NULL
- Description
Locaton of course in format like <building-code>-<room-number>
- Footnote
It might be worth considering changing this to classroom_id which relates to tbl1_Rooms table
- Options
display="true", null="true", search="false", type=""
CourseDaysPeriod varchar(255) DEFAULT NULL
- Description
Possibly obsolete. days/period of meeting in format like “W5 0320 P - 0440”
- Options
display="true", null="true", search="false", type=""
Grader varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of grader assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Recitation_Instructor varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of recitation instructor assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Workshop_Instructor varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of workshop instructor assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
TA_At_Large varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of TA at Large assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Head_TA varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of Head TA assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Tech_Assistant varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of Tech Assistant assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Lecturer varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of lecturer assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Lecturer2 varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of secondary lecturer assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Online_Lecturer varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of online lecturer to a particular course row
- Options
display="true", null="true", search="false", type=""
Online_Recitation_Instructor varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of online recitation instructor assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Recitation_Mentor varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of recitation mentor assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Observer varchar(255) DEFAULT NULL
- Description
possibly obsolete. Name of observer assigned to a particular course row
- Options
display="true", null="true", search="false", type=""
Grader_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the grader assigned to this row.
- Options
display="true", null="true", search="false", type=""
Recitation_Instructor_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the recitation instructor assigned to this row.
- Options
display="true", null="true", search="false", type=""
Workshop_Instructor_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the workshop instructor assigned to this row.
- Options
display="true", null="true", search="false", type=""
TA_At_Large_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the TA at Large assigned to this row.
- Options
display="true", null="true", search="false", type=""
Head_TA_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the Head TA assigned to this row.
- Options
display="true", null="true", search="false", type=""
Tech_Assistant_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the tech assistant assigned to this row.
- Options
display="true", null="true", search="false", type=""
Lecturer_PersonID int(11) DEFAULT NULL
- Description
PersonID from tbl1_People corresponding to the lecturer assigned to this row.
- Footnote
Be careful. I am less sure that this field is obsolete as I am with the other *_PersonID fields. That is because I see lots of values in this field which means Solutions is saving this value when saving the data from tbl1_Schedule_Data unlike with the other *_PersonID fields. However, I will have to look closer to see whether this field value is used anywhere
- Options
display="true", null="true", search="false", type=""
Lecturer2_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the secondary lecturer assigned to this row.
- Options
display="true", null="true", search="false", type=""
Online_Lecturer_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the online lecturer assigned to this row.
- Options
display="true", null="true", search="false", type=""
Online_Recitation_Instructor_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the online recitation instructor assigned to this row.
- Options
display="true", null="true", search="false", type=""
Recitation_Mentor_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the recitation mentor assigned to this row.
- Options
display="true", null="true", search="false", type=""
Observer_PersonID int(11) DEFAULT NULL
- Description
possibly obsolete. PersonID from tbl1_People corresponding to the observer assigned to this row.
- Options
display="true", null="true", search="false", type=""
CourseBuilding varchar(50) DEFAULT NULL
- Description
Building code for building that classroom is int
- Footnote
As with the BuildingRoom field, we might want to consider replacing these fields with a relationship to the tbl1_Rooms table and a room_id field
- Options
display="true", null="true", search="false", type=""
CourseRoom varchar(50) DEFAULT NULL
- Description
Room number for classroom
- Footnote
As with the BuildingRoom field, we might want to consider replacing these fields with a relationship to the tbl1_Rooms table and a room_id field
- Options
display="true", null="true", search="false", type=""
CourseCampus varchar(50) DEFAULT NULL
- Description
Campus abbreviation
- Options
display="true", null="true", search="false", type=""
CourseTime varchar(50) DEFAULT NULL
- Description
Time of course, in format like “0600 P - 0845”
- Options
display="true", null="true", search="false", type=""
CourseDays varchar(50) DEFAULT NULL
- Description
Days this row meets, for example “MW6” for a meeting on Monday and Wednesday period 6
- Options
display="true", null="true", search="false", type=""
SIRS_Enrollment smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SIRS_Responses smallint(6) DEFAULT NULL
- Description
The number of students who submitted SIRS ratings for this section
- Options
display="true", null="true", search="false", type=""
SIRS_Q9_Response_1 smallint(6) DEFAULT NULL
- Description
How many people responded with “1” for SIRS question #9 for this section
- Footnote
Question 9 reads “I rate the teaching effectiveness of the instructor as:”
- Options
display="true", null="true", search="false", type=""
SIRS_Q9_Response_2 smallint(6) DEFAULT NULL
- Description
How many people responded with “2” for SIRS question #9 for this section
- Options
display="true", null="true", search="false", type=""
SIRS_Q9_Response_3 smallint(6) DEFAULT NULL
- Description
How many people responded with “3” for SIRS question #9 for this section
- Options
display="true", null="true", search="false", type=""
SIRS_Q9_Response_4 smallint(6) DEFAULT NULL
- Description
How many people responded with “4” for SIRS question #9 for this section
- Options
display="true", null="true", search="false", type=""
SIRS_Q9_Response_5 smallint(6) DEFAULT NULL
- Description
How many people responded with “5” for SIRS question #9 for this section
- Options
display="true", null="true", search="false", type=""
SIRS_Q9_Response_none smallint(6) DEFAULT NULL
- Description
How many people did not respond to SIRS question #9 for this section
- Options
display="true", null="true", search="false", type=""
SIRS_Sec_Weighted_Mean float DEFAULT NULL
- Description
SIRS section weighted mean
- Options
display="true", null="true", search="false", type=""
SIRS_Course_Weighted_Mean float DEFAULT NULL
- Description
SIRS course weighted mean
- Options
display="true", null="true", search="false", type=""
SIRS_Level_Weighted_Mean float DEFAULT NULL
- Description
SIRS level weighted mean
- Options
display="true", null="true", search="false", type=""
SIRS_Dept_Weighted_Mean float DEFAULT NULL
- Description
SIRS department weighted mean
- Options
display="true", null="true", search="false", type=""
Enrollment int(11) DEFAULT NULL
- Description
Section’s most recent enrollment number
- Options
display="true", null="true", search="false", type=""
LectureRowID int(11) DEFAULT NULL
- Description
for recitation or workshop rows, this is the id of the associated lecture row in this table
- Options
display="true", null="true", search="false", type=""
InProgress_LectureRowID int(11) DEFAULT NULL
- Description
obsolete?
- Footnote
This is confusing and may be obsolete now, not sure. This field was used to keep track of data in tbl1_Schedule_Data in relation to this table when saving and creating lecture groups. I’m not sure if it is still used now that we have switched to the newer version of sync. As recommended in the table_transitions document, if we end up obsoleting this table, it is a non-issue.
- Options
display="true", null="true", search="false", type=""
Hybrid bit(1) DEFAULT NULL
- Description
TRUE when a hybrid section
- Options
display="true", null="true", search="false", type=""
Online bit(1) DEFAULT NULL
- Description
TRUE when an online course
- Options
display="true", null="true", search="false", type=""
section_url varchar(255) DEFAULT NULL
- Description
When building course schedule HTML, any URL specified in this field for a section will cause Solutions to make the section number a hyperlink to the given URL instead of just secton text
- Footnote
Each semester office staff sends an email with a link where instructors can submit this URL. They can then just copy/paste the link into this field in Solutions interface. (There is also a batch import option, although staff is not in the habit of using this) Ask office staff for more details on how this works.
- Options
display="true", null="true", search="false", type=""
section_textbook varchar(255) DEFAULT NULL
- Description
Name of textbook for a section if it differs from the default textbook in the tbl1_Courses table for the associated course
- Options
display="true", null="true", search="false", type=""
HideFromWeb bit(1) DEFAULT NULL
- Description
Set to TRUE for any sections that for whatever reason we want to exclude when generating HTML for web schedules
- Options
display="true", null="true", search="false", type=""
course_sort varchar(50) DEFAULT NULL
- Description
This is a sort key algorithmically derived to ensure that rows in this table appear with lecture group headers followed by their associated sections. See table_transition_notes.txt for more details on this
- Options
display="true", null="true", search="false", type=""
instructor_category varchar(25) DEFAULT NULL
- Description
Instructor’s category abbreviation which will be one of the categories in the tbl1_Categories table
- Footnote
The reason we need a category field in this table instead of just in the tbl1_People table is because an instructors’ category might change, and Solutions reports often need to know the number of instructors per category IN A GIVEN SEMESTER
- Options
display="true", null="true", search="false", type=""
instructor2_category varchar(25) DEFAULT NULL
- Description
obsolete? category for secondary instructor
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""