Workforce Training Hours (2-Year Colleges Only)

Academic Year selected = ".$acadyr." (from AY".$acadyr1." to AY".$acadyr5.").

"); $queryX = "SELECT DISTINCT f.inst_type, f.fice_code, f.school_abbr FROM fice_table f WHERE f.inst_type IN ('2') ORDER BY f.inst_type, f.school_abbr"; $resultX = odbc_exec($conn_id, $queryX); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); $n = 1; while (odbc_fetch_row($resultX)) { $inst_type = (odbc_result($resultX, "inst_type")); $fice_code = (odbc_result($resultX, "fice_code")); echo(""); echo(""); echo(""); echo(""); $hrs1 = 0; $hrs1a = 0; $hrs1b = 0; $hrs2 = 0; $hrs2a = 0; $hrs2b = 0; $hrs3 = 0; $hrs3a = 0; $hrs3b = 0; $hrs4 = 0; $hrs4a = 0; $hrs4b = 0; $hrs5 = 0; $hrs5a = 0; $hrs5b = 0; $hrs_sum = 0; // year 1 $query1a = "SELECT SUM(w.enrollment * w.cr_hrs * 15) AS hrs1a FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr1."' AND w.cr_hrs > '0' ;"; //echo("

".$query1a."

"); $result1a = odbc_exec($conn_id, $query1a); while (odbc_fetch_row($result1a)) { $hrs1a = odbc_result($result1a, "hrs1a"); $hrs1a_total = $hrs1a_total + $hrs1a; } $query1b = "SELECT SUM(w.enrollment * w.ceu * 10) AS hrs1b FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr1."' AND w.ceu > 0 AND (w.cr_hrs = '0' OR w.cr_hrs IS NULL) ;"; //echo("

".$query1a."

"); $result1b = odbc_exec($conn_id, $query1b); while (odbc_fetch_row($result1b)) { $hrs1b = odbc_result($result1b, "hrs1b"); $hrs1b_total = $hrs1b_total + $hrs1b; } echo(""); echo(""); $hrs1 = $hrs1a + $hrs1b; echo(""); $hrs1_total = $hrs1_total + $hrs1; // year 2 $query2a = "SELECT SUM(w.enrollment * w.cr_hrs * 15) AS hrs2a FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr2."' AND w.cr_hrs > '0' ;"; //echo("

".$query2a."

"); $result2a = odbc_exec($conn_id, $query2a); while (odbc_fetch_row($result2a)) { $hrs2a = odbc_result($result2a, "hrs2a"); $hrs2a_total = $hrs2a_total + $hrs2a; } $query2b = "SELECT SUM(w.enrollment * w.ceu * 10) AS hrs2b FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr2."' AND w.ceu > 0 AND (w.cr_hrs = '0' OR w.cr_hrs IS NULL) ;"; //echo("

".$query2a."

"); $result2b = odbc_exec($conn_id, $query2b); while (odbc_fetch_row($result2b)) { $hrs2b = odbc_result($result2b, "hrs2b"); $hrs2b_total = $hrs2b_total + $hrs2b; } echo(""); echo(""); $hrs2 = $hrs2a + $hrs2b; echo(""); $hrs2_total = $hrs2_total + $hrs2; // year 3 $query3a = "SELECT SUM(w.enrollment * w.cr_hrs * 15) AS hrs3a FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr3."' AND w.cr_hrs > '0' ;"; //echo("

".$query3a."

"); $result3a = odbc_exec($conn_id, $query3a); while (odbc_fetch_row($result3a)) { $hrs3a = odbc_result($result3a, "hrs3a"); $hrs3a_total = $hrs3a_total + $hrs3a; } $query3b = "SELECT SUM(w.enrollment * w.ceu * 10) AS hrs3b FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr3."' AND w.ceu > 0 AND (w.cr_hrs = '0' OR w.cr_hrs IS NULL) ;"; //echo("

".$query3a."

"); $result3b = odbc_exec($conn_id, $query3b); while (odbc_fetch_row($result3b)) { $hrs3b = odbc_result($result3b, "hrs3b"); $hrs3b_total = $hrs3b_total + $hrs3b; } echo(""); echo(""); $hrs3 = $hrs3a + $hrs3b; echo(""); $hrs3_total = $hrs3_total + $hrs3; // year 4 $query4a = "SELECT SUM(w.enrollment * w.cr_hrs * 15) AS hrs4a FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr4."' AND w.cr_hrs > '0' ;"; //echo("

".$query4a."

