Tblx_DataToSynchronize¶
- Description
This is a temp table used in the reformatting of data pulled in from CSS export/import. The fields in this table parallel the fields that come out of CSS in it’s data export. It is somewhat obsolete (see footnote)
- Footnote
The usage of this table has been almost fully replaced by the Control Center’s automatic Sync in conjunction with the getcss.py program. However, since we still have the capability of doing the original sync method available in Solutions Database interface if needed, it may be too soon to fully obsolete this table.
Columns¶
Unit varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Subject varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Course varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Section varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Sup# varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Index varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Course Title tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Full Title tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Subtitle tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Credits tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Instructor tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Stop Point tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Prior Enr# tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Last Offered tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Course Type tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
CMS Used tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Active tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Reviewed tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Approved tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BA tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Day varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Period varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Time (start, am/pm, End) varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Building tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Room tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Campus tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Mode tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LectureRowID int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
last_updated datetime 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=""
change_message mediumtext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
change_log mediumtext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
summer_section_dates tinytext 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=""
final_group tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_date datetime DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_start_time tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_end_time tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_proctor1 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_proctor1_email tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_proctor2 tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_proctor2_email tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_building_room tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_proctor1_PersonID int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_proctor2_PersonID int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
final_campus tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
proctor_notified datetime DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Saved bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BuildingRoom tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
PersonID int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
fac_current tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
course_type tinytext 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=""