.. index:: tbl1_SystemOptions ================== tbl1_SystemOptions ================== .. default-role:: doc :Description: System Options for Solutions Applications. Most of the fields here that are configurable are accessibly via the Solutions Database's System Options window, accessible via the little button with a globe picture on the Solutions Database's main window. :Footnote: Future: use this table for all administrative options, consolidating values from the other tables used for administrative options. Maybe with some sort of 'applies-to' column to indicate which applications care about this option Columns ======= **ID** ``int(11) NOT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **department_name** ``varchar(255) DEFAULT NULL`` :Description: Department name, in our case "Mathematics" :Footnote: For a brief moment in time I was preparing Solutions for use in Chemistry and English departments so I introducted this field so titles etc could be department-level configurable :Options: ``display="true", null="true", search="false", type=""`` **SaveScheduleMethod** ``int(11) DEFAULT NULL`` :Description: When to consider assignments officially accepted and publishable? See footnote. based on when instructor accepts their assignments :Footnote: We haven't really been using this option, although it is available on the Solutions System Options window. If we decide it isn't necessary I would recommend removing it since it adds a layer of complexity. The intention here was so we could use different methods as to when to save schedule for web publishing and permanancy and it was introduced per UGVC feedbaci. We have currently been keeping the option at value = 1. Possible values are: 1=Save instructor with course schedule only when DATE ACCEPTED is set OR more than 15 days since instructor has been notified; 2=Save Instructor with course schedule always; 3=Use method #1 for Summer only, otherwise method #2 :Options: ``display="true", null="true", search="false", type=""`` **email_identity_number_cs** ``smallint(6) DEFAULT NULL`` :Description: Email identity number (in Thunderbird settings) for user who is sending course assignments, when they want their 'from' address to reflect desired identity for this role :Footnote: For example, UGVC might want email assignments about course schedules to come from ugvc@math.rutgers.edu instead of from a personal email account :Options: ``display="true", null="true", search="false", type=""`` **email_identity_number_pr** ``smallint(6) DEFAULT NULL`` :Description: Email identity number (in Thunderbird settings) for user who is sending proctor assignments, when they want their 'from' address to reflect desired identity for this role :Footnote: For example, UGOFFICE might want email proctor assignments instead of from a staff memeber's personal email account :Options: ``display="true", null="true", search="false", type=""`` **payroll_contact_email** ``varchar(255) DEFAULT NULL`` :Description: Who should be sent an email warning when something changes in Solutions that affects payroll? (1 of 4) :Footnote: For example, if an instructor changes after they have accepted their assignment. The intention here is to not let anything fall through the cracks and ensure that instructors are removed from payroll (for example) as necessary. We have four possible contact here because different office staff may care about this sort of change for differing reasons. :Options: ``display="true", null="true", search="false", type=""`` **payroll_contact_email2** ``varchar(45) DEFAULT NULL`` :Description: Who should be sent an email warning when something changes in Solutions that affects payroll? (2 of 4) :Options: ``display="true", null="true", search="false", type=""`` **payroll_contact_email3** ``varchar(45) DEFAULT NULL`` :Description: Who should be sent an email warning when something changes in Solutions that affects payroll? (3 of 4) :Options: ``display="true", null="true", search="false", type=""`` **payroll_contact_email4** ``varchar(45) DEFAULT NULL`` :Description: Who should be sent an email warning when something changes in Solutions that affects payroll? (4 of 4) :Options: ``display="true", null="true", search="false", type=""`` **office_hours_last_imported** ``datetime DEFAULT NULL`` :Description: When were office hours last imported into Solutions? :Footnote: This is part of the export community builder data from Joomla / import into Solutions function. I am not sure anyone is actually doing this at the moment. Office hours are to be updated in Joomla by individual instructors and not editable in Solutions. This date reflects how recent the update from Joomla data to the Solutions' office hours field is. :Options: ``display="true", null="true", search="false", type=""`` **textbooks_last_imported** ``datetime DEFAULT NULL`` :Description: Date textbook list was last imported. :Footnote: This is part of the import of current textbook spreadsheet into Solutions function. I am not sure anyone is actually doing this at the moment. Office staff keeps a textbook list per course This date reflects the last time a textbook list was imported. Need to revisit this and pin down procedures, or should just obsolete this. :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=""`` **sync_instructor2** ``tinyint(1) DEFAULT 0`` :Description: if FALSE Solutions Control Center sync will skip all processing of instructor#2 (ie recitation and workshop instructors) :Footnote: This can be set in control center when viewing the sync tab. I think this was introduced so that we could turn off processing of the secondary instructors before all was tested and ready with the secondary instructor processing. So this is kind of obsolete now that everything is working; however, it might be a good idea to keep it in since we might need to go back to this mode of operation if needed. :Options: ``display="true", null="true", search="false", type=""`` **sv_to_email_address** ``varchar(45) DEFAULT NULL`` :Description: Summer Validator "TO" email address setting :Options: ``display="true", null="true", search="false", type=""`` **sv_registrar_email_address** ``varchar(45) DEFAULT NULL`` :Footnote: Summer validator uses "BCC" technique so that all recipients of emails sent will not see names of all other recipients. Value in this field will be the (public) "To" address that will appear in the email :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template1** ``text DEFAULT NULL`` :Description: Summer validator email template for email to students with more than one subject class :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template2** ``text DEFAULT NULL`` :Description: Summer validator email template for email to students with date/time conflicts :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template4** ``text DEFAULT NULL`` :Description: Summer validator email template for email to students with missing prerequisites :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template5** ``text DEFAULT NULL`` :Description: Summer validator email template for email to registrar about students with missing prerequisites :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template6** ``text DEFAULT NULL`` :Description: Summer validator email template for email to registrar about students with date/time conflicts :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template7** ``text DEFAULT NULL`` :Description: obsolete? :Options: ``display="true", null="true", search="false", type=""`` **sv_email_template8** ``text DEFAULT NULL`` :Description: Summer validator email template for email to visiting students with missing prerequisites :Options: ``display="true", null="true", search="false", type=""`` **course_url_prefix_undergraduate** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **course_url_prefix_graduate** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **syllabus_url_undergraduate** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **syllabus_url_graduate** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""`` **people_url_prefix** ``varchar(255) DEFAULT NULL`` :Options: ``display="true", null="true", search="false", type=""``