tbl1_schedule_inbound_from_css¶
- Description
This table is used for the Control Center Sync procedure. Most fields in this table parallel the fields in tbl1_Schedule_Data so please look at that table for more specifcs. Also refer to footnote for more info.
- Footnote
This table was introduced into Solutions so that new sync procedures available after implementing getcss.py and Solutions Conrol Center Sync could be transitioned seamlessly without rewriting all of the sync code. So currently in sync procedure:
(i) data comes from css_sections and is reformatted and moved into this table
(ii) data in this table is compared with data in tbl1_Schedule_Data to find discrepances
(iii) discrepances are written to css_upload table (which is a copy of what is in css_sections with these chnages)
In future, may want to rewrite the above steps to skip need of this table altogether
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
the_semester varchar(25) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
the_year smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Unit varchar(2) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Subject varchar(3) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Course varchar(3) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Section varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Sup# varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Index varchar(5) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Course Title varchar(127) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Full Title varchar(127) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Subtitle varchar(127) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Credits varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Instructor varchar(127) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Stop Point varchar(3) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Prior Enr# varchar(3) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Last Offered varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Course Type varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
CMS Used varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Active varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Reviewed varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Approved varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BA varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Day varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Period varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Time (start, am/pm, End) varchar(31) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Building varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Room varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Campus varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Mode varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
RoomCapacity smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ProjectedEnrollment smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Hybrid bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Online bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BuildingRoom varchar(15) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
course_type varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
person1 varchar(127) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
person1_netid varchar(45) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
person1_role varchar(7) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
person1_ID int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
course_sort varchar(50) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LeadSection varchar(2) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
LectureRowID int(11) DEFAULT NULL
- 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=""