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

Pr 2:21 For the upright will live in the land, and the
        blameless will remain in it; (NIV)
Pr 2:22 but the wicked will be cut off from the land, and
        the unfaithful will be torn from it. (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" = '2267' 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