"); //echo("TSIT = ".$tsit."
"); //echo("Hours = ".$hours."
"); //$fice_code = '020753'; echo("

Transfer Students with 12 or More Earned Credit Hours

"); switch($rcit) { case "'1'": $rcitx = "4-Year Universities"; $fice_code_list = "'001090', '001089', '001098', '001107', '001108', '001110', '001101', '001085', '001109', '001086', '001092' "; break; case "'2'": $rcitx = "2-Year Colleges"; $fice_code_list = "'012860', '001091', '901090', '011949', '020522', '022209', '009976', '012260', '023482', '012261', '012105', '030633', '020870', '001104', '020753', '021111', '020746', '007738', '005707', '020735', '005732', '005245' "; break; case "'1', '2'": $rcitx = "Any Public Institution"; $fice_code_list = "'001090', '001089', '001098', '001107', '001108', '001110', '001101', '001085', '001109', '001086', '001092', '012860', '001091', '901090', '011949', '020522', '022209', '009976', '012260', '023482', '012261', '012105', '030633', '020870', '001104', '020753', '021111', '020746', '007738', '005707', '020735', '005732', '005245' "; break; } switch($tsit) { case "'1'": $tsitx = "4-Year Universities"; break; case "'2'": $tsitx = "2-Year Colleges"; break; case "'1', '2'": $tsitx = "Any Public Institution"; break; } if($remed == 'Y') { $remed_code = "AND ((c.course_level IN ('1', '2', '7', '8', '9') AND UPPER(r.end_of_term) IN ('A', 'B', 'C', 'D', 'S', 'K', 'R', '1')) OR (c.course_level = '0' AND UPPER(r.end_of_term) IN ('A', 'B', 'C', 'S', 'K', 'R', '1'))) "; $remed_text = "Includes Remedial Credit Hours"; } if($remed == 'N') { $remed_code = "AND c.course_level IN ('1', '2', '7', '8', '9') AND UPPER(r.end_of_term) IN ('A', 'B', 'C', 'D', 'S', 'K', 'R', '1') "; $remed_text = "Does Not Include Remedial Credit Hours"; } if($list == 'A') { $fice_list = "'012860', '001091'"; } if($list == 'B') { $fice_list = "'901090', '011949'"; } if($list == 'C') { $fice_list = "'020522', '022209'"; } if($list == 'D') { $fice_list = "'009976', '012260'"; } if($list == 'E') { $fice_list = "'023482', '012261'"; } if($list == 'F') { $fice_list = "'012105', '030633'"; } if($list == 'G') { $fice_list = "'020870', '001104'"; } if($list == 'H') { $fice_list = "'020753', '021111'"; } if($list == 'I') { $fice_list = "'020746', '007738'"; } if($list == 'J') { $fice_list = "'005707', '020735'"; } if($list == 'K') { $fice_list = "'005732', '005245'"; } echo("

Transfer undergraduates and undergraduate credit hours only."); echo("
Academic Year = ".$acadyr." from ".$tsitx." to ".$rcitx."
"); echo("and ".$remed_text."."); echo("

"); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); echo(""); // list of schools - transferring students $query1 = "SELECT DISTINCT f.inst_type, f.school_abbr, f.fice_code FROM fice_table f WHERE f.inst_type IN (".$tsit.") AND f.fice_code IN (".$fice_list.") ORDER BY f.inst_type, f.school_abbr;"; //echo("

".$query1."

"); $n = 1; $result1 = odbc_exec($conn_id, $query1); while (odbc_fetch_row($result1)) { $inst_type = odbc_result($result1, "inst_type"); $school_abbr = odbc_result($result1, "school_abbr"); $fice_code = odbc_result($result1, "fice_code"); echo(""); echo(""); echo(""); echo(""); //echo(""); // transferring students $cnt = 0; $list = ''; $listx = ''; $query2 = "SELECT DISTINCT s.ssn_id, MAX(s.academic_year) AS ay, MAX(s.term) AS trm FROM student_table s JOIN fice_table f ON s.transfer_fice = f.fice_code WHERE s.transfer_fice = '".$fice_code."' AND s.enroll_status = '03' AND s.transfer_fice IS NOT NULL AND s.academic_year = '".$acadyr."' AND s.term IN ('0', '1', '2', '3') AND s.fice_code IN (".$fice_code_list.") GROUP BY s.ssn_id ORDER BY s.ssn_id; "; //echo("

".$query2."

"); $ssch_cnt = 0; $result2 = odbc_exec($conn_id, $query2); while (odbc_fetch_row($result2)) { $cnt++; $ssn_id = odbc_result($result2, "ssn_id"); $ay = odbc_result($result2, "ay"); $trm = odbc_result($result2, "trm"); $ayx = $ay - 1; //echo($ssn_id."-".$ay."-".$trm."
"); // credit hours for each transfer student $query3 = "SELECT r.ssn_id, SUM(c.credit_hours) AS ssch FROM registration_table r JOIN course_table c ON r.fice_code = c.fice_code AND r.academic_year = c.academic_year AND r.term = c.term AND r.sequence = c.sequence AND r.level_sequence = c.level_sequence WHERE r.ssn_id = '".$ssn_id."' AND r.fice_code = '".$fice_code."' AND ((r.academic_year = '".$ay."' AND r.term < '".$trm."') OR (r.academic_year <= '".$ayx."')) ".$remed_code." AND (UPPER(c.tech_inst_funding) NOT IN ('O', 'C', 'M', 'T') OR c.tech_inst_funding IS NULL) GROUP BY r.ssn_id ORDER BY r.ssn_id; "; // echo("

".$query3."

"); $result3 = odbc_exec($conn_id, $query3); while (odbc_fetch_row($result3)) { $ssch = odbc_result($result3, "ssch"); if($ssch >= $hours) { $ssch_cnt++; } } } echo(""); $cnt_total = $cnt_total + $cnt; echo(""); $ssch_cnt_total = $ssch_cnt_total + $ssch_cnt; $ssch_perc = ($ssch_cnt * 100) / $cnt; echo(""); echo(""); } // this bracket ends list of schools // all totals /*echo(""); echo(""); echo(""); echo(""); $perc = ($ssch_cnt_total * 100) / $cnt_total; echo(""); echo(""); */ echo("

#	Inst. Type	Transferring Institution	UG Transfer Students (03)	No. >= ".$hours." CrHrs	Percent
".$n++."	".$inst_type."	".$school_abbr."	".$fice_code."	".number_format($cnt,0)."	".number_format($ssch_cnt,0)."	".number_format($ssch_perc,1)."%
Totals			".number_format($cnt_total,0)."	".number_format($ssch_cnt_total,0)."	".number_format($perc,1)."%

"); odbc_error(); odbc_close($conn_id); ?>