tbl1_teaching_loads

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