Summary | Details
Faculty Load - by college <2260> <0>

              Pr 27:9 Perfume and incense bring joy to the
                      heart, and the pleasantness of one's
                      friend springs from his earnest
                      counsel. (NIV)

Numbers here might not be up to date due to latent reindexing...

SELECT c."College Name", c."Department Name", c."Course/Program", course."Units", course."Course"||' '||course."Number"||' '||course."Curriculum" as "Code", course."Description", course."Financial Units", personnel.last||', '||personnel.first||' '||personnel.middle as "Teacher", s."Days", to_char(s."Start Time",'HH12:MIam'::text) as "Start Time", to_char(s."End Time",'HH12:MIam'::text) as "End Time", s."Room", s."Student Count" as "Vacancies", s."Options", s."Notes", c."Course/Program", c."Department Name", c."College Name", c."Department Note", c."College Approval", c."VPAA Approval", c."Allowed Courses Only", c."Allowed Encoders Only", c."Prerequisites Logic", c."Students Can Encode Themselves", s.classid, c.subjectid, s."Teacher ID" FROM schedule s INNER JOIN classes c ON s.classid = c.classid LEFT JOIN course ON c.subjectid = course.courseid AND s."Curriculum" = course."Curriculum" LEFT JOIN personnel ON s."Teacher ID" = personnel.personnel_id WHERE s."Year" = '2260' AND s."Semester" = '0' ORDER BY c."College Name", c."Department Name", c."Course/Program", "Teacher", s."Days", "Start Time"

# of Students	Running Units	College Name	Department Name	Course/Program	Units	Code	Description	Financial Units	Teacher	Days	Start Time	End Time	Room	Vacancies	Options	Notes	Course/Program	Department Name	College Name
0 Students	Units		Name:

# of Teachers: 1
Average Units/Teacher: 0.00
# of class seats: 0
Average seats/teacher: 0.00
Average seats/nonempty class: 0.00
# of Students: 0