.. index:: tbl1_teaching_loads =================== tbl1_teaching_loads =================== .. default-role:: doc :Relation: many-to-one on `tbl1_People` where tbl1_teaching_loads.PersonID = tbl1_People.PersonID one-to-one on `tbl1_teaching_load_reduction_types` there tbl1_teaching_load_reduction_types.ID = tbl1_teaching_loads.reduction1_type_id (optional) one-to-one on `tbl1_teaching_load_reduction_types` there tbl1_teaching_load_reduction_types.ID = tbl1_teaching_loads.reduction2_type_id (optional) :Footnote: This is part of the evolving features related to tracking instructor teaching loads. It is not widely depended on yet. This table will contain a set of fields describing instructors' teaching loads. New rows can be added to reflect the instructors' teaching load as-of a certain date. The Solutions interface processing will assume the most recent teaching load history record reflects an instructor's current status. Columns ======= **id** ``int(8) NOT NULL AUTO_INCREMENT`` :Options: ``display="true", null="true", search="false", type=""`` **PersonID** ``int(8) DEFAULT NULL`` :Description: Instructor's person id :Relation: relates to PersonID field in tbl1_People table :Options: ``display="true", null="true", search="false", type=""`` **as_of_date** ``datetime DEFAULT NULL`` :Description: teaching load status as-of this date :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=""`` **base_load** ``decimal(10,1) DEFAULT NULL`` :Description: Instructor's base teaching load :Footnote: This information and that in the following fields parallel the questions in a teaching load survey with questions designed by Mike Saks to help determine current teaching loads in our department. These fields are subject to change as we move forward with this feature's evolutions :Options: ``display="true", null="true", search="false", type=""`` **has_teaching_reduction** ``bit(1) DEFAULT b'0'`` :Description: TRUE if instructor has any sort of load reduction :Options: ``display="true", null="true", search="false", type=""`` **has_service_job_reduction** ``bit(1) DEFAULT b'0'`` :Description: TRUE if instructor has a service job reduction :Options: ``display="true", null="true", search="false", type=""`` **service_job_reduction_amount** ``decimal(10,1) DEFAULT NULL`` :Description: Load reduction amount for a service job :Options: ``display="true", null="true", search="false", type=""`` **service_job** ``varchar(255) DEFAULT NULL`` :Description: description of the service job :Footnote: worth analyzing: would it be appropriate to tie this area in with the appointments table? And then have appointments carry a standard reduction amount? I think Mike and Nishali analyzed this in the past and decided not worthwhile; however, might be worth reconsidering as we move forward. :Options: ``display="true", null="true", search="false", type=""`` **has_additional_reduction** ``bit(1) DEFAULT b'0'`` :Description: TRUE if instructor has any additional reduction :Options: ``display="true", null="true", search="false", type=""`` **additional_reduction_amount** ``decimal(10,1) DEFAULT NULL`` :Description: Additional Reduction amount :Options: ``display="true", null="true", search="false", type=""`` **additional_reduction_time_period** ``varchar(255) DEFAULT NULL`` :Description: Additional Reduction time period :Options: ``display="true", null="true", search="false", type=""`` **next_planned_sabbatical** ``varchar(255) DEFAULT NULL`` :Description: Next planned sabbatical :Options: ``display="true", null="true", search="false", type=""`` **next_sabbatical_number_semesters** ``int(8) DEFAULT NULL`` :Description: Number of semesters in next planned sabbatical :Options: ``display="true", null="true", search="false", type=""`` **teaching_load_notes** ``varchar(255) DEFAULT NULL`` :Description: additonal notes about teaching load :Options: ``display="true", null="true", search="false", type=""`` **expected_load_fall_18** ``decimal(10,1) DEFAULT NULL`` :Description: Asked on survey; obsolete now? :Options: ``display="true", null="true", search="false", type=""`` **expected_load_spring_19** ``decimal(10,1) DEFAULT NULL`` :Description: Asked on survey; obsolete now? :Options: ``display="true", null="true", search="false", type=""`` **expected_load_fall_19** ``decimal(10,1) DEFAULT NULL`` :Description: Asked on survey; obsolete now? :Options: ``display="true", null="true", search="false", type=""`` **expected_load_spring_20** ``decimal(10,1) DEFAULT NULL`` :Description: Asked on survey; obsolete now? :Options: ``display="true", null="true", search="false", type=""`` **reduction1_type_id** ``int(8) DEFAULT NULL`` :Description: id of type of 1st reduction :Relation: relates to id in `tbl1_teaching_load_reduction_types` :Options: ``display="true", null="true", search="false", type=""`` **reduction1_description** ``varchar(255) DEFAULT NULL`` :Description: Description of reduction #1 :Options: ``display="true", null="true", search="false", type=""`` **reduction1_amount** ``decimal(10,1) DEFAULT NULL`` :Description: amount of reduction #1 (# courses) :Options: ``display="true", null="true", search="false", type=""`` **reduction1_time_period** ``varchar(255) DEFAULT NULL`` :Description: time period for reduction #1 :Options: ``display="true", null="true", search="false", type=""`` **reduction2_type_id** ``int(8) DEFAULT NULL`` :Description: id of type of 2nd reduction :Footnote: relates to id in `tbl1_teaching_load_reduction_types` :Options: ``display="true", null="true", search="false", type=""`` **reduction2_description** ``varchar(255) DEFAULT NULL`` :Description: Reduction #2 description :Options: ``display="true", null="true", search="false", type=""`` **reduction2_amount** ``decimal(10,1) DEFAULT NULL`` :Description: amount of reduction #2 (# courses) :Options: ``display="true", null="true", search="false", type=""`` **reduction2_time_period** ``varchar(255) DEFAULT NULL`` :Description: time period for reduction #2 :Options: ``display="true", null="true", search="false", type=""``