tbl1_SystemOptions¶
- 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=""