-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 01, 2016 at 07:51 PM
-- Server version: 5.5.46-0ubuntu0.14.04.2
-- PHP Version: 5.5.9-1ubuntu4.14

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `urcpp_flask`
--

-- --------------------------------------------------------

--
-- Table structure for table `budget`
--

CREATE TABLE IF NOT EXISTS `budget` (
  `bID` int(11) NOT NULL AUTO_INCREMENT,
  `facultyStipend` int(11) DEFAULT NULL,
  `facultyStipendDesc` longtext NOT NULL,
  `miles` int(11) DEFAULT NULL,
  `milesDesc` longtext NOT NULL,
  `otherTravel` int(11) DEFAULT NULL,
  `otherTravelDesc` longtext NOT NULL,
  `equipment` int(11) DEFAULT NULL,
  `equipmentDesc` longtext NOT NULL,
  `materials` int(11) DEFAULT NULL,
  `materialsDesc` longtext NOT NULL,
  `other` int(11) DEFAULT NULL,
  `otherDesc` longtext NOT NULL,
  PRIMARY KEY (`bID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `budget`
--

INSERT INTO `budget` (`bID`, `facultyStipend`, `facultyStipendDesc`, `miles`, `milesDesc`, `otherTravel`, `otherTravelDesc`, `equipment`, `equipmentDesc`, `materials`, `materialsDesc`, `other`, `otherDesc`) VALUES
(1, 5300, 'I will be the sole faculty mentor on this project', 1176, 'Twelve trips to collecting site at North Elkhorn Creek in Scott County, Kentucky', 800, '102nd  Annual Meeting of the Kentucky Academy of Science in Louisville, November 2016 & possibly the Annual Midwestern Conference of Parasitologists, June 2017', 400, 'Hip Boots', 1100, 'Chemicals to make artificial snail and pond water; microscope slides and coverslips; Kleermount; acetocarmine stain', 0, 'none'),
(2, 0, '0', 1, '', 0, '0', 0, '0', 0, '0', 1, ''),
(3, 5300, 'I will be the only faculty member and am requesting the  full stipend.', 0, '', 0, '', 1000, 'The magnetometer will require modification to make it capable of varying the temperature. Parts for this modification are likely to cost $500. The AFM will require some electronic components likely to cost in the neighborhood of $250. There will be a variety of small pieces of equipment needed to make, transport, and store the alloys (diamond saw blade, vials, dessicants, etc.). These will cost approximately $250', 1500, 'Costs of metals:\r\nChromium (50 grams) $76\r\nCobalt (100 grams) $76\r\nIron (250 grams) $32\r\nNickel (100 grams) $38\r\nPalladium (5 grams) $400\r\nGold (5 grams) $580\r\nSilver (50 grams) $230\r\nCopper (50 grams) $33', 0, ''),
(4, 5300, 'Stipend per Faculty Member—$5,300', 0, 'N/A', 0, 'N/A', 1000, 'Miscellaneous equipment:\r\n	Motor 		$500\r\n	Controller		$300\r\n	Wiring/other		$200\r\n', 2000, 'Metal: \r\n	 To be determined\r\n	 Most likely a steel alloy \r\n	(will try to recycle)\r\n', 0, 'N/A'),
(5, 5300, '', 0, '', 1500, 'Kentucky Academy of Science (KAS) (Travel, Registration, Lodging and Meals) - $600\r\nHuman Anatomy and Physiology Conference - $900', 0, '', 1500, 'Supplies for Creative Manipulatives and Educational Games - $1200\r\nResearch Poster Printing - $200\r\nLaminator Pouches - $100', 0, ''),
(6, 5300, '1 @ 5,300', 0, 'NA', 480, 'Meeting expenses (KAS 2016)\r\n 		Poster printing  (2)			        $120\r\n 		KAS student registration (4)		$140 ($35 x 4)\r\n 		Hotel (2 rooms @ $110)			$220\r\n 		Subtotal						                                                    $480\r\n', 0, 'NA', 2150, 'Materials and Supplies (List):\r\n		Bacterial culture supplies  (media, Petris)	$400\r\n 		Gene Clean Turbo kits (2)		                	$250\r\n 		MAX Efficiency® E. coli DH5? cells		        $250	\r\n 		Enzymes/primers (restriction, Taq, etc.)	         $300*\r\n 		EasyStart50 PCR tubes 			                         $250\r\n 		Gel electrophoresis supplies		                         $250\r\n 		Antibiotic test discs			                                 $200\r\n 		Disposables (e.g.dishes,pipette tips,\r\n		    microcentrifuge tubes, etc.)		                 $200\r\n 		Duplicating				                                         $50\r\n 		Subtotal						                                                         $2150\r\n\r\n*includes overnight delivery\r\n', 0, 'NA'),
(7, 10600, '5300', 0, '', 0, '', 0, '\r\n', 150, 'Reflective Writing Journals - 100 journals\r\n', 1500, 'Cinemark Movie Tickets for participants - 100 participants\r\nCopies of Literature Review Articles '),
(8, 5300, 'Stipend for one faculty member', 1000, 'We will have to travel to producer operations for four weeks (weeks 1, 3, 5, and 7) and to meet with extension personnel, representatives from relevant agencies and other interest groups. Therefore, an estimated average of 250 miles will be covered in each of these weeks for a total travel of about 1000 miles throughout the duration of this project. Hence, budgeted allocation for travel is 1000 X $0.49 = $490.00', 0, '', 0, '', 0, '', 0, ''),
(9, 5300, '', 0, 'Cost Included above', 1200, '  4 nights at hotels, 2 rooms for 3-4 adults	800\r\n  1 trip, transportation and board estimates	300\r\n', 1500, 'Website Design and implementation', 300, '  Books and Primary Materials	100 \r\n  Media Storage	200 \r\n', 0, ''),
(10, 5300, 'AJ Mortara will receive the total sum.  ', 0, '', 0, '', 820, 'Rogue Fitness Kettle Clamp (please see file labeled ''Supplemental Addendum to 2016 URCPP Application'' for details).  $199.00 each; four have been requested.  ', 0, '', 0, ''),
(11, 5300, '5300 for M Saderholm', 0, '', 700, '3 day trips to UK for protein purification & travel to the KAS meeting in Louisville in November (3 hotel rooms, van rental, food, registration)', 0, '', 2300, 'reagents, glassware, pipets, & 96-well plates', 0, ''),
(12, 5300, '$5300 x 1 full-time faculty member', 0, 'We will use a CELTS van for transportation to and from research sites. ', 400, 'Conference registration and Berea car rental for two conferences (ASK and KAS): $400', 160, 'Scale for measuring food waste: $160 (http://www.globalindustrial.com/p/packaging/scales/floor/industrial-bench-floor-scale-330-lb)\r\n', 720, 'Photo copies: $300\r\nPoster presentation materials: $60\r\nTextbooks for summer research students ($120 x 3): $360\r\n', 0, ''),
(13, 0, '', 0, '', 500, 'KAS Meeting Expenses (Registration, Hotel, etc) $125	 (x4) 			$500', 2250, '	Integrated Development Software	 $300 (x4)				$1200\r\n	Workstation/Server	(x1)				$1000\r\n	Duplicating					$50\r\n', 0, '', 0, ''),
(14, 5300, '5300', 45, 'Most work will be done on the Berea College campus.  We may take a few visits up to UK to visit Robin Cooper''s neuroscience lab for some pointers on some equipment and technique.', 2500, 'I''m putting the maximum remainder down because it is my hope that we could present our work at the Faculty for Undergraduate Neuroscience sessions held in conjunction with the Society for Neuroscience Annual Meeting which will be held in San Diego the relevant year and will be expensive to attend.  I plan on using my own travel funds to supplement.  If this turns out to be impossible, travel funds will be used to present in more local venues (e.g. ACA Summit, SETOP in Atlanta, etc.)', 0, '', 500, 'Minimal equipment will be needed because will be able to draw on prior supplies.  Some small vibration motors, a variety of small implements (such as blunt probes for temperature perception testing on skin), and printing costs.', 0, ''),
(15, 0, 'I am on an 11 month contract so I am not eligible for a stipend.', 0, '', 0, '', 3000, 'Hughes Easel 4080 (http://www.hugheseasels.com/products.html) $2995 + $300 (for black stain) + $350 (shipping)=$3645 (the amount over $3000 will be covered out of the Art Collections budget)', 0, '', 0, ''),
(16, 5300, '', 0, '', 600, 'Travel and lodging to KAS Annual Meeting 2016', 250, 'Owl pellet kits for training students at initiation of project', 0, '', 0, ''),
(17, 5300, '', 0, '', 0, '', 0, '', 3000, 'Enzyme reagents, chemicals,  and cuvettes (e.g. cytochrome c oxidase, acetyl CoA, NADH).\r\n', 0, ''),
(18, 5300, '$5,300 for one faculty member', 35, 'There may be a few trips to Richmond', 0, '', 0, '', 400, 'Memory card - for digital camera\r\n3 notebooks\r\n3 binders\r\n3 file boxes\r\n1 box hanging file folders\r\n1 box hanging file folders\r\nMisc. office supplies\r\n3 boxes of pens for the training sessions\r\n35 small legal pads (5"x8") for the training sessions\r\n3 current Nonviolent Communication books and Workbooks', 0, ''),
(19, 5300, 'One Faculty Member', 0, 'Chose to use Enterprise Rent-a-Car due to it being less expensive.', 2117, 'One Week Rental: Standard Size Vehicle from Enterprise Rent-a-Car: $198.18\r\nGas: ~$150 for round trip\r\nHotel Rental-- 2 Rooms total: \r\nOne Night: St. Louis, Missouri: Red Roof Inn--$52 per room, $104 total.\r\n	One Night: Bentonville, Arkansas: Days Inn and Suites--$54 per room, $108 total.\r\n	One Night: Amarillo, Texas: Red Roof Inn--$55 per room, $110\r\nThree Nights:Santa Fe, New Mexico; Days Inn and Suites--$51 per room per night, $306 total\r\nReturn Trip: Estimate $300 in hotel rooms over the course of three days, but stopping locations have not been determined yet. \r\n\r\nFood: $40 per day per person x 7 days: $280 Total x 3 people\r\n', 150, 'Laguna Resaw Bandsaw Blade: $150', 550, 'Supplementary White Oak; $3.00 per board Feet X 100: $300\r\n	Dimensional Pine Construction Lumber: $250\r\n', 18, 'Two Copies of  "Metaphor We Live By"'),
(20, 5800, 'Raymond Gonzalez - $5300\r\nMatt Jadud - $500', 0, '', 0, '', 1263, 'Printerbot Plus 3D Printer', 1732, 'Complete budget attached', 0, ''),
(21, 5300, '5,300 for one faculty member', 224, '  Travel to field site:  28 miles round-trip with eight (8) trips\r\n  Rental of College vehicle (minivan) = $8.00 per day \r\n  (28 miles x $0.61/mile) x 8 + ($64 for eight rentals) =\r\n$0.61 per mile is the mileage rate for College minivans\r\n\r\nThe field site where the plants are located is 14 miles (one-way) away from campus.  A minivan is required to get to the field site due to the rugged terrain.  A car would "bottom-out" as they do not sit high enough to prevent dragging on the very rough gravel road that we have to travel to get to the site.  \r\n', 201, '', 205, '  Planting Trays for seeds/young seedlings ($70 per case)	$70.00 \r\n  Fertilizer mixture	$15.00 \r\n  Petri dishes  ($60 per case of 100 x 2)	$120.00\r\n', 68, '  Potting Soil ($8.00 per bag x 6 bags)	$48.00 \r\n  Soil fungi treatment mix	$20.00 \r\n', 230, '  Cost of printing posters (for presentation of research at the 	$160.00 \r\n  Kentucky Academy of Science annual meeting)	 \r\n  Cost of KAS registration for 2 students (2 x $35)	$70.00 \r\n'),
(22, 10600, '$5300 for each faculty member', 0, '', 0, '', 0, '', 0, '', 0, ''),
(23, 5300, 'One faculty member', 0, '', 0, '', 2000, 'pipetters @ $500 ea., bottle-top dispensers @ $500 ea., pH electrodes @ $100-200 ea.', 1000, 'chemicals and glassware', 0, '');

-- --------------------------------------------------------

--
-- Table structure for table `collaborators`
--

CREATE TABLE IF NOT EXISTS `collaborators` (
  `cID` int(11) NOT NULL AUTO_INCREMENT,
  `pID_id` int(11) NOT NULL,
  `username_id` varchar(255) NOT NULL,
  `yearsFunded` longtext NOT NULL,
  PRIMARY KEY (`cID`),
  KEY `collaborators_username_id` (`username_id`),
  KEY `collaborators_pID_id` (`pID_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `collaborators`
--

INSERT INTO `collaborators` (`cID`, `pID_id`, `username_id`, `yearsFunded`) VALUES
(1, 7, 'ponderj', '{\r\n}'),
(2, 20, 'jadudm', '{\r\noneyr: true, \r\n}'),
(3, 22, 'lynchj', '{\r\noneyr: true, \r\n}');

-- --------------------------------------------------------

--
-- Table structure for table `ldapfaculty`
--

CREATE TABLE IF NOT EXISTS `ldapfaculty` (
  `fID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `bnumber` longtext NOT NULL,
  `lastname` longtext NOT NULL,
  `firstname` longtext NOT NULL,
  PRIMARY KEY (`fID`),
  UNIQUE KEY `ldapfaculty_username` (`username`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=834 ;

--
-- Dumping data for table `ldapfaculty`
--

INSERT INTO `ldapfaculty` (`fID`, `username`, `bnumber`, `lastname`, `firstname`) VALUES
(1, 'berheidem', 'B00205979', 'Berheide', 'Mike'),
(2, 'heyrmanj', 'B00260642', 'Heyrman', 'John'),
(3, 'rifaia', 'B00528383', 'Rifai', 'Abdul'),
(4, 'olsonr', 'B00044930', 'Olson', 'Richard'),
(5, 'rivage-seulp', 'B00268856', 'Rivage-Seul', 'Peggy'),
(6, 'leekl', 'B00141941', 'Leek', 'Linda'),
(7, 'baskina', 'B00420818', 'Baskin', 'Andrew'),
(8, 'christensenk', 'B00513821', 'Christensen', 'Katherine'),
(9, 'batesre', 'B00054155', 'Bates', 'Rebecca'),
(10, 'fosterr', 'B00259649', 'Foster', 'Robert'),
(11, 'mackd', 'B00047957', 'Mack', 'Dwayne'),
(12, 'bullockka', 'B00528593', 'Bullock', 'Kathy'),
(13, 'bolsterst', 'B00038927', 'Bolster', 'Steve'),
(14, 'mahoneyg', 'B00380585', 'Mahoney', 'Gary'),
(15, 'millsa', 'B00235052', 'Mills', 'Alan'),
(16, 'beaglem', 'B00053384', 'Beagle', 'Martha'),
(17, 'woodies', 'B00344975', 'Woodie', 'Stephanie'),
(18, 'ambroseth', 'B00344921', 'Ambrose', 'Kelly'),
(19, 'srsicm', 'B00065357', 'Srsic', 'Melody'),
(20, 'suderr', '', 'Suder', 'Robert'),
(21, 'hoagr', 'B00190235', 'Hoag', 'Bob'),
(22, 'pearsone', 'B00515441', 'Pearson', 'Eric'),
(23, 'smithd', 'B00505007', 'Smith', 'Duane'),
(24, 'richeyj', 'B00137357', 'Richey', 'Jeffrey'),
(25, 'smithsonp', 'B00147605', 'Smithson', 'Paul'),
(26, 'saderholmm', 'B00313475', 'Saderholm', 'Matthew'),
(27, 'baltisbergerj', 'B00509447', 'Baltisberger', 'Jay'),
(28, 'pulsfords', 'B00158027', 'Pulsford', 'Steve'),
(29, 'rhodesa', '', 'Rhodes', 'Ann'),
(30, 'ayerss', 'B00261632', 'Ayers', 'Shan'),
(31, 'blythej', 'B00326240', 'Blythe', 'Janice'),
(32, 'hoffmanm', 'B00046289', 'Hoffman', 'Megan'),
(33, 'scudder-davisr', 'B00069197', 'Scudder-Davis', 'Roy'),
(34, 'jonesl', 'B00492782', 'Jones', 'Libby'),
(35, 'rectorj', 'B00202895', 'Rector', 'Judy'),
(36, 'pearcej', 'B00265040', 'Pearce', 'Jan'),
(37, 'lynchj', 'B00079082', 'Lynch', 'James'),
(38, 'stinebricknerr', 'B00052154', 'Stinebrickner', 'Ralph'),
(39, 'bolsters', 'B00037961', 'Bolster', 'Sandy'),
(40, 'burnsidej', 'B00463703', 'Burnside', 'Jackie'),
(41, 'kazuram', '', 'Kazura', 'Martie'),
(42, 'riversk', 'B00137669', 'Rivers Thompson', 'Katrina'),
(43, 'graetzerm', 'B00498536', 'Graetzer', 'Margarita'),
(44, 'hochj', 'B00510551', 'Hoch', 'Jeanne'),
(45, 'martinde', 'B00346520', 'Martin', 'Deborah'),
(46, 'chasea', 'B00290828', 'Chase', 'Anne'),
(47, 'poolj', 'B00499781', 'Pool', 'Jeff'),
(48, 'pancieram', 'B00043103', 'Panciera', 'Michael'),
(49, 'porterd', 'B00522371', 'Porter', 'David'),
(50, 'burkee', 'B00048593', 'Burke', 'Ellen'),
(51, 'tolliverj', 'B00344864', 'Tolliver', 'Janis'),
(52, 'kirbyc', 'B00510554', 'Kirby', 'Carol'),
(53, 'mendelreyesm', 'B00526508', 'Mendel-Reyes', 'Meta'),
(54, 'krinerl', 'B00068519', 'Kriner', 'Lisa'),
(55, 'boumaj', 'B00177782', 'Bouma', 'Jill'),
(56, 'andersond', 'B00518768', 'Anderson', 'Dawn'),
(57, 'rosenr', 'B00490499', 'Rosen', 'Ron'),
(58, 'vazzanac', 'B00219632', 'Vazzana', 'Caryn'),
(59, 'robertsr', 'B00363056', 'Roberts', 'Randall'),
(60, 'crachiolob', 'B00250355', 'Crachiolo', 'Beth'),
(61, 'mcdonaldv', 'B00514166', 'McDonald', 'Verlaine'),
(62, 'wootenb', 'B00163556', 'Wooten', 'Billy'),
(63, 'broadheade', 'B00530021', 'Broadhead', 'Edwin'),
(64, 'mckiernan-gonzaleze', 'B00499568', 'Mckiernan Gonzalez', 'Eileen'),
(65, 'gowlers', 'B00259634', 'Gowler', 'Steve'),
(66, 'clarks', 'B00071402', 'Clark', 'Sean'),
(67, 'douglasg', 'B00397757', 'Douglas', 'Neil'),
(68, 'dotsonm', 'B00115094', 'Dotson', 'Margaret'),
(69, 'messerw', 'B00190928', 'Messer', 'Wayne'),
(70, 'derossetf', 'B00272132', 'de Rosset', 'Fred'),
(71, 'watkinsm', 'B00496178', 'Watkins', 'Mylene'),
(72, 'carlevalej', 'B00040700', 'Carlevale', 'John'),
(73, 'henthorns', 'B00235055', 'Henthorn', 'Susan'),
(74, 'mccormacke', 'B00308468', 'McCormack', 'Ed'),
(75, 'butlerj', 'B00257828', 'Butler', 'Jim'),
(76, 'postonp', 'B00131714', 'Poston', 'Ed'),
(77, 'tolliverw', 'B00362864', 'Tolliver', 'Wayne'),
(78, 'smithro', 'B00190823', 'Smith', 'Robert'),
(79, 'veillettem', 'B00614425', 'Veillette', 'Martin'),
(80, 'thesingt', 'B00620882', 'Thesing', 'Theresa'),
(81, 'hedgerj', 'B00363254', 'Hedger', 'John'),
(82, 'brownke', 'B00617135', 'Brown', 'Kennaria'),
(83, 'hackbertp', 'B00618036', 'Hackbert', 'Peter'),
(84, 'egertonk', 'B00584417', 'Egerton', 'Kate'),
(85, 'kovacevica', 'B00598532', 'Kovacevic', 'Anes'),
(86, 'grattonl', 'B00535448', 'Gratton', 'Larry'),
(87, 'nakazawam', 'B00061505', 'Nakazawa', 'Mario'),
(88, 'barnardk', 'B00597485', 'Barnard', 'Kristen'),
(89, 'saderholmj', 'B00382697', 'Saderholm', 'Jon'),
(90, 'starnesb', 'B00593830', 'Starnes', 'Bobby'),
(91, 'webba', 'B00010162', 'Webb', 'Althea'),
(92, 'hodget', 'B00597685', 'Hodge', 'Tracy'),
(93, 'derossetc', 'B00414473', 'deRosset', 'Carol'),
(94, 'cohenj', 'B00626114', 'Cohen', 'Jason'),
(95, 'strangej', 'B00540113', 'Strange', 'Jason'),
(96, 'jonesdo', 'B00290531', 'Jones', 'Douglas'),
(97, 'garrettm', 'B00636256', 'Garrett', 'Mary'),
(98, 'martei', 'B00641216', 'Marte', 'Ivonne'),
(99, 'bartonad', 'B00637062', 'Barton', 'Adanma'),
(100, 'calkinsm', 'B00641842', 'Calkins', 'Mark'),
(101, 'richardsonc', 'B00326366', 'Richardson', 'Cynthia'),
(102, 'mahoneym', 'B00638662', 'Mahoney', 'Mark'),
(103, 'turnerw', 'B00620455', 'Turner', 'William'),
(104, 'guthmanj', 'B00637064', 'Guthman', 'Joshua'),
(105, 'grossj', 'B00274877', 'Gross', 'Calvin'),
(106, 'steeles', 'B00511598', 'Steele', 'Scott'),
(107, 'johnsonm', 'B00426029', 'Johnson', 'Mike'),
(108, 'meadowsr', 'B00089852', 'Meadows', 'Richard'),
(109, 'mechamn', 'B00614899', 'Mecham', 'Neil'),
(110, 'houses', 'B00368552', 'House', 'Silas'),
(111, 'gardnerke', 'B00650124', 'Gardner', 'Kevin'),
(112, 'claverej', 'B00649396', 'Clavere', 'Javier'),
(113, 'cahilln', 'B00571917', 'Cahill', 'Nashwa'),
(114, 'beyj', 'B00053993', 'Bey', 'Jose'),
(115, 'williamss', 'B00382103', 'Williams', 'Sandy'),
(116, 'mckinneyg', 'B00037244', 'McKinney', 'Gordon'),
(117, 'williamsw', 'B00645513', 'Williams', 'Wendy'),
(118, 'sergentf', 'B00660208', 'Sergent', 'Tyler'),
(119, 'woodwarda', 'B00656476', 'Woodward', 'Andrea'),
(120, 'vickouss', 'B00660219', 'Vickous', 'Susan'),
(121, 'grayg', 'B00655899', 'Gray', 'Gordon'),
(122, 'grzimekv', 'B00660111', 'Grzimek', 'Volker'),
(123, 'reidma', 'B00660468', 'Reid', 'Maurice'),
(124, 'peacha', 'B00038543', 'Peach', 'Amanda'),
(125, 'hallsa', 'B00660422', 'Hall', 'Sarah'),
(126, 'dohertym', 'B00651892', 'Doherty', 'Meghan'),
(127, 'brudera', 'B00659764', 'Bruder', 'Anne'),
(128, 'disavinoe', 'B00659887', 'DiSavino', 'Elizabeth'),
(129, 'claverel', 'B00660508', 'Clavere', 'Lindsay'),
(130, 'downss', 'B00650145', 'Downs', 'Sarah'),
(131, 'whitea', 'B00529280', 'White', 'Al'),
(132, 'greenchr', 'B00647843', 'Green', 'Christopher'),
(133, 'wongp', 'B00669874', 'Wong', 'Penelope'),
(134, 'ortquistahrensl', 'B00356784', 'Ortquist-Ahrens', 'Leslie'),
(135, 'adamsch', 'B00664316', 'Adams', 'Christopher'),
(136, 'hammonda', 'B00670468', 'Hammond', 'Angela'),
(137, 'giftn', 'B00667559', 'Gift', 'Nancy'),
(138, 'blanks', 'B00366764', 'Blank', 'Sarah'),
(139, 'pattonna', 'B00670658', 'Patton', 'Nathan'),
(140, 'sutherlanda', 'B00391679', 'Sutherland', 'Adria'),
(141, 'jadudm', 'B00669796', 'Jadud', 'Matthew'),
(142, 'wiggsp', 'B00351116', 'Wiggs', 'Philip'),
(143, 'warrenw', 'B00650363', 'Warren', 'Wendy'),
(144, 'adamschr', 'B00670725', 'Adams', 'Christine'),
(145, 'flynns', 'B00670643', 'Flynn', 'Sarah'),
(146, 'riveralopeza', 'B00671047', 'Rivera', 'Angel'),
(147, 'norrisj', 'B00677092', 'Norris', 'Ian'),
(148, 'andersonch', 'B00679722', 'Anderson', 'Broughton'),
(149, 'wiltonc', 'B00654902', 'Wilton', 'Charles'),
(150, 'howardja', 'B00319655', 'Howard', 'Jason'),
(151, 'caldwellan', 'B00385925', 'Caldwell', 'Anthony'),
(152, 'talbertm', 'B00679127', 'Talbert', 'Matthew'),
(153, 'baptisteq', 'B00676892', 'Baptiste', 'Quinn'),
(154, 'keelso', '', 'Keels', 'Oliver'),
(155, 'bryantda', 'B00584353', 'Bryant', 'Daniel'),
(156, 'mortaraa', 'B00678690', 'Mortara', 'Anthony'),
(157, 'wyricka', 'B00357785', 'Wyrick', 'Amanda'),
(158, 'ponderj', 'B00291485', 'Ponder', 'Judy'),
(159, 'stevensd', 'B00516428', 'Stevens', 'Dwana'),
(160, 'myerssteelel', 'B00499676', 'Myers-Steele', 'Lori'),
(161, 'ptfaculty', '', 'Faculty', 'P'),
(162, 'gonzalezr', 'B00678936', 'Gonzalez', 'Raymond'),
(163, 'elstona', 'B00678688', 'Elston', 'Ashley'),
(164, 'feaganb', 'B00680207', 'Feagan', 'Beth'),
(165, 'marshalln', 'B00676214', 'Marshall', 'Nicholas'),
(166, 'dalessiom', 'B00041045', 'Dalessio', 'Michael'),
(167, 'lassloj', 'B00394808', 'Lasslo', 'Julie'),
(168, 'rosserj', 'B00680285', 'Rosser', 'Julee'),
(169, 'senetarm', 'B00683059', 'Senetar', 'Lisa'),
(170, 'vagtsr', 'B00682173', 'Vagts', 'Rachel'),
(171, 'kennisonm', 'B00685916', 'Kennison', 'Monica'),
(172, 'feinbergd', 'B00687001', 'Feinberg', 'Daniel'),
(173, 'mitchellj', 'B00685785', 'Mitchell', 'Jennifer'),
(174, 'cartery', 'B00684922', 'Carter', 'Yoli'),
(175, 'heggens', 'B00687855', 'Heggen', 'Scott'),
(176, 'messinat', 'B00687361', 'Messina', 'Troy'),
(177, 'elbertn', 'B00690153', 'Elbert', 'Norb'),
(178, 'matakal', 'B00689325', 'Mataka', 'Lloyd'),
(179, 'mineop', 'B00684223', 'Mineo', 'Patrick'),
(180, 'parrm', 'B00685913', 'Parr', 'Mary'),
(181, 'wilkinsonc', 'B00638849', 'Wilkinson', 'Crystal'),
(182, 'abnerl', 'B00620180', 'Abner', 'Lisa'),
(183, 'youngyeuna', 'B00690243', 'Youngyeun', 'Anna'),
(184, 'barnette', 'B00212942', 'Barnett', 'Elizabeth'),
(185, 'mckeel', 'B00684611', 'Mckee', 'Lauren'),
(186, 'cupidonj', 'B00690054', 'Cupidon', 'Jean Rene'),
(187, 'moesgaardm', 'B00690439', 'Moesgaard', 'Martin'),
(188, 'lambc', 'B00314975', 'Lamb', 'Connie'),
(189, 'andersons', 'B00627970', 'Anderson', 'Shai'),
(190, 'maddend', 'B00694693', 'Madden', 'Dianna'),
(191, 'evanssh', '', 'Evans', 'Sharon'),
(192, 'jonessa', 'B00695818', 'Jones', 'Sarah'),
(193, 'fisherm', 'B00700303', 'Fisher', 'Michelle'),
(194, 'huntere', 'B00700359', 'Hunter', 'Ella'),
(195, 'kellye', 'B00700220', 'Kelly', 'Beth'),
(196, 'mackf', 'B00133904', 'Mack', 'Felicia'),
(197, 'sowersn', 'B00700386', 'Sowers', 'Nancy'),
(198, 'blymank', 'B00700469', 'Blyman', 'Kayla'),
(199, 'phelpss', 'B00313139', 'Phelps', 'Shannon'),
(200, 'dickersonj', 'B00700419', 'Dickerson', 'Jacob'),
(201, 'blackburnm', 'B00397202', 'Blackburn', 'Mary'),
(202, 'brownjar', 'B00358199', 'Brown', 'Jarrod'),
(203, 'masonq', 'B00695816', 'Mason', 'Qrescent'),
(204, 'polishj', 'B00699259', 'Polish', 'Jessica'),
(205, 'johnsonsh', 'B00482411', 'Arnold', 'Shareese'),
(206, 'malll', 'B00709017', 'Mall', 'Scott'),
(207, 'clementsn', 'B00481613', 'Clements', 'Nathaniel'),
(208, 'bashama', 'B00310451', 'Basham', 'Anthony'),
(209, 'kirkpatrickb', 'B00629153', 'Kirkpatrick', 'Benjamin'),
(210, 'lewisro', 'B00622618', 'Lewis', 'Robert'),
(211, 'bentleyv', 'B00392087', 'Bentley', 'Vernon'),
(212, 'mullikina', 'B00345767', 'Mullikin', 'Adam'),
(213, 'ellisra', 'B00654174', 'Ellis', 'Randy'),
(214, 'ingramp', 'B00659032', 'Ingram', 'Perry'),
(215, 'conleya', 'B00417977', 'Conley', 'Albert'),
(216, 'houset', 'B00566287', 'House', 'Tom'),
(217, 'mckinneya', 'B00354203', 'McKinney', 'Andy'),
(218, 'cooperm', 'B00225542', 'Cooper', 'Melvin'),
(219, 'ramsayb', 'B00326492', 'Ramsay', 'Bill'),
(220, 'tarterj', 'B00344474', 'Tarter', 'Joe'),
(221, 'arrittm', 'B00124850', 'Arritt', 'Mona'),
(222, 'weckmanj', 'B00326513', 'Weckman', 'Judith'),
(223, 'chapmanc', 'B00108098', 'Chapman', 'Clara'),
(224, 'ryann', '', 'Ryan', 'Nancy'),
(225, 'reimondos', 'B00062564', 'Reimondo', 'Sue'),
(226, 'vaughns', 'B00415007', 'Vaughn', 'Susan'),
(227, 'kuhlmannl', 'B00249278', 'Kuhlmann', 'Linda'),
(228, 'davidsonj', 'B00327134', 'Davidson', 'Jeanette'),
(229, 'thomasca', 'B00473567', 'Thomas', 'Carl'),
(230, 'millerc', 'B00168668', 'Miller', 'Christopher'),
(231, 'labusm', 'B00108062', 'Labus', 'Mary'),
(232, 'bucknerj', 'B00382487', 'Buckner', 'Jay'),
(233, 'wellss', 'B00363386', 'Wells', 'Sandy'),
(234, 'gerassimidesg', 'B00252314', 'Gerassimides', 'Gus'),
(235, 'burnsidev', 'B00308489', 'Burnside', 'Virgil'),
(236, 'abneys', 'B00291305', 'Abney', 'Scotty'),
(237, 'morgand', 'B00448274', 'Morgan', 'Donna'),
(238, 'bullockk', 'B00506966', 'Bullock', 'Keith'),
(239, 'berheideb', 'B00192770', 'Berheide', 'Becky'),
(240, 'williamsr', 'B00344807', 'Williams', 'Regina'),
(241, 'reedj', 'B00397520', 'Reed', 'Jeff'),
(242, 'longk', 'B00274061', 'Long', 'Kevin'),
(243, 'himesl', 'B00397775', 'Himes', 'Lonnie'),
(244, 'rosenbarkerd', 'B00050618', 'Rosenbarker', 'Damon'),
(245, 'christopherp', 'B00290798', 'Christopher', 'Phyllis'),
(246, 'cottrille', 'B00239855', 'Cottrill', 'Elgin'),
(247, 'lyonss', 'B00275624', 'Lyons', 'Sheila'),
(248, 'schillh', 'B00388022', 'Schill', 'Heather'),
(249, 'stonel', 'B00292997', 'Stone', 'Linda'),
(250, 'jacksona', 'B00414515', 'Jackson', 'Allen'),
(251, 'lillyd', 'B00398027', 'Lilly', 'Debbie'),
(252, 'mclaughlinm', '', 'McLaughlin', 'Mary'),
(253, 'shinnn', '', 'Shinn', 'Nancy'),
(254, 'johnss', 'B00290918', 'Johns', 'Sue'),
(255, 'morgando', 'B00397871', 'Morgan', 'Dorothy'),
(256, 'singhj', 'B00041183', 'Singh', 'Joanne'),
(257, 'mccollumd', 'B00363176', 'McCollum', 'Dianne'),
(258, 'gergenj', 'B00397367', 'Gergen', 'Judy'),
(259, 'blairjo', 'B00330305', 'Blair', 'John'),
(260, 'crawfordla', 'B00415058', 'Crawford', 'Larky'),
(261, 'thomasc', 'B00538949', 'Thomas', 'Chris'),
(262, 'kelleym', 'B00385475', 'Kelley', 'Melissa'),
(263, 'murrayc', 'B00380195', 'Murray', 'Connie'),
(264, 'tarterp', 'B00267776', 'Tarter', 'Patty'),
(265, 'hookera', 'B00529148', 'Hooker', 'Alice'),
(266, 'brandenburga', 'B00137786', 'Brandenburg', 'Aurelia'),
(267, 'gentryd', 'B00383123', 'Gentry', 'Dreama'),
(268, 'amburgeyj', 'B00414791', 'Amburgey', 'Jeff'),
(269, 'poffa', 'B00328409', 'Poff', 'Alane'),
(270, 'strandj', 'B00057215', 'Strand', 'Jim'),
(271, 'williamsc', 'B00190052', 'Williams', 'Connie'),
(272, 'thieles', 'B00364259', 'Thiele', 'Sherry'),
(273, 'mottj', 'B00190631', 'Mott', 'Judy'),
(274, 'reynoldslo', 'B00463712', 'Reynolds', 'Loretta'),
(275, 'curlinb', 'B00499172', 'Curlin', 'Beth'),
(276, 'morrism', 'B00397859', 'Morris', 'Mike'),
(277, 'deaverr', 'B00137684', 'Deaver', 'Ron'),
(278, 'abneyb', 'B00308756', 'Abney', 'Beverly'),
(279, 'lakesc', 'B00350564', 'Lakes', 'Chris'),
(280, 'davidm', '', 'David', 'Miriam'),
(281, 'stockerd', 'B00291182', 'Stocker', 'Darlene'),
(282, 'gabbardp', 'B00248882', 'Gabbard', 'Phyllis'),
(283, 'milletth', 'B00399236', 'Millett', 'Heather'),
(284, 'copel', 'B00344876', 'Cope', 'Linda'),
(285, 'stancilm', 'B00290975', 'Stancil', 'Mary'),
(286, 'ingramr', 'B00414965', 'Ingram', 'Rick'),
(287, 'elamt', 'B00384170', 'Elam', 'Tammy'),
(288, 'carrierl', 'B00398159', 'Carrier', 'Linda'),
(289, 'tiptond', 'B00414500', 'Tipton', 'David'),
(290, 'cornelisonj', 'B00344882', 'Cornelison', 'Jim'),
(291, 'wilkersond', 'B00567748', 'Wilkerson', 'David'),
(292, 'wilsonju', 'B00441821', 'Wilson', 'Judge'),
(293, 'weinerm', 'B00223391', 'Weiner', 'Mike'),
(294, 'nigrom', 'B00515930', 'Nigro', 'Mark'),
(295, 'mckinneyd', '', 'McKinney', 'Debbie'),
(296, 'cochranea', 'B00076682', 'Cochrane', 'Ashley'),
(297, 'hallso', 'B00596763', 'Hall', 'Sondra'),
(298, 'adamse', 'B00620057', 'Adams', 'Elaine'),
(299, 'akinsj', 'B00615886', 'Akins', 'Jenny'),
(300, 'himesk', 'B00397574', 'Himes', 'Kay'),
(301, 'riceh', 'B00396920', 'Rice', 'Harry'),
(302, 'whittemorej', 'B00527645', 'Whittemore', 'Jennifer'),
(303, 'colep', 'B00610867', 'Cole', 'Brad'),
(304, 'arthurc', 'B00576814', 'Arthur', 'Candis'),
(305, 'lynns', 'B00010560', 'Lynn', 'Sylvester'),
(306, 'greenco', '', 'Green', 'Courtney'),
(307, 'keithr', 'B00412808', 'Keith', 'Robin'),
(308, 'hodsonl', 'B00411230', 'Hodson', 'Luke'),
(309, 'alexanderd', 'B00415454', 'Alexander', 'Debora'),
(310, 'cooked', 'B00115166', 'Cooke', 'David'),
(311, 'greenej', 'B00397826', 'Greene', 'Jacqui'),
(312, 'magnerl', 'B00597395', 'Magner', 'Laura'),
(313, 'lowdert', 'B00363161', 'Lowder', 'Theresa'),
(314, 'chenaultw', '', 'Chenault', 'William'),
(315, 'spiveyd', 'B00344774', 'Spivey', 'Donnie'),
(316, 'cornetth', 'B00281399', 'Cornett', 'Harrison'),
(317, 'blairje', 'B00280523', 'Blair', 'Saben'),
(318, 'cahillr', 'B00521162', 'Cahill', 'Richard'),
(319, 'berryc', 'B00596557', 'Berry', 'Chad'),
(320, 'bluel', 'B00609808', 'Blue', 'Loraine'),
(321, 'adkinsd', 'B00380492', 'Adkins', 'Doris'),
(322, 'chambersw', 'B00398831', 'Chambers', 'Wilma'),
(323, 'morans', 'B00292295', 'Moran', 'Sarah'),
(324, 'castles', 'B00602167', 'Castle', 'Sandy'),
(325, 'grantd', 'B00402408', 'Grant', 'Dennis'),
(326, 'edwardse', 'B00266834', 'Edwards', 'Gena'),
(327, 'sheheea', 'B00108122', 'Shehee', 'Amy'),
(328, 'anglinr', 'B00356333', 'Anglin', 'Rachael'),
(329, 'townsendm', 'B00248462', 'Townsend', 'Melinda'),
(330, 'evansd', 'B00251597', 'Evans', 'Dara'),
(331, 'stillwagonerd', 'B00127820', 'Stillwagoner', 'Darlene'),
(332, 'davisa', 'B00610772', 'Davis', 'Andrea'),
(333, 'brockc', 'B00291710', 'Brock', 'Cherri'),
(334, 'dyev', 'B00364085', 'Dye', 'Vicki'),
(335, 'hinklec', 'B00415031', 'Hinkle', 'Cheryl'),
(336, 'blairm', 'B00625179', 'Blair', 'Malissa'),
(337, 'cobba', 'B00622280', 'Cobb', 'Amanda'),
(338, 'rosenbarkerl', 'B00137924', 'Rosenbarker', 'Lisa'),
(339, 'taylord', 'B00076589', 'Taylor', 'Diana'),
(340, 'bonetm', 'B00508721', 'Bonet', 'Mary Beth'),
(341, 'hessr', 'B00095102', 'Hess', 'Ryan'),
(342, 'middletonc', '', 'Middleton', 'Connie'),
(343, 'sandbergc', 'B00617954', 'Sandberg', 'Curtis'),
(344, 'robertslakesr', 'B00211466', 'RobertsLakes', 'Rachel'),
(345, 'wansleysa', 'B00617781', 'Wansley', 'Samuel'),
(346, 'slinkerd', 'B00569953', 'Slinker', 'David'),
(347, 'teaterr', 'B00337997', 'Teater', 'Becky'),
(348, 'bashamk', 'B00323528', 'Basham', 'Katherine'),
(349, 'testert', '', 'Tester', 'Testit'),
(350, 'sandifers', 'B00368279', 'Sandifer', 'Shalamar'),
(351, 'mchargued', '', 'McHargue', 'David'),
(352, 'osborner', '', 'Osborne', 'Randy'),
(353, 'kaylorl', 'B00326702', 'Kaylor', 'Leslie'),
(354, 'glotzbacht', 'B00251714', 'Glotzbach', 'Tim'),
(355, 'mcclanahanc', '', 'McClanahan', 'Caitlin'),
(356, 'lippsk', 'B00625746', 'Lipps', 'Kathy'),
(357, 'kelleyr', 'B00345257', 'Kelley', 'Richard'),
(358, 'shinnl', '', 'Shinn', 'Larry'),
(359, 'jonesg', 'B00629660', 'Jones', 'Gina'),
(360, 'paynetr', 'B00293312', 'Payne', 'Trena'),
(361, 'juddam', '', 'Judd', 'Amy'),
(362, 'cartmillm', 'B00632290', 'Cartmill', 'Mark'),
(363, 'mckeell', 'B00632546', 'McKeel', 'Lori'),
(364, 'hayess', 'B00630640', 'Hayes', 'Steven'),
(365, 'hornan', 'B00631824', 'Horn', 'Anthony'),
(366, 'linvillej', 'B00315050', 'Linville', 'Jeffrey'),
(367, 'binghamte', 'B00634273', 'Bingham', 'Terry'),
(368, 'partainm', 'B00634096', 'Partain', 'Matthew'),
(369, 'turnerjes', 'B00364727', 'Turner', 'Jessa'),
(370, 'tafflerr', 'B00635568', 'Taffler', 'Robin'),
(371, 'winkerp', 'B00506384', 'Winker', 'Paul'),
(372, 'furmonb', '', 'Furmon', 'Brenda'),
(373, 'mccormickg', '', 'McCormick', 'Gary'),
(374, 'harnedb', 'B00326930', 'Harned', 'Bob'),
(375, 'meyerj', 'B00517316', 'Meyer', 'Janet'),
(376, 'garrettl', 'B00641237', 'Garrett', 'Rochelle'),
(377, 'riddellt', 'B00638872', 'Riddell', 'Teena'),
(378, 'gibaldim', 'B00242402', 'Gibaldi', 'Marie'),
(379, 'jordant', 'B00326045', 'Jordan', 'Tim'),
(380, 'allenj', 'B00398033', 'Allen', 'Johnna'),
(381, 'cookb', 'B00325967', 'Cook', 'Beverly'),
(382, 'blairj', 'B00309017', 'Blair', 'Jeffery'),
(383, 'huckd', 'B00615289', 'Huck', 'Daniel'),
(384, 'reedd', 'B00364667', 'Reed', 'Deloris'),
(385, 'robertsond', 'B00649965', 'Robertson', 'Donna'),
(386, 'rosea', 'B00344852', 'Rose', 'Alan'),
(387, 'coxv', 'B00645479', 'Cox', 'Victoria'),
(388, 'robbinsch', 'B00650571', 'Robbins', 'Chris'),
(389, 'hemenwayj', 'B00650316', 'Hemenway', 'John'),
(390, 'broomfields', 'B00196055', 'Broomfield', 'Sarah'),
(391, 'stokleyd', 'B00650997', 'Stokley', 'Donnie'),
(392, 'penaj', 'B00587197', 'Pena', 'Jessica'),
(393, 'tiptonk', 'B00362729', 'Tipton', 'Kyle'),
(394, 'thompsonde', 'B00583399', 'Thompson', 'Deborah'),
(395, 'taylorr', 'B00559430', 'Taylor', 'Rachael'),
(396, 'burchw', 'B00649881', 'Burch', 'Wanda'),
(397, 'whites', 'B00380606', 'White', 'Sara'),
(398, 'hoslert', 'B00614564', 'Hosler', 'Terry'),
(399, 'parrishr', 'B00650985', 'Parrish', 'Rebecca'),
(400, 'dandeneaug', 'B00344945', 'Dandeneau', 'Glen'),
(401, 'widnerd', 'B00651771', 'Widner', 'Douglas'),
(402, 'ceesayv', 'B00447137', 'Ceesay', 'Jenny'),
(403, 'pattersonc', 'B00651344', 'Patterson', 'Clint'),
(404, 'cumminse', 'B00274352', 'Cummins', 'Elaine'),
(405, 'hemenwayje', 'B00652089', 'Hemenway', 'Jessica'),
(406, 'dufourh', 'B00360236', 'Dufour', 'Heather'),
(407, 'reedcy', 'B00651194', 'Reed', 'Cynthia'),
(408, 'connore', 'B00096338', 'Connor', 'Erin'),
(409, 'vaughnst', '', 'Vaughn', 'Stephen'),
(410, 'pearsond', 'B00327470', 'Pearson', 'Darla'),
(411, 'hundleyr', 'B00651191', 'Hundley', 'Peyton'),
(412, 'jordanp', 'B00652762', 'Jordan', 'Penny'),
(413, 'gown', 'B00652761', 'Gow', 'Nancy'),
(414, 'maddenas', 'B00412979', 'Madden', 'Ashleigh'),
(415, 'motleyc', '', 'Motley', 'Christian'),
(416, 'linkew', 'B00571953', 'Linke', 'Walter'),
(417, 'thompsonte', 'B00653929', 'Thompson', 'Teri'),
(418, 'gardnerc', 'B00414554', 'Gardner', 'Connie'),
(419, 'hornro', 'B00655194', 'Horn', 'Ron'),
(420, 'doann', 'B00655348', 'Doan', 'Nora'),
(421, 'brewerda', 'B00380057', 'Brewer', 'Daniel'),
(422, 'boggsj', 'B00324737', 'Boggs', 'Jamie'),
(423, 'cornetts', 'B00411836', 'Cornett', 'Sara'),
(424, 'sartore', 'B00338741', 'Sartor', 'Elizabeth'),
(425, 'wardm', 'B00627719', 'Ward', 'Megan'),
(426, 'chappelll', 'B00656246', 'Tincher', 'Leigh'),
(427, 'dalessiok', 'B00409418', 'Dalessio', 'Kristin'),
(428, 'clementss', 'B00659089', 'Clements', 'Sara'),
(429, 'branscumh', 'B00372905', 'Branscum', 'Holly'),
(430, 'giftw', 'B00080483', 'Gift', 'Wesley'),
(431, 'lewisas', '', 'Lewis', 'Ashley'),
(432, 'southerlands', 'B00567955', 'Southerland', 'Shawnna'),
(433, 'higginbothamam', 'B00660134', 'Higginbotham', 'Amanda'),
(434, 'harrisk', 'B00660218', 'Harris', 'Katie'),
(435, 'weavert', 'B00613567', 'Weaver', 'Todd'),
(436, 'legera', 'B00660502', 'Leger', 'Amanda'),
(437, 'butwella', 'B00311438', 'Butwell', 'Ann'),
(438, 'devenskym', 'B00660437', 'Devensky', 'Matthew'),
(439, 'livingstone', 'B00659338', 'Livingston', 'Esther'),
(440, 'singletonp', 'B00660559', 'Singleton', 'Derrick'),
(441, 'gilmorea', 'B00660674', 'Gilmore', 'Alison'),
(442, 'masseyam', 'B00660675', 'Massey', 'Amanda'),
(443, 'johnstonjo', 'B00660747', 'Johnston', 'Joshua'),
(444, 'Colesa', 'B00574424', 'Cole', 'Sam'),
(445, 'holmesj', 'B00535907', 'Zimmerman', 'Jenna'),
(446, 'isstest', '', 'Test', 'ISS'),
(447, 'jordanf', '', 'Jordan', 'Frank'),
(448, 'mcqueensa', 'B00612517', 'McQueen', 'Sarah'),
(449, 'mooremi', 'B00585142', 'Moore', 'Mindy'),
(450, 'doddr', 'B00661170', 'Dodd', 'Richard'),
(451, 'crawforda', 'B00176381', 'Crawford', 'Aaron'),
(452, 'murrayju', 'B00661352', 'Murray', 'Judy'),
(453, 'barrettt', 'B00642539', 'Barrett', 'Teresa'),
(454, 'kingc', 'B00660211', 'King', 'Connie'),
(455, 'owensrh', 'B00661479', 'Owens', 'Rhonda'),
(456, 'adamsros', 'B00255986', 'Adams', 'Rosemarie'),
(457, 'christians', 'B00662357', 'Christian', 'Sue'),
(458, 'morgesont', 'B00383858', 'Morgeson', 'Tammy'),
(459, 'cftl', '', '', 'cftl'),
(460, 'keckm', 'B00659766', 'Keck', 'Mary'),
(461, 'mullinsl', 'B00514619', 'Mullins', 'Lyndsey'),
(462, 'belchert', 'B00359357', 'Featherly', 'Tracy'),
(463, 'CLReservations', '', 'Life', 'Campus'),
(464, 'nosem', 'B00317693', 'Nose', 'Melissa'),
(465, 'catep', 'B00666581', 'Cate', 'Pamela'),
(466, 'dennism', 'B00667317', 'Dennis', 'Marilyn'),
(467, 'choater', 'B00234375', 'Choate', 'Robin'),
(468, 'jonesste', 'B00326780', 'Jones', 'Steve'),
(469, 'lambh', 'B00656794', 'Lamb', 'Heather'),
(470, 'richardsonde', 'B00651090', 'Richardson', 'Gwen'),
(471, 'clontzh', 'B00658764', 'Clontz', 'Heather'),
(472, 'mcgranahanj', '', 'McGranahan', 'Justin'),
(473, 'hallk', 'B00662810', 'Hall', 'Kevin'),
(474, 'riffec', 'B00663367', 'Riffe', 'Celesta'),
(475, 'gabbardn', 'B00302309', 'Gabbard', 'Natalie'),
(476, 'bowmanj', 'B00344555', 'Bowman', 'John'),
(477, 'reynoldsb', 'B00345089', 'Reynolds', 'Barry'),
(478, 'sandlina', 'B00297356', 'Sandlin', 'Alena ''Brittany'''),
(479, 'evansch', 'B00659199', 'Evans', 'Charlie'),
(480, 'wilsonte', 'B00669171', 'Wilson', 'Terry'),
(481, 'Wolfenbargerr', 'B00399566', 'Wolfenbarger', 'Rodney'),
(482, 'crockettl', 'B00297359', 'Crockett', 'Laura'),
(483, 'lewellens', 'B00651784', 'Lewellen', 'Susie'),
(484, 'cashells', 'B00669380', 'Cashell', 'Stephanie'),
(485, 'erwinc', 'B00293300', 'Erwin', 'Crystal'),
(486, 'robbinsd', 'B00670023', 'Robbins', 'Danielle'),
(487, 'sizemorech', 'B00669688', 'Sizemore', 'Christina'),
(488, 'mooreke', 'B00669687', 'Moore', 'Kelli'),
(489, 'mooreje', 'B00600057', 'Moore', 'Jerrod'),
(490, 'smithcat', 'B00670013', 'Smith', 'Cathy'),
(491, 'poffj', 'B00146210', 'Poff', 'Jamie'),
(492, 'countst', 'B00666847', 'Counts', 'Tracy'),
(493, 'bowersr', 'B00383453', 'Bowers', 'Robert'),
(494, 'jonesmo', 'B00670092', 'Jones', 'Monica'),
(495, 'boggsbr', '', 'Boggs', 'Brenda'),
(496, 'bowmang', 'B00669797', 'Bowman', 'Gail'),
(497, 'turleya', 'B00191129', 'Turley', 'Alicestyne'),
(498, 'jonesli3', 'B00670276', 'Jones', 'Lisa'),
(499, 'roelofsl', 'B00662333', 'Roelofs', 'Lyle'),
(500, 'crutcherc', 'B00644545', 'Crutcher', 'Carey'),
(501, 'turnerli', 'B00452564', 'Turner', 'Lisa'),
(502, 'pollardj', 'B00412175', 'Pollard', 'Jennie'),
(503, 'hamptonan', 'B00670788', 'Hampton', 'Angela '),
(504, 'davisrosenbaums', 'B00670814', 'Davis-Rosenbaum', 'Steve'),
(505, 'pennycuffj', 'B00581927', 'Pennycuff', 'Jayla'),
(506, 'parkm', 'B00236576', 'Park', 'Maggie'),
(507, 'orrj', 'B00670789', 'Orr', 'James'),
(508, 'daviste', 'B00309197', 'Davis', 'Teresa'),
(509, 'beichlera', 'B00399956', 'Beichler', 'Andy'),
(510, 'hammondh', 'B00670573', 'Hammond', 'Heather'),
(511, 'lawsonje', 'B00672139', 'Lawson', 'Jenna'),
(512, 'carterta', 'B00391652', 'Carter', 'Tammy'),
(513, 'metcalfk', 'B00638567', 'Metcalf', 'Keri'),
(514, 'beattyk', 'B00674205', 'Beatty', 'Kimberly'),
(515, 'tauberts', 'B00666374', 'Taubert', 'Sherry'),
(516, 'williamsy', 'B00326507', 'Williams', 'Yvonne'),
(517, 'vanhookr', 'B00670472', 'Vanhook', 'Ronnie'),
(518, 'mitchells', 'B00215935', 'Mitchell', 'Sharyn'),
(519, 'deppc', 'B00674663', 'Depp', 'Chantel'),
(520, 'wallaceka', 'B00674664', 'Wallace', 'Kathy'),
(521, 'destefanisa', 'B00676908', 'DeStefanis', 'Amy'),
(522, 'gallowaym', 'B00207239', 'Galloway', 'Mary'),
(523, 'cueac', '', 'UEAC', 'Cisco'),
(524, 'FinancialS', '', 'Financial', 'Student'),
(525, 'morrisab', 'B00678819', 'Morris', 'Abby'),
(526, 'wheelerri', 'B00675163', 'Wheeler', 'Rita'),
(527, 'ahrenst', 'B00679531', 'Ahrens', 'Thomas'),
(528, 'stormsisaacsa', 'B00679959', 'Storms-Isaacs', 'Amanda'),
(529, 'whittamorel', 'B00647372', 'Whittamore', 'Rusty'),
(530, 'morrist', 'B00345884', 'Morris', 'Todd'),
(531, 'colemanl', 'B00679375', 'Coleman', 'Laney'),
(532, 'pangbornj', 'B00678810', 'Pangborn', 'Joshua'),
(533, 'bidwellc', 'B00679229', 'Bidwell', 'Courtney'),
(534, 'ladanyie', 'B00618601', 'Ladanyi', 'Elisabeth (Lisa)'),
(535, 'alexanderm', 'B00388595', 'Alexander', 'Mike'),
(536, 'hillb', 'B00571835', 'Hill', 'Brian'),
(537, 'offutta', 'B00680042', 'Offutt', 'Ashley'),
(538, 'arnoldja', 'B00362975', 'Arnold', 'Tom'),
(539, 'alexandert', 'B00330161', 'Alexander', 'Tim'),
(540, 'barrettj', 'B00059375', 'Barrett', 'James'),
(541, 'bealeaa', 'B00676426', 'Beale', 'Aaron'),
(542, 'adamsju', 'B00671016', 'Adams', 'Judy'),
(543, 'carpenterca', 'B00307754', 'Carpenter', 'Carl'),
(544, 'bratcherk', 'B00679991', 'Bratcher', 'Kathy'),
(545, 'hensleyr', 'B00637687', 'Hensley', 'Rodney'),
(546, 'johnsonth', 'B00679992', 'Johnson', 'Thomas'),
(547, 'ladouceure', 'B00535982', 'LaDouceur', 'Emily'),
(548, 'kirkt', 'B00089807', 'Kirk', 'Tennant'),
(549, 'carpenterw', 'B00291902', 'Carpenter', 'William'),
(550, 'mattinglyg', 'B00215934', 'Mattingly', 'Gary'),
(551, 'mckenziec', 'B00529415', 'McKenzie', 'Christopher'),
(552, 'peterss', 'B00677232', 'Peters', 'Stephen'),
(553, 'lyle', '', 'Roelofs', 'Lyle'),
(554, 'mathisp', 'B00671017', 'Mathis', 'Pam'),
(555, 'shortke', 'B00291005', 'Short', 'Kenneth'),
(556, 'teststaff', '', 'Staff', 'Test'),
(557, 'mullinslin', 'B00640618', 'Mullins', 'Lindsey'),
(558, 'mullinsch', 'B00585581', 'Mullins', 'Chester'),
(559, 'santiagok', 'B00203816', 'Santiago', 'Kara'),
(560, 'coyd', 'B00344759', 'Coy', 'Don'),
(561, 'mckenzieg', 'B00407153', 'McKenzie', 'Grace'),
(562, 'shearerd', 'B00668687', 'Shearer', 'Alan'),
(563, 'startzmanj', '', 'Startzman', 'J-D'),
(564, 'rowsej', 'B00620947', 'Rowse', 'Jamie'),
(565, 'embertonk', 'B00670774', 'Emberton', 'Kiel'),
(566, 'waldenm', 'B00672597', 'Walden', 'Mark'),
(567, 'smithwil', 'B00680153', 'Smith', 'Willam'),
(568, 'spanglerme', 'B00666848', 'Spangler', 'Melissa'),
(569, 'roelofsla', 'B00669913', 'Roelofs', 'Laurie'),
(570, 'osborneme', '', 'Osborne', 'Melissa'),
(571, 'stoebelj', 'B00680179', 'Stoebel', 'Jacob'),
(572, 'pricetr', 'B00300131', 'Price', 'Troy'),
(573, 'gurtatowskij', 'B00680029', 'Gurtatowski', 'Jill'),
(574, 'mullinscl', 'B00647492', 'Mullins', 'Clifford'),
(575, 'milbyt', 'B00680240', 'Milby', 'Trent'),
(576, 'clontzp', 'B00680373', 'Clontz', 'Phillip'),
(577, 'paulyj', 'B00680388', 'Pauly', 'Joan'),
(578, 'daviser', 'B00680409', 'Davis', 'Eric'),
(579, 'kingjes', '', 'King', 'Bailey'),
(580, 'bryantje', 'B00661682', 'Bryant', 'Jennifer'),
(581, 'hinklech', 'B00339761', 'Hinkle', 'Chelsi'),
(582, 'ssc', '', 'Student Service Center', 'Registrar'),
(583, 'warrenr', 'B00680616', 'Warren', 'Robert'),
(584, 'robinsonga', 'B00545818', 'Robinson', 'Alex'),
(585, 'morganjoh', 'B00365819', 'Morgan', 'John'),
(586, 'thomasmi', 'B00626036', 'Thomas', 'Michael'),
(587, 'taylorang', 'B00681302', 'Taylor', 'Angela'),
(588, 'tracys', 'B00681359', 'Tracy', 'Scott'),
(589, 'watkinsva', 'B00681426', 'Watkins', 'Valeria'),
(590, 'crimk', 'B00600699', 'Crim', 'Kelsey'),
(591, 'mcclainn', 'B00639496', 'McClain', 'Nate'),
(592, 'campbellc', 'B00277439', 'Campbell', 'Charlie'),
(593, 'francisch', 'B00606286', 'Francis', 'Channing'),
(594, 'sizemorest', 'B00682964', 'Sizemore', 'Stanley'),
(595, 'millerjas', 'B00683054', 'Miller', 'Jason'),
(596, 'swaffordd', 'B00683055', 'Swafford', 'Danny'),
(597, 'combsk', 'B00613006', 'Combs', 'Kendra'),
(598, 'davish', 'B00683457', 'Davis', 'Hallie'),
(599, 'collettje', 'B00683890', 'Collett', 'Jenny'),
(600, 'mullinsc', 'B00634353', 'Mullins', 'Candace'),
(601, 'burtm', 'B00599365', 'Burt', 'Melanie'),
(602, 'cootsd', 'B00680644', 'Coots', 'Dana'),
(603, 'brownbe', 'B00573165', 'Brown', 'Beth'),
(604, 'hudginsla', '', 'Hudgins', 'Lavoyed'),
(605, 'withrowr', 'B00686465', 'Withrow', 'Rose'),
(606, 'goverwa', 'B00687782', 'Gover', 'Wade'),
(607, 'tuckerr', 'B00306749', 'Tucker', 'Rebecca'),
(608, 'cornettr', 'B00687840', 'Cornett', 'Ryan'),
(609, 'combscr', 'B00687838', 'Combs', 'Craig'),
(610, 'hubbardka', 'B00657840', 'Hubbard', 'Kayla'),
(611, 'thomasma', 'B00663166', 'Thomas', 'Maleia'),
(612, 'blountr', 'B00647158', 'Blount', 'Duncan'),
(613, 'poultond', '', 'Poulton', 'David'),
(614, 'ashb', 'B00613734', 'Ash', 'Brittany'),
(615, 'snyderje', 'B00689086', 'Snyder', 'Jennifer'),
(616, 'pattonj', 'B00635622', 'Patton', 'Jacob'),
(617, 'bellnierd', 'B00622539', 'Bellnier', 'David'),
(618, 'brooksjo', 'B00638742', 'Brooks', 'Jordaun'),
(619, 'pcontrol', '', '', 'pcontrol'),
(620, 'thackerk', 'B00368333', 'Thacker', 'Kelley'),
(621, 'gordons', 'B00378134', 'Gordon', 'Sheri'),
(622, 'marciniakj', 'B00689918', 'Marciniak', 'Jennifer'),
(623, 'hernandezs', 'B00647560', 'Hernandez', 'Stephany'),
(624, 'gonzalesfr', 'B00264695', 'Gonzales', 'Fred'),
(625, 'ptce', '', 'ptce', ''),
(626, 'klopfera', 'B00590105', 'Klopfer', 'Alicia'),
(627, 'deutscherk', '', 'Deutscher', 'Kylie'),
(628, 'rathbonea', 'B00583220', 'Rathbone', 'Austin'),
(629, 'murphykat', 'B00647943', 'Murphy', 'Kathleen'),
(630, 'hallrappoleej', 'B00629064', 'Hall-Rappolee', 'Johanna'),
(631, 'jenkinsdo', 'B00690289', 'Jenkins', 'Donna'),
(632, 'hackettt', 'B00602718', 'Hackett', 'Tasha'),
(633, 'coxer', 'B00639870', 'Cox', 'Erin'),
(634, 'gibsonm', 'B00281150', 'Gibson', 'Mary'),
(635, 'buchananje', 'B00690344', 'Buchanan', 'Jessica'),
(636, 'bostl', 'B00690345', 'Bost', 'Laura'),
(637, 'smithbra', 'B00690362', 'Smith', 'Brad'),
(638, 'jonesdaw', 'B00690359', 'Jones', 'Dawn'),
(639, 'collettijonesl', 'B00690238', 'Colletti-Jones', 'Lisa'),
(640, 'wyliec', 'B00525245', 'Wylie', 'Crystal'),
(641, 'partaing', 'B00690396', 'Partain', 'Gayle'),
(642, 'priceth', '', 'Price', 'Thomas'),
(643, 'livesays', 'B00220586', 'Livesays', 'Sarah'),
(644, 'shupea', 'B00298895', 'Shupe', 'Ami'),
(645, 'kiddl', '', 'Kidd', 'Lisa'),
(646, 'scrippst', 'B00690547', 'Scripps', 'Theo'),
(647, 'weddingtond', 'B00325331', 'Weddington', 'Daniel'),
(648, 'korbh', '', 'Korb', 'Holly'),
(649, 'hayessu', '', 'Hayes-Gonzales', 'Suzanna'),
(650, 'meglenj', 'B00690624', 'Meglen', 'Jenna'),
(651, 'stjohnj', 'B00690836', 'St. John', 'Johann'),
(652, 'thomasonm', 'B00690828', 'Thomason', 'Mark'),
(653, 'couchsa', 'B00690988', 'Couch', 'Sara'),
(654, 'quarlesr', 'B00605954', 'Quarles', 'Roger'),
(655, 'durhamk', 'B00635472', 'Durham', 'Kevin'),
(656, 'wrayj', 'B00314285', 'Wray', 'JoJo'),
(657, 'capillod', 'B00377603', 'Capillo', 'Danielle'),
(658, 'johnsonhe', 'B00678386', 'Johnson', 'Heather'),
(659, 'pooleje', 'B00691483', 'Poole', 'Jennifer'),
(660, 'brockr', 'B00597297', 'Brock', 'Rachel'),
(661, 'jamesd', 'B00630672', 'James', 'Dylan'),
(662, 'belll', 'B00623111', 'Bell', 'Loreal'),
(663, 'morganchr', 'B00693257', 'Morgan', 'Chris'),
(664, 'marcumb', 'B00693254', 'Marcum', 'Belinda'),
(665, 'wilesm', 'B00691614', 'Wiles', 'Micah'),
(666, 'altschulm', 'B00693529', 'Altschul', 'Melissa'),
(667, 'linvillek', 'B00302621', 'Linville', 'Kelly'),
(668, 'gilbertam', 'B00559879', 'Gilbert', 'Amy'),
(669, 'collierj', 'B00244727', 'Collier', 'Jackie'),
(670, 'webbda', 'B00628087', 'Webb', 'Daniel'),
(671, 'jadudc', 'B00694773', 'Jadud', 'Carrie'),
(672, 'littleje', 'B00694777', 'Little', 'Jennifer'),
(673, 'wallacez', '', 'Wallace', 'Zachary'),
(674, 'hobsonj', 'B00694784', 'Hobson', 'Jenny'),
(675, 'turnernat', 'B00659066', 'Turner', 'Nathan'),
(676, 'waltersja', 'B00545791', 'Walters', 'Jason'),
(677, 'jonesand', 'B00695792!', 'Jones', 'Andrew'),
(678, 'perduec', 'B00695904', 'Perdue', 'Casey'),
(679, 'robertsje', 'B00277523', 'Roberts', 'Jennifer'),
(680, 'gallowayk', 'B00330290', 'Galloway', 'Kelvin'),
(681, 'lawsonl', 'B00334577', 'Lawson', 'Lori'),
(682, 'clarkst', 'B00083162', 'Clark', 'Stephanie'),
(683, 'berryl', 'B00642238', 'Berry', 'Lisa'),
(684, 'mckeehanan', 'B00370787', 'McKeehan', 'Andrea'),
(685, 'wassonm', 'B00054473', 'Wasson', 'Michelle'),
(686, 'cootsdo', 'B00696672', 'Coots', 'Doug'),
(687, 'hughesmic', 'B00696673', 'Hughes', 'Michael'),
(688, 'mcfaddend', 'B00696731', 'McFadden', 'Devona'),
(689, 'gleavess', 'B00642230', 'Gleaves', 'Samuel'),
(690, 'berrych', 'B00567362', 'Berry', 'Christopher'),
(691, 'wrayja', '', 'Wray', 'James'),
(692, 'woodsl', 'B00698636', 'Woods', 'Lutricia'),
(693, 'hallta', 'B00698656', 'Hall', 'Tanya'),
(694, 'elliottm', 'B00698696', 'Elliott', 'Marsha'),
(695, 'martinvo', 'B00698695', 'Martin', 'Vonda'),
(696, 'butcherp', 'B00698824', 'Butcher', 'Pam'),
(697, 'mcphersond', '', 'McPherson', 'Denessa'),
(698, 'norrisb', 'B00698834', 'Norris', 'Billy'),
(699, 'williamsons', 'B00698835', 'Williamson', 'Shane'),
(700, 'willoughbyk', '', 'Willoughby', 'Kasey'),
(701, 'wrightka', 'B00698969', 'Wright', 'Karen'),
(702, 'mckenziem', 'B00699270', 'McKenzie', 'Marlene'),
(703, 'jakubowskis', '', 'Jakubowski', 'Shawn'),
(704, 'douglasb', 'B00699569', 'Douglas', 'Bernadine'),
(705, 'hubbardna', 'B00699681', 'Hubbard', 'Nathaniel'),
(706, 'mcintoshje', 'B00380237', 'McIntosh', 'Jennifer'),
(707, 'newtont', 'B00699764', 'Newton', 'Tory'),
(708, 'colec', 'B00651501', 'Cole', 'Cameron'),
(709, 'thomasas', 'B00636647', 'Thomas', 'Ashley'),
(710, 'grindstaffk', 'B00648412', 'Grindstaff', 'Katie'),
(711, 'smithmol', 'B00654170', 'Smith', 'Molly'),
(712, 'tudora', 'B00699773', 'Tudor', 'Amanda'),
(713, 'eppsm', 'B00699772', 'Epps', 'Marcus'),
(714, 'bontak', 'B00647454', 'Bonta', 'Kelly'),
(715, 'colemanch', '', 'Coleman', 'Chris'),
(716, 'petroskis', '', 'Petroski', 'Sonya'),
(717, 'thomasrac', '', 'Thomas', 'Rachel'),
(718, 'shortkr', '', 'Short', 'Kristi'),
(719, 'partina', 'B00653944', 'Partin', 'Ashley'),
(720, 'buckmasters', 'B00700245', 'Buckmaster', 'Susan'),
(721, 'rileyk', 'B00655917', 'Riley', 'Koty'),
(722, 'simsj', 'B00653335', 'Sims', 'Jordan'),
(723, 'hughesca', '', 'Hughes', 'Catherine'),
(724, 'swordc', '', 'Sword', 'Candace'),
(725, 'lawsonst', '', 'Lawson', 'Steve'),
(726, 'philpotm', 'B00700347', 'Philpot', 'Melinda'),
(727, 'burken', '', 'Burke', 'Naomi'),
(728, 'chenhp', '', 'Chen', 'Huapei'),
(729, 'morgann', 'B00700460', 'Morgan', 'Nancy-Jo'),
(730, 'schroaderj', '', 'Schroader', 'John'),
(731, 'lovellk', '', 'Lovell', 'Kristy'),
(732, 'olesa', 'B00044402', 'Oles', 'Andrew'),
(733, 'hustonw', 'B00700548', 'Huston', 'Patrick'),
(734, 'newhousea', 'B00700535', 'Newhouse', 'Renae'),
(735, 'sieversd', '', 'Sievers', 'Debra'),
(736, 'grinnellc', '', 'Grinnell', 'Cody'),
(737, 'bruces', '', 'Bruce', 'Shawn'),
(738, 'montgomeryjam', '', 'Montgomery', 'James'),
(739, 'hayesm', '', 'Hayes', 'Matthew'),
(740, 'andrewsj', 'B00700571', 'Andrews', 'James'),
(741, 'blaneya', '', 'Blaney', 'Admiral'),
(742, 'kimj', 'B00702460', 'Kim', 'John'),
(743, 'eppersonj', 'B00702459', 'Epperson', 'John'),
(744, 'adamstr', 'B00690506', 'Adams', 'Travis'),
(745, 'baileyv', 'B00700502', 'Bailey', 'Victoria'),
(746, 'brandenburgc', 'B00643724', 'Brandenburg', 'Christina'),
(747, 'caink', 'B00708064', 'Cain', 'Kala'),
(748, 'mcclainje', 'B00680717', 'McClain', 'Jeffery'),
(749, 'collettju', 'B00392795', 'Collett', 'Justin'),
(750, 'cornettd', 'B00700565', 'Cornett', 'Daniel'),
(751, 'couchv', 'B00680631', 'Couch', 'Victoria'),
(752, 'couchj', 'B00700501', 'Couch', 'Johnathan'),
(753, 'deharte', 'B00700573', 'Dehart', 'Elizabeth'),
(754, 'feltnere', 'B00700574', 'Feltner', 'Evelyn'),
(755, 'frostr', 'B00690397', 'Frost', 'Ruth'),
(756, 'fugatei', 'B00685185', 'Fugate', 'Irene'),
(757, 'gaym', 'B00680618', 'Gay', 'Megan'),
(758, 'grayk', 'B00680633', 'Gray', 'Kathy'),
(759, 'gwinc', 'B00700566', 'Gwin', 'Cassondra'),
(760, 'hydej', 'B00690515', 'Hyde', 'Janet'),
(761, 'isaacsje', 'B00696132', 'Isaacs', 'Jennifer'),
(762, 'lanem', 'B00690358', 'Lane', 'Merlie'),
(763, 'lewisti', 'B00700527', 'Lewis', 'Tiffany'),
(764, 'lewismi', 'B00700529', 'Lewis', 'Michael'),
(765, 'mullinschr', 'B00643724', 'Mullins', 'Christopher'),
(766, 'rootc', 'B00700530', 'Root', 'Carrie'),
(767, 'sheltonka', 'B00700528', 'Shelton', 'Kayla'),
(768, 'wellsch', 'B00680623', 'Wells', 'Charles'),
(769, 'wootonm', 'B00680635', 'Wooton', 'Mara'),
(770, 'amundsens', 'B00707950', 'Amundsen', 'Shirley'),
(771, 'bentonr', 'B00707945', 'Benton', 'Rebecca'),
(772, 'chaviesv', 'B00669048', 'Chavies', 'Vanessa'),
(773, 'huffd', 'B00700525', 'Huff', ' Damon'),
(774, 'dunnr', 'B00691523', 'Dunn', 'Ruth'),
(775, 'frithl', 'B00681412', 'Frith', 'Lisa'),
(776, 'mannngk', 'B00691079', 'Manning', 'Kimberly'),
(777, 'millercou', 'B00680643', 'Miller', 'Courntey'),
(778, 'napiera', 'B00690548', 'Napier', 'Amber'),
(779, 'suttonc', 'B00691656', 'Sutton', 'Courtney'),
(780, 'wrighth', 'B00681413', 'Wright', 'Holli'),
(781, 'leem', '', 'Lee', 'Melissa'),
(782, 'begleyt', '', 'Begley', 'Tanya'),
(783, 'goldeyc', '', 'Goldey', 'Charles'),
(784, 'woodj', '', 'Wood', 'James'),
(785, 'pelfreyc', '', 'Pelfrey', 'Charles'),
(786, 'robertsau', '', 'Roberts', 'Austin'),
(787, 'nantzp', 'B00708137', 'Nantz', 'Patricia'),
(788, 'catesj', 'B00690627', 'Cates', 'Jackie'),
(789, 'arthurj', 'B00708449', 'Arthur', 'Joshua'),
(790, 'bakerna', 'B00708400', 'Baker', 'Natasha'),
(791, 'warfordp', 'B00691077', 'Warford', 'Paul'),
(792, 'macleank', 'B00708938', 'MacLean', 'Kyle'),
(793, 'hunleyr', '', 'Hunley', 'Richard'),
(794, 'campt', '', 'Camp', 'Tiffany'),
(795, 'manceborodriguezlima', 'B00692407', 'Rodriguez', 'Rubem'),
(796, 'durhaml', 'B00598849', 'Durham', 'Lee'),
(797, 'godseyv', 'B00213657', 'Godsey', 'Veronica'),
(798, 'strangeb', '', 'Strange', 'Beverly'),
(799, 'smithty', '', 'Smith', 'Tyler'),
(800, 'strobelm', '', 'Strobel', 'Melissa'),
(801, 'hamptonam', '', 'Hampton', 'Amanda'),
(802, 'layn', 'B00629930', 'Lay', 'Nicole'),
(803, 'trank', '', 'Tran', 'Kate'),
(804, 'ruckere', 'B00352799', 'Rucker', 'Ellen'),
(805, 'hallte', 'B00709764', 'Hall', 'Teresa'),
(806, 'abnerk', 'B00709796', 'Abner', 'Kelly'),
(807, 'feltnerg', 'B00708406', 'Feltner', 'Gary'),
(808, 'caudillji', 'B00709716', 'Caudill', 'Jimmy'),
(809, 'combscou', 'B00709634', 'Combs', 'Courtney'),
(810, 'mcqueena', 'B00710076', 'McQueen', 'Alison'),
(811, 'sizemorehe', '', 'Sizemore', 'Helena'),
(812, 'taylorben', 'B00632410', 'Taylor', 'Benjamin'),
(813, 'mountsz', 'B00640635', 'Mounts', 'Zachary'),
(814, 'manningbeavins', 'B00314087', 'Manning-Beavin', 'Sara'),
(815, 'nerdinc', 'B00709616', 'Nerdin', 'Clarissa'),
(816, 'ecklere', 'B00655875', 'Eckler', 'Emily'),
(817, 'brayjon', 'B00709690', 'Bray', 'Jonathan'),
(818, 'hillke', 'B00569822', 'Hill', 'Kelsey'),
(819, 'leejes', '', 'Lee', 'Jessica'),
(820, 'vaughto', 'B00639791', 'Vaught', 'Oliver'),
(821, 'creekmorea', 'B00577244', 'Creekmore', 'Ashley'),
(822, 'patrickd', '', 'Patrick', 'Darryll'),
(823, 'darsta', '', 'Darst', 'Abbie'),
(824, 'collettk', 'B00711023', 'Collett', 'Karen'),
(825, 'dailyc', 'B00711039', 'Daily', 'Cheryl'),
(826, 'hughescan', 'B00711174', 'Hughes', 'Candace'),
(827, 'ratliffca', 'B00711182', 'Ratliff', 'Candi'),
(828, 'stacyk', 'B00711180', 'Stacy', 'Kayla'),
(829, 'miraclem', 'B00711173', 'Miracle', 'Megan'),
(830, 'harshmane', 'B00711541', 'Harshman', 'Eric'),
(831, 'thompsonz', '', 'Thompson', 'Zack'),
(832, 'sporingl', 'B00652417', 'Sporing', 'Lawrence'),
(833, 'cornettth', 'B00711750', 'Cornett', 'Theodore');

-- --------------------------------------------------------

--
-- Table structure for table `ldapstudents`
--

CREATE TABLE IF NOT EXISTS `ldapstudents` (
  `username` int(11) NOT NULL AUTO_INCREMENT,
  `bnumber` longtext NOT NULL,
  `lastname` longtext NOT NULL,
  `firstname` longtext NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `parameters`
--

CREATE TABLE IF NOT EXISTS `parameters` (
  `pID` int(11) NOT NULL AUTO_INCREMENT,
  `year` int(11) NOT NULL,
  `appOpenDate` datetime NOT NULL,
  `appCloseDate` datetime NOT NULL,
  `mileageRate` float NOT NULL,
  `laborRate` float NOT NULL,
  PRIMARY KEY (`pID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `parameters`
--

INSERT INTO `parameters` (`pID`, `year`, `appOpenDate`, `appCloseDate`, `mileageRate`, `laborRate`) VALUES
(1, 2016, '2015-12-07 00:00:00', '2016-01-31 00:00:00', 0.49, 8);

-- --------------------------------------------------------

--
-- Table structure for table `postsurvey`
--

CREATE TABLE IF NOT EXISTS `postsurvey` (
  `psID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`psID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `presurvey`
--

CREATE TABLE IF NOT EXISTS `presurvey` (
  `psID` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`psID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `programs`
--

CREATE TABLE IF NOT EXISTS `programs` (
  `pID` int(11) NOT NULL AUTO_INCREMENT,
  `name` longtext NOT NULL,
  `abbreviation` longtext NOT NULL,
  PRIMARY KEY (`pID`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=41 ;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`pID`, `name`, `abbreviation`) VALUES
(1, 'Biology', 'BIO'),
(2, 'Chemistry', 'CHM'),
(3, 'Mathematics', 'MAT'),
(4, 'Nursing', 'NUR'),
(5, 'Physics', 'PHY'),
(6, 'Agriculture and Natural Resources', 'ANR'),
(7, 'Computer Science', 'CSC'),
(8, 'Economics and Business', 'BUS'),
(9, 'Economics and Business', 'ECO'),
(10, 'Sustainability & Environmental Studies', 'SENS'),
(11, 'Technology and Applied Design', 'TAD'),
(12, 'Child and Family Studies', 'CFS'),
(13, 'Health & Human Performance', 'HHP'),
(14, 'Health & Human Performance', 'HLT'),
(15, 'Psychology', 'PSY'),
(16, 'Sociology', 'SOC'),
(17, 'Communication', 'COM'),
(18, 'English', 'ENG'),
(19, 'Foreign Languages', 'FRN'),
(20, 'Foreign Languages', 'GER'),
(21, 'Foreign Languages', 'JPN'),
(22, 'Foreign Languages', 'LAT'),
(23, 'Foreign Languages', 'SPN'),
(24, 'Music', 'MUA'),
(25, 'Music', 'MUS'),
(26, 'Theatre', 'THR'),
(27, 'Art and Art History', 'ARH'),
(28, 'Art and Art History', 'ART'),
(29, 'Asian Studies', 'AST'),
(30, 'History', 'HIS'),
(31, 'Philosophy', 'PHI'),
(32, 'Political Science', 'PSC'),
(33, 'Religion', 'REL'),
(34, 'African and African American Studies', 'AFR'),
(35, 'Appalachian Studies', 'APS'),
(36, 'Education Studies', 'EDS'),
(37, 'Peace and Social Justice Studies', 'PSJ'),
(38, 'Womens and Gender Studies', 'WGS'),
(39, 'General Studies', 'GST'),
(40, 'General Studies', 'GSTR');

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE IF NOT EXISTS `projects` (
  `pID` int(11) NOT NULL AUTO_INCREMENT,
  `title` longtext NOT NULL,
  `budgetID_id` int(11) NOT NULL,
  `duration` int(11) NOT NULL,
  `startDate` datetime NOT NULL,
  `year` int(11) NOT NULL,
  `hasCommunityPartner` tinyint(1) NOT NULL,
  `isServiceToCommunity` tinyint(1) NOT NULL,
  `humanSubjects` tinyint(1) DEFAULT NULL,
  `numberStudents` int(11) NOT NULL,
  `status` longtext NOT NULL,
  `createdDate` datetime NOT NULL,
  PRIMARY KEY (`pID`),
  KEY `projects_budgetID_id` (`budgetID_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`pID`, `title`, `budgetID_id`, `duration`, `startDate`, `year`, `hasCommunityPartner`, `isServiceToCommunity`, `humanSubjects`, `numberStudents`, `status`, `createdDate`) VALUES
(1, '(1) Cotylaspis insignis (Trematoda: Aspidogastrea): Seasonal Recruitment, Migration and Differentiation in the Mollusk Host (2) The Effect of Temperature on the Release of the Proterometra macrostoma Cercaria from its Snail Intermediate Host', 1, 8, '2016-06-06 00:00:00', 2016, 0, 0, 0, 4, 'Pending', '2015-12-18 09:26:11'),
(3, 'Experiments in Condensed Matter Physics', 3, 10, '2016-05-30 00:00:00', 2016, 0, 0, 0, 3, 'Pending', '2016-01-04 09:32:36'),
(4, 'Biomass Stove Design Project: Automated Fuel Feeder System', 4, 8, '2016-05-16 00:00:00', 2016, 1, 1, 0, 4, 'Withdrawn', '2016-01-06 10:11:26'),
(5, 'Examination of the Effectiveness of a Peer-Assisted Learning (PAL) Pilot Program in Anatomy & Physiology I and II', 5, 8, '2016-06-06 00:00:00', 2016, 0, 0, 1, 3, 'Pending', '2016-01-07 16:11:38'),
(6, 'I.  Isolation and characterization of mobile genetic elements from  non-pathogenic human commensal Escherichia coli –  a continuing research study AND  II.  Prevalence and isolation / characterization of antibiotic-resistant  Staphylococcus aureus in Berea College students - a research pilot study ', 6, 8, '2016-05-12 00:00:00', 2016, 0, 0, 0, 4, 'Pending', '2016-01-12 15:24:57'),
(7, 'Expressive Writing among Healthy College Students: a Self-Help Strategy to Improve Quality of Life', 7, 8, '2016-05-16 00:00:00', 2016, 0, 0, 1, 2, 'Withdrawn', '2016-01-15 13:48:35'),
(8, 'Nutritional Management and Reproductive Performance of Beef Heifers Raised in Sustainable Production Systems at Berea College and Community Producer Operations', 8, 8, '2016-05-16 00:00:00', 2016, 0, 1, 0, 4, 'Pending', '2016-01-15 13:53:22'),
(9, 'Collecting Cultures', 9, 8, '2016-05-15 00:00:00', 2016, 0, 0, 0, 2, 'Pending', '2016-01-15 14:36:23'),
(10, 'Using Lean Body Mass to Determine Kettlebell Training Loads for Power and Cardiovascular Fitness: A Pilot Study', 10, 10, '2016-05-16 00:00:00', 2016, 0, 0, 1, 3, 'Pending', '2016-01-15 14:51:39'),
(11, 'Engineering Novel Substrates for the Neuropeptidase Neurolysin', 11, 8, '2016-05-11 00:00:00', 2016, 0, 0, 0, 4, 'Pending', '2016-01-15 16:42:05'),
(12, 'Summer Food Service Program Evaluation ', 12, 8, '2016-05-16 00:00:00', 2016, 1, 1, 1, 3, 'Pending', '2016-01-18 10:36:27'),
(13, 'Design and Development of a Web Based Computer Simulation', 13, 8, '2016-05-17 00:00:00', 2016, 0, 1, 0, 4, 'Pending', '2016-01-18 11:17:20'),
(14, 'Developing Low-Cost, High-Impact Laboratory Exercises for Behavioral Neuroscience', 14, 8, '2016-06-06 00:00:00', 2016, 0, 0, 0, 4, 'Pending', '2016-01-18 11:24:19'),
(15, 'Spreading Knowledge of the Berea College Art Collection to the Larger Community', 15, 8, '2016-05-09 00:00:00', 2016, 0, 0, 0, 2, 'Pending', '2016-01-18 11:29:17'),
(16, 'Comparison of Small Mammal Remains from Barn Owl (Tyto alba) Pellets Collected in 1998 from a Silo Roost on the Campus of Lincoln Memorial University in Northern Claiborne County, Tennessee ', 16, 8, '2016-05-16 00:00:00', 2016, 0, 0, 0, 3, 'Pending', '2016-01-18 12:10:32'),
(17, 'The effects of life history stage and membrane composition on temperature tolerance in an ectotherm', 17, 10, '2016-05-16 00:00:00', 2016, 0, 0, 0, 3, 'Pending', '2016-01-18 13:00:54'),
(18, 'Diversity and Community Policing', 18, 8, '2016-05-16 00:00:00', 2016, 1, 1, 0, 2, 'Pending', '2016-01-18 15:19:44'),
(19, 'Without Metaphor', 19, 9, '2016-05-23 00:00:00', 2016, 0, 0, 0, 2, 'Pending', '2016-01-18 15:41:25'),
(20, 'Implementation of Digital Fabrication Technologies in Ceramics Practice', 20, 8, '2016-06-01 00:00:00', 2016, 0, 0, 0, 2, 'Pending', '2016-01-18 15:57:15'),
(21, 'Studies on Seed Dormancy, Germination, Survivorship, and Competition for the Rare Cream Gentian, Gentiana flavida (Gentianaceae)', 21, 8, '2016-05-16 00:00:00', 2016, 0, 0, 0, 2, 'Pending', '2016-01-18 18:49:17'),
(22, 'Mathematics of Phylogenetics', 22, 8, '2016-05-16 00:00:00', 2016, 0, 0, 0, 4, 'Pending', '2016-01-19 10:34:41'),
(23, 'Persistence of the herbicide glyphosate in forest soils', 23, 8, '2016-05-16 00:00:00', 2016, 0, 1, 0, 4, 'Pending', '2016-01-19 13:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `urcppfaculty`
--

CREATE TABLE IF NOT EXISTS `urcppfaculty` (
  `fID` int(11) NOT NULL AUTO_INCREMENT,
  `pID_id` int(11) NOT NULL,
  `username_id` varchar(255) NOT NULL,
  `yearsFunded` longtext NOT NULL,
  `relatedFunding` longtext NOT NULL,
  `programID_id` int(11) NOT NULL,
  PRIMARY KEY (`fID`),
  KEY `urcppfaculty_username_id` (`username_id`),
  KEY `urcppfaculty_pID_id` (`pID_id`),
  KEY `urcppfaculty_programID_id` (`programID_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `urcppfaculty`
--

INSERT INTO `urcppfaculty` (`fID`, `pID_id`, `username_id`, `yearsFunded`, `relatedFunding`, `programID_id`) VALUES
(1, 1, 'rosenr', '{\r\ntwoyr: true, \r\n}', '', 1),
(3, 3, 'messinat', '{\r\n}', '', 5),
(4, 4, 'mahoneym', '{\r\nthreeToFiveyr: true, \r\n}', '', 11),
(5, 5, 'blanks', '{\r\ntwoyr: true, \r\n}', '', 1),
(6, 6, 'andersond', '{\r\ntwoyr: true, \r\n}', '', 1),
(7, 7, 'lambc', '{\r\n}', '', 4),
(8, 8, 'baptisteq', '{\r\noneyr: true, \r\n}', '', 6),
(9, 9, 'cohenj', '{\r\noneyr: true, \r\n}', '', 18),
(10, 10, 'mortaraa', '{\r\noneyr: true, \r\ntwoyr: true, \r\n}', '', 13),
(11, 11, 'saderholmm', '{\r\ntwoyr: true, \r\n}', '', 2),
(12, 12, 'woodwarda', '{\r\ntwoyr: true, \r\n}', '', 16),
(13, 13, 'veillettem', '{\r\nsixToTenyr: true, \r\n}', '', 5),
(14, 14, 'messerw', '{\r\nsixToTenyr: true, \r\n}', '', 15),
(15, 15, 'dohertym', '{\r\ntwoyr: true, \r\n}', '', 27),
(16, 16, 'douglasg', '{\r\noneyr: true, \r\n}', '', 1),
(17, 17, 'mineop', '{\r\noneyr: true, \r\n}', '', 1),
(18, 18, 'brownke', '{\r\nsixToTenyr: true, \r\n}', '', 17),
(19, 19, 'feinbergd', '{\r\noneyr: true, \r\n}', '', 28),
(20, 20, 'gonzalezr', '{\r\n}', '', 28),
(21, 21, 'adamsch', '{\r\noneyr: true, \r\n}', '', 1),
(22, 22, 'kellye', '{\r\n}', '', 3),
(23, 23, 'smithsonp', '{\r\ntwoyr: true, \r\nthreeToFiveyr: true,\r\nsixToTenyr: true,\r\nelevenPlus: true\r\n}', '', 2);

-- --------------------------------------------------------

--
-- Table structure for table `urcppstudents`
--

CREATE TABLE IF NOT EXISTS `urcppstudents` (
  `sID` int(11) NOT NULL AUTO_INCREMENT,
  `username_id` int(11) NOT NULL,
  `preSurveyID_id` int(11) NOT NULL,
  `postSurveyID_id` int(11) NOT NULL,
  `projectID_id` int(11) NOT NULL,
  PRIMARY KEY (`sID`),
  KEY `urcppstudents_username_id` (`username_id`),
  KEY `urcppstudents_preSurveyID_id` (`preSurveyID_id`),
  KEY `urcppstudents_postSurveyID_id` (`postSurveyID_id`),
  KEY `urcppstudents_projectID_id` (`projectID_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `voting`
--

CREATE TABLE IF NOT EXISTS `voting` (
  `vID` int(11) NOT NULL AUTO_INCREMENT,
  `committeeID_id` varchar(255) NOT NULL,
  `projectID_id` int(11) NOT NULL,
  `studentLearning` float DEFAULT NULL,
  `studentAccessibility` float DEFAULT NULL,
  `qualityOfResearch` float DEFAULT NULL,
  `studentDevelopment` float DEFAULT NULL,
  `facultyDevelopment` float DEFAULT NULL,
  `collaborative` float DEFAULT NULL,
  `interaction` float DEFAULT NULL,
  `communication` float DEFAULT NULL,
  `scholarlySignificance` float DEFAULT NULL,
  `proposalQuality` float DEFAULT NULL,
  `budget` float DEFAULT NULL,
  `timeline` float DEFAULT NULL,
  `comments` longtext,
  PRIMARY KEY (`vID`),
  KEY `voting_projectID_id` (`projectID_id`),
  KEY `voting_committeeID_id` (`committeeID_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `voting`
--

INSERT INTO `voting` (`vID`, `committeeID_id`, `projectID_id`, `studentLearning`, `studentAccessibility`, `qualityOfResearch`, `studentDevelopment`, `facultyDevelopment`, `collaborative`, `interaction`, `communication`, `scholarlySignificance`, `proposalQuality`, `budget`, `timeline`, `comments`) VALUES
(1, 'heggens', 1, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 'Notes!'),
(2, 'heggens', 23, 1, 4, 4, 4, 4, 4, 2, 2, 1, 4, 4, 1, 'Testing!'),
(3, 'heggens', 3, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, 4, ''),
(4, 'broomfields', 1, 5, 5, 1, 1, 1, 1, 1, 1, 2, 2, 1, 3, 'Notes');

--
-- Constraints for dumped tables
--

--
-- Constraints for table `collaborators`
--
ALTER TABLE `collaborators`
  ADD CONSTRAINT `collaborators_ibfk_1` FOREIGN KEY (`pID_id`) REFERENCES `projects` (`pID`),
  ADD CONSTRAINT `collaborators_ibfk_2` FOREIGN KEY (`username_id`) REFERENCES `ldapfaculty` (`username`);

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`budgetID_id`) REFERENCES `budget` (`bID`);

--
-- Constraints for table `urcppfaculty`
--
ALTER TABLE `urcppfaculty`
  ADD CONSTRAINT `urcppfaculty_ibfk_1` FOREIGN KEY (`pID_id`) REFERENCES `projects` (`pID`),
  ADD CONSTRAINT `urcppfaculty_ibfk_2` FOREIGN KEY (`username_id`) REFERENCES `ldapfaculty` (`username`),
  ADD CONSTRAINT `urcppfaculty_ibfk_3` FOREIGN KEY (`programID_id`) REFERENCES `programs` (`pID`);

--
-- Constraints for table `urcppstudents`
--
ALTER TABLE `urcppstudents`
  ADD CONSTRAINT `urcppstudents_ibfk_1` FOREIGN KEY (`username_id`) REFERENCES `ldapstudents` (`username`),
  ADD CONSTRAINT `urcppstudents_ibfk_2` FOREIGN KEY (`preSurveyID_id`) REFERENCES `presurvey` (`psID`),
  ADD CONSTRAINT `urcppstudents_ibfk_3` FOREIGN KEY (`postSurveyID_id`) REFERENCES `postsurvey` (`psID`),
  ADD CONSTRAINT `urcppstudents_ibfk_4` FOREIGN KEY (`projectID_id`) REFERENCES `projects` (`pID`);

--
-- Constraints for table `voting`
--
ALTER TABLE `voting`
  ADD CONSTRAINT `voting_ibfk_1` FOREIGN KEY (`committeeID_id`) REFERENCES `ldapfaculty` (`username`),
  ADD CONSTRAINT `voting_ibfk_2` FOREIGN KEY (`projectID_id`) REFERENCES `projects` (`pID`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
