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

Pr 21:20 In the house of the wise are stores of choice food
         and oil, but a foolish man devours all he has.
         (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" = '2014' AND s."Semester" = '0' ORDER BY c."College Name", c."Department Name", c."Course/Program", "Teacher", s."Days", "Start Time"

#	Students	Units	Teacher
1	174	11	Worked Dept, Worked Dept
2	40	3	Barrios, Romeo M.
3	1	3	Arellano, Divina Lope Dimaano
4	3	6	Villahermosa, Genfil Q.
5	78	3	Manlapig, Belle C
6	1	3	Naidas, Michael S
7	1	3	Oblimar, Nancy P
8	60	3	Pulido, Nora T
9	7	3	Santiago, Priscilo P
10	55	3	Tolentino, Oliveth H
11	23	6	Belarmino, Teresita G
12	22	6	Fiedacan, Sherwin F
13	25	3	Flores, Kathleen Bienes
14	15	3	Lagajino, Elmie Lynn V
15	78	6	Manlapig, Belle C
16	60	9	Pulido, Nora T
17	73	6	Reyes, Juliet S
18	55	6	Tolentino, Oliveth H
19	54	3	Trantham, Esther M
20	15	3	Asi, Gerardo Mendoza
21	79	6	Angelino, Corazon C
22	15	3	Asi, Gerardo Mendoza
23	45	6	Ledesma, Grezaida M
24	67	6	Merana (old account), Aiza L
25	54	6	Trantham, Esther M
26	57	3	Anolin, Ann G.
27	2	3	Pagaduan, Reuben A
28	3	3	Marticio, Flor Villa P
29	22	3	De Leon, Jezamine Reyes
30	12	3	Mercado, Jocelyn P
31	3	3	Tobias, Vicky
32	12	6	Mercado, Jocelyn P
33	1	3	Fabella, Armand T
34	53	3	Ibañez, Jeruel Bocala
35	134	12	Acquioben, Edmund R
36	35	6	Doble, Jasper A
37	53	9	Ibañez, Jeruel Bocala
38	97	9	Ledesma, Joseph Y
39	27	6	Songcayawon, Jesse Rondael
40	32	6	Tayamora, Michi Rey B
41	47	9	Torres, Aser A
42	43	6	Valencia, Gamaliel U
43	38	9	Ytang, Feliciano Jr. Morcisa
44	3	7	de Dios, Edgardo
45	12	6	De Dios, Sheryl B.
46	10	5	Diamante, Ermilin P
47	133	6	Florece, Jervenesense Salathiel Orbon
48	35	2	Aclon, Jona Gonzales
49	0	2	Fabroa, Amelina R
50	35	4	Aclon, Jona Gonzales
51	0	2	Fabroa, Amelina R
52	37	4	Mendoza, Mario D
53	35	2	Salazar, Nimrod S
54	37	2	Mendoza, Mario D
55	35	4	Salazar, Nimrod S
56	66	3	Castillo, Eva T
57	22	3	De Leon, Jezamine Reyes
58	66	3	Castillo, Eva T
59	28	5	Grijalvo, Myrtle Orbon
60	59	3	De Ocampo, Moises V
61	19	6	Amurao, Julio C
62	25	3	Balila, Edwin Arojado
63	27	3	Balila, Jolly S
64	59	3	De Ocampo, Moises V
65	9	3	Mergal, Vicky C
66	58	17	STAFF, STAFF STAFF
67	47	3	Saban, Gracel Ann Salangsang
68	56	3	Perdido, Ron Ivan Salib-o
69	42	3	Lopez, Glenda Joy B
70	29	6	Lintao, Evely G
71	56	3	Perdido, Ron Ivan Salib-o
72	29	6	Lintao, Evely G
73	1	3	Reyes, Nedilyn Talasan
74	78	3	Salera, Jose Pasco
75	56	3	Perdido, Ron Ivan Salib-o
76	4	3	Apalat, Armando A
77	172	3	Macalalad, Marta
78	4	3	Apalat, Armando A
79	2	3	De Ocampo, Lowena G
80	42	3	Lascuna, Shirley J
81	23	3	Sausa, Lualhati P
82	172	15	Macalalad, Marta
83	78	3	Salera, Jose Pasco
84	2	3	Macaya, Bibly L
85	17	3	Narbarte, Reuel E
86	19	3	Apacible, Elias Y
87	27	3	Balila, Jolly S
88	17	3	Borromeo, Robert A
89	16	3	Javier, Richard S
90	172	3	Macalalad, Marta
91	37	3	Sabado, Janet N.
92	23	6	Sausa, Lualhati P
93	58	6	STAFF, STAFF STAFF
94	23	6	Sausa, Lualhati P
95	30	2	Diaz, Veronica C
96	21	3	Carpizo, Ruben T
97	37	3	Sabado, Janet N.
98	6	5	Virgines, Marissa
99	55	1	Zarsaga, Uriel L
100	1	2	Gatchalian, Deborah Cynthia
101	4	2	Tensuan, Rodolfo C.
102	5	2	Tiongco, Mylene M
103	4	2	Resontoc, Magda Georgetta R
104	47	3	Saban, Gracel Ann Salangsang
105	23	1	Francisco, Rufina P
106	40	3	Barrios, Romeo M.
107	128	3	Idaosos, Caezar F
108	9	3	Mergal, Vicky C
109	13	3	Fajanilan, Levy Meraña
110	47	6	Saban, Gracel Ann Salangsang
111	45	3	Ledesma, Grezaida M
112	2	6	Beratio, Nerilyn R.
113	4	6	Oblimar, Dante C
114	40	6	Barrios, Romeo M.
115	31	3	Batulayan, Nerissa S.
116	59	3	De Ocampo, Moises V
117	25	3	Flores, Kathleen Bienes
118	23	3	Francisco, Rufina P
119	57	3	Guyo, Johnny G
120	128	24	Idaosos, Caezar F
121	42	6	Lascuna, Shirley J
122	45	6	Ledesma, Grezaida M
123	4	3	Oblimar, Dante C
124	37	6	Sabado, Janet N.
125	47	3	Saban, Gracel Ann Salangsang
126	7	6	Santiago, Priscilo P
127	27	6	Songcayawon, Jesse Rondael
128	58	6	STAFF, STAFF STAFF
129	59	3	Tayaben, Precious Ramos
130	76	3	Tuting, Agapito A.
131	21	3	Yllano, Orlex B
132	31	3	Batulayan, Nerissa S.
133	32	3	Balitar, Jaylord E
134	31	3	Batulayan, Nerissa S.
135	15	6	Collado, M T
136	24	9	Esguerra Jr., Teofilo
137	32	6	Fameronag, Jeremiah Cebeda
138	23	6	Francisco, Rufina P
139	12	3	Gelladuga, Rey
140	15	6	Pagaduan, Marietta B
141	84	4	Valencia, Zenaida A
142	9	12	Castillo, Eleanor C
143	5	3	Estrada, Miriam R
144	21	3	Marquez, Hannah G.
145	19	2	Macayan, Yanna Yvonne C
146	28	3	Sales, Ma. Estrella H.
147	63	5	Defino, Mary Cyrin Victoria Capco
148	24	2	Gavas, Marie Isabel Antonio
149	19	3	Macayan, Yanna Yvonne C
150	77	6	Mendoza, Ferdinand
151	56	5	Rodriguez, Princess Red Rose Gabutero
152	28	1	Sales, Ma. Estrella H.
153	24	2	Gavas, Marie Isabel Antonio
154	56	6	Oasan, Ruchel Gagarin
155	58	3	Romero, Cryslie
156	3	4	Balagtas, Maribel C
157	32	3	Balitar, Jaylord E
158	21	2	Marquez, Hannah G.
159	19	3	Seaman, Rima Nepangue
160	15	4	Galang, Dina D
161	19	4	Seaman, Rima Nepangue
162	13	3	Orbe, Joyosthie b
163	19	4	Seaman, Rima Nepangue
164	186	7	Caagbay, Raymond
165	56	6	Mergal, Beryl Ben C
166	56	2	Rodriguez, Jane L
167	83	4	Tantia, Enrilyd
168	186	1	Caagbay, Raymond
169	4	3	Malabat, Carmela G.
170	1	3	Arit, Leocadio P
171	4	3	Malabat, Carmela G.
172	1	2	Polancos, Jacqueline G.
173	112	3	Genebago, Petronio Mardo
174	30	6	Conejos, Danilo H
175	24	6	del Rosario, Mariano
176	59	3	De Ocampo, Moises V
177	38	6	Diesta, Baltazar R.
178	102	6	Fernando, Andresito Parian
179	112	3	Genebago, Petronio Mardo
180	18	6	Reyes, Manuel D
181	58	0	STAFF, STAFF STAFF
182	76	6	Tuting, Agapito A.
183	56	3	Vergara, Abel B
184	59	3	De Ocampo, Moises V
185	102	3	Fernando, Andresito Parian
186	1	2	Cadalig, Maximo P
187	112	2	Genebago, Petronio Mardo
188	102	9	Fernando, Andresito Parian
189	11	3	Lascuna, Medardo O
190	16	3	Vegafria, Juarren
191	11	3	Lascuna, Medardo O
192	21	6	Yllano, Orlex B
193	40	3	Pedro, Merbeth Christine Ladores
194	57	3	Guyo, Johnny G
195	53	3	Esplana, Ferdinand Aloran
196	93	7	Catolico, Lester Harris
197	16	3	Vegafria, Juarren
198	93	7	Catolico, Lester Harris
199	40	3	Pedro, Merbeth Christine Ladores
200	21	2	Yllano, Orlex B
201	67	6	Arce, Leilani D.
202	93	3	Catolico, Lester Harris
203	53	3	Esplana, Ferdinand Aloran
204	53	5	Evangelista, Ephraim
205	65	5	Abuel, Erlinda A.
206	43	4	Balane, Rosamond Beltran
207	28	5	Celis, Jeandalyn Andales
208	39	5	Galang, Myrnille Joy Zabala
209	22	3	Garduque, Viola R
210	34	3	Leowa, Hannah Mae Ronquillo
211	26	9	Rivera, Gaudevic Lloyd Napod
212	18	3	Bicua, Levie L
213	21	3	Bingcang, Ivar Nelson
214	8	6	Pasamba, Winelfred Guadiz
215	6	6	Cruz, Abner Mendoza
216	44	6	Bosito, Danilo C
217	6	12	Cruz, Abner Mendoza
218	30	6	Lopez, Gerson
219	21	6	Bingcang, Ivar Nelson
220	30	3	Lopez, Gerson
221	18	6	Rellis, Hilario Aala
222	18	5	Lagade, Hulk Hogan Bustamante
223	19	5	Zapanta, Paola Ruth Rebellion
224	4	12	Garrino, Melquiades Binueza
225	104	8	Jimenez, Crisville S
226	15	12	Carbonilla, Michelle O
227	18	3	Bicua, Levie L
228	28	5	Ramos, Rowena Imelda Agagas
229	38	3	Racca, Abraham Perral
230	18	3	Bicua, Levie L
231	87	9	Capiendo, Rodrigo D
232	47	5	Catangay, Alden An
233	94	9	Datoy, Peter Villaver
234	38	5	Racca, Abraham Perral
235	28	3	Ramos, Rowena Imelda Agagas
236	59	6	Tayaben, Precious Ramos

# of Teachers: 236
Average Units/Teacher: 4.49
# of class seats: 9567
Average seats/teacher: 40.71
Average seats/nonempty class: 0.00
# of Students: 2112