tbl1_Schedule_Data¶
- Description
This table holds all of the schedule data used in Solutions.
- Footnote
This table represents the “in progress” data as semesters are being built. The tbl1_Instructors_ClassesTaught table contains similar data, but is considered “Saved”. It is recommended that in future we remove tbl1_Instructors_ClassesTaught and rely exclusively on this table (which will likely require some changes and additional fields to this table)
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
the_semester varchar(25) DEFAULT NULL
- Description
Fall, Spring or Summer
- Options
display="true", null="true", search="false", type=""
the_year smallint(6) DEFAULT NULL
- Description
Semester Year
- Options
display="true", null="true", search="false", type=""
Unit varchar(255) DEFAULT NULL
- Description
School code, for “01” for undergrad, “16” for graduate
- Options
display="true", null="true", search="false", type=""
Subject varchar(255) DEFAULT NULL
- Description
Subject Code, 640 for Math Undergrad, 640,642 or 643 for Math Graduate
- Options
display="true", null="true", search="false", type=""
Course varchar(255) DEFAULT NULL
- Description
3-digit course code
- Options
display="true", null="true", search="false", type=""
Section varchar(255) DEFAULT NULL
- Description
2-digit section number
- Footnote
For section group-header rows this will be a list or range of the associated sections
- Options
display="true", null="true", search="false", type=""
Sup# varchar(255) DEFAULT NULL
- Description
Supplement Code
- Footnote
Probably obsolete. Was included to parallel data from CSS export but I don’t think we ever used this for anything
- Options
display="true", null="true", search="false", type=""
Index varchar(255) DEFAULT NULL
- Description
5 digit course index number (blank for lecture header rows)
- Options
display="true", null="true", search="false", type=""
Course Title tinytext DEFAULT NULL
- Description
Title of course
- Options
display="true", null="true", search="false", type=""
Full Title tinytext DEFAULT NULL
- Description
Full Title (not used? from CSS when there is a longer title)
- Options
display="true", null="true", search="false", type=""
Subtitle tinytext DEFAULT NULL
- Description
Course Subtitle from CSS
- Footnote
Math Dept does not use subtitles often, but might in cases where it is a “selected topics” type of course
- Options
display="true", null="true", search="false", type=""
Credits tinytext DEFAULT NULL
- Description
Number of credits for a course
- Footnote
It is unclear if this credits field is being used for anything in this table, and this field is possibly obselete. Credits can always be looked up for a course in the tbl1_Courses table
- Options
display="true", null="true", search="false", type=""
Instructor tinytext DEFAULT NULL
- Description
Instructor Name
- Footnote
Pretty sure this is obsolete. It used to refer to course instructor, but now we would use person1_role and person1 to indicate instructor
- Options
display="true", null="true", search="false", type=""
Stop Point tinytext DEFAULT NULL
- Description
Stop point for course. This is pulled in from CSS data during sync procedure
- Options
display="true", null="true", search="false", type=""
Prior Enr# tinytext DEFAULT NULL
- Description
Prior Enrollment # for course. This is pulled in from CSS data during sync procedure
- Options
display="true", null="true", search="false", type=""
Last Offered tinytext DEFAULT NULL
- Description
Obsolete? Date course last offered.
- Footnote
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
Course Type tinytext DEFAULT NULL
- Description
Obsolete?
- Source
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
CMS Used tinytext DEFAULT NULL
- Description
Obsolete?
- Source
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
Active tinytext DEFAULT NULL
Obsolete?
- Description
“Active” code taken from CSS. 3=canceled/inactive course
- Options
display="true", null="true", search="false", type=""
Reviewed tinytext DEFAULT NULL
- Description
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
Approved tinytext DEFAULT NULL
- Description
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
BA tinytext DEFAULT NULL
- Description
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
Day varchar(255) DEFAULT NULL
- Description
This was likely here to parallel data coming out of CSS but it doesn’t look like we ever used it in Solutions
- Options
display="true", null="true", search="false", type=""
Period varchar(255) DEFAULT NULL
- Description
Period course meets. Might be a single period (eg M4) or a period pair (eg MW6)
- Options
display="true", null="true", search="false", type=""
Time (start, am/pm, End) varchar(255) DEFAULT NULL
- Description
Time value as in CSS, for example “1055 A - 1215”
- Footnote
This was column header name as it came out of CSS on its export to Excel. It is a horrible field name and should be changed!
- Options
display="true", null="true", search="false", type=""
Building tinytext DEFAULT NULL
- Description
Building Code. Possibly obsolete, BuildingRoom field used instead
- Options
display="true", null="true", search="false", type=""
Room tinytext DEFAULT NULL
- Description
Room. Possibly obsolete, BuildingRoom field used instead
- Options
display="true", null="true", search="false", type=""
Campus tinytext DEFAULT NULL
- Description
Campus code for course location
- Options
display="true", null="true", search="false", type=""
Mode tinytext DEFAULT NULL
- Description
Meeting mode of course. Corresponds to one of values in tbl1_CourseModes table
- Options
display="true", null="true", search="false", type=""
LectureRowID int(11) DEFAULT NULL
- Description
id value of lecture header row for rows that share a common lecture
- Options
display="true", null="true", search="false", type=""
last_updated datetime DEFAULT NULL
- Description
automatically set by solutions when row is saved
- Options
display="true", null="true", search="false", type=""
RoomCapacity smallint(6) DEFAULT NULL
- Description
Capacity of classroom assigned to course
- Options
display="true", null="true", search="false", type=""
ProjectedEnrollment smallint(6) DEFAULT NULL
- Description
Most recent enrollment number for the section, automatically populated during sync with CSS
- Options
display="true", null="true", search="false", type=""
change_message longtext DEFAULT NULL
- Description
Message of change detected after CSS sync
- Footnote
This is a little redundant with new tbl1_sync_log tables and we might want to redesign this. This is message that shows up as a ‘change message’ on Solutions course scheduling window to show changes detected in most recent sync. ‘Clear change messages’ will clear all values in this field
- Options
display="true", null="true", search="false", type=""
change_log longtext DEFAULT NULL
- Description
This is log of all changes detected for a row with date of each one
- Footnote
unlike the change_message field, this field keeps a change history and does not get clearned with ‘clear change messages’
- Options
display="true", null="true", search="false", type=""
summer_section_dates tinytext DEFAULT NULL
- Description
For summer courses, this is the dates the course runs
- Footnote
see also tbl1_SummerSectionDates table
- Options
display="true", null="true", search="false", type=""
Hybrid bit(1) DEFAULT NULL
- Description
TRUE if a hybrid section
- Options
display="true", null="true", search="false", type=""
Online bit(1) DEFAULT NULL
- Description
TRUE if an online course
- Options
display="true", null="true", search="false", type=""
final_group varchar(255) DEFAULT NULL
- Description
Exam group code
- Footnote
assigned from exam_code field in tbl1_Courses table
- Options
display="true", null="true", search="false", type=""
final_date datetime DEFAULT NULL
- Description
Final exam date
- Source
getfinals.py
- Footnote
assigned by Python getfinals program
- Options
display="true", null="true", search="false", type=""
final_start_time tinytext DEFAULT NULL
- Description
Final Exam start time
- Source
getfinals.py
- Options
display="true", null="true", search="false", type=""
final_end_time tinytext DEFAULT NULL
- Description
Final exam end time
- Source
getfinals.py
- Options
display="true", null="true", search="false", type=""
final_proctor1 tinytext DEFAULT NULL
- Description
Name of exam proctor
- Options
display="true", null="true", search="false", type=""
final_proctor1_email tinytext DEFAULT NULL
- Description
proctor’s email
- Options
display="true", null="true", search="false", type=""
final_proctor2 tinytext DEFAULT NULL
- Description
name of 2nd proctor
- Options
display="true", null="true", search="false", type=""
final_proctor2_email tinytext DEFAULT NULL
- Description
2nd proctor’s email
- Options
display="true", null="true", search="false", type=""
final_building_room tinytext DEFAULT NULL
- Description
Location of final exam, building-room
- Options
display="true", null="true", search="false", type=""
final_proctor1_PersonID int(11) DEFAULT NULL
- Description
Person id of first proctor
- Relation
relates to PersonID in tbl1_People table
- Options
display="true", null="true", search="false", type=""
final_proctor2_PersonID int(11) DEFAULT NULL
- Description
Person id of second proctor
- Relation
relates to PersonID in tbl1_People table
- Options
display="true", null="true", search="false", type=""
final_campus tinytext DEFAULT NULL
- Description
Final Exam location campus
- Options
display="true", null="true", search="false", type=""
proctor_notified datetime DEFAULT NULL
- Description
Date proctor was notified
- Options
display="true", null="true", search="false", type=""
Saved bit(1) DEFAULT b'0'
- Description
TRUE if record is saved. See footnote.
- Footnote
Whenever user makes a change to a row, the “Saved” flag is set to false. If user attempts to exit schedule window with unsaved records, they will be asked if they want to save. If they say yes, changes will be saved to the tbl1_Instructors_ClassesTaught table, and saved set to false. Note that this is one of the areas of Solutions where a rewrite might be in order, and this field may ultimately become obsolete.
- Options
display="true", null="true", search="false", type=""
BuildingRoom tinytext DEFAULT NULL
- Description
Location of class, building-room#
- Options
display="true", null="true", search="false", type=""
PersonID int(11) DEFAULT NULL
- Description
obsolete?
- Footnote
no longer used. Now we use personN_id fields instead
- Options
display="true", null="true", search="false", type=""
fac_current tinytext DEFAULT NULL
- Description
obsolete
- Footnote
This used to be the category of the person, this has been replaced by use of the personN_category fields
- Options
display="true", null="true", search="false", type=""
course_type tinytext DEFAULT NULL
- Description
U for undergraduate, G for graduate
- Footnote
Can probably be obsoleted since overlapping meaning with UNIT field
- Options
display="true", null="true", search="false", type=""
person1 tinytext DEFAULT NULL
- Description
Name of first assigned person in lastname, firstname format
- Options
display="true", null="true", search="false", type=""
person1_role tinytext DEFAULT NULL
- Description
Role person #1 is playing in course. Value is one listed in tbl1_Roles table
- Footnote
For first person, this role is typically “L” for lecturer, “R” for recitation instructor or “W” for workshop instructor
- Options
display="true", null="true", search="false", type=""
person1_email tinytext DEFAULT NULL
- Description
person 1 email
- Options
display="true", null="true", search="false", type=""
person1_ID int(11) DEFAULT NULL
- Description
id of first person assigned to class
- Relation
relates to PersonID field in tbl1_People table
- Footnote
This is the first of six available fields for people assigned to a course. All others are named like PersonN_id and have similar functions
- Options
display="true", null="true", search="false", type=""
person1_notified datetime DEFAULT NULL
- Description
Date person1 was notified of their assignment
- Options
display="true", null="true", search="false", type=""
person1_accepted datetime DEFAULT NULL
- Description
Date person1 accepted their assignment
- Options
display="true", null="true", search="false", type=""
person2 tinytext DEFAULT NULL
- Description
Name of second assigned person in lastname, firstname format
- Options
display="true", null="true", search="false", type=""
person2_ID int(11) DEFAULT NULL
- Description
id of 2nd person assigned to class
- Relation
relates to PersonID field in tbl1_People table
- Options
display="true", null="true", search="false", type=""
person2_role tinytext DEFAULT NULL
- Description
Role person #2 is playing in course. Value is one listed in tbl1_Roles table
- Options
display="true", null="true", search="false", type=""
person2_email tinytext DEFAULT NULL
- Description
person 2 email
- Options
display="true", null="true", search="false", type=""
person2_notified datetime DEFAULT NULL
- Description
Date person 2 was notified of their assignment
- Options
display="true", null="true", search="false", type=""
person2_accepted datetime DEFAULT NULL
- Description
Date person 2 accepted their assignment
- Options
display="true", null="true", search="false", type=""
person3 tinytext DEFAULT NULL
- Description
Name of third assigned person in lastname, firstname format
- Options
display="true", null="true", search="false", type=""
person3_ID int(11) DEFAULT NULL
- Description
id of 3rd person assigned to class
- Relation
relates to PersonID field in tbl1_People table
- Options
display="true", null="true", search="false", type=""
person3_role tinytext DEFAULT NULL
- Description
Role person #3 is playing in course. Value is one listed in tbl1_Roles table
- Options
display="true", null="true", search="false", type=""
person3_email tinytext DEFAULT NULL
- Description
Person 3 email
- Options
display="true", null="true", search="false", type=""
person3_notified datetime DEFAULT NULL
- Description
Date person 3 was notified of their assignment
- Options
display="true", null="true", search="false", type=""
person3_accepted datetime DEFAULT NULL
- Description
Date person 3 accepted their assignment
- Options
display="true", null="true", search="false", type=""
person4 tinytext DEFAULT NULL
- Description
Name of fourth assigned person in lastname, firstname format
- Options
display="true", null="true", search="false", type=""
person4_ID int(11) DEFAULT NULL
- Description
id of 4th person assigned to class
- Relation
relates to PersonID field in tbl1_People table
- Options
display="true", null="true", search="false", type=""
person4_role tinytext DEFAULT NULL
- Description
Role person #4 is playing in course. Value is one listed in tbl1_Roles table
- Options
display="true", null="true", search="false", type=""
person4_email tinytext DEFAULT NULL
- Description
Person 4 email
- Options
display="true", null="true", search="false", type=""
person4_notified datetime DEFAULT NULL
- Description
Date person 4 was notified of their assignment
- Options
display="true", null="true", search="false", type=""
person4_accepted datetime DEFAULT NULL
- Description
Date person 4 accepted their assignment
- Options
display="true", null="true", search="false", type=""
person5 tinytext DEFAULT NULL
- Description
Name of fifth assigned person in lastname, firstname format
- Options
display="true", null="true", search="false", type=""
person5_ID int(11) DEFAULT NULL
- Description
id of 5th person assigned to class
- Relation
relates to PersonID field in tbl1_People table
- Options
display="true", null="true", search="false", type=""
person5_role tinytext DEFAULT NULL
- Description
Role person #5 is playing in course. Value is one listed in tbl1_Roles table
- Options
display="true", null="true", search="false", type=""
person5_email tinytext DEFAULT NULL
- Description
person 5 eamil
- Options
display="true", null="true", search="false", type=""
person5_notified datetime DEFAULT NULL
- Description
Date person 5 was notified of their assignment
- Options
display="true", null="true", search="false", type=""
person5_accepted datetime DEFAULT NULL
- Description
Date person 5 accepted their assignment
- Options
display="true", null="true", search="false", type=""
person6 tinytext DEFAULT NULL
- Description
Name of sixth assigned person in lastname, firstname format
- Options
display="true", null="true", search="false", type=""
person6_ID int(11) DEFAULT NULL
- Description
id of 6th person assigned to class
- Relation
relates to PersonID field in tbl1_People table
- Options
display="true", null="true", search="false", type=""
person6_role tinytext DEFAULT NULL
- Description
Role person #6 is playing in course. Value is one listed in tbl1_Roles table
- Options
display="true", null="true", search="false", type=""
person6_email tinytext DEFAULT NULL
- Description
person 6 email
- Options
display="true", null="true", search="false", type=""
person6_notified datetime DEFAULT NULL
- Description
Date person 6 was notified of their assignment
- Options
display="true", null="true", search="false", type=""
person6_accepted datetime DEFAULT NULL
- Description
Date person 6 accepted their assignment
- Options
display="true", null="true", search="false", type=""
course_sort varchar(50) DEFAULT NULL
- Description
algorithmically derived sort key so that coures are sorted in correct order with lecture headers before their associated sections
- Footnote
This may be handled differently in the future
- Options
display="true", null="true", search="false", type=""
person1_category varchar(25) DEFAULT NULL
- Description
Person 1 category code taken from tbl1_Categories table
- Options
display="true", null="true", search="false", type=""
person2_category varchar(25) DEFAULT NULL
- Description
Person 2 category code taken from tbl1_Categories table
- Options
display="true", null="true", search="false", type=""
person1_netid varchar(45) DEFAULT NULL
- Description
Person 1 netid
- Options
display="true", null="true", search="false", type=""
person2_netid varchar(45) DEFAULT NULL
- Description
Person 2 netid
- 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=""