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

Pr 22:20 Have I not written thirty sayings for you, sayings
         of counsel and knowledge, (NIV)
Pr 22:21 teaching you true and reliable words, so that you
         can give sound answers to him who sent you? (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" = '2246' 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