Modified the way creq majors are queried so that we don't include ones that have been "removed"

application/modules/bulletin/models/UtilityModel.php

@@ -86,7 +86,8 @@ class Bulletin_UtilityModel implements Creq_Model_UtilityInterface
$db = Zend_Db_Table::getDefaultAdapter();
$select = $db->select();
$select->from(array('m' => 'creqMajors'), array('majorId', 'major' => 'name'));
-        $select->join(array('c' => 'creqColleges'), 'm.college = c.collegeId', array('collegeId', 'college' => 'description'));
+	$select->join(array('c' => 'creqColleges'), 'm.college = c.collegeId', array('collegeId', 'college' => 'description'));
+	$select->where("m.removed = 'no'");
$select->order('c.description');
$select->order('m.name');