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