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

Pr 2:1 My son, if you accept my words and store up my
       commands within you, (NIV)
Pr 2:3 and if you call out for insight and cry aloud for
       understanding, (NIV)
Pr 2:4 and if you look for it as for silver and search for
       it as for hidden treasure, (NIV)
Pr 2:5 then you will understand the fear of the LORD and
       find the knowledge of God. (NIV)
Pr 2:6 For the LORD gives wisdom, and from his mouth come
       knowledge and understanding. (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" = '2361' 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