css_sync_options¶
- Description
This table is used to tell Solutions how instructor to/from Solutions and CSS should be handled based on the course unit and subject
Columns¶
id int(11) NOT NULL AUTO_INCREMENT
- 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=""
unit varchar(45) DEFAULT NULL
- Description
two-digit code to represent undergraduate (01) or graduate (16) courses
- Options
display="true", null="true", search="false", type=""
subject varchar(45) DEFAULT NULL
- Description
three-digit code representing subject. math = 640 but we also use 642 and 643 for graduate courses
- Options
display="true", null="true", search="false", type=""
reset_instructors tinyint(4) DEFAULT 0
- Description
If set to TRUE, instructors will be flagged to be blanked out in CSS when new semester is started in Solutions If set to FALSE, instructors will not be blanked out. We needed this option because the graduate and undergraduate programs are on different timeframes and handle instructors differently. When an undergraduate semester is started, our procedure is to blank out all of the instructors in CSS and start fresh (so TRUE). But for graduate schedules, instructors are often set from last year and are already fixed for that semester, so should not be automatically blanked out (so FALSE)
- Options
display="true", null="true", search="false", type=""
instructor_update_type int(11) DEFAULT 2
- Description
This tells Solutions how to handle instructor updates based on department procedures, Possible values are: 0 = always replace CSS instructor with Solutions Instructor 1 = always replace Solutions instrutccor with CSS Instructor 2 = make no updates, just report warning. In math, we typically will have update type 0 for 01:640, 1 for 16:640 and 16:642. Math Finance (16:643) is currently set to 2 because those procedures haven’t been analyzed yet. If set to 0, Solutions Sync will stage changed instructors for automatic CSS update (later to be picked up by the putcss.py program, see table descriptions for css_sections and css_upload) If set to 1, Solutions Sync will automatically update the Solutions database.
- Options
display="true", null="true", search="false", type=""