Tbl1_Schedule_Data_Unformatted

Description

This table is used to hold data as it is imported from CSS. Obsolete?

Footnote

This table was used for holding data that is exported from CSS in Excel format and then imported into Solution. Since we have switched to new procedures where new semesters are imported via Control Center, this table is typically not used. However, since at time of writing this the Solutions Database still has the option to import semesters directly, this table might still be needed in those cases.

Columns

the_semester varchar(255) 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(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 tinytext DEFAULT NULL

Options

display="true", null="true", search="false", type=""

Period tinytext DEFAULT NULL

Options

display="true", null="true", search="false", type=""

Time (start, am/pm, End) tinytext 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=""