"); $result4a = odbc_exec($conn_id, $query4a); while (odbc_fetch_row($result4a)) { $hrs4a = odbc_result($result4a, "hrs4a"); $hrs4a_total = $hrs4a_total + $hrs4a; } $query4b = "SELECT SUM(w.enrollment * w.ceu * 10) AS hrs4b FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr4."' AND w.ceu > 0 AND (w.cr_hrs = '0' OR w.cr_hrs IS NULL) ;"; //echo("

".$query4a."

"); $result4b = odbc_exec($conn_id, $query4b); while (odbc_fetch_row($result4b)) { $hrs4b = odbc_result($result4b, "hrs4b"); $hrs4b_total = $hrs4b_total + $hrs4b; } echo(""); echo(""); $hrs4 = $hrs4a + $hrs4b; echo(""); $hrs4_total = $hrs4_total + $hrs4; // year 5 $query5a = "SELECT SUM(w.enrollment * w.cr_hrs * 15) AS hrs5a FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr5."' AND w.cr_hrs > '0' ;"; //echo("

".$query5a."

"); $result5a = odbc_exec($conn_id, $query5a); while (odbc_fetch_row($result5a)) { $hrs5a = odbc_result($result5a, "hrs5a"); $hrs5a_total = $hrs5a_total + $hrs5a; } $query5b = "SELECT SUM(w.enrollment * w.ceu * 10) AS hrs5b FROM workforce_table w WHERE w.fice_code = '".$fice_code."' AND w.academic_year = '".$acadyr5."' AND w.ceu > 0 AND (w.cr_hrs = '0' OR w.cr_hrs IS NULL) ;"; //echo("

".$query5a."

"); $result5b = odbc_exec($conn_id, $query5b); while (odbc_fetch_row($result5b)) { $hrs5b = odbc_result($result5b, "hrs5b"); $hrs5b_total = $hrs5b_total + $hrs5b; } echo(""); echo(""); $hrs5 = $hrs5a + $hrs5b; echo(""); $hrs5_total = $hrs5_total + $hrs5; $hrs_avg3 = ($hrs1 + $hrs2 + $hrs3) / 3; $hrs_avg2 = ($hrs4 + $hrs5) / 2; echo(""); echo(""); $change = (($hrs_avg2 - $hrs_avg3) * 100) / $hrs_avg3; echo(""); echo(""); } // totals echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo("
#Inst.
Type		InstitutionAY".$acadyr1."AY".$acadyr2."AY".$acadyr3."AY".$acadyr4."AY".$acadyr5."3-Year Avg.2-Year Avg.Change
CRNCBothCRNCBothCRNCBothCRNCBothCRNCBoth
".$n++."".$inst_type."".odbc_result($resultX, "school_abbr")."".number_format($hrs1a,0)."".number_format($hrs1b,0)."".number_format($hrs1,0)."".number_format($hrs2a,0)."".number_format($hrs2b,0)."".number_format($hrs2,0)."".number_format($hrs3a,0)."".number_format($hrs3b,0)."".number_format($hrs3,0)."".number_format($hrs4a,0)."".number_format($hrs4b,0)."".number_format($hrs4,0)."".number_format($hrs5a,0)."".number_format($hrs5b,0)."".number_format($hrs5,0)."".number_format($hrs_avg3,0)."".number_format($hrs_avg2,0)."".number_format($change,1)."%
Grand Total".number_format($hrs1a_total,0)."".number_format($hrs1b_total,0)."".number_format($hrs1_total,0)."".number_format($hrs2a_total,0)."".number_format($hrs2b_total,0)."".number_format($hrs2_total,0)."".number_format($hrs3a_total,0)."".number_format($hrs3b_total,0)."".number_format($hrs3_total,0)."".number_format($hrs4a_total,0)."".number_format($hrs4b_total,0)."".number_format($hrs4_total,0)."".number_format($hrs5a_total,0)."".number_format($hrs5b_total,0)."".number_format($hrs5_total,0)."
"); odbc_free_result($result1); odbc_free_result($result2); odbc_free_result($result3); odbc_free_result($result4); odbc_free_result($result5); odbc_free_result($result6); odbc_free_result($result7); odbc_free_result($result8); odbc_free_result($result9); odbc_free_result($result10); odbc_error(); odbc_close($conn_id); ?>

NOTES: (1) All credit courses were counted and each credit hour multiplied by 15 to produce training hours.
(2) Non-credit CEUs were only counted if the credit hours was zero or null. Non-credit CEUs were muliplied by 10 to produce training hours.