Summary | Details
Faculty Load - by college <2613> <0>
 
              Pr 30:20 "This is the way of an adulteress:
                       She eats and wipes her mouth and
                       says, `I've done nothing wrong.'
                       (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" = '2613' 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