Summary | Details
Faculty Load - by college <2552> <0>
 
Pr 1:11 If they say, "Come along with us; let's lie in wait
        for someone's blood, let's waylay some harmless
        soul; (NIV)
Pr 1:12 let's swallow them alive, like the grave, and whole,
        like those who go down to the pit; (NIV)
Pr 1:13 we will get all sorts of valuable things and fill
        our houses with plunder; (NIV)
Pr 1:14 throw in your lot with us, and we will share a
        common purse"-- (NIV)
Pr 1:16 for their feet rush into sin, they are swift to shed
        blood. (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" = '2552' 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