.. index:: tbl1_Schedule_Data ================== tbl1_Schedule_Data ================== .. default-role:: doc :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=""``