Summary | Details
Faculty Load - by college <2305> <0>
 
              Pr 30:4 Who has gone up to heaven and come
                      down? Who has gathered up the wind in
                      the hollow of his hands? Who has
                      wrapped up the waters in his cloak?
                      Who has established all the ends of
                      the earth? What is his name, and the
                      name of his son? Tell me if you know!
                      (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" = '2305' 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 NameDepartment NameCourse/ProgramUnitsCodeDescriptionFinancial UnitsTeacherDaysStart TimeEnd TimeRoomVacanciesOptionsNotesCourse/ProgramDepartment NameCollege 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