Dict-Physical

View VMF_FacultyWorkloadActivity

Card of view VMF_FacultyWorkloadActivity

Name	VMF_FacultyWorkloadActivity
Comment	Artificial fact view built out of MF_FacultyNonTeachingAssignment and MF_TeachSection. Intended to facilitate faculty workload reporting by treating non-teaching assignments and teaching assignments identically. See also VMD_FacultyAssignment. The information in this view should generally only be utilized via an OLAP cube, because it is inefficiently implemented in the relational database. Please note, though, that although this cube can be used to create faculty workload reports that look like the traditional, printed ones we used until 2010, the data will be organized somewhat differently. In particular, if you break the report up by the primary department of the instructor, you may find the same instructor in multiple places, because instructors do change departments. If, therefore, you want workloads by department, then by all means break the workloads up by department. But if you want workloads by person, then organize them by person.
Dimensional Type	Fact

SQL query of the view VMF_FacultyWorkloadActivity

(select
MD_CollPers_SurrogateKey,
MD_CarlTerm_SurrogateKey,
'O' + CAST(MD_CarlOrg_SurrogateKey AS VARCHAR(32)) AS MD_FacAsgn_SurrogateKey,
MD_CarlOrg_SurrogateKey,
(SELECT MD_Sect_SurrogateKey FROM MD_Section WHERE MD_Sect_Name = 'UNKN.9999.99') AS MD_Sect_SurrogateKey,
MF_NonTeachAsgn_Workload AS MF_FacLoad_Workload,
0 AS MF_FacLoad_Enrolled,
0 AS MF_FacLoad_Credits
from
MF_FacultyNonTeachingAssignment)

union

(select
mft.MD_CollPers_SurrogateKey,
mft.MD_CarlTerm_SurrogateKey,
'S' + CAST(mft.MD_Sect_SurrogateKey AS VARCHAR(32)) AS MD_FacAsgn_SurrogateKey,
(SELECT MD_CarlOrg_SurrogateKey FROM MD_CarletonOrganization WHERE MD_CarlOrg_Name = 'Unknown') AS MD_CarlOrg_SurrogateKey,
mft.MD_Sect_SurrogateKey,
mft.MF_TeachSect_Load AS MF_FacLoad_Workload,
mfs.MF_SectSeatBT_Enrolled AS MF_FacLoad_Enrolled,
mft.MF_TeachSect_CreditsTaught AS MF_FacLoad_Credits
from
MF_TeachSection mft
INNER JOIN MF_SectionSeatsByTerm mfs
ON mft.MD_CarlTerm_SurrogateKey = mfs.MD_CarlTerm_SurrogateKey
AND mft.MD_Sect_SurrogateKey = mfs.MD_Sect_SurrogateKey)

List of outgoing view references of the view VMF_FacultyWorkloadActivity

ViewReference_98

VMD_Instructor (Shortcut)

ViewReference_99

VMD_CarlTerm (Shortcut)

ViewReference_100

VMD_FacultyAssignment

List of diagrams containing the view VMF_FacultyWorkloadActivity

ViewsFacultyDiagram

List of permissions of the view VMF_FacultyWorkloadActivity

SELECT,VIEW DEFINITION

FacultyReader

List of view columns of the view VMF_FacultyWorkloadActivity

MD_COLLPERS_SURROGATEKEY

MD_CARLTERM_SURROGATEKEY

MD_FACASGN_SURROGATEKEY

MD_CARLORG_SURROGATEKEY

MD_SECT_SURROGATEKEY

MF_FACLOAD_WORKLOAD

This workload value is a bit different from the HR workload figure. HR is concerned with overall FTE value for a given position, or a given individual. Here the workload is only the total workload for courses and committees/course releases/sabbaticals, etc.

MF_FACLOAD_ENROLLED

MF_FACLOAD_CREDITS

The value here is usually correct. In cases where multiple instructors teach a course, however (as often happens with BIOL), the numbers may not be right IF the percentages have not been fully entered. For example, if three instructors teach a course, we need to mark them, in Colleague, as teaching 33.3% of the course each. In the past we have done this, but in recent years (2004-present as of 2011) this practice has not been continued. If we want accurate credit values, we need to enter percentages.

Home