-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'btc2015',NULL,'6555 NW 9th Avenue, Suite 210<br>\nFt. Lauderdale, FL 33309<br>\nPhone: (877) 944-4235<br>\nFax: (954) 771-2098','',0);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=427 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','78bfd17437cb85e2d2acb28c01717fe5f8b13d1fd54fe9fc974934403d79a205',2,2,1941,'2014-03-04 20:52:18',46863347,1,0,1,NULL),(11,'Cornell','Peters','cjp@fortriscorp.com','02ddfa996b303cd6e1f57c9a51243e5f2b9ef3c5133959cda431d4395f39b3db',2,6,1982,'2014-03-08 02:31:35',63198034,1,0,1,NULL),(13,'CJ','Peters','info@fortriscorp.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1991,'2014-08-05 22:35:19',72423850,1,0,1,NULL),(14,'Cornell','Peters','fortriscorp@gmail.com','fe2e757802f5cff053eb5307ea69e65203bfff78e82b9144d47600008902a547',2,6,1948,'2014-08-06 02:19:45',60313016,1,6,1,NULL),(148,'Jeff','Gandelman','jgandelman@banyantreatmentcenter.com','437a29ca3fafa76c8579ee5b4b8e9c4ee53c7b80fd1f1597a05186dd1aa33d1a',21,10,1970,'2015-06-23 18:53:58',89098558,1,3,0,NULL),(149,'David','Goloski','dgoloski15@yahoo.com','07dc0ae5f02c136092da4fa9884504ada91148a6f393659fc92e5e1f3e68e871',14,11,1992,'2015-06-23 19:09:20',95924166,1,3,0,NULL),(150,'Christopher','Cosgrove','cozgrove1111@gmail.com','eff093e772f9e39b75b8d09a05d07ada433854a77953b8d05fe8a2a2fac7d85f',10,1,1989,'2015-06-23 19:32:41',65977093,1,3,0,NULL),(151,'darrell','toombs','toombs.darrell@yahoo.com','ed305ec6ba76f738dd760ed4326e0bbbcf31b9a5bbf6a1b7ec31611d8805793c',3,5,1968,'2015-06-23 20:25:18',41313893,1,17,0,NULL),(152,'Kyle','Feaman','kylefeaman@yahoo.com','8ceb0893936a93501b9fdfb9c469e7a6b7dc9195aa6ba66a8c9021f469b40b3f',7,6,1990,'2015-06-23 21:23:44',83999318,1,18,0,NULL),(153,'Josh','McPherson','jmcpherson@banyantreatmentcenter.com','9c97a772cd8905d2636d5d574d2a4f73b9535ce16688f446c3716b54d84ad7c6',18,12,1990,'2015-06-23 21:29:51',49620309,1,15,0,NULL),(154,'Anthony ','Johns','antbird89@gmail.com','7d4a7036291ae25934455c8431dd452bc0e66acf04160027863fef69c0a213da',7,11,1989,'2015-06-23 22:06:49',24168998,1,3,0,NULL),(155,'Shannon','Williams','shannonw050@gmail.com','0daf3706460197042727dc84e3f7258d5e9ed7f996cfedaf44fb0341b8dbd0f4',13,1,1987,'2015-06-24 00:19:52',35219739,1,11,0,NULL),(156,'ozzie','Ingram','oingram100@yahoo.com','e2e2cc36435d610303933b6e7a0ccc21fd056fa28ab56f6f5c7a206e10708714',4,11,1965,'2015-06-24 01:12:18',57108033,1,3,0,NULL),(157,'Alex','Cook','alex.cook5588@gmail.com','d2245216ef3c8b89eccdbb28a5d1cd2838c6727ee05a612b5ef06660a4acf01b',4,5,1988,'2015-06-24 01:52:49',13026501,1,3,0,NULL),(158,'william','reith','billreith16@gmail.com','d6da76410381eb15f816a30d1133c7417414423417d2f567a0aed1409dbd74fc',7,9,1967,'2015-06-24 02:48:34',27652417,1,16,0,NULL),(159,'Adam ','Silvers','silversadam44@yahoo.com','414d5e5568c4b5c10aab8571a8e9bcf411aefd8ef94cb3dc2873afbd1ffb92ef',18,11,1992,'2015-06-24 03:51:16',90420416,1,12,0,NULL),(160,'Kathryn','O\'Connell','elleoconnell1091@gmail.com','a784d1c45cb87942cbd5e28b243eda0fe8f04410d27a408fbcd03ee03a0a8b60',8,10,1991,'2015-06-24 03:55:21',40523840,1,3,0,NULL),(161,'Renee','Ross','renee.ross1814@gmail.com','dbd3ad85cf3db63e5c1d9a4fbd68233970be24ffe071e63b87b01edd5c31682e',5,5,1991,'2015-06-24 04:18:21',51937678,1,3,0,NULL),(162,'Robert','Gabal','rgabal91@gmail.com','557055b82a119069d0a81ae8dc95dfe78a487551bf561b60ccc3a70ab2567021',19,7,1991,'2015-06-24 06:05:39',82250396,1,3,0,NULL),(163,'Kristi','Salvatore','kaysalvatore223@yahoo.com','7c8971dd46c93a868756f120f78327e180efd6dea782f9a3da8cb3ec61050057',22,2,1994,'2015-06-24 07:03:12',92242750,1,11,0,NULL),(164,'dwght ','Knowles','dwightknowles@att.net','0730f7beef329339149fcdec61f49a347f4d9a35bf2946c99359275dc00b8c6b',28,4,1961,'2015-06-24 12:43:39',61618787,1,3,0,NULL),(165,'Salvatore ','Rose','bigsal383@yahoo.com','8aedba3d661c3fa80d03f7f921480b212d7b51bf85aa6e2ab8a3d60732b7a7f9',4,10,1984,'2015-06-24 13:14:43',65921294,1,3,0,NULL),(166,'LaTina','Williams','latinawims@yahoo.com','5d9d33b615172f1e0a04f59d635d34961002fc57accc3e216f8bdaad64d573c9',7,1,1977,'2015-06-24 15:41:15',22610916,1,7,0,NULL),(167,'Nicolas','Caballero','nico_11_04@yahoo.com','58a866fd62b22d4075e5890530f1e3424dca87c591c63e883128c88fa7a3c36b',3,11,1986,'2015-06-24 16:10:24',56515525,1,18,0,NULL),(168,'Frank ','Passarella','emailfrank14@gmail.com','a91f8647ba1cc6528815129bf9e0cabcafb40db262a9bba28a1d35267a570033',10,10,1973,'2015-06-24 18:04:33',96983126,1,3,0,NULL),(169,'kristin','merlo','KMERLO@BANYANTREATMENTCENTER.COM','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',6,7,1989,'2015-06-24 18:07:44',47303665,1,3,0,NULL),(170,'Sherilyn','Toro','sherilyntor@gmail.com','c78b7c27b07f8c07dda7a0502f818e19877640588567748166d6c1794af13f09',10,7,1992,'2015-06-24 18:19:43',89378607,1,3,0,NULL),(171,'Nicole ','Murano','nicolemurano@gmail.com','faf0cb7dace3521341d95166571d1eb27d633bfca4ee557bd6763ba7631d88dc',1,2,1986,'2015-06-24 18:27:52',83142995,1,9,0,NULL),(172,'Olin','Kennedy','kennedyolin61@gmail.com','a95246c9d6c45bb5653351db1dedb435a6d73155584b8cdafcf0e742c40a58ed',3,4,1996,'2015-06-24 19:35:31',17859957,1,3,0,NULL),(173,'makena ','mazur','makenamazur2@gmail.com','decc0e11be948382a3becf322547551d468d9c90e4946ee8e1abe892e2d7ebab',13,12,1991,'2015-06-24 21:31:03',66889738,1,3,0,NULL),(174,'Roberta','Eugene','RobertaEugene@yahoo.com','283d2437b056c1ac40cb5b50cb49bd3f99a7da3aea1cd301d591e587fd8d8af2',15,1,1986,'2015-06-24 21:55:54',53126319,1,11,0,NULL),(175,'Megan ','Shockley','mshockley91@yahoo.com','8c1f6046f9ed83248a4cfdc2e0df40ae747b3af101046a949652ab64ffd1ecd5',5,11,1991,'2015-06-24 22:49:41',74791074,1,3,0,NULL),(176,'Elizabeth','Matekovic','lizmatekovic18@gmail.com','739fb2fb3638462edde248916cc93728edcd31b67de991ebbc24746fa234f319',17,10,1993,'2015-06-25 04:55:39',17306672,1,7,0,NULL),(177,'Sam','Horovitz','sam.horovitz@gmail.com','32c5ef7ac91524ce2984fb7f473adbeb7603afa67d696b109b33b0507939ae8d',4,5,1991,'2015-06-25 07:25:06',97083514,1,3,0,NULL),(178,'art','palmer','art.palmer@comcast.net','834e39ad5f5fcea4c5bdfd3dbb1873c44ca2dfad8ca032368f9521b9a90768ab',5,7,1949,'2015-06-25 11:59:19',70558416,1,3,0,NULL),(179,'LATOYA','ZANDERS','latoya.zanders@yahoo.com','bf377164eec406c9b6ea687deee37117e143c46e144f214149d2e6f594754594',26,3,1984,'2015-06-25 14:49:48',90613470,1,9,0,NULL),(180,'gina','arnold','mginaarnold@yahoo.com','198e2ce5ecac5242bea01f6a890e286dc00c13fae96ae18486e9e27cb62ff708',15,4,1966,'2015-06-25 18:02:59',62089866,1,3,0,NULL),(181,'Stephen','Kenney','stevekenney75@gmail.com','e4b5e6107615245a202bf6a9aaa3e94a9b6584bd241be403f9217a4e302b78b7',6,9,1975,'2015-06-25 20:08:46',70737546,1,17,0,NULL),(182,'Frank','Touloumis Jr','ftouloumis@banyantreatmentcenter.com','2e66763f53b85062499253d747e2e1d9ad4cff53527f0e3a3661a6c785c13cd2',27,7,1989,'2015-06-25 20:19:14',66570792,1,9,0,NULL),(183,'Wyatt','Bostrom','wyattbostrom11@gmail.com','b68d34720e1ac79827b35123517066c5b81b8bf6188933dead249a8d70c92d74',19,7,1994,'2015-06-25 20:51:03',20060031,1,3,0,NULL),(184,'jaclyn','kobler','jaclyn780@gmail.com','52e9fcdeb8c6fcf349e7eeeebe61a42a81c18955cb72254169ce63a4895c684a',8,1,1987,'2015-06-25 21:08:48',14068046,1,13,0,NULL),(185,'Angel','Apolinaris','aapolinaris@banyantreatmentcenter.com','f2f8f3a5a3a38422045f976f129873b82eec261670169eab047f2c96650dacc4',12,1,1975,'2015-06-26 02:49:11',28230447,1,3,0,NULL),(186,'Amanda ','Cook','amandacook1984@gmail.com','63f764b5d87d983d55511a68f8319fd05265708ecdffdac1176fdefce718da08',7,10,1984,'2015-06-26 03:50:24',87052282,1,3,0,NULL),(187,'Glenn','Whelan','gwhelan55@yahoo.com','47994be4562cb235fc25c6eb9a287369da7a964e7953067d06d01a3e9801b8f5',16,4,1955,'2015-06-26 03:56:32',31538577,1,14,0,NULL),(188,'Alyssa','Newton','lyssleigh23@gmail.com','91e9a1949c03e4f3e0d27b6281721944d9858cddb1ca27fa164d5f5c17be6072',22,2,1995,'2015-06-26 07:03:02',18472526,1,14,0,NULL),(189,'Alyssa ','Howell','alyssahowell2@gmail.com','d9b4f1c6f309f0637702cb347e90e519006f7725acd59cee7fe2e57f8eaf0fda',17,11,1987,'2015-06-26 08:17:55',91786182,1,3,0,NULL),(190,'Jean','Thommen','jeannethommen@gmail.com','7717bf61a0828f4b97619ab4d3790a3e326fb1fe1000409ee237651ad115e6db',18,12,1960,'2015-06-26 14:43:16',25513351,1,3,0,NULL),(191,'Gloria','Freifeld','gfreifeld@banyantreatmentcenter.com','99c6cd2b6ab271c8ae926bfc3ff09d7cb2fb892c6b492790170a0c2d02f03bf0',17,9,1958,'2015-07-09 20:37:04',34419576,1,2,0,NULL),(192,'Inez','Edwards','Iedwards@banyantreatmentcenter.com','0d8bb402fb3d03b0f142ef5d525b68cdb8520b67ecaf31900b2c453c93e8615a',21,1,1960,'2015-07-17 07:30:19',49130259,1,4,0,NULL),(193,'Mercedes','Machado','mmachado1990@gmail.com','e1d6817c8e20484f1c0f5e908630270ee94d43ebf0528da95e425343432c0fe7',29,5,1990,'2015-08-15 17:51:20',67268896,1,12,0,NULL),(194,'Shira','Ackerman','shira@addictionacademy.com','NULL',4,10,1970,'2015-08-17 13:52:18',14170351,1,1,0,NULL),(195,'Katherine ','Townsend ','ktownsend2014@fau.edu','d9ec00122285e7dd31a08e73b5b9476ae8cbd4f2c4d5da35e2938426ff58b20a',13,11,1986,'2015-08-24 17:30:16',40955487,1,16,0,NULL),(196,'Kelley','Roberts','Kroberts@banyantreatmentcenter.com','9318ed656a29430205ff8fdd075e8d266b14d11f51ae81d75ea4ed246c85bec3',13,10,1985,'2015-08-24 18:17:02',45722837,1,17,0,NULL),(197,'Haley','Wilson','hwilson@banyantreatmentcenter.com','6e2e386aa131e86c2a29564b02cfdf8fed26f45a29334b3d112fc6eade6dd75d',23,9,1993,'2015-08-24 18:47:39',22979685,1,15,0,NULL),(198,'Samara','Quintero','squintero@banyantreatmentcenter.com','bc48788334115ab3aa581097a958a8d664a7eb85b80c93d9e1d52e7224417fda',25,5,1988,'2015-08-24 19:23:04',59704139,1,15,0,NULL),(199,'Oliver','Hora','ohora@banyantreatmentcenter.com','f237075352226ba17bf0857d1b4d4c835e6a3ce102a9828e7699cda0c84eb287',11,7,1972,'2015-08-24 20:26:09',70212494,1,18,0,NULL),(200,'Alyssa','Brady','abrady728@gmail.com','d8fc90cacfc7f9f5d79f2610d8997a59d0252392e8957295d248fcfddbc29317',27,7,1992,'2015-08-25 13:40:51',54216045,1,12,0,NULL),(201,'Anita','Smiley','asmiley@banyantreatmentcenter.com','2e03ada72b1777f10a9d257aca0a0a3807b2e0a8db6bdbebab7fe9d535ddfc63',26,6,1975,'2015-08-25 17:30:48',11415820,1,19,0,NULL),(202,'John','Sontag','jsontag231@gmail.com','288ca74b75d82741aa50d875a92eb23e894d489e30fb03928a5068c7ae3e9b0b',28,9,1993,'2015-08-25 21:59:32',76131133,1,11,0,NULL),(203,'Joseph ','Ragno','ragno3.joseph@gmail.com','0a02033f53fbabce05d2b871ddf54094d5fdbc38041df96df3a4bdac7439dcee',17,9,1990,'2015-08-26 05:50:10',81255047,1,3,0,NULL),(204,'Patricia','Stull','pattitude33@gmail.com','1d0a1d36d41d21b1d500a3c02bcc2efc1c9a0c937e157d7d60ec104a00d457f5',17,10,1968,'2015-08-26 10:13:56',78784210,1,6,0,NULL),(205,'Tyler','Braile','t.braile9@gmail.com','6d645d3fa8b946aa868d94f1179351220eeaee0f9fd9d896378c03a02420367d',6,11,1988,'2015-08-26 10:44:39',64531552,1,0,0,NULL),(206,'Tyler','Braile','aynonamyss9@gmail.com','267ba565bcfe9d923d33912c0f37f0cdda5b28201f9f121837ec042f831d8a8d',6,11,1988,'2015-08-26 10:46:22',80242138,1,2,0,NULL),(207,'Thomas','Dean','tdean@banyantreatmentcenter.com','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',8,11,1964,'2015-08-26 16:42:31',55420996,1,14,0,NULL),(208,'Heather','O\'Donnell','Heatherod1990@gmail.com','b8a56276321b43cbd5391e6570bbb8207a4a2ed2022c101bf5377fa91cf1f8f5',2,12,1990,'2015-08-26 20:08:57',39119442,1,17,0,NULL),(209,'Spencer ','Moore','srmoore818@gmail.com','1994ab013008632fa49e370408ceef5b3ad58c721efa324ac90c87a38a2fa1e4',17,8,1987,'2015-08-27 05:24:22',65659119,1,18,0,NULL),(210,'Dannielle','Swart','dswart@banyantreatmentcenter.com','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',10,7,1991,'2015-08-27 17:16:43',96849501,1,17,0,NULL),(211,'Kyle','McHugh','kmchugh@banyantreatmentcenter.com','ceeb133bc7b08123739d3c3b8a0eea98acdc3bbe137481547879fc8a07639321',23,12,1986,'2015-08-27 18:04:48',73121010,1,17,0,NULL),(212,'Robert','Castro','rcastro@banyantreatmentcenter.com','981812cd8240bf10b6c436d63de55afff4a22b3cf644612e69d9e66ae5518b06',17,1,1985,'2015-08-27 18:45:19',97779953,1,23,0,NULL),(213,'Diann','Toney','dtoney@banyantreatmentcenter.com','fe278df291d70cd1f553ad3e16baa00c88779c849a94877b8ab16e88ac07947b',12,12,1963,'2015-08-27 21:16:26',77552999,1,0,0,NULL),(214,'Peter','Tolosky','ptolosky@gmail.com','26db51861400229828944c989eb48e922fee459f92a856be2af61071b9455f62',6,6,1982,'2015-08-28 02:23:59',77302288,1,17,0,NULL),(215,'krystal ','serbeck ','kkserbeck@gmail.com','cc5923b680a9d1df766d8c44168d8a5a70509b441ec667e667eede6a1ff96602',13,9,1991,'2015-08-28 08:18:08',99643269,1,3,0,NULL),(216,'Diann','Toney','toneyporchia@bellsouth.net','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',16,3,1988,'2015-08-28 17:10:02',24229577,1,2,0,NULL),(217,'Lane','Feinberg','Lane.k.317@gmail.com','0dbf942c75e96208719c3cd15aecc1ae2d410b8d110d6bb2a4279d9b4afe724a',16,3,1980,'2015-08-29 06:36:42',60917351,1,17,0,NULL),(218,'Sheldon','Goldman','sobertech@banyantreatmentcenter.com','9e8435ecafcefdf0b1ca9b94dab798521b5bd6ea84291c70ebbef3ea9d9ff6de',9,4,1949,'2015-08-30 16:51:36',82176320,1,4,0,NULL),(219,'Virginia','Clancy','virginia.clancy1218@gmail.com','b15a03072f1fd62dfbddcb23654b85a04707a507badf18aac8ce69456d80b99d',17,12,1985,'2015-09-16 17:35:30',75758894,1,21,0,NULL),(220,'Shane ','Marcus','Shanerm77@gmail.com','d0dd8d57e59839ef059d790636e7e4949051ef6d1b334461a0aacf4abd8ee77b',25,9,1984,'2015-09-18 02:03:12',96229154,1,17,0,NULL),(221,'Salvatore ','Rose','srose@banyantreatmentcenter.com','5a6dd1e9fd5b96e56c8c4c18ad15e6ebb5af86e51d927bbd79345ce8565520ad',4,10,1984,'2015-09-18 13:28:46',59865755,1,6,0,NULL),(222,'Alton','Johnson','chris561561@yahoo.com','62779b88c7847c9851c625cde423bb236793203f02dc8f4f4edc272b7b9bc2bb',8,2,1989,'2015-09-18 13:35:29',43851453,1,18,0,NULL),(223,'Alicia','Allen-Lewis','a.allen-lewis@hotmail.com','5cbcc645288a10bfe88ccab984c796bcd045ab3c607c27e9f1a423a652950d79',14,6,1982,'2015-09-18 14:38:48',77666581,1,9,0,NULL),(224,'Reshma','Harilal','rharilal@banyantreatmentcenter.com','f1e1f5c869eff457867280b1a6063b2e3f1ca6685e36a5ddf0b25d527e3492d7',4,5,1974,'2015-09-20 00:38:10',23408548,1,18,0,NULL),(225,'david ','levitz','dlevitz2000@yahoo.com','815e39d599de5febe90381d0c33fbbd516909ee81953c47822b8cc55b48b55f9',9,3,1974,'2015-09-21 06:39:51',82147214,1,16,0,NULL),(226,'Michael','Stenson','mstenson003@gmail.com','9aa31b63818af23f08ff3f8d52c055a22453c12d647aae2b602a5acaeeac1bc2',3,6,1987,'2015-09-21 10:24:52',50055144,1,6,0,NULL),(227,'Michael','Stenson','sci7ms@yahoo.com','9aa31b63818af23f08ff3f8d52c055a22453c12d647aae2b602a5acaeeac1bc2',3,6,1987,'2015-09-21 10:25:53',88047754,1,11,0,NULL),(228,'Mary Lee','Delate','mdelate@banyantreatmentcenter.com','b6b45a7e383db451ba2e77b95b1114530d1fc290c9d49c2b18312c3dc1c23f68',23,7,1957,'2015-09-21 13:13:58',74738651,1,0,0,NULL),(229,'egbert','price','eprice7277@gmail.com','3937d7337f49c192872361c534ec3ed6f65ce01ba85a9434db559f22c746d97a',0,4,1976,'2015-09-21 21:26:06',95493430,1,13,0,NULL),(230,'Tyler','Braile','t.braile99@gmail.com','267ba565bcfe9d923d33912c0f37f0cdda5b28201f9f121837ec042f831d8a8d',13,11,1945,'2015-09-22 06:04:00',84143946,1,15,0,NULL),(231,'Haley','Wilson','wilsonh32@icloud.com','6e2e386aa131e86c2a29564b02cfdf8fed26f45a29334b3d112fc6eade6dd75d',23,9,1993,'2015-09-22 13:16:11',70751544,1,0,0,NULL),(232,'Marla','Sriskand','msriskand@banyantreatment.com','90df8bd12e7363830b938a8d016240221306b545c9d27e566ed982642f565bac',28,7,1955,'2015-09-22 16:21:26',84046096,1,16,0,NULL),(233,'Betty ','Rivers','riversgurl6512@gmail.com','ca3c4a52d2490e52d47dbb22dadc9252d527339d7c927362d28cb93f787c766e',22,7,1965,'2015-09-22 19:21:41',26148548,1,4,0,NULL),(234,'Yesenia','Ramirez','yesenia101109@yahoo.com','86e4203ef59f923154f6ad9a6e9f0792ca50f456b315ddd347100acca3edb260',15,3,1989,'2015-09-23 02:09:40',93443641,1,14,0,NULL),(235,'michelle','ortiz','miche_ortiz@aol.com','3d78fd7a27422439a6a65e46638b8b91025ef6be18cc6cab3ae52491dfa31f79',26,9,1983,'2015-09-23 05:54:35',86033586,1,17,0,NULL),(236,'christina','deperna','chris.deperna1007@gmail.com','3d6f505331be72cc95e6f49e111ec76e1529ba32b346e21404faa731581efca3',6,10,1984,'2015-09-23 06:21:20',89618327,1,49,0,NULL),(237,'Mary Ann','Walsh','mwalsh@banyantreatmentcenter.com','189579c73884e816e63cbe2fc2f2d1c36403afa96c4642bff2fac3d0f4f00ff4',6,4,1964,'2015-09-23 17:40:32',83267432,1,15,0,NULL),(238,'Jadus','Burgess','jstyleflyy@gmail.com','cb08524721601e747374c312c69583d85f8a175836ebc9bdba9fd69fb48d3813',1,12,1981,'2015-09-23 18:18:39',23141090,1,19,0,NULL),(239,'ariella','sherman','asherman@banyantreatmentcenter.com','17d12a3a21f22fe0b1425e8f2dca5164a01b9835f79b3d47e9fcfd2c1b571541',4,11,1989,'2015-09-24 13:01:24',44292445,1,19,0,NULL),(240,'Ryan','Steinberg','rsteinberg@banyantreatmentcenter.com','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',29,10,1990,'2015-09-25 00:46:48',73660250,1,19,0,NULL),(241,'Joan ','Bowla','jbowla@banyantreatmentcenter.com','077147a69d88a459b82c7e02b14665ca5d5fc0a105a080b4667f0b6b379bae95',28,6,1962,'2015-09-25 14:53:47',79791890,1,15,0,NULL),(242,'Olin','kennedy','okennedy@banyantreatmentcenter.com','0674a7aa42933fb3671b8b54f038297afdde23070f28d36ae33ee01e8f4dbcb1',3,4,1996,'2015-09-25 20:23:36',19247462,1,12,0,NULL),(243,'cheryl','smith','smithcheryl433@yahoo.com','1c6f15373435e9fe3aa9383b8b25db9947c9f7b6d64950ca9dfc4f8bfedbb90c',7,12,1955,'2015-09-28 04:55:07',41613199,1,18,0,NULL),(244,'art','palmer','apalmer@banyantreatmentcenter.com','834e39ad5f5fcea4c5bdfd3dbb1873c44ca2dfad8ca032368f9521b9a90768ab',5,7,1949,'2015-09-28 18:17:53',34957454,1,2,0,NULL),(245,'Julinda','Keja','jkeja328@aol.com','1aba4f1c5ef78d40812002ce991caef9b3926a385c679c961ee50d420b08b99d',5,7,1993,'2015-09-28 21:11:42',16896463,1,14,0,NULL),(246,'Stiphenee','Flores','stipheneeflores@gmail.com','ac5294d1fd12c2a202eb1922cd5be3ee9964d5e56688c0a867d74fc758d80bf9',9,1,1992,'2015-09-29 16:41:57',99927312,1,17,0,NULL),(247,'Mari','Middleton','marmic66@bellsouth.net','d43622ceb5c67367cc25a09ade1dccd5e9f14d6e9b0d84af1777aa4d59bc5c44',18,10,1962,'2015-09-30 00:01:30',48082187,1,13,0,NULL),(248,'Nicolas','Caballero','ncaballero@banyantreatmentcenter.com','58a866fd62b22d4075e5890530f1e3424dca87c591c63e883128c88fa7a3c36b',3,11,1986,'2015-09-30 01:10:14',13466444,1,0,0,NULL),(249,'Alyssa','Howell','alyssarenee06@yahoo.com','53de3315675b3970f82467cbb175359ea4c77c06127d0b97868a3d85886183d6',17,11,1987,'2015-09-30 03:56:13',41781953,1,11,0,NULL),(250,'Daniel','Cincotta','dcincotta5515@gmail.com','f774b81084029d2274cabc27d20fe7f1fc48ad24a6305a2f8001db28d4ae5015',3,10,1989,'2015-09-30 14:42:41',87510781,1,14,0,NULL),(251,'Kareen','Wisdom','kareenwis@yahoo.com','42099aa1d831c110f02e8e31412661ee9e9e849db7985015aebd99fadc5f8636',17,3,1980,'2015-09-30 18:10:35',11252858,1,2,0,NULL),(252,'Sherilyn','Toro','sherilyntoro@gmail.com','c78b7c27b07f8c07dda7a0502f818e19877640588567748166d6c1794af13f09',10,7,1992,'2015-10-01 17:03:51',95078433,1,9,0,NULL),(253,'Patricia','Stull','pstull@banyantreatmentcenter.com','bb7291d70bfbe216f6b85a092dba48216e1c66cb1297b5d32c15f8143427aa02',17,10,1968,'2015-10-02 05:40:55',87856243,1,16,0,NULL),(254,'Dwight ','Knowles','dwightk1961@gmail.com','05bb050c55a39db1c56c6decae5e15be08922524dcaaa93bd798cd706c612eca',28,4,1961,'2015-10-02 13:55:39',35314751,1,14,0,NULL),(255,'Sam','Horovitz','shorovitz@banyantreatmentcenter.com','32c5ef7ac91524ce2984fb7f473adbeb7603afa67d696b109b33b0507939ae8d',4,5,1991,'2015-10-02 14:20:19',89415772,1,6,0,NULL),(256,'stephen','kenney','skenney@banyantreatmentcenter.com','29097860c467aaba6fef2f8ba4f994149038042eddf7aaf93a6da2c4b3dd1106',6,9,1975,'2015-10-02 15:11:22',17610739,1,6,0,NULL),(257,'May','Lam','mlam1103@gmail.com','348c7488ff5b02d201ed4cb7942a07a4b9cd34a7bbceede4e058729258cebad8',2,11,1982,'2015-10-03 01:58:24',10837767,1,11,0,NULL),(258,'William','Fraser','bfraser7183@gmail.com','84648adf9a8e53e0289c9d435e488139353b5940329911401374972775d8f348',0,7,1983,'2015-10-03 03:06:55',35596993,1,17,0,NULL),(259,'Chantal','Marsh','chantal.marsh@yahoo.com','1ae291ec0a6287309d3703e3244323c5ee4bc0cd70603088dc66dcd1ea0e722a',16,12,1989,'2015-10-03 17:16:01',56630819,1,18,0,NULL),(260,'Peter','Gaudette','peter.gaudette94@gmail.com','48d2de6da378a10fcc3072ca102572b047a7132d99622abca83ca26533d498aa',6,2,1994,'2015-10-03 17:17:46',97613692,1,17,0,NULL),(261,'Jeremy','McKee','jmckee@banyantreatmentcenter.com','b621640f2ca53220e763aaba6c70b269087b44aa1c57afd6e5e7ea59f7bf1a1e',19,9,1982,'2015-10-03 17:38:35',25201376,1,14,0,NULL),(262,'Roberta','Eugene','Berta12340@gmail.com','283d2437b056c1ac40cb5b50cb49bd3f99a7da3aea1cd301d591e587fd8d8af2',15,1,1986,'2015-10-03 19:08:04',33794697,1,9,0,NULL),(263,'kathy','sanders','marshallkathy44@gmail.com','fa3a21e64cb50ee7d0f83e61376010c056da99c7dfec8dc20913c2499e7efc5b',28,6,1965,'2015-10-03 21:39:30',76302879,1,17,0,NULL),(264,'john','spencer','johnrainspencer@yahoo.com','1c2bb4fbafc326f662863e18644f81aab3cee93dd36fbeb1a4b9f3d31435c827',3,12,1960,'2015-10-03 22:49:57',39265299,1,11,0,NULL),(265,'Corbin','Personti','cpersonti@gmail.com','19d34b1d040b9de347618139a45e56406c75e972db5fa330c63d09b5c7a89ca5',11,4,1991,'2015-10-05 01:48:53',58840937,1,14,0,NULL),(266,'Cody','Bothe','cbothe@banyantreatmentcenter.com','b5b1aebf6c4d06118b6d74fe638738806a75ffa3468c7000757065de93296eee',28,10,1986,'2015-10-05 14:14:37',45991810,1,14,0,NULL),(267,'David','Humphries','dhumphries@banyantreatmentcenter.com','2b17f0e7f782e0aedb9337323236276ee3b8708fc71287b221a59dd35027faf1',12,8,1959,'2015-10-05 15:05:43',35223985,1,17,0,NULL),(268,'Maria ','Barakat','mbarakat@banyantreatmentcenter.com','13f5aff03daf32428574f19e5484afa7e823f611aa1ae7e9be9af27f1e3a3168',7,10,1990,'2015-10-06 15:47:27',44749821,1,11,0,NULL),(269,'Michelline','Wilson','wilsonmichelline@gmail.com','f9f4a3dd212834b3801c6a9248125921780fe4f439da280cc9408cd4ef8ee58e',20,8,1987,'2015-10-07 02:56:28',46763047,1,9,0,NULL),(270,'Crysta','Snyder','Crystachaos@icloud.com','d71119ed2ebded497b1383fc64fada7390c34fff0689c5539cc4a8f967c605ce',23,4,1993,'2015-10-07 05:58:13',82448863,1,20,0,NULL),(271,'David','Goloski','dgoloski@banyantreatmentcenter.com','07dc0ae5f02c136092da4fa9884504ada91148a6f393659fc92e5e1f3e68e871',14,11,1992,'2015-10-07 18:27:45',97361344,1,10,0,NULL),(272,'Wyatt','Bostrom','wbostrom@banyantreatmentcenter.com','3767bcf186f52b602650a7e8d5b1497b8ef553d793109281f0ab0c20502dcf71',19,7,1994,'2015-10-07 18:28:03',92805354,1,13,0,NULL),(273,'Frank','Passarella','fpassarella@banyantreatmentcenter.com','bfeab57e63d37ee0b44ff41c593b9b1ba6b8d5c5b975e10d84097d71a31fbf81',10,10,1973,'2015-10-08 15:39:48',78214164,1,19,0,NULL),(274,'Jesse','Wagner','jwagner@banyantreatmentcenter.com','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',21,6,1990,'2015-10-08 16:08:07',75177049,1,15,0,NULL),(275,'VANESSA','RAMIREZ','VRAMIREZ@BANYANTREATMENTCENTER.COM','0f413d5137f06cf5d3b595d4729c41a55949a751da42fc890015d2231b8c093f',26,8,1984,'2015-10-08 19:57:00',16864342,1,9,0,NULL),(276,'Marlies','Butler','mbutler@banyantreatmentcenter.com','427387082cc343cdbd4da0cca1a3559137d88e74e827e8786950502c9d5e67ed',0,1,1980,'2015-10-09 13:47:19',46272015,1,7,0,NULL),(277,'Moises','Salazar','moisessalazarjr@aol.com','425c221e4a190d4a76f11ba393e7facb54cb43639f4d570085811f3372447b59',12,2,1985,'2015-10-09 14:23:19',10052774,1,0,0,NULL),(278,'Taylor','Leach','tleach@banyantreatmentcenter.com','2debaf51625277f80cb306a9b13a94ab7f5e752a8a4adffdcdebf43ededfa0c4',11,12,1991,'2015-10-09 14:23:43',68545852,1,15,0,NULL),(279,'liz','matekovic','ematekovic@banyantreatmentcenter.com','739fb2fb3638462edde248916cc93728edcd31b67de991ebbc24746fa234f319',17,10,1993,'2015-10-09 17:46:59',65207039,1,6,0,NULL),(280,'Lyvette','Hiller-Nieves','livielivermore@gmail.com','64a7948ecc69916b4857efed943751db15d97ac44d7d22dece822b91e0f12340',14,9,1965,'2015-10-10 12:28:02',37235803,1,11,0,NULL),(281,'horacio','bazzano','hbazzano@banyantreatmentcenter.com','385098ddc5c7c641dd0830ce90f85f590346b47e4efee560ada49629bd8acd30',11,8,1947,'2015-10-11 21:13:36',54567719,1,10,0,NULL),(282,'William','Jankiewicz','wjankiewicz@banyantreatmentcenter.com','e0cd132d85093c28c563aef39b9c940df90316979a8fbe8594e502fe99d68751',20,11,1972,'2015-10-13 14:25:21',73447890,1,17,0,NULL),(283,'Zack','Traynor','zacktraynor@gmail.com','2123b645b24034c005b62060e811bdd2350bdd65f2086fdebd71a7dd222274e4',12,11,1990,'2015-10-14 14:43:36',58713018,1,31,0,NULL),(284,'Jennifer','Mooney-Gregory','moon333us@gmail.com','84643479317078e1e875296b7ce8529b05fd8501f9cae56594c25cb830b977f3',8,12,1964,'2015-10-19 01:38:36',54474876,1,7,0,NULL),(285,'Kareen','Wisdom','kwisdom@banyantreatmentcenter.com','42099aa1d831c110f02e8e31412661ee9e9e849db7985015aebd99fadc5f8636',17,3,1980,'2015-10-20 19:36:19',81546930,1,17,0,NULL),(286,'Tammy','Lynn','tammyelainelynn@gmail.com','566291bce695bd319ecbac5f16c6a0084e7d15a17ee4850cf623749d2b89468b',26,4,1963,'2015-10-23 05:38:39',11507816,1,6,0,NULL),(287,'Kristopher','Harris','kharris@banyantreatmentcenter.com','3c15af704f14c25f4597f92e517c498f2933512efad850c909601958f60cec14',11,8,1958,'2015-10-23 15:20:59',19502131,1,0,0,NULL),(288,'Kristopher','Harris','Eregon52@comcast.net','3c15af704f14c25f4597f92e517c498f2933512efad850c909601958f60cec14',11,8,1958,'2015-10-23 15:24:34',96675226,1,16,0,NULL),(289,'Ryan','Cierzniewski','cineski@optonline.net','bf9740523d99c88552a32edbe09253c2d01c3e2e6b0f6b6486215ec0c2e84691',17,5,1992,'2015-10-25 03:20:34',61041405,1,37,0,NULL),(290,'Frank','Touloumis','frank.touloumis@gmail.com','2e66763f53b85062499253d747e2e1d9ad4cff53527f0e3a3661a6c785c13cd2',27,7,1989,'2015-10-25 13:57:50',17823667,1,4,0,NULL),(291,'Joseph','Cirnigliaro','Jcirni@gmail.com','128a8f2b9ba9f732d2230b11365fdbeede2a713dab6865870424755767908335',4,4,1957,'2015-10-25 15:38:36',87719149,1,17,0,NULL),(292,'shameela','ayala','ayalashameela@yahoo.com','5063a5f9470e3b02202a3256fc72a29a639de971aa003a6bf6bea66abc9b3b53',20,7,1983,'2015-10-26 23:16:57',57876729,1,13,0,NULL),(293,'Suzette','Papadakis','spapadakis@banyantreatmentcenter.com','08554055a9e770a192522f07244865e59785dcdc76bcdacba9ce95157b8bdf6a',6,3,1975,'2015-10-29 17:43:26',44829968,1,14,0,NULL),(294,'Cheryl','Zaabel','czaabel@banyantreatmentcenter.com','f6146f715fc2fd58cb284d9fad72c6a0b0efcee4368774cbd3aedd7b144fb68a',14,6,1959,'2015-10-29 17:54:22',15803539,1,20,0,NULL),(295,'Taylor','Klutke','tklutke@banyantreatmentcenter.com','9835c7a94fbf895cb0eb675c9a959a93d3eac0f988411d1febfe2a42c280326e',22,9,1988,'2015-10-29 18:02:41',89637247,1,17,0,NULL),(296,'Mackenzie','Ciprich','kenzieciprich@yahoo.com','a11dd97581438ec49b90ae262e1180df6f8860c7521c0754c5975ccd9de2fcca',26,9,1994,'2015-10-30 13:40:02',99091884,1,19,0,NULL),(297,'kristen','trafford','ktrafford1992@gmail.com','456f4d79084468dded47332affd18a3b556f337276ce01ba0bc71cbd81f54e6f',28,7,1992,'2015-10-31 16:53:31',87973892,1,17,0,NULL),(298,'Devon','Parodi','devonleigh88@gmail.com','4cd8800f8f2a334658b27cdcce4294680311b3dac5d20fc4b623f3d0edb6629d',7,11,1988,'2015-11-04 00:18:07',42901944,1,17,0,NULL),(299,'Samuel','King','samuel.a.king@gmail.com','950fd9d719fcbdb770cb0bf236a98f95f00d9ac30a1a2c6817d741b7757c79b3',13,9,1980,'2015-11-05 14:52:26',35338786,1,13,0,NULL),(300,'Nicole','Reimert','NikkiReimert@icloud.com','563edbc248686a41e1788823c8a61cf8347d0cc91791403a08719eb3be91057b',17,2,1993,'2015-11-05 22:14:53',30348781,1,22,0,NULL),(301,'Laura','Lyons','llyons533@gmail.com','28487cc1f81dddeac28db1e0196cb90963563f91cd215cd136bb2c6c5b569d6d',4,8,1991,'2015-11-08 14:30:30',53358136,1,19,0,NULL),(302,'Sean','DiCesare','sdicesare@banyantreatmentcenter.com','bc48788334115ab3aa581097a958a8d664a7eb85b80c93d9e1d52e7224417fda',29,3,1991,'2015-11-09 20:20:03',83733929,1,3,0,NULL),(303,'Moises','Salazar','msalazar@banyantreatmentcenter.com','425c221e4a190d4a76f11ba393e7facb54cb43639f4d570085811f3372447b59',12,2,1985,'2015-11-10 13:56:48',51845383,1,9,0,NULL),(304,'Angela','Stringer','astringer@banyantreatmentcenter.com','425c221e4a190d4a76f11ba393e7facb54cb43639f4d570085811f3372447b59',2,11,1989,'2015-11-10 14:48:24',33628189,1,7,0,NULL),(305,'Nicosha','Wooten','Nicosha.Wooten@newleafbilling.com','571db3820672f77151b6f5f889633a0d8eefc010972894fe54df263c8f0c5824',21,9,1980,'2015-11-10 16:47:10',73502748,1,0,0,NULL),(306,'Trinee','Lee','trinee.lee@newleafbilling.com','b2410cbeb7569cb5e3ec03c892610574bfda41e9835e2f5e0d5d7d30c05f7d67',8,12,1986,'2015-11-11 13:14:03',38753085,1,6,0,NULL),(307,'KARLA','BAEZ','Karla.baez@newleafbilling.com','0cfb9565df1907b8b8ee251f4f092d998b05bece2c0eeac2945709dad9cf3559',30,10,1982,'2015-11-11 13:41:46',29859593,1,7,0,NULL),(308,'tonya','brinson','Tonya.Brinson@newleafbilling.com','3564fcb7bfb80d9dd1100076c787b359f9c5040f877322f56b3b1184a6144309',0,12,1972,'2015-11-11 14:27:30',85282471,1,9,0,NULL),(309,'SIAN','PESSOA','spessoa@banyantreatmentcenter.com','26647c7f56a4b5abb5bc183fb8ef5c3b92233ee5c605063d226f4cd1371efff5',0,8,1982,'2015-11-11 15:28:14',55273167,1,7,0,NULL),(310,'Brad','Gerke','bhgerke@gmail.com','7c65a2cae342be7986e4acfa626e7424e53dc13943cd3e09f61504704514f430',6,6,1984,'2015-11-11 17:31:51',10299727,1,16,0,NULL),(311,'Lauren','Connolly','lconnolly@banyantreatmentcenter.com','e4bd036497c6f901e98a80912218fea72f079e3ea0084da23db1e6d5000e8e17',14,10,1963,'2015-11-11 20:18:39',31252792,1,13,0,NULL),(312,'SHERITA','CHANG','SCHANG@BANYANTREATMENTCENTER.COM','73e05733f8309bf73134389d9bebee3ce35f694abf93722bdc874b97b892c636',4,1,1979,'2015-11-11 20:33:44',10507683,1,7,0,NULL),(313,'Jordan','Racic','jracic@banyantreatmentcenter.com','14d8d6d876222227d429ea1b9377b95b5ab76a692f0e9106a60266fea596a561',10,7,1989,'2015-11-12 14:51:50',98641354,1,17,0,NULL),(314,'Crystal','Jackson','biller2coder@gmail.com','a71b901823ae24a153c4389362ebe745ecb97429d1a5aff165d348c19ae157b6',21,9,1983,'2015-11-12 16:12:34',65872407,1,7,0,NULL),(315,'Valerie','Rusk','valrusk@aol.com','bab8f9386c18c01bdc61f5aac126128cbe90c91f891bb4a4eeace844d9af0ffb',14,10,1961,'2015-11-13 06:26:39',98622764,1,17,0,NULL),(316,'MORAYMA','ARDANAL','MARDANAL@banyantreatmentcenter.com','ecc1eacbbfb36193aa3d7d316bf106d592ee411fc1d0520f6ea1e04a3d0d1204',20,3,1982,'2015-11-13 19:52:12',15436909,1,7,0,NULL),(317,'Brian','Stewart','bsbllplayer@yahoo.com','6b22fe4cc06fc597c2f776b0107b1547b1ad1cc5b4a3773793d82d408487b404',3,7,1984,'2015-11-17 14:19:07',45035480,1,17,0,NULL),(318,'Kyle','simari','ksimari@banyantreatmentcenter.com','e932e6ed9db1a7abb58da313832ca7830087e497ee39c53a4c522b0d0d5eafe9',4,6,1996,'2015-11-17 19:00:45',41471608,1,17,0,NULL),(319,'Miriam ','Guerrero','mguerrero@banyantreatmentcenter.com','40772951ff150eec4c21887bea6c604a35b55216370581e79ee6e421a8612e27',10,4,1971,'2015-11-17 19:02:13',91724238,1,7,0,NULL),(320,'Janet','Downie','jedownie@bellsouth.net','ec53090d35c1dc85d688246e7ecd6986aedf9668c68caaf4ae685cf0205e5a3b',22,7,1955,'2015-11-19 02:05:03',70189151,1,16,0,NULL),(321,'mari','middleton','mmiddlet@fau.edu','d43622ceb5c67367cc25a09ade1dccd5e9f14d6e9b0d84af1777aa4d59bc5c44',18,10,1962,'2015-11-19 10:39:57',28758965,1,6,0,NULL),(322,'Nicolette','Stevens','serenity101314@gmail.com','e07be7b666a093da2f5e09ebccb1704e96732934e079698747eb2b09b8b98664',5,6,1987,'2015-11-19 22:06:34',14631663,1,14,0,NULL),(323,'Timothy','Meise','tmeise21@yahoo.com','721455cd23ff7c45f66f83294188f66953aee771476ba82546ce2b4163d9111b',28,8,1989,'2015-11-22 14:03:01',81501078,1,14,0,NULL),(324,'Bonita','Pierce','bonita.pierce@newleafbilling.com','684815e971c393f192c904b0ad1694c751f44090442345492a36ee47bfde11e4',27,6,1964,'2015-11-23 15:22:17',65494340,1,20,0,NULL),(325,'Kyle','Graff','graffin3535@aol.com','91b656a30b5be289e42e645d95a9a71e452ac67e65d1c76709bff9eb5f40bac9',30,8,1989,'2015-11-23 18:47:28',97083407,1,17,0,NULL),(326,'shameela','Ayala','shayayala14@yahoo.com','01f61b59dc26ad1fd9270d94887080a55d7151766f45ef04a9a3722514082ef9',20,7,1983,'2015-11-30 02:13:04',14736662,1,13,0,NULL),(327,'Anthony','Acampora','aacampora@banyantreatmentcenter.com','45f70c1981ea70b8055577557536f5692f4ddeaef9bcae6a84a7114e28f6bb69',20,1,1967,'2015-12-02 18:02:16',25853841,1,23,0,NULL),(328,'Renee ','Ross','renee.ross1841@gmail.com','8ad8ab9db8c13809e622f6cc5b932ea069cba8926cc6b356d08b29abec1c7990',5,5,1991,'2015-12-07 16:59:42',99209596,1,12,0,NULL),(329,'Vincent ','Samayoa','samayoavinny@gmail.com','ef01869fdf742b0199c8497207ce73163db4382d6138f4c13c835d87e3309632',17,8,1993,'2015-12-11 06:17:47',99031116,1,17,0,NULL),(330,'jillian','meyer','jillian.meyer18@gmail.com','859bed40d36a669091af54e48c18e88d1b9503556a115785ba7062f9f0a86c19',11,1,1995,'2015-12-16 15:04:15',65156735,1,14,0,NULL),(331,'Julia','Risik','julzerisik@gmail.com','2d97aab5c5ef288e6b36c896bf25f6de3b6ce16e9665ba6d289c8f313d6b2e97',12,4,1993,'2015-12-16 15:25:52',93168608,1,17,0,NULL),(332,'Calvin','McKayle','calvin.mckayle@gmail.com','c4bad345de787b45512e8fcdf4fb8fc9c7cd09bd9289edb49a45e978eb637815',13,6,1990,'2015-12-16 23:18:59',82627762,1,17,0,NULL),(333,'Kasandra','Goldfinger','kasandrajoy007@gmail.com','d357cda7c99807316e18caa10c3aafc68fdd841b54c79744d7d15a892e88cea8',8,2,1986,'2015-12-23 02:13:32',60768888,1,26,0,NULL),(334,'Jonah','O\'Toole','JonahPhilly@gmail.com','8d1aaeff300d6bd88c2230a73226591bbeca013c213b93fa24e0407e2d28807a',14,10,1988,'2015-12-25 19:24:05',35738494,1,17,0,NULL),(335,'ERIN','KENNEDY','ekennedy@banyantreatmentcenter.com','4de84bc51287f0feff505507b4c1a2689cb292a7ea8fc62a9a05432581cab39b',25,6,1984,'2015-12-30 20:09:04',52166146,1,7,0,NULL),(336,'Michele','Krell','krill12@hotmail.com','6d48971e635e44535525bf0df189b51fc81599805005b91894ec5d295da6ffa2',18,1,1980,'2015-12-30 20:46:20',67069202,1,5,0,NULL),(337,'Lauren','Chambers','champ1785@gmail.com','e4406a0eeb00cc72b0bd8a9f9af88066951f40624dbcf000a74bb6e60a44461f',6,1,1985,'2016-01-02 23:33:06',74755580,1,17,0,NULL),(338,'Alyssa','Valentin','alyssavalentin068@gmail.com','aea927a2e9f6b9752b368398f5b7dc4ab6b88be497f84c4403304f05fb1037ea',17,6,1989,'2016-01-05 14:51:33',72655020,1,14,0,NULL),(339,'Robert','Mulligan','mulligantim1@gmail.com','ca48f55ead8decc39a45b59c3a9c0f389e0d65f3f989ee1fbac4b6df5cbdbb3c',13,4,1990,'2016-01-07 06:42:46',32659447,1,17,0,NULL),(340,'Samantha','Krueger','skmissinglink@gmail.com','2cb267524fa264a424844e72196068405f5c79200d7bee38ae1bcc54ec65a2cc',18,7,1994,'2016-01-07 15:42:13',67244207,1,17,0,NULL),(341,'David','Lawrence II','davidlawrenceii96@gmail.com','951fd5ae565200558dde51db4cb3313fa6b3a389b95e8bca46f44fc44b1e7e23',8,10,1996,'2016-01-09 02:15:40',84683253,1,17,0,NULL),(342,'Rashad','Eutsey','shadeutsey@gmail.com','785df1e95d7fb9cea23e41294cdfadd41248fed9b688750975ca612398486c9d',7,8,1990,'2016-01-12 18:03:16',99355521,1,13,0,NULL),(343,'Tiffany','Focks','jewellgyrl@gmail.com','1339567e9ab576ec3484635c154e508c26ebadde682f05a54deba05622bd736a',28,6,1982,'2016-01-18 19:08:24',87194428,1,27,0,NULL),(344,'Judith','Sheldon','jsheldon@banyantreatmentcenter.com','491d75c14b71b9d0b868f6438e8a6da5056e0b0fb7a2abeeb93f54e6466779cd',29,12,1962,'2016-01-18 21:12:22',69137880,1,17,0,NULL),(345,'Robert','Noetzel','bnoetzel38@yahoo.com','6710972c4de00d839e4f10e53f0d0ba5d611e9a2775f8bd4840dae5f6c519262',4,4,1965,'2016-01-18 22:19:45',60835306,1,0,0,NULL),(346,'Brandon','Giostra','bowiz777@aol.com','b5fd72012c64d9dbf3306487c740ab01011e28d1625e85717950c3e6400dfe09',15,8,1978,'2016-01-18 22:53:56',93121453,1,7,0,NULL),(347,'Michael','Morresi','MMmissinglink@gmail.com','b5dfc3036c414739cea150167f894dfb3bf229a6b8e271f397bccefeafa4c87e',10,6,1987,'2016-01-20 16:03:03',19101587,1,7,0,NULL),(348,'Suzette','Papadakis','lsuzzi@yahoo.com','5c02a60ebe3eef22fa76a10722d3dddd70dca860a67209691c7ea03fd242061d',6,3,1975,'2016-01-20 17:05:05',46851202,1,3,0,NULL),(349,'James','Peck','surrender0611@aol.com','969f1be65fd3b1384c5d7842d39ba0f4cffc8f7fe576bab7579aa8a4196802d3',5,9,1964,'2016-01-21 08:16:43',38747455,1,17,0,NULL),(350,'Mark','Ellis','Tanmane23@icloud.com','d20705cd1945af08f1a2eac1a99e971a9965b258aa607f2e554d149a67943f7e',3,11,1991,'2016-01-21 17:08:06',81658098,1,14,0,NULL),(351,'Marla','Sriskand','msriskand@banyantreatmentcenter.com','94bcd3c18e697a6e1bd2a1a1e30a4e120dff802eebcb5aacfc8e6870b30dfb60',28,7,1955,'2016-01-22 20:51:22',86602672,1,0,0,NULL),(352,'Danielle','Menendez','dmccaskill2612@gmail.com','0bfaa0e83e69a904644cb792b9476adaa80949246a38e64b6e4bf1b542993ba0',3,9,1981,'2016-01-25 16:29:28',23852878,1,5,0,NULL),(353,'Tim ','Ryan','tryan@banyantreatmentcenter.com','7ce45a876b65844354f606fca1f0716c6b6b544e2682397b862ef5c2ae306e60',18,9,1968,'2016-01-25 16:30:54',68929275,1,6,0,NULL),(354,'Brad','Gerke','inkheadtattoo@gmail.com','7ce45a876b65844354f606fca1f0716c6b6b544e2682397b862ef5c2ae306e60',6,6,1984,'2016-01-25 16:45:30',42797649,1,3,0,NULL),(355,'Dahlia','Ramirez','dahlia.ramirez@newleafbilling.com','88323154430093560eaba6c8abbbdeb50e9e0253b6fafa4104b15fcaa133e7d1',12,8,1968,'2016-01-25 17:16:59',39573397,1,7,0,NULL),(356,'Andrea','Romanos','romanosbettandrea@gmail.com','c39b44d4996ac5fad44f1fec2577b699a47691388fa82129382d61f0012c2332',29,9,1994,'2016-01-29 05:54:03',26449399,1,17,0,NULL),(357,'NATANIELLA','MIKELSTEIN','MNATANIELLA@GMAIL.COM','3d958ce62804684a47befd253a28e4658baea24a83b92c05b11084f923d5dc7e',14,11,1989,'2016-01-29 06:18:04',47961674,1,16,0,NULL),(358,'Dairo','Restrepo','dairorestrepo89@gmail.com','98cbeacc52c09ad4f9477df90b7cc71b93e29118af6cb40a4ea94de2b93595b3',15,6,1989,'2016-01-29 15:48:04',32478340,1,0,0,NULL),(359,'Dairo','Restrepo','flmia305@gmail.com','98cbeacc52c09ad4f9477df90b7cc71b93e29118af6cb40a4ea94de2b93595b3',15,6,1989,'2016-01-29 15:48:51',77097057,1,17,0,NULL),(360,'Lakeitha','Baker','lakeitha.baker@newleafbilling.com','87ae7f1dea8556582dd3db527a8a68bfaa11d70bfbca4842401fca9fec21fcd1',29,1,1980,'2016-02-01 18:00:52',43997529,1,7,0,NULL),(361,'JULI','ALBERTO','JULIAYALA2507@YAHOO.COM','4d8539580dde5aa69b9630e2804653c16170168d4340ac93dc0545b797fd3184',20,11,1985,'2016-02-03 22:35:57',81622926,1,17,0,NULL),(362,'Brittany','Sherfield','brittany.sherfield@yahoo.com','edf04343642633962a06ffa77ca4341525925e95808808dc290295175a7d7035',13,3,1991,'2016-02-04 14:19:24',60289464,1,35,0,NULL),(363,'jordan','thomas','jordy2797@gmail.com','e5c2710a1d55c2dc4010c1438768dbead9883db22ab359d55ecac6781eb87342',26,11,1989,'2016-02-04 18:20:30',31135340,1,5,0,NULL),(364,'Calvert','Victor','cvictor@banyantreatmentcenter.com','dfb6191491b6fd88674824deb66084ebb8509bacf5fb36c1da48231296ed88c3',15,8,1980,'2016-02-05 19:54:04',67852614,1,19,0,NULL),(365,'Michael','Dirscherl ','mdirscherl6889@yahoo.com','e27be1cf6c5d8dc17ff73dd7d50973d3c9e6c43afc928cb408107c3cf059fee8',7,6,1989,'2016-02-08 06:15:48',69494505,1,8,0,NULL),(366,'marki lyn','warlow','ml2000w@aol.com','1ccb9a547c3d6b197a3fb45db491a851b2e6956933e68c13816c72335d7832cf',21,3,1986,'2016-02-10 17:33:55',29553903,1,15,0,NULL),(367,'Tracy','Souza','tracysouza42@gmail.com','4d8539580dde5aa69b9630e2804653c16170168d4340ac93dc0545b797fd3184',11,4,1964,'2016-02-11 01:29:51',33839475,1,17,0,NULL),(368,'Matthew','Cincogrono','mcincogrono@banyantreatmentcenter.com','00f63329ee9236e7cfa192af079612ced2b9cead71ae879b42ec3877b38d8360',8,11,1987,'2016-02-11 20:46:56',93212215,1,6,0,NULL),(369,'brittany','meyer','brittanyrose.m411@gmail.com','5c3b85d06bbf1abdcfdd91dd8d9a38495dfe3167bf7783720ae956c5a70be201',10,4,1992,'2016-02-12 00:54:28',81402007,1,17,0,NULL),(370,'Stefanie','Creary','stefaniecreary@yahoo.com','539d925a582b2dfe6ddd977d3d7e6de2e65bbb333ae1a0e94c7c2955c7af2249',5,9,1983,'2016-02-15 15:38:28',23280200,1,9,0,NULL),(371,'Maraha','Crockett','marsha.crockett@newleafbilling.com','60c30b739b5a1848a45fe13a18ef394c6e33fa5e9692dc959693302098231bd1',24,10,1983,'2016-02-16 16:17:17',85645501,1,9,0,NULL),(372,'kedeen','johnson','kedeen.johnson@gmal.com','7440f4c5b744d5ce9854b28603eecf048a4f6f6a84e65630bf75052517907ca3',26,7,1981,'2016-02-17 16:20:05',16600749,1,0,0,NULL),(373,'kedeen','johnson','kedeen.johnson@newleafbilling.com','7440f4c5b744d5ce9854b28603eecf048a4f6f6a84e65630bf75052517907ca3',26,7,1981,'2016-02-17 16:23:34',79298125,1,17,0,NULL),(374,'Timala ','Sims','timala.sims@newleafbilling.com','c45827c7ed18c804770f433f0b6081880c12d77ade980a0e453067cef5c56b35',18,4,1990,'2016-02-22 16:05:30',10074994,1,58,0,NULL),(375,'junnette','broomfield','junnette.broomfield@newleafbilling.com','83f86b1589574db1bfc60e5c3fee21b6e71fa6c6829813805d3c945709a52882',28,9,1979,'2016-02-22 17:26:43',51439581,1,17,0,NULL),(376,'William','McNulty','wjmc92@gmail.com','f74d6bc30c91328f1f5e2558ac3ba046a9cac73efa8e54387d63ccde1570e4ec',29,6,1992,'2016-02-26 10:41:13',50227399,1,17,0,NULL),(377,'Kenneth','Miyake','kmiyake@banyantreatmentcenter.com','5cbb723a631d5deba6952aafc1791c8a11fd684a0b5cf88b9bd9d3dc740298f9',16,4,1949,'2016-02-29 21:11:27',89608972,1,24,0,NULL),(378,'Tilisa','Thomas','tilisa.thomas@newleafbilling.com','3dec812686dcbf36096fd8de3548f7e2470eb20b3f01cef5c7bea358b1c4d637',1,2,1990,'2016-03-02 16:04:15',58557750,1,7,0,NULL),(379,'Lisa','Molyneaux','lmolyneaux@banyantreatmentcenter.com','84027dc54c965e198a5425132688403b8aa8efb2c1c88a405636faea3d4e57cd',9,9,1970,'2016-03-04 17:35:37',50411448,1,17,0,NULL),(380,'Courtney','Puckett','cpuckett1993@gmail.com','ef4aaaa7669531974599c63faec034be1a449e201f1bc1065766b0da3a302dfa',22,5,1993,'2016-03-07 20:30:07',73817186,1,17,0,NULL),(381,'Jessica','Leinbach','jleinbach@banyantreatmentcenter.com','7ae99ab4006db4c2ce78b07e6026296461a4e23f981497acdba54b1726ff8c16',30,1,1992,'2016-03-07 21:24:00',58819482,1,10,0,NULL),(382,'Vanessa','Holmes','vanessa.holmes@newleafbilling.com','7642aeae50d845ec7a60cfe876ca3cc657ad17bd5980c71a46dd6db94d2eb684',9,12,1960,'2016-03-08 16:56:08',73772442,1,97,0,NULL),(383,'courtney','macker','cmacker001@gmail.com','0ca38e3f91b5b8a03bfb68f74047c984a31289edb8eff1b00e34fa9cf8508db0',16,10,1993,'2016-03-12 05:12:59',92185750,1,17,0,NULL),(384,'Kelly','Murphy','murphykelly601@gmail.com','4d5e4711e036bb17f0af0df4bd79c20ba57e24c9bca911f160ea3a037803409c',20,2,1992,'2016-03-12 06:31:40',10481290,1,17,0,NULL),(385,'Justi','Murphy','fatts83@yahoo.com','15528b93c415fb4c4d1666f698823ca674db4e2d8fa24ad4f3470695395cf082',8,2,1983,'2016-03-15 22:55:22',10349309,1,6,0,NULL),(386,'Colin','Mackey','colmack90@gmail.com','5e495d1fb19433be1fa164eecaaab2c213f8d2dfc7f9872f7d3a3813118c1dce',0,11,1990,'2016-03-17 19:22:45',94054930,1,7,0,NULL),(387,'David','Arsenault','darsenault865@gmail.com','e9eeaa9c85ddf2cadeb89d31835daec1e6d2007f20ff9292afca5be1ac00ad7a',18,8,1993,'2016-03-19 15:17:17',10145896,1,17,0,NULL),(388,'Brendan ','Fox','bbfox0414@gmail.com','f6e25edff2a695d7817467cfaee8a818a7eda7c2d6033978cc6a5764143656be',13,4,1991,'2016-03-21 19:33:20',46963964,1,7,0,NULL),(389,'Trina','Holliday','trina.holliday@gmail.com','b3a6f782b282dcbfde83625d2beba6219660418464b8523c2c7ccf28588d9cc6',3,4,1972,'2016-03-24 16:27:41',98304123,1,18,0,NULL),(390,'Paul','Blake','paul.blake1911@gmail.com','c03fe0c67ae8bdba863c58b121b19ffd8645765b4f4ead396f455b3663087ebc',19,7,1967,'2016-03-25 18:32:35',60749638,1,18,0,NULL),(391,'Manoucheka','Nelson-Jeudy','manoucheka.nelson@newleafbilling.com','6df2febcda0af70b5a268c8255482b02cb89b817e2ed508052a4c815424fd6ab',8,12,1985,'2016-03-28 17:14:00',35962553,1,17,0,NULL),(392,'Isaac','Sochaczewski','isaacsoch@gmail.com','685fa5d5c5681c18d9d725ce2abc2c73f7b3887007ade6e56ba6cb1e09003ca1',22,2,1979,'2016-03-28 18:59:11',39086132,1,64,0,NULL),(393,'christopher','hussey','chussey222@gmail.com','0ec621f3db5e40a5c6682736efe00dea50eb19ff33c304b5f5ee03ef387ce2ee',11,7,1968,'2016-03-29 23:16:17',29362498,1,18,0,NULL),(394,'Samone','Baker','samone.baker@newleafbilling.com','b27e3412ca5553b97de368cd693b92950c122ed0d16475a799515a8b5f4257d0',29,10,1984,'2016-03-30 16:01:30',68363252,1,17,0,NULL),(395,'Jeffrey','Decker','Jdeck91@yahoo.com','2fce4e1fc307ff517fa2bb180287e27db78b14560bac301f8ce609eb54b25057',10,6,1991,'2016-03-30 22:00:25',87328840,1,17,0,NULL),(396,'Monica','Smith','msmsmith75@yahoo.com','40052fbac215518b490cb538a5879b14c9307a60fc717554c6757a330593cb6c',16,7,1975,'2016-04-04 15:58:31',76509109,1,17,0,NULL),(397,'Virginia','Gray Fabio','virginiagrayfabio@newleafbuilding.com','848807b75a9f1d43a266293e86e47eb6ffd6972b525d13292de65db416d86de4',8,2,1948,'2016-04-04 16:22:24',45634090,1,0,0,NULL),(398,'Virginia','grayfabio','virginia.grayfabio@newleafbuilding.com','06df0754a7885448eb5dbc035c61ba52cc01a11875a126bc771c557a7fd2ba37',8,2,1948,'2016-04-04 16:33:53',79580098,1,0,0,NULL),(399,'virginia','grayfabio','virginiafabio@newleafbilling.com','c51198e27b598cc431783e6cbe8c72fa0460f0b957f5147c6c06107448967fdb',1,2,1948,'2016-04-04 16:47:55',28473847,1,17,0,NULL),(400,'Dominique','Troadec','dtroadec@banyantreatmentcenter.com','e86fc25eb87d127b5eb048cd3e07a70a14bb42e6748bfac7aeb7c17f8d6740a3',28,12,1967,'2016-04-05 17:59:52',13937500,1,18,0,NULL),(401,'maude','derose','derosemaude@yahoo.com','c2ce112631db57fc44ed639ad51236c27999ed57083672d698a58376cab4d2ca',13,3,1988,'2016-04-06 15:22:35',32499976,1,20,0,NULL),(402,'Yvonelle','Jean Simon','yvonelle.Simon@newleafbilling.com','8fad5d21a538707bc4ca1a73587968e2b85e6a402e18ce5fb9fd206570cb5416',27,4,1962,'2016-04-07 15:41:29',81251774,1,6,0,NULL),(403,'Alec','Sperduto','alec.sperduto@gmail.com','d4e8c43413d2ba5692ae7f13a3520e5b9d70e0442e3ca12f00958273eee256ab',21,9,1991,'2016-04-10 15:47:21',22333882,1,18,0,NULL),(404,'Michael','Snider','michael.snider@newleafbilling.com','5fbd1b736b33b535372b52f634719886b20cef280e235e04814ffd0938242979',18,2,1980,'2016-04-11 15:29:29',21157426,1,18,0,NULL),(405,'nicoy ','LaTouche','nlatouche@banyantreatment.com','7ae99ab4006db4c2ce78b07e6026296461a4e23f981497acdba54b1726ff8c16',22,1,1985,'2016-04-11 18:42:35',16048723,1,19,0,NULL),(406,'Dominique ','Francis','Dfranc14@fau.edu','598d044899a66f5e5e18754c863b31691b698258bd6379098115d32f08a124d1',22,4,1988,'2016-04-12 18:45:29',87004088,1,0,0,NULL),(407,'Alexia','Touboul','atouboul@banyantreatmentcenter.com','108d5746fed6cffbf6076058d8162fd927ba5cbff028ff269ec80c2dad854011',7,10,1985,'2016-04-13 16:48:25',61903331,1,18,0,NULL),(408,'Dianne','Aviles','dianneaviles@yahoo.com','4d89fea734217d873c6748d193ef310fb47358e8247ddd59f84147af6421accb',12,12,1959,'2016-04-15 04:25:27',47543768,1,9,0,NULL),(409,'Scott','Stone','Scott.Stone.1209@gmail.com','d72fe329b53b6f5505d3c62aae9ea56866c068a234cb82471297c577fd2fbbfc',8,12,1987,'2016-04-17 23:53:48',42062266,1,0,0,NULL),(410,'Johnathan','Wurst','jwurstferrer@banyantreatmentcenter.com','d4cf4025771d50fe7cc9343ee3211c37c1e80124c6ee590b3847b8ee65e313b3',27,12,1965,'2016-04-20 20:42:43',59279650,1,0,0,NULL),(411,'DeVona','Smith','devonas421@gmail.com','9fb8cb08b8799ef88c962a6e98512eec8dcd50b29fb34065ce26e109fdb21d6f',26,9,1977,'2016-04-24 16:12:29',78846979,1,7,0,NULL),(412,'Michelle','Gregorovic','michelle.gregorovic@newleafbilling.com','5e5ef7c89c9177f53fd1017e4eeee919ba48215ca4b643a0a1f172d848fb7a85',15,5,1985,'2016-04-25 15:01:35',28429417,1,18,0,NULL),(413,'Miles','Schimert','mschimert@banyantreatmentcenter.com','c65c51ffc114ad5bf688baa5e8fce3dfe10f824635ab8efb272071cf2de09c8d',19,2,1993,'2016-04-26 00:09:37',36535184,1,15,0,NULL),(414,'marie','gaffney','mariegaffney724@yahoo.com','e83cbfc914e367916110a7706de3a611d470368b34b22ef7cad93274bdfcce97',7,4,1991,'2016-04-26 09:57:06',36619534,1,18,0,NULL),(415,'Gilberto','peter.gaudette94@gmail.com','chivemimi@gmail.com','8b1d1981f1d78ef7aee4355b372a1b988d6963be2ce019539be8a28286fbb7b2',26,5,1969,'2016-04-26 11:02:49',31399455,1,18,0,NULL),(416,'Shawn','Wenhold','tylerjohnson3221@yahoo.com','b1b6a77d1e23c27fad75602f4bed58a49d39ebbd9e4a493ba226b98067b3463f',6,11,1991,'2016-05-02 14:19:56',74356899,1,18,0,NULL),(417,'S','Johnson','sjohnson@banyantreatmentcenter.com','7ae99ab4006db4c2ce78b07e6026296461a4e23f981497acdba54b1726ff8c16',12,3,1961,'2016-05-02 16:12:27',62483548,1,2,0,NULL),(418,'Sherline ','Henry','sherline.henry@newleafbilling.com','45b266c08ff9304d7c8565461daac7ae4e1feedca485abecfa769f19a75af483',15,9,1986,'2016-05-02 16:32:15',11830759,1,20,0,NULL),(419,'Cindy','Spencer','cindy.spencer@newleafbilling.com','60c30b739b5a1848a45fe13a18ef394c6e33fa5e9692dc959693302098231bd1',1,5,1990,'2016-05-03 15:21:19',47672425,1,20,0,NULL),(420,'Tammy','Lynn','tammy_tammi@yahoo.com','566291bce695bd319ecbac5f16c6a0084e7d15a17ee4850cf623749d2b89468b',26,4,1963,'2016-05-08 18:07:56',55004669,1,0,0,NULL),(421,'aaron','smith','aaronsmith1977555555@gmail.com','bd20f05c52c603964b66227aeda44b119024a4cc58504e60e5e796600b7bce83',16,1,1977,'2016-05-10 09:09:11',36212685,1,18,0,NULL),(422,'Cynthia','LaFollette','cynthialafollette0108@gmail.com','566291bce695bd319ecbac5f16c6a0084e7d15a17ee4850cf623749d2b89468b',7,1,1985,'2016-05-11 16:06:36',54810791,1,2,0,NULL),(423,'Gilberto','Quintanilla','gquintanilla@banyantreatmentcenter.com','48d2de6da378a10fcc3072ca102572b047a7132d99622abca83ca26533d498aa',26,5,1969,'2016-05-16 04:54:29',70083907,1,0,0,NULL),(424,'Gilberto','Quintanilla','gilbertq1969@gmail.com','3a0832675d56241f55fa952333d7f4021cfaae8171515a266f631bade8eb8142',26,5,1969,'2016-05-16 05:03:19',43104617,1,18,0,NULL),(425,'Brianna ','Fiore','Bfiore10@comcast.net','9a016a94c36cd93df1903b4ab6198d94c1c24f0f58397e60c78c7d42559975ce',8,8,1991,'2016-05-22 13:25:28',99399828,1,17,0,NULL),(426,'Paul','Berndt','pberndt@banyantreatmentcenter.com','7ae99ab4006db4c2ce78b07e6026296461a4e23f981497acdba54b1726ff8c16',5,9,1994,'2016-06-28 21:49:20',58244604,1,15,0,NULL);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2392 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--

INSERT INTO `user_course_access` VALUES (625,148,3,'Completed',1435086496,0),(626,148,5,'Completed',1435087549,0),(627,150,3,'Completed',1435088660,0),(628,150,5,'Completed',1435089359,0),(629,151,3,'Completed',1435091505,0),(630,151,5,'Completed',1435093173,0),(631,152,3,'Completed',1435094817,0),(632,153,3,'Completed',1435095332,0),(633,153,5,'Completed',1435096151,0),(634,154,3,'Completed',1435097469,0),(635,154,5,'Completed',1435098055,0),(636,152,5,'Completed',1435101418,0),(637,155,3,'Completed',1435105671,0),(638,155,5,'Completed',1435106423,0),(639,156,3,'Completed',1435108799,0),(640,156,5,'Completed',1435109933,0),(641,157,3,'Completed',1435111414,0),(642,157,5,'Completed',1435113477,0),(643,158,3,'Completed',1435114546,0),(644,158,5,'Completed',1435114978,0),(645,160,3,'Completed',1435118431,0),(646,159,3,'Completed',1435118689,0),(647,160,5,'Completed',1435119038,0),(648,159,5,'Completed',1435119261,0),(649,161,3,'Completed',1435119789,0),(650,161,5,'Completed',1435120228,0),(651,162,3,'Completed',1435126124,0),(652,162,5,'Completed',1435126710,0),(653,163,3,'Completed',1435129763,0),(654,163,5,'Completed',1435130320,0),(655,149,3,'Completed',1435148222,0),(656,149,5,'Completed',1435148426,0),(657,164,3,'Completed',1435150279,0),(658,164,5,'Completed',1435150788,0),(659,165,3,'Completed',1435152016,0),(660,165,5,'Completed',1435152819,0),(661,166,3,'Completed',1435160856,0),(662,166,5,'Completed',1435161544,0),(663,167,3,'Completed',1435162631,0),(664,167,5,'Completed',1435162811,0),(665,168,3,'Completed',1435169449,0),(666,169,3,'Completed',1435169678,0),(667,168,5,'Completed',1435169692,0),(668,169,5,'Completed',1435170746,0),(669,170,3,'Completed',1435170114,0),(670,170,5,'Completed',1435170258,0),(671,171,3,'Completed',1435170614,0),(672,171,5,'Completed',1435170876,0),(673,172,5,'Completed',1435174674,0),(674,172,3,'Completed',1435175003,0),(675,173,3,'Completed',1435181998,0),(676,173,5,'Completed',1435182624,0),(677,174,3,'Completed',1435183503,0),(678,174,5,'Completed',1435183698,0),(679,175,3,'Completed',1435186324,0),(680,175,5,'Completed',1435186427,0),(681,176,3,'Completed',1435213026,0),(682,176,5,'Completed',1435214685,0),(683,177,3,'Completed',1435217462,0),(684,177,3,'In Progress',NULL,0),(685,177,5,'Completed',1435217853,0),(686,178,3,'Completed',1435243702,0),(687,178,5,'Completed',1435244046,0),(688,179,3,'Completed',1435244103,1),(689,180,3,'Completed',1435255797,1),(690,180,3,'In Progress',NULL,0),(691,180,5,'Completed',1435256731,0),(692,181,5,'Completed',1435263132,0),(693,181,3,'Completed',1435263292,0),(694,182,3,'Completed',1435263737,0),(695,182,5,'Completed',1435263922,0),(696,183,3,'Completed',1435265813,0),(697,183,5,'Completed',1435266105,0),(698,184,3,'Completed',1435266826,0),(699,184,5,'Completed',1435267171,0),(700,184,5,'Completed',1435267171,0),(701,185,3,'Completed',1435287476,0),(702,185,5,'Completed',1435288106,1),(703,186,3,'Completed',1435290836,0),(704,186,5,'Completed',1435291145,0),(705,187,3,'Completed',1435291214,0),(706,187,5,'Completed',1435291397,0),(707,188,5,'Completed',1435303616,0),(708,188,3,'Completed',1435305551,0),(709,189,3,'Completed',1435306864,0),(710,189,5,'Completed',1435307015,0),(711,179,5,'Completed',1435323125,0),(712,190,3,'Completed',1435330256,1),(713,190,3,'In Progress',NULL,1),(714,190,5,'Completed',1435330806,1),(715,191,3,'Completed',1436474911,0),(716,192,3,'Completed',1440465991,0),(717,193,3,'Completed',1439661227,0),(718,195,3,'Completed',1440438577,0),(719,195,5,'Completed',1440503971,0),(720,196,3,'Completed',1440442880,0),(721,197,3,'Completed',1440443275,0),(722,196,5,'Completed',1440447177,0),(723,198,3,'Completed',1440447699,0),(724,198,5,'Completed',1440526182,0),(725,199,3,'Completed',1440448221,0),(726,199,5,'Completed',1440448658,0),(727,200,3,'Completed',1440514390,0),(728,200,5,'Completed',1440515115,0),(729,201,3,'Completed',1440525094,0),(730,202,3,'Completed',1440541166,0),(731,202,5,'Completed',1440542636,0),(732,203,3,'Completed',1440568456,0),(733,203,5,'Completed',1442212924,0),(734,204,3,'Completed',1440584550,0),(735,206,3,'Completed',1440586148,0),(736,207,3,'Completed',1440607664,0),(737,207,5,'Completed',1440608650,0),(738,208,3,'Completed',1440620118,0),(739,208,5,'Completed',1440620966,0),(740,209,3,'Completed',1440653926,0),(741,209,5,'Completed',1440655364,0),(742,210,3,'Completed',1440696496,0),(743,210,5,'Completed',1440697144,0),(744,211,3,'Completed',1440699628,0),(745,211,5,'Completed',1440700975,0),(746,212,3,'Completed',1440701326,0),(747,212,5,'Completed',1440701984,0),(748,214,3,'Completed',1440730634,0),(749,214,3,'In Progress',NULL,0),(750,215,3,'Completed',1440750169,0),(751,215,5,'Completed',1440750796,0),(752,204,5,'Completed',1440751366,0),(753,10,4,'In Progress',NULL,0),(754,194,4,'In Progress',NULL,0),(755,216,3,'Completed',1440787126,0),(756,217,3,'Completed',1440831049,0),(757,217,5,'Completed',1440831882,0),(758,217,4,'Completed',1440832825,0),(759,214,5,'Completed',1440889060,0),(760,218,3,'Completed',1440953769,0),(761,218,5,'Completed',1440954369,0),(762,14,13,'In Progress',NULL,0),(763,14,4,'In Progress',NULL,0),(764,14,15,'In Progress',NULL,0),(765,207,4,'Completed',1441820003,0),(766,219,3,'Completed',1442425485,0),(767,219,5,'Completed',1442431073,0),(768,219,4,'Completed',1442431651,0),(769,220,3,'Completed',1442545754,0),(770,220,4,'Completed',1442546354,0),(771,222,4,'Completed',1442583800,0),(772,222,3,'Completed',1442584634,0),(773,222,5,'Completed',1442584978,0),(774,222,15,'Completed',1442585229,0),(775,222,13,'Completed',1443553531,0),(776,223,3,'Completed',1442591403,0),(777,223,4,'Completed',1443025761,0),(778,224,3,'Completed',1442710133,0),(779,224,4,'Completed',1442710701,0),(780,224,5,'Completed',1442711616,1),(781,224,13,'Completed',1442713842,0),(782,224,15,'Completed',1442714259,0),(783,225,3,'Completed',1442818688,0),(784,225,4,'Completed',1442819931,0),(785,225,5,'Completed',1442825936,0),(786,227,4,'Completed',1442831399,0),(787,227,3,'Completed',1442831815,0),(788,227,5,'Completed',1442832549,0),(789,14,11,'Completed',1443129958,0),(790,210,11,'Completed',1443554937,0),(791,192,11,'Completed',1443555602,0),(792,188,11,'Completed',1443193357,0),(793,224,11,'Completed',1443437810,0),(794,229,11,'Completed',1443738378,1),(795,167,11,'Completed',1443790228,0),(796,230,3,'Completed',1442902249,0),(797,230,11,'Completed',1443419508,0),(798,231,11,'In Progress',NULL,0),(799,200,11,'Completed',1443192450,0),(800,221,11,'Completed',1444138031,0),(801,232,11,'Completed',1443212539,0),(802,199,11,'Completed',1443200884,0),(803,233,3,'Completed',1442950438,0),(804,233,11,'In Progress',NULL,0),(805,179,11,'Completed',1443197745,0),(806,193,11,'Completed',1443192026,0),(807,202,4,'Completed',1444410356,0),(808,202,13,'Completed',1444414773,0),(809,202,15,'Completed',1444414245,0),(810,202,11,'Completed',1444412418,0),(811,234,3,'Completed',1442975469,0),(812,234,4,'Completed',1442977161,0),(813,234,11,'Completed',1443216262,0),(814,235,4,'Completed',1442987838,0),(815,235,3,'Completed',1442988606,0),(816,236,4,'Completed',1442989516,0),(817,236,3,'Completed',1442990104,0),(818,236,11,'Completed',1443422948,0),(819,236,13,'Completed',1443423429,0),(820,228,11,'In Progress',NULL,0),(821,237,3,'Completed',1444931879,0),(822,238,3,'Completed',1443032464,0),(823,238,4,'Completed',1443032747,0),(824,223,11,'Completed',1443197338,0),(825,214,4,'Completed',1443057539,0),(826,214,13,'Completed',1443059449,0),(827,214,15,'Completed',1443065395,0),(828,214,11,'Completed',1443655375,0),(829,239,3,'Completed',1443099984,0),(830,194,11,'In Progress',NULL,0),(831,151,15,'Completed',1443137048,0),(832,151,13,'Completed',1443137410,1),(833,151,4,'Completed',1443137678,0),(834,240,3,'Completed',1443142355,0),(835,240,11,'Completed',1443143160,0),(836,240,5,'Completed',1443143760,0),(837,241,11,'Completed',1443196675,0),(838,197,11,'Completed',1443199380,0),(839,223,5,'Completed',1443210801,0),(840,196,4,'Completed',1443211024,0),(841,201,11,'Completed',1443457904,0),(842,242,11,'Completed',1443213341,0),(843,236,5,'Completed',1443247635,0),(844,243,3,'Completed',1443416858,0),(845,243,5,'Completed',1443417606,0),(846,243,11,'Completed',1443418722,0),(847,243,4,'Completed',1443419447,0),(848,243,13,'Completed',1443420727,1),(849,243,15,'Completed',1443425002,0),(850,236,15,'Completed',1443425287,0),(851,196,13,'Completed',1444155478,0),(852,244,11,'Completed',1443464466,0),(853,151,11,'Completed',1443465377,0),(854,245,11,'Completed',1443475510,0),(855,245,4,'Completed',1443476627,0),(856,245,3,'Completed',1443477022,0),(857,242,13,'Completed',1443483488,0),(858,155,11,'Completed',1443498881,0),(859,155,13,'Completed',1443499849,0),(860,155,13,'In Progress',NULL,0),(861,155,4,'Completed',1443500128,0),(862,155,15,'Completed',1443500762,0),(863,246,3,'Completed',1443551179,0),(864,242,15,'Completed',1443552926,0),(865,222,11,'Completed',1443553812,0),(866,211,11,'Completed',1443555048,0),(867,159,11,'Completed',1443555728,0),(868,247,3,'Completed',1443572244,0),(869,247,5,'Completed',1443573890,0),(870,247,13,'Completed',1443576751,0),(871,247,15,'Completed',1443577579,0),(872,249,11,'Completed',1443586194,0),(873,184,11,'Completed',1443586636,0),(874,184,4,'Completed',1443587262,0),(875,184,13,'Completed',1443588164,0),(876,184,15,'Completed',1443588464,0),(877,235,13,'Completed',1443593052,0),(878,235,15,'Completed',1443593164,0),(879,235,11,'Completed',1443593323,0),(880,235,5,'Completed',1443594118,0),(881,163,4,'Completed',1443594995,0),(882,163,13,'Completed',1443595844,0),(883,163,15,'Completed',1443595955,0),(884,163,11,'Completed',1443596534,0),(885,250,3,'Completed',1443624899,0),(886,250,5,'Completed',1443625797,0),(887,250,4,'Completed',1443626426,0),(888,250,13,'Completed',1443628946,0),(889,250,15,'Completed',1443629175,0),(890,250,11,'Completed',1443631448,0),(891,251,11,'Completed',1443639122,0),(892,188,13,'Completed',1443639378,0),(893,159,13,'Completed',1443639864,0),(894,159,15,'Completed',1443640409,0),(895,238,5,'Completed',1443642714,0),(896,238,11,'Completed',1443643454,0),(897,238,15,'Completed',1443643736,0),(898,238,13,'Completed',1443644793,0),(899,246,4,'Completed',1443711154,0),(900,246,15,'Completed',1443711447,0),(901,246,5,'Completed',1443712860,0),(902,223,15,'Completed',1443712659,0),(903,223,13,'In Progress',NULL,0),(904,246,13,'Completed',1443719692,0),(905,252,13,'Completed',1444147663,0),(906,246,11,'Completed',1443797288,0),(907,229,3,'Completed',1443739865,0),(908,229,4,'Completed',1443740152,0),(909,229,15,'Completed',1443757975,0),(910,229,5,'Completed',1443758443,0),(911,229,13,'Completed',1443759060,0),(912,158,11,'Completed',1443761131,0),(913,158,15,'Completed',1443761936,0),(914,158,13,'Completed',1443763891,0),(915,253,4,'Completed',1443764843,0),(916,158,4,'Completed',1443765585,0),(917,253,13,'Completed',1443765745,0),(918,253,15,'Completed',1443765980,0),(919,253,11,'Completed',1443766689,0),(920,225,15,'Completed',1443767258,0),(921,225,13,'Completed',1443768307,0),(922,225,11,'Completed',1443768507,0),(923,227,13,'Completed',1443774038,0),(924,227,11,'Completed',1443774379,0),(925,227,15,'Completed',1443774580,0),(926,187,11,'Completed',1443779356,0),(927,187,11,'In Progress',NULL,0),(928,187,15,'Completed',1443779706,0),(929,187,15,'In Progress',NULL,0),(930,187,13,'Completed',1443780178,0),(931,187,13,'In Progress',NULL,0),(932,209,15,'Completed',1443784958,0),(933,209,11,'Completed',1443785180,0),(934,209,13,'Completed',1443785448,0),(935,167,15,'Completed',1443790452,0),(936,167,13,'Completed',1443791274,0),(937,167,4,'Completed',1443792668,0),(938,254,13,'Completed',1443796448,0),(939,255,13,'Completed',1443796207,0),(940,255,15,'Completed',1443796372,0),(941,255,11,'Completed',1443797272,0),(942,256,13,'Completed',1443800825,0),(943,256,11,'Completed',1443801193,0),(944,254,15,'Completed',1444061224,1),(945,256,15,'Completed',1443801643,0),(946,230,5,'Completed',1443824732,0),(947,230,15,'Completed',1443824860,0),(948,230,13,'Completed',1443825200,0),(949,257,3,'Completed',1443838029,0),(950,257,15,'Completed',1443838544,0),(951,257,4,'Completed',1443839016,0),(952,257,5,'Completed',1443839711,0),(953,257,13,'Completed',1443840409,0),(954,257,11,'Completed',1443841171,0),(955,258,3,'Completed',1443841861,0),(956,258,5,'Completed',1443842791,0),(957,220,5,'Completed',1443843076,0),(958,220,11,'Completed',1443843746,0),(959,220,13,'Completed',1443844327,0),(960,220,15,'Completed',1443844530,0),(961,259,3,'Completed',1443893038,0),(962,260,3,'Completed',1443893171,1),(963,259,5,'Completed',1443893829,0),(964,260,5,'Completed',1443893839,0),(965,260,4,'Completed',1443894680,0),(966,259,4,'Completed',1443894145,0),(967,261,3,'Completed',1443894317,0),(968,259,13,'Completed',1443895382,0),(969,260,13,'Completed',1443895727,0),(970,259,15,'Completed',1443895600,0),(971,259,11,'Completed',1443896557,0),(972,260,15,'Completed',1443895899,0),(973,260,11,'Completed',1444358396,0),(974,262,11,'Completed',1443899582,0),(975,262,15,'Completed',1443899779,0),(976,262,13,'Completed',1443899974,0),(977,258,13,'Completed',1443900661,0),(978,258,15,'Completed',1443900766,0),(979,258,4,'Completed',1443901055,0),(980,261,13,'Completed',1443901377,0),(981,261,15,'Completed',1443901495,0),(982,261,5,'Completed',1443901638,0),(983,261,4,'Completed',1444083580,0),(984,217,13,'Completed',1443905085,0),(985,217,13,'In Progress',NULL,0),(986,217,11,'Completed',1443905482,0),(987,217,11,'In Progress',NULL,0),(988,217,15,'Completed',1443906834,0),(989,217,15,'In Progress',NULL,0),(990,263,11,'Completed',1443909374,0),(991,263,4,'Completed',1443909711,0),(992,263,13,'Completed',1443910953,0),(993,263,3,'Completed',1443911638,0),(994,263,5,'Completed',1443912085,0),(995,263,15,'Completed',1443912434,0),(996,264,11,'Completed',1443915007,0),(997,264,13,'Completed',1443915938,0),(998,264,15,'Completed',1443916156,0),(999,264,5,'Completed',1443917902,0),(1000,264,3,'Completed',1443922311,0),(1001,264,4,'Completed',1443923465,0),(1002,258,11,'Completed',1443964246,0),(1003,265,3,'Completed',1444012259,0),(1004,265,5,'Completed',1444012525,0),(1005,265,4,'Completed',1444012702,0),(1006,265,13,'Completed',1444012908,0),(1007,265,15,'Completed',1444013017,0),(1008,265,11,'Completed',1444011135,1),(1009,266,3,'Completed',1444055123,0),(1010,266,3,'In Progress',NULL,0),(1011,266,5,'Completed',1444056325,0),(1012,266,11,'Completed',1444059467,0),(1013,267,3,'Completed',1444058115,0),(1014,266,13,'Completed',1444060276,0),(1015,254,11,'Completed',1444401357,0),(1016,267,5,'Completed',1444063093,0),(1017,267,4,'Completed',1444063601,0),(1018,267,13,'Completed',1444064155,0),(1019,266,15,'Completed',1444067006,0),(1020,267,11,'Completed',1444071186,0),(1021,261,11,'Completed',1444085245,0),(1022,232,13,'Completed',1444658927,1),(1023,221,13,'Completed',1444138934,0),(1024,221,15,'Completed',1444140235,0),(1025,268,3,'Completed',1444147583,0),(1026,268,5,'Completed',1444147925,0),(1027,252,15,'Completed',1444147779,0),(1028,252,11,'Completed',1444148126,0),(1029,268,4,'Completed',1444148090,0),(1030,268,13,'Completed',1444149084,0),(1031,268,15,'Completed',1444149144,0),(1032,268,11,'Completed',1444149684,0),(1033,195,13,'Completed',1444153024,0),(1034,196,11,'Completed',1447101237,0),(1035,208,4,'Completed',1444162284,0),(1036,208,13,'Completed',1444162854,0),(1037,208,15,'Completed',1444165191,0),(1038,208,11,'Completed',1444166185,0),(1039,269,5,'Completed',1444189159,0),(1040,269,13,'Completed',1444190743,0),(1041,270,3,'Completed',1444197907,0),(1042,270,5,'Completed',1444198878,0),(1043,270,4,'Completed',1444201232,0),(1044,270,13,'Completed',1444202929,0),(1045,270,15,'Completed',1444203301,0),(1046,270,11,'Completed',1444208150,0),(1047,272,3,'Completed',1444242830,0),(1048,271,13,'Completed',1444243244,0),(1049,272,4,'Completed',1444243024,0),(1050,272,15,'Completed',1444243101,0),(1051,272,5,'In Progress',NULL,0),(1052,272,13,'Completed',1444243707,0),(1053,271,11,'Completed',1444244249,0),(1054,272,11,'Completed',1444244371,0),(1055,197,5,'Completed',1444249756,0),(1056,249,4,'Completed',1444255895,0),(1057,152,15,'Completed',1445091846,0),(1058,249,13,'Completed',1444256598,1),(1059,152,15,'Completed',1445091846,0),(1060,249,15,'Completed',1444362949,0),(1061,273,3,'Completed',1444319598,0),(1062,273,5,'Completed',1444320600,0),(1063,212,4,'Completed',1444320978,0),(1064,274,3,'Completed',1444321093,0),(1065,212,13,'Completed',1444321182,0),(1066,212,15,'Completed',1444321330,0),(1067,274,15,'Completed',1444321317,0),(1068,212,11,'Completed',1444321441,0),(1069,274,11,'Completed',1444321441,0),(1070,274,5,'Completed',1444321581,0),(1071,193,5,'Completed',1444321619,0),(1072,274,4,'Completed',1444321663,0),(1073,274,13,'Completed',1444321741,0),(1074,273,4,'Completed',1444324035,0),(1075,273,13,'Completed',1444325328,0),(1076,275,3,'Completed',1444336509,0),(1077,276,13,'Completed',1444400845,1),(1078,278,3,'Completed',1444403309,0),(1079,276,3,'In Progress',NULL,0),(1080,278,11,'Completed',1447254875,0),(1081,279,13,'Completed',1444414123,0),(1082,239,11,'Completed',1444413518,0),(1083,279,11,'Completed',1444414550,0),(1084,279,15,'Completed',1444414731,0),(1085,234,5,'Completed',1444428869,0),(1086,234,13,'Completed',1444429465,0),(1087,234,15,'Completed',1444429791,0),(1088,280,3,'Completed',1444484744,0),(1089,280,4,'Completed',1444487799,0),(1090,280,15,'Completed',1444618087,0),(1091,280,13,'Completed',1444611191,0),(1092,281,11,'Completed',1448062633,0),(1093,280,11,'Completed',1444615129,0),(1094,280,5,'Completed',1444617148,0),(1095,269,4,'Completed',1444618481,0),(1096,269,15,'Completed',1444619172,0),(1097,269,11,'Completed',1444621579,0),(1098,192,13,'In Progress',NULL,0),(1099,192,5,'In Progress',NULL,0),(1100,247,4,'Completed',1444692547,0),(1101,247,11,'Completed',1444695442,0),(1102,282,3,'Completed',1444754471,0),(1103,282,4,'Completed',1446496590,0),(1104,200,13,'Completed',1444758668,1),(1105,240,13,'Completed',1444768869,0),(1106,283,3,'Completed',1444835081,0),(1107,283,5,'Completed',1444836176,0),(1108,283,4,'Completed',1444836837,0),(1109,283,13,'Completed',1444837988,0),(1110,283,15,'Completed',1444839546,0),(1111,283,11,'Completed',1444840685,0),(1112,237,13,'Completed',1444932704,0),(1113,237,4,'Completed',1444933224,0),(1114,197,13,'Completed',1444933357,0),(1115,237,5,'Completed',1444933563,0),(1116,237,11,'Completed',1444934094,0),(1117,237,15,'Completed',1444934292,0),(1118,193,13,'Completed',1444937585,0),(1119,171,13,'Completed',1445004349,0),(1120,171,11,'Completed',1445006336,0),(1121,171,15,'Completed',1445006526,0),(1122,152,4,'Completed',1445092055,0),(1123,152,13,'Completed',1450206514,0),(1124,152,11,'Completed',1450205553,0),(1125,284,3,'Completed',1445362764,0),(1126,284,5,'Completed',1445365180,0),(1127,284,4,'Completed',1445358931,0),(1128,284,13,'Completed',1445445034,0),(1129,284,15,'In Progress',NULL,0),(1130,284,11,'In Progress',NULL,0),(1131,232,15,'Completed',1445356411,1),(1132,285,5,'Completed',1445370787,0),(1133,285,13,'Completed',1445372179,1),(1134,201,5,'Completed',1445372444,0),(1135,198,11,'Completed',1445372739,0),(1136,201,13,'Completed',1445372990,0),(1137,219,13,'Completed',1445376530,0),(1138,219,11,'Completed',1445377160,0),(1139,207,13,'Completed',1445433081,0),(1140,207,11,'Completed',1445433828,0),(1141,201,15,'Completed',1445449381,0),(1142,207,15,'Completed',1445517577,0),(1143,239,5,'Completed',1445523400,0),(1144,245,15,'Completed',1445571678,0),(1145,286,15,'Completed',1445579273,1),(1146,286,11,'Completed',1445580194,0),(1147,286,13,'Completed',1445580815,0),(1148,209,4,'Completed',1445593640,0),(1149,288,13,'Completed',1445615561,0),(1150,289,3,'Completed',1445744251,0),(1151,290,13,'Completed',1445787699,0),(1152,290,11,'Completed',1445788616,0),(1153,291,3,'Completed',1445793513,1),(1154,291,3,'Completed',1445793513,1),(1155,291,4,'Completed',1445802213,1),(1156,241,5,'Completed',1445801617,0),(1157,241,13,'Completed',1445803137,0),(1158,291,5,'Completed',1445807083,1),(1159,292,5,'Completed',1445903730,0),(1160,292,13,'Completed',1445904566,0),(1161,292,15,'Completed',1445904892,0),(1162,293,4,'Completed',1446141593,0),(1163,294,4,'Completed',1446142025,0),(1164,293,13,'Completed',1446142023,0),(1165,295,4,'Completed',1446141946,0),(1166,295,13,'Completed',1446142526,0),(1167,294,13,'Completed',1446143093,0),(1168,293,15,'Completed',1446142363,0),(1169,295,15,'Completed',1446142609,0),(1170,295,11,'Completed',1446143007,0),(1171,293,11,'Completed',1446143215,0),(1172,293,3,'Completed',1446143869,0),(1173,295,3,'Completed',1446143479,0),(1174,294,15,'Completed',1446143603,0),(1175,295,5,'Completed',1446143871,0),(1176,294,11,'Completed',1446145596,0),(1177,293,5,'Completed',1446144105,0),(1178,294,3,'Completed',1446146194,0),(1179,294,5,'Completed',1446146582,0),(1180,296,3,'Completed',1446212597,0),(1181,296,5,'Completed',1446213011,0),(1182,296,4,'Completed',1446213232,0),(1183,296,13,'Completed',1446213685,0),(1184,296,15,'Completed',1446213864,0),(1185,296,11,'Completed',1446214298,0),(1186,261,12,'Completed',1446300735,0),(1187,285,11,'Completed',1446306577,0),(1188,285,3,'Completed',1446306975,0),(1189,297,3,'Completed',1446311178,0),(1190,297,5,'Completed',1446312370,0),(1191,297,4,'Completed',1446313304,0),(1192,291,13,'Completed',1446392372,0),(1193,291,15,'Completed',1446395262,0),(1194,291,11,'Completed',1446401753,0),(1195,297,13,'Completed',1446416713,0),(1196,297,15,'Completed',1446416899,0),(1197,297,11,'Completed',1446417824,0),(1198,282,5,'Completed',1446497940,0),(1199,282,13,'Completed',1446498994,0),(1200,282,15,'Completed',1446499223,0),(1201,282,11,'Completed',1446499722,0),(1202,298,5,'Completed',1446597272,0),(1203,298,3,'Completed',1446598275,0),(1204,298,4,'Completed',1446598788,0),(1205,298,13,'Completed',1446599899,0),(1206,298,15,'Completed',1446684920,0),(1207,298,11,'Completed',1446686254,0),(1208,298,12,'Completed',1446686768,0),(1209,299,13,'Completed',1446745820,0),(1210,299,11,'Completed',1446759398,0),(1211,194,10,'Completed',1446749156,0),(1212,299,5,'Completed',1446786278,0),(1213,300,4,'Completed',1446762204,0),(1214,300,3,'Completed',1446762553,0),(1215,300,5,'Completed',1447278376,0),(1216,299,15,'Completed',1446837585,0),(1217,198,12,'Completed',1447425340,0),(1218,198,10,'Completed',1447425790,0),(1219,198,13,'Completed',1447425596,0),(1220,301,4,'Completed',1446993374,0),(1221,301,3,'Completed',1446993783,0),(1222,301,5,'Completed',1446994577,0),(1223,301,11,'Completed',1446995266,0),(1224,301,13,'Completed',1446996194,0),(1225,301,15,'Completed',1446996337,0),(1226,239,13,'Completed',1447095455,0),(1227,239,15,'Completed',1447095613,0),(1228,196,15,'Completed',1447098719,0),(1229,271,10,'Completed',1447097715,0),(1230,271,12,'Completed',1447097953,0),(1231,199,10,'Completed',1447099021,0),(1232,199,12,'Completed',1447099274,0),(1233,278,10,'Completed',1447258680,0),(1234,302,13,'In Progress',NULL,0),(1235,188,12,'Completed',1447101450,0),(1236,222,10,'Completed',1447101521,0),(1237,196,12,'Completed',1447270074,0),(1238,196,10,'Completed',1447266779,0),(1239,199,15,'Completed',1447102305,0),(1240,199,13,'Completed',1447102036,0),(1241,188,10,'Completed',1447102159,0),(1242,242,12,'Completed',1447101965,0),(1243,242,10,'Completed',1447102190,0),(1244,239,4,'Completed',1447103911,0),(1245,239,10,'Completed',1447104143,0),(1246,239,12,'Completed',1447104282,0),(1247,207,12,'Completed',1447113734,0),(1248,207,10,'Completed',1447114130,0),(1249,224,12,'Completed',1447125719,1),(1250,224,10,'Completed',1447125920,0),(1251,220,12,'Completed',1447126129,0),(1252,220,10,'Completed',1447126412,0),(1253,151,12,'Completed',1447126667,0),(1254,151,10,'Completed',1447126764,0),(1255,261,10,'Completed',1447132875,0),(1256,158,12,'Completed',1447146971,0),(1257,158,10,'Completed',1447147405,0),(1258,219,15,'Completed',1447162157,0),(1259,219,12,'Completed',1450227396,0),(1260,219,12,'Completed',1450227396,0),(1261,219,10,'Completed',1447162045,0),(1262,303,13,'Completed',1447187794,0),(1263,275,13,'Completed',1447167042,0),(1264,304,13,'Completed',1447169024,0),(1265,275,10,'Completed',1447172067,0),(1266,188,4,'Completed',1447170980,0),(1267,304,10,'Completed',1447177901,0),(1268,188,15,'Completed',1447171172,0),(1269,267,15,'Completed',1447173071,0),(1270,267,12,'Completed',1447173336,0),(1271,267,10,'Completed',1447173771,0),(1272,305,13,'In Progress',NULL,0),(1273,197,12,'Completed',1447176775,0),(1274,159,12,'Completed',1447178548,0),(1275,159,10,'Completed',1447178811,0),(1276,304,11,'Completed',1447187959,0),(1277,295,12,'Completed',1447183235,0),(1278,295,10,'Completed',1447183452,0),(1279,197,10,'Completed',1447184098,0),(1280,303,10,'Completed',1447188258,0),(1281,304,15,'Completed',1447192430,0),(1282,201,12,'Completed',1447188981,0),(1283,201,10,'Completed',1447189227,0),(1284,293,12,'Completed',1447191218,0),(1285,293,10,'Completed',1447191433,0),(1286,300,13,'Completed',1447192809,0),(1287,294,12,'Completed',1447192604,0),(1288,294,10,'Completed',1447193274,0),(1289,300,10,'Completed',1447197455,0),(1290,300,15,'Completed',1447197578,0),(1291,300,11,'Completed',1447198098,0),(1292,300,12,'Completed',1447198418,0),(1293,222,12,'Completed',1447201570,0),(1294,226,12,'Completed',1447222608,0),(1295,226,10,'Completed',1447239860,0),(1296,209,12,'Completed',1447223920,0),(1297,209,10,'Completed',1447224533,0),(1298,217,12,'Completed',1447224628,0),(1299,217,10,'Completed',1447224804,0),(1300,225,10,'Completed',1447225743,0),(1301,225,12,'Completed',1447226150,0),(1302,187,4,'Completed',1447227767,0),(1303,204,15,'In Progress',NULL,0),(1304,204,15,'In Progress',NULL,0),(1305,204,12,'Completed',1447227612,0),(1306,204,10,'Completed',1447228281,0),(1307,187,12,'Completed',1447228675,0),(1308,187,10,'Completed',1447229200,0),(1309,270,12,'Completed',1447238506,0),(1310,270,10,'Completed',1447239414,0),(1311,306,10,'Completed',1447250094,0),(1312,276,10,'Completed',1447252251,0),(1313,275,11,'Completed',1447251463,0),(1314,276,15,'Completed',1447251699,0),(1315,276,15,'Completed',1447251699,0),(1316,307,10,'Completed',1447250379,0),(1317,276,11,'Completed',1447251990,0),(1318,275,15,'Completed',1447251897,0),(1319,308,13,'Completed',1447252269,0),(1320,307,15,'Completed',1447252305,0),(1321,307,11,'Completed',1447252503,0),(1322,308,10,'Completed',1447252474,0),(1323,308,11,'Completed',1447252634,0),(1324,307,13,'Completed',1447252818,0),(1325,308,15,'Completed',1447252750,0),(1326,309,11,'Completed',1447333047,0),(1327,288,12,'Completed',1447340452,0),(1328,278,13,'Completed',1447258987,0),(1329,278,15,'Completed',1447259152,0),(1330,303,11,'Completed',1447259896,0),(1331,303,15,'Completed',1447260003,0),(1332,310,3,'Completed',1447265047,0),(1333,310,5,'Completed',1447266539,0),(1334,310,12,'Completed',1447267578,0),(1335,310,10,'Completed',1447267757,0),(1336,310,4,'Completed',1447268223,0),(1337,310,13,'Completed',1447270803,0),(1338,310,15,'Completed',1447272271,0),(1339,310,11,'Completed',1447273881,0),(1340,311,5,'Completed',1447275105,1),(1341,312,11,'Completed',1447275773,0),(1342,311,10,'Completed',1447276299,1),(1343,311,11,'Completed',1447276966,0),(1344,14,12,'In Progress',NULL,0),(1345,299,12,'Completed',1447300681,0),(1346,299,10,'Completed',1447303284,0),(1347,193,12,'Completed',1447334681,0),(1348,311,15,'Completed',1447334934,0),(1349,193,10,'Completed',1447335003,0),(1350,311,12,'Completed',1447339577,0),(1351,232,12,'Completed',1447361977,0),(1352,311,13,'Completed',1447340388,0),(1353,301,12,'Completed',1447340391,0),(1354,301,10,'Completed',1447340642,0),(1355,212,10,'Completed',1447342834,0),(1356,272,10,'Completed',1447342595,0),(1357,272,12,'Completed',1447342845,0),(1358,212,12,'Completed',1447343472,0),(1359,274,12,'Completed',1447345175,0),(1360,314,11,'Completed',1447347891,0),(1361,274,10,'Completed',1447345523,0),(1362,266,10,'Completed',1447346958,0),(1363,197,15,'Completed',1447346174,0),(1364,246,12,'Completed',1453591695,0),(1365,246,10,'Completed',1453592448,0),(1366,228,12,'In Progress',NULL,0),(1367,266,10,'In Progress',NULL,0),(1368,266,12,'Completed',1447347492,0),(1369,314,15,'Completed',1447348658,1),(1370,314,10,'Completed',1447349330,0),(1371,314,13,'Completed',1447350594,0),(1372,273,15,'Completed',1447351888,0),(1373,273,11,'Completed',1447352969,0),(1374,200,10,'Completed',1447353946,0),(1375,313,3,'Completed',1447354231,0),(1376,195,10,'Completed',1447354458,0),(1377,313,5,'Completed',1447356155,0),(1378,195,15,'Completed',1447354624,0),(1379,195,4,'Completed',1447354817,0),(1380,195,12,'Completed',1447355034,0),(1381,195,11,'Completed',1447356253,0),(1382,273,12,'Completed',1447355881,0),(1383,313,4,'Completed',1447358782,0),(1384,313,13,'Completed',1447360783,0),(1385,281,5,'Completed',1447363202,0),(1386,313,15,'Completed',1447360906,0),(1387,313,11,'Completed',1447362230,0),(1388,232,10,'Completed',1447421533,0),(1389,313,12,'Completed',1447380739,0),(1390,200,12,'Completed',1447362643,0),(1391,200,15,'Completed',1447362768,0),(1392,285,10,'Completed',1447363479,0),(1393,281,15,'Completed',1447364860,0),(1394,285,15,'Completed',1447363636,0),(1395,260,12,'Completed',1447372498,0),(1396,260,10,'Completed',1447377240,0),(1397,214,12,'Completed',1447373099,0),(1398,214,10,'Completed',1447373821,0),(1399,313,10,'Completed',1447381218,0),(1400,315,3,'Completed',1447397446,0),(1401,315,5,'Completed',1447398254,0),(1402,315,4,'Completed',1447398933,0),(1403,315,15,'Completed',1447399170,0),(1404,315,11,'Completed',1447400121,0),(1405,315,10,'Completed',1447401295,0),(1406,315,12,'Completed',1447401694,0),(1407,309,10,'Completed',1447425281,0),(1408,198,15,'Completed',1447425155,0),(1409,193,15,'Completed',1447425492,0),(1410,309,15,'Completed',1447432179,0),(1411,309,13,'Completed',1447432724,0),(1412,250,12,'Completed',1447435179,0),(1413,250,10,'Completed',1447435942,0),(1414,211,12,'Completed',1447437736,0),(1415,211,10,'Completed',1447439845,0),(1416,210,4,'Completed',1447440033,0),(1417,237,12,'Completed',1447440423,0),(1418,210,13,'Completed',1447440350,0),(1419,211,4,'Completed',1447440919,0),(1420,210,15,'Completed',1447440427,0),(1421,210,12,'Completed',1447440608,0),(1422,237,10,'Completed',1447441157,0),(1423,210,10,'Completed',1447440797,0),(1424,211,15,'Completed',1447441111,0),(1425,211,13,'Completed',1447441640,0),(1426,316,15,'Completed',1447445373,0),(1427,316,11,'Completed',1447444950,0),(1428,316,10,'Completed',1447445104,0),(1429,316,13,'Completed',1447445284,0),(1430,285,12,'Completed',1447446563,0),(1431,312,10,'Completed',1447448772,0),(1432,312,15,'Completed',1447448938,0),(1433,312,13,'Completed',1447449182,0),(1434,315,13,'Completed',1447488103,0),(1435,291,12,'Completed',1447611972,0),(1436,291,10,'Completed',1447613711,0),(1437,288,10,'Completed',1447686982,1),(1438,238,10,'Completed',1447690376,0),(1439,238,12,'Completed',1447691103,0),(1440,302,3,'Completed',1447700467,0),(1441,302,5,'Completed',1447708962,0),(1442,317,3,'Completed',1447770338,0),(1443,317,5,'Completed',1447770874,0),(1444,317,4,'Completed',1447771094,0),(1445,317,13,'Completed',1447771742,0),(1446,317,15,'Completed',1447771827,0),(1447,317,11,'Completed',1447772482,0),(1448,317,12,'Completed',1447772744,0),(1449,317,10,'Completed',1447773034,0),(1450,318,3,'Completed',1447787086,0),(1451,319,11,'Completed',1447788508,0),(1452,318,5,'Completed',1447787376,0),(1453,318,4,'Completed',1447787640,0),(1454,318,13,'Completed',1447788112,0),(1455,318,12,'Completed',1447788331,0),(1456,318,11,'Completed',1447789452,0),(1457,319,12,'Completed',1447863326,0),(1458,318,10,'Completed',1447789081,0),(1459,318,15,'Completed',1447789559,0),(1460,240,12,'Completed',1447811466,0),(1461,240,12,'In Progress',NULL,0),(1462,240,10,'Completed',1447811757,0),(1463,298,10,'Completed',1447858633,0),(1464,265,12,'Completed',1447863031,0),(1465,265,10,'Completed',1447863917,0),(1466,281,10,'Completed',1447874708,1),(1467,281,13,'Completed',1447885911,1),(1468,232,4,'Completed',1447880479,1),(1469,281,12,'Completed',1447892914,0),(1470,320,5,'Completed',1447899777,0),(1471,289,5,'Completed',1447900640,0),(1472,289,4,'Completed',1447901232,0),(1473,289,12,'Completed',1447901808,0),(1474,321,10,'Completed',1447930729,0),(1475,232,3,'Completed',1452890855,0),(1476,322,3,'Completed',1447972140,0),(1477,322,3,'In Progress',NULL,0),(1478,322,5,'Completed',1447974145,0),(1479,322,4,'Completed',1447974882,0),(1480,322,4,'In Progress',NULL,0),(1481,322,13,'Completed',1447989284,0),(1482,230,10,'Completed',1447982443,0),(1483,230,12,'Completed',1447983043,0),(1484,320,15,'Completed',1447985087,0),(1485,320,10,'Completed',1447985796,0),(1486,322,13,'In Progress',NULL,0),(1487,322,15,'Completed',1447989405,0),(1488,322,15,'In Progress',NULL,0),(1489,322,11,'Completed',1447991085,0),(1490,322,11,'In Progress',NULL,0),(1491,322,10,'Completed',1447992066,0),(1492,322,10,'In Progress',NULL,0),(1493,322,12,'Completed',1448153229,0),(1494,322,12,'Completed',1448153229,0),(1495,243,10,'Completed',1447998722,0),(1496,243,12,'Completed',1448000858,0),(1497,323,3,'Completed',1448201436,0),(1498,323,5,'Completed',1448202214,0),(1499,323,4,'Completed',1448202781,0),(1500,323,13,'Completed',1448203642,0),(1501,323,15,'Completed',1448204024,0),(1502,323,11,'Completed',1448204789,0),(1503,323,12,'Completed',1448205767,0),(1504,323,10,'Completed',1448206335,0),(1505,167,12,'Completed',1448245414,0),(1506,167,10,'Completed',1448246383,0),(1507,324,13,'Completed',1448294650,0),(1508,324,10,'Completed',1448296059,0),(1509,259,12,'Completed',1448295928,0),(1510,324,15,'Completed',1448296754,0),(1511,324,11,'Completed',1448299663,0),(1512,259,10,'Completed',1448300224,0),(1513,324,3,'Completed',1448304526,0),(1514,325,3,'Completed',1448304667,0),(1515,325,5,'Completed',1448305071,0),(1516,324,5,'Completed',1448305702,0),(1517,325,4,'Completed',1448305286,0),(1518,325,13,'Completed',1448305515,0),(1519,324,12,'Completed',1448374049,0),(1520,324,4,'Completed',1448374801,0),(1521,325,15,'Completed',1448485247,0),(1522,325,11,'Completed',1448485593,0),(1523,325,12,'Completed',1448485836,0),(1524,325,10,'Completed',1448486505,0),(1525,241,12,'Completed',1448836742,0),(1526,241,10,'Completed',1448837912,0),(1527,326,15,'Completed',1448849791,0),(1528,326,13,'Completed',1448850212,0),(1529,289,13,'Completed',1448934848,0),(1530,320,12,'Completed',1448935367,0),(1531,321,12,'Completed',1448937276,0),(1532,289,10,'Completed',1448940038,0),(1533,176,10,'Completed',1448949494,0),(1534,176,12,'Completed',1448949975,0),(1535,292,12,'Completed',1450728094,0),(1536,327,3,'Completed',1449080214,0),(1537,327,5,'Completed',1449081870,0),(1538,327,4,'Completed',1449082149,0),(1539,327,13,'Completed',1449084248,0),(1540,327,15,'Completed',1449084497,0),(1541,327,11,'Completed',1449504737,0),(1542,327,12,'Completed',1449515097,0),(1543,327,10,'Completed',1449514420,0),(1544,328,11,'Completed',1449508307,0),(1545,328,13,'Completed',1449516511,0),(1546,328,15,'Completed',1449516712,0),(1547,328,10,'Completed',1449517490,0),(1548,328,12,'Completed',1449518037,0),(1549,263,12,'Completed',1449547639,0),(1550,263,10,'Completed',1449548287,0),(1551,249,12,'Completed',1449548565,0),(1552,249,10,'Completed',1449548733,0),(1553,296,10,'Completed',1449549806,0),(1554,296,12,'Completed',1449550104,0),(1555,235,10,'Completed',1449552993,0),(1556,235,12,'Completed',1449554227,0),(1557,236,12,'Completed',1449554844,0),(1558,236,10,'Completed',1449555352,0),(1559,329,3,'Completed',1449814912,0),(1560,329,5,'Completed',1449816173,0),(1561,329,4,'Completed',1449817181,0),(1562,329,13,'Completed',1449818150,0),(1563,329,15,'Completed',1449818343,0),(1564,329,11,'Completed',1449819685,0),(1565,329,12,'Completed',1449820333,0),(1566,329,10,'Completed',1449820675,0),(1567,254,10,'Completed',1449847877,1),(1568,254,10,'In Progress',NULL,1),(1569,254,12,'Completed',1450256624,1),(1570,297,12,'Completed',1449981411,0),(1571,297,10,'Completed',1449981797,0),(1572,181,12,'Completed',1450115315,0),(1573,181,10,'Completed',1450115660,0),(1574,174,12,'Completed',1450118178,0),(1575,240,15,'Completed',1450117332,0),(1576,174,10,'Completed',1450120317,0),(1577,174,11,'Completed',1450122207,0),(1578,174,4,'Completed',1450122703,0),(1579,283,12,'Completed',1450123224,0),(1580,174,13,'In Progress',NULL,0),(1581,283,10,'Completed',1450123553,0),(1582,245,12,'Completed',1450201936,0),(1583,245,10,'Completed',1450202220,0),(1584,258,12,'Completed',1450203909,0),(1585,152,12,'Completed',1450205104,0),(1586,152,10,'Completed',1450204542,0),(1587,258,10,'Completed',1450204151,0),(1588,208,12,'Completed',1450213671,0),(1589,208,10,'Completed',1450213998,0),(1590,330,3,'Completed',1450278520,0),(1591,330,5,'Completed',1450278689,0),(1592,330,4,'Completed',1450278967,0),(1593,330,13,'Completed',1450279171,0),(1594,330,13,'Completed',1450279171,0),(1595,330,15,'Completed',1450279264,0),(1596,330,11,'Completed',1450279499,0),(1597,331,4,'Completed',1450279922,0),(1598,331,3,'Completed',1450280400,0),(1599,331,5,'Completed',1450280949,0),(1600,331,11,'Completed',1450298633,0),(1601,331,13,'Completed',1450299261,0),(1602,331,15,'Completed',1450299449,0),(1603,331,10,'Completed',1450299794,0),(1604,331,12,'Completed',1450299993,0),(1605,330,12,'Completed',1450304614,0),(1606,332,3,'Completed',1450308452,0),(1607,332,5,'Completed',1450309244,0),(1608,332,4,'Completed',1450309678,0),(1609,332,13,'Completed',1450310618,0),(1610,332,15,'Completed',1450310894,0),(1611,332,11,'Completed',1450311653,0),(1612,332,12,'Completed',1450311913,0),(1613,332,10,'Completed',1450320144,0),(1614,153,11,'Completed',1450357490,0),(1615,153,15,'Completed',1450357716,0),(1616,153,12,'Completed',1450358274,0),(1617,153,13,'Completed',1452258035,0),(1618,241,15,'Completed',1450365447,0),(1619,330,10,'Completed',1450393053,0),(1620,252,12,'Completed',1450455831,0),(1621,252,10,'Completed',1450456425,0),(1622,234,10,'Completed',1450624874,0),(1623,234,12,'Completed',1450626282,0),(1624,182,10,'Completed',1450663664,0),(1625,182,12,'Completed',1450664002,0),(1626,273,10,'Completed',1450713366,0),(1627,292,10,'Completed',1450727139,0),(1628,333,3,'Completed',1450837159,0),(1629,333,5,'Completed',1450837790,0),(1630,333,4,'Completed',1450838355,0),(1631,333,13,'Completed',1450839077,0),(1632,333,15,'Completed',1450839486,0),(1633,333,11,'Completed',1450840025,0),(1634,333,12,'Completed',1450840239,0),(1635,333,10,'Completed',1450840908,0),(1636,334,4,'Completed',1451073313,0),(1637,334,3,'Completed',1451073908,0),(1638,334,5,'Completed',1451074568,0),(1639,334,11,'Completed',1451677125,0),(1640,306,11,'Completed',1451505860,0),(1641,306,13,'Completed',1451508588,0),(1642,335,10,'Completed',1451506238,0),(1643,335,15,'Completed',1451506346,0),(1644,335,13,'Completed',1451507878,0),(1645,336,11,'Completed',1451508772,0),(1646,336,10,'Completed',1451508897,0),(1647,336,13,'Completed',1451509658,0),(1648,334,13,'Completed',1451677934,0),(1649,334,15,'Completed',1451678111,0),(1650,334,10,'Completed',1451678574,0),(1651,334,12,'Completed',1451679067,0),(1652,289,15,'Completed',1451766826,0),(1653,289,11,'Completed',1451767995,0),(1654,337,3,'Completed',1451778385,0),(1655,337,5,'Completed',1451782464,0),(1656,337,4,'Completed',1451786321,0),(1657,337,13,'Completed',1451787123,0),(1658,337,15,'Completed',1451926439,0),(1659,337,11,'Completed',1451927279,0),(1660,337,12,'Completed',1451927851,0),(1661,337,10,'Completed',1451928160,0),(1662,338,3,'Completed',1452019430,0),(1663,338,5,'Completed',1452020594,0),(1664,338,4,'Completed',1452021191,0),(1665,338,13,'Completed',1452021812,0),(1666,338,11,'Completed',1452023901,0),(1667,338,15,'Completed',1452022034,0),(1668,338,12,'Completed',1452025720,0),(1669,338,10,'Completed',1452026130,0),(1670,339,3,'Completed',1452149738,0),(1671,339,5,'Completed',1452150709,0),(1672,339,4,'Completed',1452151388,0),(1673,339,13,'Completed',1452153397,0),(1674,340,3,'Completed',1452181914,0),(1675,340,5,'Completed',1452182946,0),(1676,340,4,'Completed',1452183790,0),(1677,340,13,'Completed',1452272837,0),(1678,10,14,'In Progress',NULL,0),(1679,340,15,'Completed',1452273201,0),(1680,340,11,'Completed',1452273521,0),(1681,340,12,'Completed',1452525255,0),(1682,341,3,'Completed',1452306065,0),(1683,341,5,'Completed',1452306667,0),(1684,341,4,'Completed',1452306974,0),(1685,341,13,'Completed',1452307788,0),(1686,341,15,'Completed',1452308072,0),(1687,341,11,'Completed',1452309300,0),(1688,341,12,'Completed',1452309506,0),(1689,341,10,'Completed',1452309810,0),(1690,341,14,'Completed',1452310069,0),(1691,339,15,'Completed',1452325051,0),(1692,339,11,'Completed',1452325990,0),(1693,339,12,'Completed',1452335466,0),(1694,339,10,'Completed',1452335796,0),(1695,339,14,'Completed',1452336015,0),(1696,209,14,'Completed',1452336310,0),(1697,340,10,'Completed',1452523292,0),(1698,340,14,'Completed',1452523817,0),(1699,271,14,'Completed',1452542799,0),(1700,212,14,'Completed',1452543690,0),(1701,199,14,'Completed',1452546085,0),(1702,199,4,'Completed',1452546382,0),(1703,230,14,'Completed',1452549837,0),(1704,260,14,'Completed',1452549936,0),(1705,167,14,'Completed',1452554035,0),(1706,208,14,'Completed',1452556083,0),(1707,289,14,'Completed',1452557790,0),(1708,301,14,'Completed',1452558017,0),(1709,337,14,'Completed',1452564790,0),(1710,220,14,'Completed',1452574439,0),(1711,258,14,'Completed',1452574652,0),(1712,317,14,'Completed',1452574845,0),(1713,325,14,'Completed',1452575313,0),(1714,253,14,'Completed',1452579523,0),(1715,226,14,'Completed',1452579690,0),(1716,151,14,'Completed',1452581446,1),(1717,151,14,'In Progress',NULL,1),(1718,217,14,'Completed',1452582315,0),(1719,291,14,'Completed',1452603688,0),(1720,259,14,'Completed',1452613810,0),(1721,298,14,'Completed',1452614193,0),(1722,181,14,'Completed',1452616636,0),(1723,181,13,'Completed',1452617872,0),(1724,181,4,'Completed',1452618728,0),(1725,181,11,'Completed',1452619670,0),(1726,181,15,'Completed',1452620065,0),(1727,342,11,'Completed',1452623814,0),(1728,242,14,'Completed',1452623181,0),(1729,342,13,'Completed',1452625189,0),(1730,222,14,'Completed',1452625039,0),(1731,342,10,'Completed',1452698366,0),(1732,288,14,'Completed',1453159694,0),(1733,342,15,'In Progress',NULL,0),(1734,224,14,'Completed',1452777289,0),(1735,219,14,'Completed',1452797302,0),(1736,232,14,'Completed',1453998473,0),(1737,320,14,'Completed',1452975749,0),(1738,240,14,'Completed',1453038521,0),(1739,343,3,'Completed',1453144987,0),(1740,343,3,'Completed',1453144987,0),(1741,343,5,'Completed',1453145592,0),(1742,343,4,'Completed',1453146162,0),(1743,343,13,'Completed',1453148468,0),(1744,343,15,'Completed',1453148670,0),(1745,343,11,'Completed',1453149784,0),(1746,343,12,'Completed',1453150432,0),(1747,343,10,'Completed',1453151011,0),(1748,343,14,'Completed',1453151605,0),(1749,318,14,'Completed',1453150602,0),(1750,344,3,'Completed',1453152964,1),(1751,344,5,'Completed',1453153515,0),(1752,344,4,'Completed',1453154055,0),(1753,344,13,'Completed',1453154435,0),(1754,344,15,'Completed',1453159280,0),(1755,344,11,'Completed',1453159905,0),(1756,344,12,'Completed',1453160099,0),(1757,344,10,'Completed',1453160406,0),(1758,344,14,'Completed',1453160660,0),(1759,152,14,'Completed',1453223182,0),(1760,214,14,'Completed',1453252148,0),(1761,347,3,'Completed',1453306152,0),(1762,348,14,'Completed',1453317692,0),(1763,349,14,'Completed',1453364391,0),(1764,349,3,'Completed',1453365470,0),(1765,349,5,'Completed',1453366123,0),(1766,349,4,'Completed',1453366425,0),(1767,349,13,'Completed',1453366891,0),(1768,349,11,'Completed',1453367744,0),(1769,349,15,'Completed',1453367862,0),(1770,349,12,'Completed',1453368600,0),(1771,349,10,'Completed',1453369530,0),(1772,347,5,'Completed',1453391566,0),(1773,347,4,'Completed',1453392173,0),(1774,347,13,'Completed',1453393130,0),(1775,345,3,'In Progress',NULL,0),(1776,345,3,'In Progress',NULL,0),(1777,295,14,'Completed',1453394041,0),(1778,350,15,'Completed',1453396250,0),(1779,350,3,'Completed',1453396592,0),(1780,350,4,'Completed',1453396864,0),(1781,350,5,'Completed',1453397252,0),(1782,350,11,'Completed',1453398148,0),(1783,350,13,'Completed',1453398926,0),(1784,350,10,'Completed',1453399356,0),(1785,350,12,'Completed',1453400816,0),(1786,326,3,'Completed',1453408888,0),(1787,326,4,'Completed',1453409299,0),(1788,326,11,'Completed',1453410004,0),(1789,294,14,'Completed',1453473804,0),(1790,246,14,'Completed',1453592878,0),(1791,352,3,'Completed',1453739651,0),(1792,353,14,'Completed',1453739845,0),(1793,352,5,'Completed',1453740033,0),(1794,352,4,'Completed',1453740454,0),(1795,354,14,'Completed',1453740776,0),(1796,355,3,'In Progress',NULL,0),(1797,355,3,'In Progress',NULL,0),(1798,355,13,'Completed',1453745595,1),(1799,355,11,'Completed',1453749427,0),(1800,355,10,'Completed',1453750944,0),(1801,355,15,'Completed',1453751598,0),(1802,331,14,'Completed',1453759862,0),(1803,263,14,'Completed',1453761461,0),(1804,263,14,'In Progress',NULL,0),(1805,313,14,'Completed',1453818098,0),(1806,311,14,'Completed',1453817504,0),(1807,210,14,'Completed',1453818114,0),(1808,211,14,'Completed',1453818499,0),(1809,300,14,'Completed',1453821673,0),(1810,201,14,'Completed',1453929227,0),(1811,297,14,'Completed',1453870437,0),(1812,333,14,'Completed',1453871680,0),(1813,243,14,'Completed',1453873900,0),(1814,235,14,'Completed',1453874435,0),(1815,332,14,'Completed',1453905767,0),(1816,326,14,'Completed',1453908663,0),(1817,196,14,'Completed',1454944143,0),(1818,182,14,'Completed',1453920674,0),(1819,273,14,'Completed',1453922463,0),(1820,328,14,'Completed',1453922688,0),(1821,242,4,'In Progress',NULL,0),(1822,201,4,'Completed',1453930415,0),(1823,239,14,'Completed',1454103733,0),(1824,198,14,'Completed',1453990731,0),(1825,327,14,'Completed',1453995290,0),(1826,241,14,'Completed',1453998643,0),(1827,267,14,'Completed',1453999415,0),(1828,254,14,'Completed',1454008367,0),(1829,254,4,'Completed',1454009119,0),(1830,270,14,'Completed',1454014517,0),(1831,329,14,'Completed',1454015552,0),(1832,356,14,'Completed',1454047144,0),(1833,236,14,'Completed',1454047620,0),(1834,356,4,'Completed',1454048859,1),(1835,357,5,'Completed',1454049199,0),(1836,356,3,'Completed',1454050217,0),(1837,357,4,'Completed',1454049680,0),(1838,357,13,'Completed',1454050220,0),(1839,357,15,'Completed',1454050391,0),(1840,356,5,'Completed',1454051569,0),(1841,357,11,'Completed',1454050831,0),(1842,356,11,'Completed',1454052480,0),(1843,153,14,'Completed',1454072855,0),(1844,153,10,'Completed',1454073205,0),(1845,262,14,'Completed',1454077913,0),(1846,238,14,'Completed',1454078571,0),(1847,359,3,'Completed',1454083598,0),(1848,359,5,'Completed',1454084164,0),(1849,359,4,'Completed',1454084416,0),(1850,282,12,'Completed',1454084885,0),(1851,359,13,'Completed',1454085218,0),(1852,282,10,'Completed',1454085954,0),(1853,282,14,'Completed',1454086369,0),(1854,359,15,'Completed',1454088569,0),(1855,285,14,'Completed',1454091228,0),(1856,285,4,'Completed',1454094485,0),(1857,319,14,'Completed',1454097561,0),(1858,296,14,'Completed',1454100952,0),(1859,245,14,'Completed',1454106082,0),(1860,334,14,'Completed',1454176411,0),(1861,315,14,'Completed',1454240386,0),(1862,360,11,'Completed',1454351282,0),(1863,360,13,'Completed',1454353031,0),(1864,360,15,'Completed',1454355746,0),(1865,360,10,'Completed',1454356407,0),(1866,283,14,'Completed',1454391325,0),(1867,357,12,'Completed',1454682464,0),(1868,299,14,'Completed',1454475149,0),(1869,361,3,'Completed',1454543177,0),(1870,361,5,'Completed',1454562538,1),(1871,359,12,'Completed',1454574858,0),(1872,359,11,'Completed',1454576071,0),(1873,359,10,'Completed',1454576797,0),(1874,359,14,'Completed',1454577117,0),(1875,362,3,'Completed',1454595965,0),(1876,362,5,'Completed',1454597007,0),(1877,362,4,'Completed',1454597617,0),(1878,362,13,'Completed',1454610650,0),(1879,363,3,'Completed',1454610488,0),(1880,363,5,'Completed',1454611328,0),(1881,362,15,'Completed',1454610784,0),(1882,362,11,'Completed',1454701672,0),(1883,363,4,'Completed',1454611603,0),(1884,197,14,'Completed',1454611885,0),(1885,363,11,'In Progress',NULL,0),(1886,357,14,'Completed',1454681895,0),(1887,357,3,'Completed',1454682119,0),(1888,357,10,'In Progress',NULL,0),(1889,357,10,'In Progress',NULL,0),(1890,362,12,'Completed',1454706230,0),(1891,361,4,'Completed',1454703844,0),(1892,364,4,'Completed',1454703963,1),(1893,361,13,'Completed',1454704636,0),(1894,364,3,'Completed',1454704774,0),(1895,361,15,'Completed',1454704908,1),(1896,364,5,'Completed',1454705569,0),(1897,361,11,'Completed',1454705689,0),(1898,364,11,'Completed',1454706525,0),(1899,361,12,'Completed',1454706072,0),(1900,361,10,'Completed',1454706468,0),(1901,362,10,'Completed',1454706920,0),(1902,361,14,'Completed',1454706758,0),(1903,364,10,'Completed',1454946506,0),(1904,362,14,'Completed',1454707322,0),(1905,356,13,'Completed',1454825210,0),(1906,356,15,'Completed',1454826666,0),(1907,356,12,'Completed',1454827722,0),(1908,356,10,'Completed',1454828054,0),(1909,365,4,'Completed',1454912511,0),(1910,365,3,'Completed',1454913598,0),(1911,364,13,'Completed',1454947851,0),(1912,364,15,'Completed',1454949014,0),(1913,364,12,'Completed',1454953551,0),(1914,364,14,'Completed',1454954302,0),(1915,365,5,'Completed',1454979760,0),(1916,365,13,'Completed',1454980259,0),(1917,365,10,'Completed',1454980648,0),(1918,365,14,'In Progress',NULL,0),(1919,366,3,'Completed',1455127609,0),(1920,366,5,'Completed',1455128616,0),(1921,366,4,'In Progress',NULL,0),(1922,366,13,'Completed',1455131403,0),(1923,366,15,'Completed',1455131680,0),(1924,366,11,'Completed',1455132333,0),(1925,366,12,'Completed',1455133579,0),(1926,366,10,'Completed',1455133844,0),(1927,366,14,'Completed',1455134187,0),(1928,367,3,'Completed',1455155069,0),(1929,367,5,'Completed',1455155472,0),(1930,367,4,'Completed',1455155711,0),(1931,367,13,'Completed',1455156118,0),(1932,367,15,'Completed',1455156575,0),(1933,367,11,'Completed',1455157015,0),(1934,367,12,'Completed',1455157358,0),(1935,367,10,'Completed',1455157654,0),(1936,367,14,'Completed',1455157817,0),(1937,368,3,'Completed',1455223909,0),(1938,368,14,'Completed',1455224130,0),(1939,368,10,'Completed',1455224483,0),(1940,368,5,'In Progress',NULL,0),(1941,369,3,'Completed',1455238846,0),(1942,369,5,'Completed',1455239332,0),(1943,369,4,'Completed',1455239593,0),(1944,369,13,'Completed',1455246075,0),(1945,369,15,'Completed',1455246324,0),(1946,369,11,'Completed',1455247190,0),(1947,369,12,'Completed',1455247565,0),(1948,369,10,'Completed',1455283416,0),(1949,369,14,'Completed',1455334921,0),(1950,253,12,'Completed',1455348737,0),(1951,321,14,'Completed',1455549161,0),(1952,370,10,'Completed',1455550880,0),(1953,370,15,'Completed',1455551755,0),(1954,370,13,'Completed',1455551989,0),(1955,370,11,'Completed',1455552332,0),(1956,371,11,'Completed',1455640218,0),(1957,371,10,'Completed',1455640622,0),(1958,371,13,'Completed',1455641176,0),(1959,371,15,'Completed',1455641268,0),(1960,373,3,'Completed',1455729184,0),(1961,373,5,'Completed',1455733662,0),(1962,373,4,'Completed',1455737498,0),(1963,373,13,'Completed',1455736396,0),(1964,373,15,'In Progress',NULL,0),(1965,373,11,'Completed',1455739207,0),(1966,373,10,'Completed',1455739873,0),(1967,373,14,'Completed',1455741535,0),(1968,373,12,'Completed',1455744161,0),(1969,281,14,'In Progress',NULL,0),(1970,374,3,'Completed',1456158404,0),(1971,374,5,'Completed',1456159357,0),(1972,374,4,'In Progress',NULL,0),(1973,374,14,'Completed',1456160198,0),(1974,374,11,'Completed',1456161308,0),(1975,374,15,'Completed',1456161917,0),(1976,374,13,'Completed',1456163843,0),(1977,375,4,'Completed',1456163102,0),(1978,375,3,'Completed',1456163616,0),(1979,375,5,'Completed',1456164729,0),(1980,374,10,'Completed',1456164797,0),(1981,375,11,'Completed',1456166336,0),(1982,374,12,'Completed',1456166192,0),(1983,375,13,'Completed',1456168131,0),(1984,375,15,'Completed',1456170700,0),(1985,375,10,'Completed',1456171449,0),(1986,375,12,'Completed',1456172395,0),(1987,375,14,'Completed',1456173020,0),(1988,376,3,'Completed',1456484078,0),(1989,376,5,'Completed',1456484190,0),(1990,376,4,'Completed',1456484286,0),(1991,376,13,'Completed',1456484392,0),(1992,376,15,'Completed',1456484438,0),(1993,376,11,'Completed',1456484527,0),(1994,376,12,'Completed',1456484984,0),(1995,376,10,'Completed',1456485075,0),(1996,376,14,'Completed',1456485162,0),(1997,377,3,'Completed',1456781655,0),(1998,377,5,'Completed',1456783497,0),(1999,377,5,'Completed',1456783497,0),(2000,377,13,'Completed',1456784269,0),(2001,377,4,'Completed',1456785103,0),(2002,377,15,'Completed',1456785619,0),(2003,377,15,'Completed',1456785619,0),(2004,377,11,'Completed',1456786493,0),(2005,377,12,'Completed',1456862904,0),(2006,377,10,'Completed',1456863608,0),(2007,377,14,'Completed',1456864498,0),(2008,378,11,'Completed',1456936256,0),(2009,378,13,'Completed',1456937490,0),(2010,378,15,'Completed',1456938286,0),(2011,378,10,'Completed',1456938926,0),(2012,379,4,'Completed',1457113193,0),(2013,379,3,'Completed',1457113616,0),(2014,379,5,'Completed',1457113863,0),(2015,379,13,'Completed',1457114920,0),(2016,379,15,'Completed',1457115016,0),(2017,379,11,'Completed',1457115635,0),(2018,379,12,'Completed',1457120353,0),(2019,379,10,'Completed',1457120673,0),(2020,379,14,'Completed',1457121232,0),(2021,380,11,'Completed',1457383131,0),(2022,380,13,'Completed',1457383804,0),(2023,380,15,'Completed',1457384185,0),(2024,381,11,'Completed',1457386535,0),(2025,381,13,'Completed',1457386890,0),(2026,381,3,'Completed',1457387217,0),(2027,381,15,'Completed',1457387409,0),(2028,381,10,'Completed',1457387604,0),(2029,381,5,'Completed',1457387852,0),(2030,382,11,'Completed',1457458067,0),(2031,382,13,'Completed',1457459835,0),(2032,382,13,'In Progress',NULL,0),(2033,382,15,'Completed',1457463487,0),(2034,382,10,'Completed',1457464464,0),(2035,382,4,'Completed',1457467322,0),(2036,382,3,'Completed',1457468453,1),(2037,382,5,'Completed',1457471848,0),(2038,382,12,'Completed',1457473923,0),(2039,382,14,'Completed',1457531952,0),(2040,380,10,'Completed',1457652756,0),(2041,380,3,'Completed',1457653308,0),(2042,380,5,'Completed',1457670052,0),(2043,380,4,'Completed',1457670311,0),(2044,380,12,'Completed',1457670630,0),(2045,380,14,'Completed',1457730161,0),(2046,383,3,'Completed',1457760003,0),(2047,383,5,'Completed',1457760752,0),(2048,383,4,'Completed',1457761007,0),(2049,383,13,'Completed',1457761986,0),(2050,383,15,'Completed',1457762150,0),(2051,383,11,'Completed',1457763109,0),(2052,383,12,'Completed',1457763491,0),(2053,383,10,'Completed',1457763829,0),(2054,383,14,'Completed',1457764080,0),(2055,384,3,'Completed',1457764607,0),(2056,384,5,'Completed',1457764902,0),(2057,384,4,'Completed',1457765151,0),(2058,384,13,'Completed',1457765416,0),(2059,384,15,'Completed',1457770709,0),(2060,384,11,'Completed',1457770932,0),(2061,384,12,'Completed',1457771768,0),(2062,384,10,'Completed',1457771515,0),(2063,384,14,'Completed',1457771670,0),(2064,385,12,'Completed',1458083914,0),(2065,385,12,'In Progress',NULL,0),(2066,385,10,'Completed',1458084482,0),(2067,385,10,'In Progress',NULL,0),(2068,385,14,'Completed',1458084903,0),(2069,386,11,'Completed',1458243289,0),(2070,386,13,'Completed',1458244525,0),(2071,386,15,'Completed',1458244740,0),(2072,386,10,'Completed',1458245153,0),(2073,387,3,'Completed',1458401804,0),(2074,387,13,'Completed',1458403758,0),(2075,387,11,'Completed',1458409537,0),(2076,387,15,'Completed',1458410142,0),(2077,387,10,'Completed',1458411182,0),(2078,387,4,'Completed',1458412386,0),(2079,387,5,'Completed',1458412208,0),(2080,387,14,'Completed',1458412735,0),(2081,387,12,'Completed',1458413564,0),(2082,388,13,'Completed',1458589342,0),(2083,388,10,'Completed',1458589755,0),(2084,388,15,'Completed',1458589856,0),(2085,388,11,'Completed',1458590352,0),(2086,14,8,'In Progress',NULL,0),(2087,389,3,'Completed',1458843510,0),(2088,389,11,'Completed',1458845415,0),(2089,389,13,'Completed',1458847853,0),(2090,389,5,'Completed',1458848870,0),(2091,389,15,'Completed',1458849276,0),(2092,389,10,'Completed',1458850394,0),(2093,389,4,'Completed',1458851058,0),(2094,389,14,'Completed',1458851829,0),(2095,389,12,'Completed',1458922787,0),(2096,224,8,'Completed',1458930449,0),(2097,390,11,'Completed',1458930889,0),(2098,390,13,'Completed',1458931103,0),(2099,390,15,'Completed',1458931241,0),(2100,390,14,'Completed',1458931362,0),(2101,390,12,'Completed',1458932645,0),(2102,152,8,'Completed',1458933190,0),(2103,390,10,'Completed',1459141054,0),(2104,390,3,'Completed',1459142375,0),(2105,390,5,'Completed',1459143467,0),(2106,391,4,'Completed',1459187533,0),(2107,391,3,'Completed',1459189052,0),(2108,389,8,'Completed',1459190420,0),(2109,391,5,'Completed',1459190490,0),(2110,391,11,'Completed',1459192554,0),(2111,390,8,'Completed',1459190797,0),(2112,390,4,'Completed',1459191426,0),(2113,392,3,'Completed',1459192356,0),(2114,392,3,'In Progress',NULL,0),(2115,392,5,'Completed',1459193911,0),(2116,391,13,'Completed',1459193981,0),(2117,392,5,'In Progress',NULL,0),(2118,391,15,'Completed',1459194212,0),(2119,392,4,'Completed',1459194566,0),(2120,391,10,'Completed',1459195090,0),(2121,392,4,'In Progress',NULL,0),(2122,392,13,'Completed',1459196320,0),(2123,391,12,'Completed',1459196075,0),(2124,391,14,'Completed',1459197098,0),(2125,392,13,'In Progress',NULL,0),(2126,392,15,'Completed',1459259509,0),(2127,392,11,'Completed',1459277069,0),(2128,392,11,'In Progress',NULL,0),(2129,392,12,'Completed',1459277917,0),(2130,392,12,'In Progress',NULL,0),(2131,392,10,'Completed',1459278557,0),(2132,392,10,'In Progress',NULL,0),(2133,392,14,'Completed',1459278925,0),(2134,392,14,'In Progress',NULL,0),(2135,392,8,'Completed',1459279207,0),(2136,392,8,'In Progress',NULL,0),(2137,393,3,'Completed',1459293777,0),(2138,393,4,'Completed',1459294211,0),(2139,393,5,'Completed',1459294749,0),(2140,393,13,'Completed',1459300789,0),(2141,393,15,'Completed',1459301715,0),(2142,393,11,'Completed',1459301575,0),(2143,393,10,'Completed',1459302067,0),(2144,393,12,'Completed',1459302336,0),(2145,393,14,'Completed',1459302663,0),(2146,393,8,'Completed',1459302881,0),(2147,394,10,'Completed',1459353921,0),(2148,394,15,'Completed',1459354185,0),(2149,394,13,'Completed',1459354778,0),(2150,394,11,'Completed',1459355497,0),(2151,394,3,'Completed',1459362253,0),(2152,394,5,'Completed',1459366662,0),(2153,394,4,'Completed',1459367087,0),(2154,394,12,'Completed',1459368316,0),(2155,394,14,'Completed',1459369111,0),(2156,395,3,'Completed',1459375457,0),(2157,395,5,'Completed',1459375984,0),(2158,395,10,'Completed',1459732995,0),(2159,395,11,'Completed',1459733929,0),(2160,395,13,'Completed',1459734825,0),(2161,395,4,'Completed',1459783664,0),(2162,395,15,'Completed',1459784205,0),(2163,395,12,'Completed',1459784467,0),(2164,395,14,'Completed',1459784806,0),(2165,396,3,'Completed',1459787590,0),(2166,396,4,'Completed',1459800031,0),(2167,396,5,'Completed',1459789206,0),(2168,398,4,'In Progress',NULL,0),(2169,399,4,'Completed',1459804750,0),(2170,399,3,'Completed',1459791784,0),(2171,396,11,'Completed',1459796798,0),(2172,399,5,'Completed',1459796006,0),(2173,396,15,'Completed',1459794353,0),(2174,396,13,'Completed',1459796438,0),(2175,399,11,'Completed',1459800688,0),(2176,396,10,'Completed',1459797367,0),(2177,396,12,'Completed',1459798605,0),(2178,396,14,'Completed',1459799603,0),(2179,399,13,'Completed',1459802198,0),(2180,399,15,'Completed',1459802462,0),(2181,399,10,'Completed',1459803043,0),(2182,399,12,'Completed',1459803553,0),(2183,399,14,'Completed',1459804043,0),(2184,243,8,'Completed',1459839877,1),(2185,243,8,'In Progress',NULL,1),(2186,236,8,'Completed',1459855151,0),(2187,400,11,'Completed',1459880895,0),(2188,400,10,'Completed',1459881888,0),(2189,400,15,'Completed',1459882150,0),(2190,400,13,'Completed',1459882741,0),(2191,400,3,'Completed',1459943473,1),(2192,400,5,'Completed',1459944320,0),(2193,400,5,'In Progress',NULL,0),(2194,401,3,'Completed',1459958941,0),(2195,401,5,'Completed',1459960617,0),(2196,401,4,'Completed',1459974670,0),(2197,401,13,'Completed',1459964422,0),(2198,400,3,'In Progress',NULL,0),(2199,400,4,'Completed',1459962040,0),(2200,400,4,'In Progress',NULL,0),(2201,400,12,'Completed',1459962666,0),(2202,400,12,'In Progress',NULL,0),(2203,400,14,'Completed',1459962891,0),(2204,400,14,'In Progress',NULL,0),(2205,400,8,'Completed',1459963038,0),(2206,400,8,'In Progress',NULL,0),(2207,401,10,'Completed',1459965362,0),(2208,401,11,'Completed',1459968493,0),(2209,401,15,'Completed',1459969138,0),(2210,401,12,'Completed',1459970900,0),(2211,401,14,'Completed',1459972609,0),(2212,401,8,'Completed',1459973457,0),(2213,402,11,'Completed',1460123653,0),(2214,402,13,'Completed',1460124899,0),(2215,402,15,'Completed',1460055723,0),(2216,403,3,'Completed',1460304133,0),(2217,403,5,'Completed',1460305762,0),(2218,403,4,'Completed',1460318729,0),(2219,403,13,'Completed',1460309088,0),(2220,403,14,'Completed',1460311588,0),(2221,403,8,'Completed',1460314645,0),(2222,403,15,'Completed',1460315521,0),(2223,403,11,'Completed',1460316988,0),(2224,403,12,'Completed',1460317822,0),(2225,403,10,'Completed',1460318447,0),(2226,404,3,'Completed',1460390206,1),(2227,404,5,'Completed',1460390998,0),(2228,404,4,'Completed',1460398354,0),(2229,404,13,'Completed',1460393910,0),(2230,404,15,'Completed',1460399115,0),(2231,404,11,'Completed',1460401650,0),(2232,404,10,'Completed',1460404467,0),(2233,404,12,'Completed',1460402968,0),(2234,404,8,'Completed',1460403346,0),(2235,404,14,'Completed',1460398098,0),(2236,405,11,'Completed',1460484677,0),(2237,405,3,'Completed',1460485201,0),(2238,405,5,'Completed',1460485463,0),(2239,405,4,'Completed',1460485784,0),(2240,405,13,'Completed',1460485964,0),(2241,405,15,'Completed',1460486116,0),(2242,405,12,'Completed',1460486865,0),(2243,405,10,'Completed',1460487465,0),(2244,405,14,'Completed',1460487847,0),(2245,405,8,'In Progress',NULL,0),(2246,407,3,'Completed',1460566324,0),(2247,407,5,'Completed',1460566779,0),(2248,407,4,'Completed',1460567115,0),(2249,407,13,'Completed',1460567559,0),(2250,407,15,'Completed',1460567629,0),(2251,407,11,'Completed',1460568057,0),(2252,407,12,'Completed',1460568405,0),(2253,407,10,'Completed',1460568596,0),(2254,407,14,'Completed',1460568753,0),(2255,407,8,'Completed',1460568945,0),(2256,408,11,'Completed',1460696284,0),(2257,408,15,'Completed',1460696485,0),(2258,408,10,'Completed',1460696848,0),(2259,408,13,'Completed',1460697326,0),(2260,209,8,'Completed',1461265388,0),(2261,167,8,'Completed',1461336376,0),(2262,411,3,'Completed',1461518142,0),(2263,411,5,'Completed',1461537215,1),(2264,411,4,'In Progress',NULL,0),(2265,411,13,'Completed',1461596689,0),(2266,412,4,'Completed',1461599925,0),(2267,411,15,'Completed',1462435556,0),(2268,412,4,'Completed',1461599925,0),(2269,412,4,'Completed',1461599925,0),(2270,412,3,'Completed',1461598913,0),(2271,412,5,'Completed',1461601739,0),(2272,412,11,'Completed',1461602496,0),(2273,412,13,'Completed',1461604360,0),(2274,412,15,'Completed',1461605016,0),(2275,412,10,'Completed',1461605754,0),(2276,412,12,'Completed',1461606797,0),(2277,412,14,'Completed',1461609525,0),(2278,413,11,'Completed',1461634793,0),(2279,413,13,'Completed',1461769380,0),(2280,414,3,'Completed',1461665112,0),(2281,414,5,'Completed',1461665902,0),(2282,414,4,'Completed',1461666154,0),(2283,414,13,'Completed',1461666669,0),(2284,414,15,'Completed',1461666917,0),(2285,414,11,'Completed',1461667482,0),(2286,414,12,'Completed',1461667712,0),(2287,414,10,'Completed',1461668231,0),(2288,414,14,'Completed',1461668566,0),(2289,414,8,'Completed',1461668979,0),(2290,415,3,'Completed',1461669298,0),(2291,415,5,'Completed',1461670011,0),(2292,415,4,'Completed',1461670523,0),(2293,415,13,'Completed',1461671287,0),(2294,413,15,'Completed',1461773641,0),(2295,413,10,'Completed',1461774703,0),(2296,416,11,'Completed',1462200354,0),(2297,416,3,'Completed',1462202286,0),(2298,416,5,'Completed',1462203679,0),(2299,416,4,'Completed',1462204681,0),(2300,416,13,'Completed',1462206054,0),(2301,417,11,'Completed',1462207087,0),(2302,416,15,'Completed',1462206354,0),(2303,416,12,'Completed',1462206857,0),(2304,418,3,'Completed',1462208559,0),(2305,416,10,'Completed',1462207653,0),(2306,416,14,'Completed',1462207866,0),(2307,416,8,'Completed',1462208336,0),(2308,418,4,'Completed',1462209226,0),(2309,418,5,'Completed',1462210186,0),(2310,418,13,'Completed',1462214125,0),(2311,418,15,'Completed',1462214474,0),(2312,418,11,'Completed',1462216028,0),(2313,418,12,'Completed',1462217365,0),(2314,418,10,'Completed',1462218287,0),(2315,418,14,'Completed',1462218938,0),(2316,418,8,'Completed',1462219652,0),(2317,419,11,'Completed',1462293164,0),(2318,419,15,'Completed',1462292137,0),(2319,419,3,'Completed',1462295302,0),(2320,419,5,'Completed',1462296934,0),(2321,419,4,'Completed',1462297969,0),(2322,419,13,'Completed',1462299957,0),(2323,419,12,'Completed',1462300706,0),(2324,419,10,'Completed',1462301245,0),(2325,419,14,'Completed',1462301774,0),(2326,419,8,'Completed',1462302047,0),(2327,411,11,'In Progress',NULL,0),(2328,421,3,'Completed',1462871954,0),(2329,421,5,'Completed',1462872723,0),(2330,421,4,'Completed',1462873370,0),(2331,421,13,'Completed',1462874744,0),(2332,421,11,'Completed',1463116193,0),(2333,422,12,'Completed',1462983313,0),(2334,422,13,'In Progress',NULL,0),(2335,421,15,'Completed',1463115528,0),(2336,421,12,'Completed',1463116641,0),(2337,421,10,'Completed',1463116950,0),(2338,421,14,'Completed',1463117285,0),(2339,421,8,'Completed',1463117518,0),(2340,415,15,'Completed',1463118426,0),(2341,415,11,'Completed',1463119533,0),(2342,415,12,'Completed',1463121039,0),(2343,415,10,'Completed',1463121459,0),(2344,415,14,'Completed',1463122335,0),(2345,415,8,'Completed',1463122560,0),(2346,424,3,'Completed',1463375136,0),(2347,424,5,'Completed',1463376202,0),(2348,424,4,'Completed',1463377703,0),(2349,424,13,'Completed',1463378815,0),(2350,424,15,'Completed',1463378959,0),(2351,424,11,'Completed',1463379821,0),(2352,424,12,'Completed',1463380102,0),(2353,424,10,'Completed',1463380422,0),(2354,424,14,'Completed',1463380619,0),(2355,424,8,'Completed',1463380820,0),(2356,346,11,'Completed',1463873221,0),(2357,346,13,'Completed',1463876987,0),(2358,425,11,'Completed',1463923797,0),(2359,425,13,'Completed',1463924149,0),(2360,425,15,'Completed',1463924258,0),(2361,425,10,'Completed',1463925785,0),(2362,425,4,'Completed',1463926169,0),(2363,425,3,'Completed',1463926460,0),(2364,425,5,'Completed',1463926669,0),(2365,425,12,'Completed',1463926957,0),(2366,425,14,'Completed',1463927162,0),(2367,228,4,'In Progress',NULL,0),(2368,228,8,'In Progress',NULL,0),(2369,228,8,'In Progress',NULL,0),(2370,288,5,'Completed',1466028636,0),(2371,288,8,'Completed',1466113525,1),(2372,426,3,'Completed',1467154269,0),(2373,426,4,'Completed',1467154961,0),(2374,426,4,'Completed',1467154961,0),(2375,426,15,'Completed',1467155315,0),(2376,426,12,'Completed',1467156981,0),(2377,426,14,'In Progress',NULL,0),(2378,426,5,'Completed',1467162506,0),(2379,426,13,'Completed',1467164855,0),(2380,426,11,'Completed',1467165341,0),(2381,426,10,'Completed',1467166026,0),(2382,426,8,'Completed',1467166454,0),(2383,288,3,'Completed',1472075254,0),(2384,346,15,'Completed',1471213661,0),(2385,346,10,'Completed',1471213997,0),(2386,288,4,'Completed',1473367994,1),(2387,288,11,'Completed',1472504373,1),(2388,288,15,'In Progress',NULL,0),(2389,288,15,'In Progress',NULL,0),(2390,199,8,'Completed',1495203080,0),(2391,199,8,'Completed',1495203080,0);

--
-- Current Database: `bupa_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `bupa_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `bupa_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  `frequency_required` int(11) DEFAULT NULL,
  `staff_requirement` int(11) DEFAULT NULL,
  `required_within_time` int(11) DEFAULT NULL,
  `in_person` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (3,'HIV / AIDS','<p>HIV is an acronym for human immunodeficiency virus and it is the disease that often leads to AIDS. Continuing Education Course (2 CEUs)</p>','<p style=\"margin: 0px; padding: 0px; font-size: 12px; color: rgb(68, 68, 68); line-height: 18px; font-family: helvetica, arial, sans-serif;\">This class provides information on HIV and AIDS- related illnesses. Materials will be presented on the symptoms, causes, pathophysiology, diagnosis, transmission and prevention, treatment, epidemiology, prognosis, and history of HIV and AIDS.</p>',80,'0','Online Only',NULL,'Online-HIVAIDS-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',730,NULL,30,0),(4,'Aggression Management','<p>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions.</p>','<p><strong>Course Overview and Objectives</strong><br><br>The effective handling of aggression is one of the most demanding aspects of working in Behavioral Health. It is an area in which the ability to manage self and assertively communicate with others is essential. This course will explore identifying, preventing and managing aggressive behavior through the use of verbal de-escalation interventions. <br><br>Upon successful completion of this course the learner will be able to: </p><ol><li>Define “Aggression” and “Verbal De-escalation\" </li><li>Identify warning signs for aggressive behavior. </li><li>Give examples of verbal\r\nde-escalation techniques to use in a crisis situation\r\n   </li></ol>',80,'0','Online Only',NULL,'online-aggression-management-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,180,0),(5,'Infection Control','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. 1 CEU</p>','<p>Healthcare workers are required to participate in an annual training on infection prevention and control. At the end of this study guide participants will be able to:</p><ul><li>Understand modes of transmission of bacteria and infections</li><li>Understand universal precautions</li><li>Practice proper hand washing techniques</li><li>Take action to prevention of the spread of disease in your workplace</li></ul>',80,'0','Online Only',NULL,'Online-InfectionControl-021815.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(7,'Confidentiality / HIPAA','<p>Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p>','<p>Confidentiality is one of the most basic rights that our clients have. All healthcare workers are legally and morally bound to protect the confidentiality of others.</p><p>This course is designed to:</p><ol><li><span  style=\"font-size: 10pt;\">Give you an overview of The Health Insurance Portability and Accountability Act of 1996 </span><span  style=\"font-size: 10pt;\">(HIPAA).</span></li><li><span  style=\"font-size: 10pt;\">Familiarize you with any major changes that have been implemented with the new 2013 </span><span  style=\"font-size: 10pt;\">Omnibus Rule Changes.</span></li><li><span  style=\"font-size: 10pt;\">Help you recognize the serious consequences if you fail to comply with HIPAA.</span></li></ol>',80,'','Online',NULL,'HIPAA-2016.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,90,0),(8,'Incident Reporting Requirements','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting.</p>','<p>All public or private substance abuse service providers, licensed by The Department of Children and Families (DCF) must create and maintain policies and procedures for Incident Reporting. This course details the internal procedure for completing and filing an incident report form for an unusual event, as well as, the procedure for reporting a critical incident to the DCF and Joint Commission.</p>',80,'0','Online',NULL,'INCIDENTREPORTING_destinationhope.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(9,'Abuse Reporting & Affirmative Duties','<p>Every individual in Florida has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to report abuse or neglect. This course will take you through the legal requirements in Florida regarding abuse reporting and affirmative duties.</p>','<p>Everyone in Florida is a mandated reporter but some people are professionally mandated reporters. Every person has a responsibility to report suspected abuse or neglect. In addition, Florida Law specifies professionals in certain occupations as required to do so. These professionals are mandated to make a report if they have reasonable  cause to suspect abuse, neglect or exploitation is of a child or a vulnerable adult. Providers of substance abuse services shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under Chapter 39, F.S., and of adults under Section 415.1034 and paragraph 397.501(7)(c), F.S.</p>',80,'0','Online',NULL,'finalcurrentchapter 415.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',730,NULL,90,0),(10,'Sexual Harassment','<p>After completing this self-study session, you will be able to: Define sexual harassment, Identify the types of sexual harassment and Identify behaviors that may be interpreted as sexual harassment.</p>','<p>After completing this self-study session, you will be able to:</p><ul><li>Define sexual harassment.</li><li>Identify the types of sexual harassment.</li><li>Identify behaviors that may be interpreted as sexual harassment.</li></ul>',80,'0','Online',NULL,'finalsexualharassment.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',730,NULL,90,0),(11,'The Americans With Disabilities Act','<p>The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the\r\nnation’s first comprehensive civil rights law addressing the needs of people with disabilities,\r\nprohibiting discrimination in employment, public services, public accommodations, and\r\ntelecommunications.</p>','<p>The Americans with Disabilities Act (ADA), which was signed into law on July 26, 1990, is the nation’s first comprehensive civil rights law addressing the needs of people with disabilities, prohibiting discrimination in employment, public services, public accommodations, and telecommunications. The ADA assures equality of opportunity, full participation, independent living, and economic self-sufficiency to persons with disabilities.</p>',80,'0','Online',NULL,'fADAonline.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(12,'CPR','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,'',730,NULL,180,1),(13,'Ethical Conduct','','',80,'','',NULL,'ethicsfinal.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,90,0),(16,'Cultural Diversity / Cultural Competence','','',80,'','',NULL,NULL,NULL,NULL,'culturaldiversityfinal.pptx',NULL,NULL,NULL,2,'',365,NULL,90,0),(19,'Sexual Abuse and Trauma','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,'',730,NULL,180,1),(20,'Relapse Prevention / Addiction Education','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,180,1),(21,'Medication Management','','',80,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',180,NULL,30,1),(22,'New Employee Orientation','<p>The following study guide has been prepared to orient\r\nyou to various policies and guidelines to Destination Hope, Inc.  Please review this and complete the\r\npost-study test at the end of the packet.</p><p><strong></strong></p>','<p>This following study guide has been prepared to orient\r\nyou to various policies and guidelines to Destination Hope, Inc.  Please review this and complete the\r\npost-study test at the end of the packet.</p>',80,'0','Online',NULL,'New Employee Orientation Packet V1.docx',NULL,NULL,NULL,NULL,NULL,NULL,1,'',NULL,NULL,30,0),(23,'Domestic Violence','<p>This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence.</p>','<p>This course is designed to assist the behavioral healthcare worker in understanding domestic violence and the mandates that involve behavioral healthcare workers. In addition to defining domestic violence, this course will review the effects of domestic violence, the cycle of violence, associated risk factors, safety planning, confidentiality and the legalities of domestic violence. </p><p>Upon completion of this course the participant will: </p><ul>\r\n<li><span  style=\"font-size: 10pt;\">Be able to define domestic violence.</span></li><li><span  style=\"font-size: 10pt;\">Be able to discuss the statistics related to domestic violence.</span></li><li><span  style=\"font-size: 10pt;\">Develop an understanding of the impact and consequences of domestic violence on the\r\nvictim from a health, psychological, and emotional perspective.</span></li><li><span  style=\"font-size: 10pt;\">Be able to assess, counsel and formulate safety plans for clients at risk of domestic violence\r\nor who are currently in a violence relationship. </span></li><li><span  style=\"font-size: 10pt;\">Be able to identify national and local domestic violence resources.</span></li></ul>',80,'0','Online Only',NULL,'finaldomesticviolence.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,180,0),(24,'Understanding Co-occurring Disorders','<p>Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders. Participants will become familiar with the assessment, symptoms, and treatment of co-occurring disorders, and will be provided with an example of a special population that exists within the realm of co-occurring disorders.</p>','<p>Prevalence rates show that individuals with co-occurring disorders are common in both the substance abuse and mental health treatment systems. This course will provide participants with an understanding of the concept and term: co-occurring disorders. Participants will become familiar with the assessment, symptoms, and treatment of co-occurring disorders, and will be provided with an example of a special population that exists within the realm of co-occurring disorders.  </p><p>On completion of this course, participants will be able to identify/demonstrate familiarity with: </p><ol><li><span  style=\"font-size: 10pt;\">The definition and terms related to co-occurring disorders. </span></li><li><span  style=\"font-size: 10pt;\">The assessment of co-occurring disorders and common symptoms. </span></li><li><span  style=\"font-size: 10pt;\">The relationship between substance abuse and mental health concerns. </span></li><li><span  style=\"font-size: 10pt;\">The symptoms of specific co-occurring disorders. </span></li><li><span  style=\"font-size: 10pt;\">Available treatments for clients with co-occurring disorders. </span></li><li><span  style=\"font-size: 10pt;\">A special population example and co-occurring disorders.</span></li></ol>',80,'','Online',NULL,'Co-Occuring Disorders.pdf',NULL,NULL,NULL,NULL,NULL,NULL,2,'',365,NULL,180,0),(25,'Disaster Preparedness','<p>An\r\neffective organizational safety program cannot exist without optimal reporting\r\nof medical/health errors and occurrences. </p>','<p>An\r\neffective organizational safety program cannot exist without optimal reporting\r\nof medical/health errors and occurrences. Therefore, it is the intent of\r\nDestination Hope, Inc. to adopt a non-punitive approach in its management of\r\nerrors and occurrences. All personnel are requiredto report suspected and\r\nidentified medical/health care errors, and should do so without the fear of\r\nreprisal in relationship to their employment. \r\nThis organization supports the concept that errors occur due to a\r\nbreakdown in systems and processes, and will focus on improving systems and\r\nprocesses, rather than disciplining those responsible for errors and\r\noccurrences. A focus will be placed on remedial actions and individual development\r\nto assist rather than punish staff members.</p>',80,'0','',NULL,'Disaster Preparedness.docx',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,90,0),(26,'FLU SHOT','<p>We will keep track of which employees took the FLU shot.</p>','',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,'',365,NULL,14,1),(27,'Relapse Prevention','<p>Relapse Prevention</p>','',80,'','',NULL,'Relapse Prevention.docx',NULL,NULL,NULL,NULL,NULL,NULL,1,'',365,NULL,180,0),(28,'Medication Observation','<p>This training will go over three topics. Hand washing, medication observation and finally the taking of blood pressure. </p>','<p>When you have completed this course, you will know how to take a persons blood pressure correctly. You will also understand the types of medication common to our clients plus side effects of said medication. The trainee will be shown the types of common errors that are often made with medication observation plus go over the various protocols. Finally the trainee will be shown the proper way to wash their hands. </p>',70,'0','',NULL,NULL,NULL,NULL,'Psychotropic Medications.pptx',NULL,NULL,NULL,0,'',362,NULL,5,0),(29,'Hand washing','<p>This training demonstrates BHT\'s wash their hands properly.</p>','<p>Our BHT\'s will be trained towash their hands properly. This training will be taught by our RN in person with our employees.</p>',NULL,'0','',NULL,NULL,'06122017122558.pdf',NULL,NULL,NULL,NULL,NULL,1,'',362,NULL,5,1),(30,'Blood Pressure ','<p>This training is for the BHT\'s and will show them how to take blood pressure.</p>','<p>This training will go into detail how to administer a blood pressure test. This will be taught by a RN.</p>',NULL,'0','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'',362,NULL,5,1),(31,'WORKPLACE VIOLENCE PREVENTION','<p>This course deals with workplace violence prevention. At the end of this training, the trainee is expected to:</p><p>1.Identify the factors that increase the risk of workplace violence, and the types of violence that can occur in any workplace.</p><p>2.Know the strategies and techniques for preventing workplace violence.</p><p>3.Learn how to recognize signs of potentially violent behavior and how to defuse tension.</p><p>4.Know how to respond to threats of violence.</p>','<p>This course deals with workplace violence prevention. At the end of this training, the trainee is expected to:</p><p style=\"margin-left: 20px;\">1.Identify the factors that increase the risk of workplace violence, and the types of violence that can occur in any workplace.</p><p style=\"margin-left: 20px;\">2.Know the strategies and techniques for preventing workplace violence.</p><p style=\"margin-left: 20px;\">3.Learn how to recognize signs of potentially violent behavior and how to defuse tension.</p><p style=\"margin-left: 20px;\">4.Know how to respond to threats of violence.</p>',70,'','',NULL,'Workplace-Violence.pdf',NULL,NULL,NULL,NULL,NULL,NULL,1,'',360,NULL,90,0);

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Admin'),(2,'Direct Care'),(3,'BHT');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=84 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (12,3,1,1),(13,5,1,1),(16,7,1,1),(17,8,1,1),(18,9,1,1),(19,10,1,1),(20,11,1,1),(21,12,2,1),(22,13,1,1),(25,16,1,1),(28,19,2,1),(29,20,2,1),(30,4,2,1),(32,3,2,1),(33,3,3,1),(35,4,3,1),(36,5,2,1),(37,5,3,1),(38,13,2,1),(39,13,3,1),(40,10,2,1),(41,10,3,1),(42,9,2,1),(43,9,3,1),(44,11,2,1),(45,11,3,1),(48,8,2,1),(49,8,3,1),(50,7,2,1),(51,7,3,1),(54,16,2,1),(55,16,3,1),(58,19,3,1),(59,20,3,1),(60,21,3,1),(61,22,1,1),(62,22,2,1),(63,22,3,1),(64,24,2,1),(65,24,3,1),(66,23,2,1),(67,23,3,1),(68,25,1,1),(69,25,2,1),(70,25,3,1),(71,26,1,1),(72,26,2,1),(73,26,3,1),(75,12,3,1),(76,27,2,1),(77,27,3,1),(78,28,3,1),(79,29,3,1),(80,30,3,1),(81,31,1,1),(82,31,2,1),(83,31,3,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--

INSERT INTO `evaluation` VALUES (9,2,1414693949,'','','','','','',3),(10,2,1414693963,'','','','','','',3),(11,2,1414694058,'','','','','','',5),(12,1,1414698803,'','','','','','',3);

--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4336 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--

INSERT INTO `exam_results` VALUES (50,14,4,0),(51,14,4,0),(52,10,4,60),(54,14,4,69),(55,14,4,75),(57,14,4,94),(98,10,3,15),(99,10,3,100),(827,14,3,85),(1224,14,5,100),(3010,10,8,100),(3022,10,5,20),(3023,10,5,100),(3079,14,8,100),(3080,14,8,100),(3081,14,8,13),(3082,14,8,67),(3083,14,8,100),(3417,14,10,53),(4332,10,31,100),(4333,10,31,100),(4334,10,31,100),(4335,10,31,100);

--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Compliance Training');

--
-- Table structure for table `option`
--

CREATE TABLE `option` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `question_id` int(11) NOT NULL,
  `content` text NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_id` (`question_id`),
  CONSTRAINT `option_ibfk_1` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1903 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `option`
--

INSERT INTO `option` VALUES (4,6,'1 in 2',NULL),(5,6,'1 in 5',NULL),(6,6,'1 in 3',NULL),(7,6,'1 in 4',NULL),(8,7,'An effective vaccine is now available to prevent the disease.',NULL),(9,7,'HIV testing is not only free but compulsory for everyone over age 18.',NULL),(10,7,'People believe that antiretroviral drugs have solved the HIV problem.',NULL),(11,7,'The number of new infections is continuing to decline.',NULL),(12,8,'Free HIV testing of all patients over age 13.',NULL),(13,8,'Developing a vaccine to prevent HIV infection.',NULL),(14,8,'Reducing the rate of new infections.',NULL),(15,8,'Compulsory HIV testing of all patients in emergency departments.',NULL),(16,9,'Black/African Americans.',NULL),(17,9,'Seniors.',NULL),(18,9,'Hispanics.',NULL),(19,9,'Native Americans.',NULL),(20,10,'Women and children, seniors, and transgender persons',NULL),(21,10,'Men who have sex with men, women who have sex with women, prisoners',NULL),(22,10,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',NULL),(23,10,'Women who have sex with women, homeless people, and seniors',NULL),(24,11,'Adopt compulsory hand-washing policies for staff and inmates.',NULL),(25,11,'Provide inmates with condoms and access to bleach for cleaning injection equipment.',NULL),(26,11,'Increase the number of correctional officers who monitor inmate activity.',NULL),(27,11,'Enroll inmates in HIV vaccine clinical trials.',NULL),(28,12,'When they enter prison.',NULL),(29,12,'Within 60 days prior to release.',NULL),(30,12,'Within 30 days prior to release.',NULL),(31,12,'Never; it is not required by law.',NULL),(32,13,'Healthcare workers are more focused on mental health issues in seniors.',NULL),(33,13,'Seniors avoid answering questions about sexual activity.',NULL),(34,13,'Seniors believe they are immune to HIV/AIDS.',NULL),(35,13,'Symptoms of AIDS such as fatigue and weight loss mimic those of normal aging.',NULL),(36,14,'Saliva and cervical secretions',NULL),(37,14,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(38,14,'Blood, semen, breast milk, and vaginal and cervical secretions',NULL),(39,14,'Blood, semen, and urine',NULL),(40,15,'Blood collected for transfusion',NULL),(41,15,'Used needles and syringes',NULL),(42,15,'Casual contact with an infected patient',NULL),(43,15,'A public toilet seat',NULL),(44,16,'Increases the risk of HIV transmission.',NULL),(45,16,'Reduces the risk of HIV transmission.',NULL),(46,16,'Makes no difference in the risk of HIV transmission.',NULL),(47,16,'Increases the risk of pregnancy in women.',NULL),(48,17,'Syphilis',NULL),(49,17,'Hepatitis B (HBV)',NULL),(50,17,'Chlamydia',NULL),(51,17,'Tuberculosis (TB)',NULL),(52,18,'Relatively simple if the patient has health insurance.',NULL),(53,18,'A complex, multi-drug process that takes at least 6 months.',NULL),(54,18,'Usually not successful in African American patients.',NULL),(55,18,'Successful in most patients.',NULL),(56,19,'Unnecessary in HIV patient situations.',NULL),(57,19,'Warranted only if a patient has been diagnosed with TB.',NULL),(58,19,'Effective only if properly fitted and appropriately worn in all areas where risk of exposure is high.',NULL),(59,19,'Primarily used with patients who are coinfected with hepatitis.',NULL),(60,20,'Brain tumors from syphilis.',NULL),(61,20,'Liver disease from chronic hepatitis C.',NULL),(62,20,'Heart disease from antiretroviral drugs.',NULL),(63,20,'Stroke related to antiretroviral drugs.',NULL),(295,53,'True',NULL),(296,53,'False',1),(299,55,'True',NULL),(300,55,'False',1),(325,60,'True',1),(326,60,'False',NULL),(327,62,'True',1),(328,62,'False',NULL),(329,63,'Defensive level, anxiety level, acting out, tension reduction',NULL),(330,63,'Tension inducing, anxiety level, defensive level, acting out',NULL),(331,63,'Anxiety level, defensive level, acting out, tension reduction',1),(332,63,'Acting out, anxiety level, defensive level, tension reduction',NULL),(333,64,'True',1),(334,64,'False',NULL),(339,82,'Clenched fists',NULL),(340,82,'Pacing',NULL),(341,82,'Rapid breathing',NULL),(342,82,'Withdrawn behavior',NULL),(343,82,'All of the Above',1),(344,83,'The person is under the influence of a substance',NULL),(345,83,'The person has a history of psychiatric illness',NULL),(346,83,'The person is facing a high level of stress',NULL),(347,83,'All of the Above',1),(348,83,'A and B',NULL),(409,58,'Using a calm voice and acronyms or jargon',NULL),(410,58,'Giving the person your full attention',NULL),(411,58,'Paraphrasing what the person is saying',NULL),(412,58,'Validating the person’s feelings about the situation',NULL),(413,58,'All of the above',NULL),(414,58,'B, C, and D',1),(415,59,'Speak slowly clearly and gently',NULL),(416,59,'Walk fast away from client to avoid an altercation',NULL),(417,59,'Appear confident and display calmness',NULL),(418,59,'Show you are listening',NULL),(419,59,'A, C, and D',1),(420,59,'A and B',NULL),(421,61,'Don’t use jargon',NULL),(422,61,'Avoid demeaning language',NULL),(423,61,'Find someone that speaks that person’s language',NULL),(424,61,'A and B',NULL),(425,61,'All of the above',1),(449,54,'True',1),(450,54,'False',NULL),(451,57,'Telling the patient what he/she is feeling.',NULL),(452,57,'Summarize what the patient stated and repeat back to verify accuracy ',1),(453,57,'Make client aware of the incongruities from their statement',NULL),(454,57,'None of the above',NULL),(455,65,'Acting out',NULL),(456,65,'Tension Reduction',NULL),(457,65,'Anxiety Level',NULL),(458,65,'Defensive Level',1),(459,85,'True',1),(460,85,'False',NULL),(465,27,'False',1),(466,27,'True',NULL),(467,28,'True',1),(468,28,'False',NULL),(469,29,'False',1),(470,29,'True',NULL),(471,30,'True',1),(472,30,'False',NULL),(473,31,'True',NULL),(474,31,'False',1),(475,32,'True',1),(476,32,'False',NULL),(477,33,'True',1),(478,33,'False',NULL),(479,34,'True',1),(480,34,'False',NULL),(481,35,'Abstinence',NULL),(482,35,'Monogamous Relationship with partners not infected with HIV/AIDS',NULL),(483,35,'Protected Sex',NULL),(484,35,'Sterile needles',NULL),(485,35,'All of the above',1),(490,37,'Black/African Americans',1),(491,37,'Seniors',NULL),(492,37,'Hispanics',NULL),(493,37,'Native Americans',NULL),(498,38,'Women and children, seniors, and transgender persons',NULL),(499,38,'Men who have sex with men, women who have sex with women, prisoners',NULL),(500,38,'Men who have sex with men, injecting-drug users, and men who have sex with men and also use injection drugs',1),(501,38,'Women who have sex with women, homeless people, and seniors',NULL),(506,39,'Saliva and cervical secretions',NULL),(507,39,'Saliva, tears, serous fluid, and vaginal secretions',NULL),(508,39,'Blood, semen, breast milk, and vaginal and cervical secretions',1),(509,39,'Blood, semen, and urine',NULL),(510,40,'Blood collected for transfusion',NULL),(511,40,'Used needles and syringes',1),(512,40,'Casual contact with an infected patient',NULL),(513,40,'A public toilet seat',NULL),(514,41,'Are entitled to know their child\'s HIV test results without their child\'s consent.',NULL),(515,41,'May not be informed directly or indirectly of their child\'s HIV test results without the child\'s consent.',1),(516,41,'May be informed indirectly of their child\'s HIV test results when sent a bill for said testing.',NULL),(517,41,'Must give consent for their child to be tested for HIV.',NULL),(519,47,'Bona fide medical emergencies',NULL),(520,47,'Court order',NULL),(521,47,'All of the above',1),(527,49,'Medical personnel involved with the diagnosis or treatment of the person tested; ',NULL),(528,49,'Licensed medical professionals who regularly participate as part of an interdisciplinary team ',NULL),(529,49,'Staff that handle body fluids ',NULL),(530,49,'Personnel involved in utilization review, risk management or peer review activities; ',NULL),(531,49,'Financial staff who compile or review medical records as part of routine billing activities',NULL),(532,49,'All of the above',1),(533,42,'Be tested for HIV at their initial prenatal visit and at 28-32 weeks.',1),(534,42,'Be tested for HCV at the first prenatal visit.',NULL),(535,42,'Not be offered HIV testing on an opt-out basis (right to refuse).',NULL),(536,42,'Request to be tested for HIV',NULL),(537,67,'A source',NULL),(538,67,'A mode of transmission',NULL),(539,67,'A host',NULL),(540,67,'All of the above',1),(541,68,'Every healthcare worker plays a vital role ',NULL),(542,68,'Staff education is an important aspect',NULL),(543,68,'Utilizes measures used to minimize the risk of transmission',NULL),(544,68,'All of the above',1),(545,69,'Droplets are generated by coughs, sneezes, talking',NULL),(546,69,'Droplet transmission is the most frequent mode of transmission in the healthcare setting',1),(547,69,'You can become infected when they land in eyes, mouth or nose',NULL),(548,69,'They can transmit infection when propelled a short distance and land on a surface',NULL),(549,70,'HIV',NULL),(550,70,'Hepatitis B',NULL),(551,70,'Tuberculosis',1),(552,70,'Herpes',NULL),(553,71,'From mosquitos or insect bites',1),(554,71,'From blood or body fluids',NULL),(555,71,'From food or water',NULL),(556,71,'From coughs and sneezes ',NULL),(557,72,'Wear a fit-tested NIOSH-approved N95',1),(558,72,'Wear a surgical mask',NULL),(559,72,'Take 15 minute hot shower after exposure',NULL),(560,72,'Wash your hands with soap and water for 10 minutes',NULL),(561,73,'Direct contact',NULL),(562,73,'Indirect contact',NULL),(563,73,'Respiratory transmission',NULL),(564,73,'Vector-born transmission',NULL),(565,73,'All of the above',1),(576,81,'Sweat',1),(577,81,'Saliva',NULL),(578,81,'Blood',NULL),(579,81,'None of the above',NULL),(580,78,'30 seconds',NULL),(581,78,'15 seconds',NULL),(582,78,'At least for 20 seconds',1),(583,78,'60 seconds',NULL),(598,89,'Airborne Precautions',NULL),(599,89,'Contact Precautions',NULL),(600,89,'Standard Precautions',1),(601,89,'Droplet Precautions',NULL),(602,90,'True',NULL),(603,90,'False',1),(604,91,'Where clinical professionals, in this case in the addiction industry, have multiple relationship roles with their clients',1),(605,91,'An unaviodable part of doing business in the addiction treatment industry',NULL),(606,91,'A multiple role relationship that is generally suitable for the therapist-client relationship',NULL),(607,91,'All of the above',NULL),(608,92,'To give authorization for treatment center employees to use private information',NULL),(609,92,'To secure a person\'s private financial information',NULL),(610,92,'To define the the proper use of an individual\'s health records',1),(611,92,'To punish addiction treatment centers that misuse personal information',NULL),(612,93,'Health Information Portability Protection Act',NULL),(613,93,'Health Insurance Portability and Accountability Act',1),(614,93,'Human Interest Protection  Act',NULL),(615,93,'None of the above',NULL),(616,94,'True',NULL),(617,94,'False',1),(618,95,'A fraudulent accounting scheme',NULL),(619,95,'The requirement for an arrested person to be brought into court or before a judge',1),(620,95,'The legal definition of self-inflicted bodily harm',NULL),(621,95,'None of the above',NULL),(622,96,'The clinician is the professional',NULL),(623,96,'Proper boundaries cannot be defined therefore this is a moot point',NULL),(624,96,'The client may not understand proper boundaries and may not be able to defend themselves against violations',NULL),(625,96,'The counselor must report to their supervisor',NULL),(626,96,'A and C',1),(627,96,'A and D',NULL),(628,97,'True',1),(629,97,'False',NULL),(630,98,'Quid Pro Quo',NULL),(631,98,'Professional Business',NULL),(632,98,'Dual Relationship',1),(633,98,'None of the Above',NULL),(634,99,'On a need to know basis within the facility',NULL),(635,99,'Medical emergencies',NULL),(636,99,'When parents ask',NULL),(637,99,'Client information can never be disclosed without written consent',NULL),(638,99,'B and C',NULL),(639,99,'A and B',1),(640,100,'Crossed Legs',NULL),(641,100,'Standing Tall',NULL),(642,100,'Slouching',NULL),(643,100,'Red face',NULL),(644,100,'B and D',1),(645,100,'A and B',NULL),(646,101,'True',NULL),(647,101,'False',1),(648,102,'Stress and history of violence',1),(649,102,'Stress and a long marriage',NULL),(650,102,'A long marriage and a high degree of social interaction',NULL),(651,102,'A high degree of social interaction and a history of violence',NULL),(652,103,'Perception and prejudice',NULL),(653,103,'Noise',NULL),(654,103,'Language',NULL),(655,103,'All of the above',1),(656,104,'Common depression',NULL),(657,104,'bipolar disorder doesn\'t fall under the DSMIV-TR purview',NULL),(658,104,'Mood changes that last for 48 hours or less',NULL),(659,104,'Significant mood changes that last for weeks or months',1),(660,105,'True',NULL),(661,105,'False',1),(662,106,'Use',NULL),(663,106,'Abuse',1),(664,106,'Misuse',NULL),(665,106,'Addiction',NULL),(666,107,'A good idea to use as proof',NULL),(667,107,'Not a problem if the copies are lost',NULL),(668,107,'A bad idea unless needed for an important purpose.',1),(669,107,'Something that should never be done',NULL),(670,108,'True',NULL),(671,108,'False',1),(674,110,'True',NULL),(675,110,'False',1),(676,111,'True',NULL),(677,111,'False',1),(678,112,'True',1),(679,112,'False',NULL),(680,113,'True',NULL),(681,113,'False',1),(682,109,'True',1),(683,109,'False',NULL),(684,114,'It eliminates the possibility of infection',NULL),(685,114,'It helps determine the exposure risk of staff members',1),(686,114,'A and B',NULL),(687,114,'None of the above',NULL),(688,115,'Common cold, Pinkeye, Flu',1),(689,115,'Common cold, Flu, HIV',NULL),(690,115,'HIV, Common cold, Pinkeye, Flu',NULL),(691,115,'AIDS, Pinkeye, Flu',NULL),(692,116,'FS 387.219 (1)',NULL),(693,116,'FS 456.222 (4)',NULL),(694,116,'FS 397.419 (2)',1),(695,116,'FS 298.419 (1)',NULL),(696,117,'Organizations',NULL),(697,117,'Supervisors',NULL),(698,117,'Risk Managers',NULL),(699,117,'All Staff',1),(700,118,'Verification of corrective action',NULL),(701,118,'Results of Root Cause Analyses',NULL),(702,118,'Provision for reporting to the Department',NULL),(703,118,'a and b',NULL),(704,118,'a and c',1),(705,119,'As soon as possible and no later than 48 hours',NULL),(706,119,'As soon as possible and no later than 72 hours',NULL),(707,119,'As soon as possible and no later than 24 hours',1),(708,119,'As soon as possible',NULL),(709,120,'Collaborate for accuracy of events witnessed',NULL),(710,120,'Both sign the Incident Report Form',NULL),(711,120,'Each file a separate Incident Report Form',1),(712,120,'Jointly prepare one Incident Report Form',NULL),(713,121,'True',NULL),(714,121,'False',1),(715,122,'Complete one Incident Report listing all clients involved in the incident',NULL),(716,122,'Complete a separate Incident Report for each client involved',1),(717,122,'Have client’s Primary Therapist complete an incident report',NULL),(718,122,'None of the above',NULL),(723,124,'Enter concise subjective statements of fact',NULL),(724,124,'Express their own opinion of the occurrence',NULL),(725,124,'Enter concise objective statements of fact',1),(726,124,'a and b',NULL),(727,125,'Promptly report a critical incidence within 6 hours',NULL),(728,125,'Promptly report a critical incident within 24 hours',NULL),(729,125,'Promptly report a critical incident within one business day',1),(730,125,'None of the above',NULL),(731,126,'The Critical Incident Reporting System (CIRS)',NULL),(732,126,'The Critical Incident Analyses System (CIAS)',NULL),(733,126,'The Incident Analysis and Reporting System (IRAS)',NULL),(734,126,'The Incident Reporting and Analysis System (IRAS)',1),(735,127,'All Substance Abuse Providers licensed by the DCF',NULL),(736,127,'Managing Entities',NULL),(737,127,'State  mental health treatment facilities  ',NULL),(738,127,'A and B',1),(739,127,'A and C',NULL),(740,128,'True',1),(741,128,'False',NULL),(742,129,'1994',NULL),(743,129,'1998',NULL),(744,129,'1996',1),(745,129,'1997',NULL),(746,130,'True',NULL),(747,130,'False',1),(748,131,'To report it to your supervisor',NULL),(749,131,'To report it only if you believe it is an emergency',NULL),(750,131,'To report it to the Florida Abuse Hotline of Children and Families',1),(751,131,'You are only required to report it to the person’s insurance company',NULL),(752,132,'Abandonment',NULL),(753,132,'Abuse',NULL),(754,132,'Exploitation',NULL),(755,132,'Neglect',1),(760,134,'They are ashamed ',NULL),(761,134,'They feel no one will believe them',NULL),(762,134,'They are afraid someone may retaliate if they report them',NULL),(763,134,'All of the above',1),(764,135,'True',1),(765,135,'False',NULL),(777,139,'Section 415.1034',NULL),(778,139,'Chapter 40, F.S.',NULL),(779,139,'Chapter 39, F.S.',1),(780,139,'Section 48 F.S.',NULL),(781,140,'800-222-2873',NULL),(782,140,'800-962-2873',1),(783,140,'800-914-0004',NULL),(784,140,'800-453-5145',NULL),(785,141,'Welcomed, physical in nature, and occur in or impact the workplace',NULL),(786,141,'Unwelcome, sexual in nature, and occur in or impact the workplace.',1),(787,141,'Unwelcome, sexual in nature and occur in the workplace',NULL),(788,141,'Unwelcome, physical in nature and occur in the workplace',NULL),(789,142,'Making derogatory or sexually explicit comments',NULL),(790,142,'Displaying sexually suggestive posters',NULL),(791,142,'Making unwanted physical contact',NULL),(792,142,'All of the above',1),(793,143,'Rewards or threats in the areas of hiring/firing, promotion, and performance review',1),(794,143,'Behavior that makes the workplace uncomfortable ',NULL),(795,143,'Unwelcome suggestive, sexually explicit or obscene letters, notes, emails or invitations.',NULL),(796,143,'Sexually explicit offensive comments',NULL),(797,144,'Express yourself verbally',NULL),(798,144,'Tell the harasser the behavior is making you uncomfortable',NULL),(799,144,'Express yourself non verbally',NULL),(800,144,'If you are afraid of retaliation say nothing and go straight to HR',NULL),(801,144,'All of the above',1),(802,145,'Disagrees with employers that discriminate based on sex, gender, race, religion or any other protected class.',NULL),(803,145,'Files a discrimination charge',NULL),(804,145,'Offers testimony or partakes in an investigation or court proceeding',NULL),(805,145,'All of the above',1),(810,148,'True',1),(811,148,'False',NULL),(812,149,'True',1),(813,149,'False',NULL),(814,150,'True',1),(815,150,'False',NULL),(816,151,'True',NULL),(817,151,'False',1),(818,152,'True',NULL),(819,152,'False',1),(820,154,'Yes',1),(821,154,'No',NULL),(822,155,'Yes',NULL),(823,155,'No',1),(824,156,'Yes',1),(825,156,'No',NULL),(826,136,'True',NULL),(827,136,'False',1),(828,138,'Exploitation',NULL),(829,138,'Abuse',1),(830,138,'Neglect',NULL),(831,138,'All of the above',NULL),(832,157,'State and local governments',NULL),(833,157,'Private employers',NULL),(834,157,'Employment agencies',NULL),(835,157,'Labor organizations',NULL),(836,157,'All of the above',1),(837,158,'No means of transportation',NULL),(838,158,'A criminal history',NULL),(839,158,'A physical or mental impairment that substantially limits one or more life activities',1),(840,158,'None of the above',NULL),(841,158,'All of the above',NULL),(842,159,'Sexual preference',NULL),(843,159,'Kleptomania',NULL),(844,159,'Illegal Drug use',NULL),(845,159,'All of the above',1),(846,160,'True',1),(847,160,'False',NULL),(848,161,'Changing a training manual',NULL),(849,161,'Letting employee sleep during work hours',NULL),(850,161,'Providing an interpreter',NULL),(851,161,'A and C',1),(852,162,'True',1),(853,162,'False',NULL),(854,163,'True',NULL),(855,163,'False',1),(856,164,'True',1),(857,164,'False',NULL),(858,165,'True',NULL),(859,165,'False',1),(860,166,'Walking',NULL),(861,166,'Breathing',NULL),(862,166,'Eating',NULL),(863,166,'Major bodily functions',NULL),(864,166,'All of the above',1),(865,146,'True',1),(866,146,'False',NULL),(867,147,'True',1),(868,147,'False',NULL),(869,133,'Law enforcement officer',NULL),(870,133,'Nurse in an assisted living facility',NULL),(871,133,'School teacher',NULL),(872,133,'All of the above',1),(876,169,'ZXZX',1),(1037,170,'A public health problem, impacting large numbers of the population',1),(1038,170,'A family problem, best dealt with within the family ',NULL),(1039,170,'A reportable crime in Florida regardless of whether or not a weapon was used in the abuse',NULL),(1040,170,'All of the above',NULL),(1041,171,'Stalking, psychological violence; neglect and physical violence',NULL),(1042,171,'Physical violence, sexual violence; stalking; and emotional violence',NULL),(1043,171,'Physical violence; sexual violence; threats of physical and sexual violence; emotional and psychological violence',1),(1044,171,'None of the above',NULL),(1045,172,'Witnessing or experiencing violence as a child',NULL),(1046,172,'Economic security',1),(1047,172,'Weak community sanctions against Domestic Violence such as police being unwilling to intervene',NULL),(1048,172,'Dominance and control by one partner in the relationship',NULL),(1049,173,'Low self-esteem, low income and drug and alcohol abuse',NULL),(1050,173,'Individual, societal, relational and community',1),(1051,173,'Anger, passivity, Anti-social personality traits and Borderline personality traits',NULL),(1052,173,'All of the above',NULL),(1053,174,'Verbal abuse',NULL),(1054,174,'Physical acting out',NULL),(1055,174,'Difficulty getting along with others',1),(1056,174,'All of the above',NULL),(1057,175,'Forcing sexual acts',NULL),(1058,175,'Isolating the victim',NULL),(1059,175,'The abuser threatening suicide',NULL),(1060,175,'All of the above',1),(1061,176,'Drug or alcohol abuse',NULL),(1062,176,'Intense jealousy',NULL),(1063,176,'Welcoming of others into relationship',1),(1064,176,'Will not allow a break-up of the relationship',NULL),(1065,177,'Emotional insecurity and depression',1),(1066,177,'Belief in the bonds of marriage and monogamy',NULL),(1067,177,'Maturity and self-reliance',NULL),(1068,177,'Strong ego and many friends',NULL),(1069,178,'Withhold money',NULL),(1070,178,'Intimidate',NULL),(1071,178,'Use children to deliver messages',NULL),(1072,178,'All of the above',1),(1073,179,'Signs of a victim',NULL),(1074,179,'Parts of the cycle of violence',1),(1075,179,'Signs of an abuser',NULL),(1076,179,'Signs of marital conflict',NULL),(1077,180,'911—If you are in immediate danger',NULL),(1078,180,'The National Domestic Violence Hotline at 1-800-799-SAFE (7233)',NULL),(1079,180,'The National Sexual Assault Hotline at 1-800-656-4673',NULL),(1080,180,'All of the above',1),(1081,181,'9.2% to 30.5%',1),(1082,181,'15%',NULL),(1083,181,'24.3%',NULL),(1084,181,'14.8%',NULL),(1085,182,'Emotional discomfort',NULL),(1086,182,'Blaming the victim',1),(1087,182,'Cultural barriers',NULL),(1088,182,'Uncooperative behavior by the victim',NULL),(1089,183,'Accurate documentation and safe guarding evidence',1),(1090,183,'Staying disconnected',NULL),(1091,183,'Demand the criminal justice system get involved',NULL),(1092,183,'All of the above',NULL),(1093,184,'Intervening directly with the abuser',NULL),(1094,184,'Acknowledging client barriers for seeking help',1),(1095,184,'Filing police reports on behalf of the victim',NULL),(1096,184,'None of the above',NULL),(1097,185,'Helping victim create a safety plan',NULL),(1098,185,'Give advice whether to leave or stay in abusive relationship',1),(1099,185,'Validate victims experience',NULL),(1100,185,'Respect confidentiality of victim',NULL),(1101,186,'800-799-7233',NULL),(1102,186,'800-500-1119',1),(1103,186,'800-656-4673',NULL),(1104,186,'800-656-6767',NULL),(1105,187,'Increasing safety at home',NULL),(1106,187,'Planning for emotional support',NULL),(1107,187,'Immediate and long term safety',NULL),(1108,187,'All of the above',1),(1109,188,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a gunshot wound, or life threatening injury indicating an act of violence.',1),(1110,188,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a broken arm, leg etc.',NULL),(1111,188,'That physicians, nurses and employees or hospitals, clinics, nursing homes and sanitariums must report treating any person sustaining a fall',NULL),(1112,188,'None of the above',NULL),(1113,189,'That the assessment was conducted and no Domestic Violence signs were indicated',NULL),(1114,189,'That the assessment was conducted and the worker did not get an answer about DV from the patient',NULL),(1115,189,'That the assessment was conducted and that the patient did not disclose abuse',1),(1116,189,'None of the above',NULL),(1161,566,'a. The presence of two or more disorders at the same time',1),(1162,566,'b. The presence of at least 2 mental health disorders',NULL),(1163,566,'c. The presence of at least 2 substance related disorders',NULL),(1164,566,'d. None of the above',NULL),(1165,567,'a. Schizophrenia and Depression ',NULL),(1166,567,'b. Bipolar Disorder and Anxiety Disorder',1),(1167,567,'c. Depression and Fibromyalgia',NULL),(1168,567,'d. Bipolar Disorder and Chronic Fatigue',NULL),(1169,568,'a. Alcohol and drugs can increase underlying risk for mental disorders.',NULL),(1170,568,'b. Alcohol or drugs are often used to self-medicate symptoms of depression or anxiety.',NULL),(1171,568,'c. Psychiatric problems do not get worse by using drugs or alcohol.',1),(1172,568,'d. Alcohol and drug abuse can make symptoms of a mental health problem worse.',NULL),(1173,569,'a. Lying about one’s addiction',NULL),(1174,569,'b. Denial frequently occurs in mental disorders',NULL),(1175,569,'c. If the problem is not acknowledged, it doesn\'t exist.',NULL),(1176,569,'d. All of the above',1),(1177,570,'a. Feeling restless or jumpy',NULL),(1178,570,'b. Trouble concentrating',NULL),(1179,570,'c. Decreased need for sleep',NULL),(1180,570,'d. A and B',1),(1181,571,'a. Sequential model of treatment',NULL),(1182,571,'b. Parallel model of treatment',NULL),(1183,571,'c. Integrated model of treatment',1),(1184,571,'d. All of the above',NULL),(1189,575,'a. Depression?',NULL),(1190,575,'b. Bipolar Disorder?',NULL),(1191,575,'c. Obsessive Compulsive Disorder?',1),(1192,575,'d. Social Anxiety Disorder? ',NULL),(1193,576,'a. Obsessive Compulsive Disorder?',NULL),(1194,576,'b. Anxiety Disorder?',NULL),(1195,576,'c. Mania phase in Bipolar Disorder?',1),(1196,576,'d. Depression?',NULL),(1197,577,'True',1),(1198,577,'False',NULL),(1199,578,'True',1),(1200,578,'False',NULL),(1201,579,'True',1),(1202,579,'False',NULL),(1203,580,'True',1),(1204,580,'False',NULL),(1205,36,'a)	1 in 2',NULL),(1206,36,'b)	1 in 7',1),(1207,36,'c)	1 in 3',NULL),(1208,36,'d)	1 in 4',NULL),(1209,581,'Discussing client issues only in private areas',NULL),(1210,581,'Requiring written authorization before releasing information',NULL),(1211,581,'Not utilizing client last names in public areas or medical record file covers',NULL),(1212,581,'All of the above',1),(1213,582,'Health Information Property Accountability Association',NULL),(1214,582,'Human Insurance Process Accumulation Act',NULL),(1215,582,'Health Insurance Portability and Accountability Act',1),(1216,583,'Security',NULL),(1217,583,'Privacy',1),(1218,583,'Confidentiality',NULL),(1219,584,'Electronic Medical Record ',NULL),(1220,584,'Security ',NULL),(1221,584,'HITECH',1),(1222,584,'HHS',NULL),(1223,585,'Medical record number',NULL),(1224,585,'Telephone number',NULL),(1225,585,'Fax number',NULL),(1226,585,'Social security number',NULL),(1227,585,'All of the above',1),(1228,585,'A, B and D',NULL),(1229,586,'Disciplinary action',NULL),(1230,586,'Loss of access privileges',NULL),(1231,586,'Fines and penalties',NULL),(1232,586,'Imprisonment',NULL),(1233,586,'All of the above',1),(1234,587,'Yes',NULL),(1235,587,'No',1),(1236,588,'Yes, if he is an employee and you know him.',NULL),(1237,588,'Yes, if your manager says that it’s okay.',NULL),(1238,588,'No, sharing log-in IDs and passwords is a security violation.',1),(1239,588,'A and B',NULL),(1240,589,'I am only expected to complete the minimum requirements of my job.',NULL),(1241,589,' Requests for and disclosures of PHI are limited to what is needed to perform the task.',1),(1242,589,'A medical center is no longer allowed to provide information about patients to the media under any circumstances',NULL),(1243,589,'A and B',NULL),(1244,590,'Yes.  They can be used interchangeably.',NULL),(1245,590,'No.  Consents are used to get the patient\'s permission to use or disclose health information for       treatment, payment or business operations. Authorizations are used to obtain permission to disclose    PHI for activities outside the realm of treatment, payment or business operations.',1),(1246,591,'True',1),(1247,591,'False',NULL),(1248,592,'True',1),(1249,592,'False',NULL),(1250,593,'True',NULL),(1251,593,'False',1),(1252,594,'Management of Safe Devices and Systems.',NULL),(1253,594,'Maintenance and Storage of Devices and Systems.',NULL),(1254,594,'Material Safety Data Sheets.',1),(1255,594,'Management, Storage and Distribution of Substances.',NULL),(1256,595,'True',1),(1257,595,'False',NULL),(1258,596,'Tornado',NULL),(1259,596,'Medical',NULL),(1260,596,'Bomb',1),(1261,596,'Patient Emergency',NULL),(1262,597,'Code Hot',NULL),(1263,597,'Code Red',1),(1264,597,'Code Fire',NULL),(1265,597,'Patient Emergency',NULL),(1266,598,'Code Yellow',NULL),(1267,598,'Code Grey',1),(1268,598,'Code Purple',NULL),(1269,598,'Code Pink',NULL),(1274,600,'Read, Act, Collect, Evacuate',NULL),(1275,600,'Read, Ask, Confine, Extinguish',NULL),(1276,600,'Rescue/Remove from danger, Alert/Alarm, Confine/Contain, Extinguish/Evacuate',1),(1281,602,'True',1),(1282,602,'False',NULL),(1283,603,'True',1),(1284,603,'False',NULL),(1285,604,'True',1),(1286,604,'False',NULL),(1291,605,'Code Red',NULL),(1292,605,'Code Purple',NULL),(1293,605,'Code White',1),(1294,605,'Code Green',NULL),(1299,607,'Outside lighting',NULL),(1300,607,'Alarm system',NULL),(1301,607,'Employee picture ID badges',NULL),(1302,607,'All of the above',1),(1303,608,'True',1),(1304,608,'False',NULL),(1305,609,'True',NULL),(1306,609,'False',1),(1307,610,'The beliefs customs, arts, etc., of a particular society, group, place or time.',NULL),(1308,610,'A way of thinking, behaving, or working that exists in a place or organization.',NULL),(1309,610,'A particular society that has its own beliefs or ways of life.',NULL),(1310,610,'All of the above',1),(1311,611,'True',NULL),(1312,611,'False',1),(1313,612,'True',1),(1314,612,'False',NULL),(1315,613,'Spirituality and religion are not the same',NULL),(1316,613,'Spirituality/Religion is not part of every ethnic group',1),(1317,613,'Religion is an organized system of belief in a higher power',NULL),(1318,613,'Spirituality/religion is the belief individuals have about themselves, their connections with others and their relationship with a higher power.',NULL),(1319,614,'True',1),(1320,614,'False',NULL),(1325,616,'Cultural Incapacity',NULL),(1326,616,'Cultural Destructiveness',NULL),(1327,616,'Cultural Blindness',1),(1328,616,'Cultural Pre-competence',NULL),(1329,617,'Acceptance of ethnic differences between people',NULL),(1330,617,'A willingness to work with clients of a different ethnic background',NULL),(1331,617,'Avoid jokes that offend',NULL),(1332,617,'Understand that diversity within cultures is as important as diversity between cultures.',NULL),(1333,617,'All of the above',1),(1334,618,'Practitioners are aware of their own values and biases',NULL),(1335,618,'Enables organizations and staff to work effectively in cross-cultural situations',NULL),(1336,618,'Builds trust in a relationship',NULL),(1337,618,'All of the above',1),(1338,572,'a. Abusing alcohol and/or other drugs',NULL),(1339,572,'b. A complex interplay of genetics, the environment, and other outside factors. ',1),(1340,572,'c. The environment',NULL),(1341,572,'d. Genetics',NULL),(1346,573,'Behaviors to prevent weight gain such as self-induced vomiting',NULL),(1347,573,'Frequent episodes of consuming very large amounts of food ',1),(1348,573,'Intense fear of weight gain',NULL),(1349,573,'All of the above',NULL),(1350,574,'Restricting food intake',NULL),(1351,574,'Frequent episodes of consuming very large amount of food followed by behaviors to prevent weight gain, such as self-induced vomiting.',1),(1352,574,'Extreme loss of weight',NULL),(1353,574,'All of the above',NULL),(1358,620,'Is our moral but not legal obligation',NULL),(1359,620,'Is our legal and moral obligation',1),(1360,620,'Is neither our legal nor moral obligation',NULL),(1361,620,'Is our legal but not moral obligation',NULL),(1362,620,'All of the above',NULL),(1363,621,'Keep functions separate based on location',NULL),(1364,621,'Understand your role as a counselor',NULL),(1365,621,'By having an honest conversation with the client about your relationship',NULL),(1366,621,'Stay wary of possible confidentiality breaches',NULL),(1367,621,'All of the above',1),(1368,622,'A counselor\'s beliefs',NULL),(1369,622,'A counselor\'s moral compass',NULL),(1370,622,'A counselor\'s experience',NULL),(1371,622,'A counselor\'s values',NULL),(1372,622,'A counselor\'s daily routine',1),(1373,623,'Basic requiring no knowledge of law and precedent',NULL),(1374,623,'Generally easy and apply to every client',NULL),(1375,623,'Nuanced making them often very difficult',1),(1376,623,'Cut and dried when following the law',NULL),(1377,623,'All of the above',NULL),(1378,624,'The counselor cannot make up their mind',NULL),(1379,624,'Counselors have more than one client',NULL),(1380,624,'Counselors have more than one relationship with the client',1),(1381,624,'The counselor is empathetic towards a client',NULL),(1382,624,'All of the above',NULL),(1383,625,'Are set by the client',NULL),(1384,625,'Don’t generally apply to counselors',NULL),(1385,625,'Were more important in the past',NULL),(1386,625,'Are an important part of counseling',1),(1387,625,'All of the above',NULL),(1388,626,'May require a counselor to sign an agreement to uphold certain standards.',NULL),(1389,626,'Are important',NULL),(1390,626,'Require counselor training, in most states',NULL),(1391,626,'Are generally self-regulated by the industry',NULL),(1392,626,'All of the above',1),(1393,627,'Are not worth understanding.',NULL),(1394,627,'Mean that a counselor must be able to make ethical decisions on the fly.',1),(1395,627,'Are unavoidable but largely irrelevant.',NULL),(1396,627,'Don\'t exist - there are standard responses to every problem.',NULL),(1397,627,'All of the above',NULL),(1398,628,'Confidentiality',1),(1399,628,'Issuance of a Certificate of Financial Responsibility',NULL),(1400,628,'Oral records only',NULL),(1401,628,'Current clients only',NULL),(1402,628,'All of the above',NULL),(1405,630,'Should be encouraged',NULL),(1406,630,'Can increase the risk of exploitation or misinterpretation',1),(1407,630,'Is rarely a problem',NULL),(1408,630,'Can keep the client-counselor relationship more interesting',NULL),(1409,630,'All of the above',NULL),(1410,631,'Is administered by the counselor with minimal client input.',NULL),(1411,631,'Not a part of professional ethics.',NULL),(1412,631,'Helpful in allowing the client to understand the direction of their treatment.',1),(1413,631,'Just about signing paperwork',NULL),(1414,631,'All of the above',NULL),(1415,632,'Should never be done',NULL),(1416,632,'Should be done with every client',NULL),(1417,632,'Should be done when counselor has strong belief client will benefit',1),(1418,632,'Should be done when the client asks a personal questions',NULL),(1419,632,'All of the above',NULL),(1430,635,'May make clinical mistakes',NULL),(1431,635,'May begin to burn out',NULL),(1432,635,'May exploit the client',NULL),(1433,635,'All of the above',1),(1434,636,'Counselor and hair stylist',NULL),(1435,636,'Counselor to your best friends brother',NULL),(1436,636,'Counselor and supervisor',NULL),(1437,636,'Counselor and 12-step sponsor',NULL),(1438,636,'All of the above',1),(1439,637,'Areas a professional counselor is interested in working in',NULL),(1440,637,'All areas of clinical practice',NULL),(1441,637,'Actions that a member of the profession is trained and authorized to perform',1),(1442,637,'Clinical practice in areas where the counselor can receive clinical supervision',NULL),(1443,637,'None of the above',NULL),(1444,638,'Clinical, moral, legal',NULL),(1445,638,'Legal, moral, ethical',1),(1446,638,'Ethical, moral, clinical',NULL),(1447,638,'Ethical, legal, clinical',NULL),(1448,638,'None of the above',NULL),(1449,639,'True',1),(1450,639,'False',NULL),(1451,640,'Submission to the conduct, either implicitly or explicitly, is made as a condition of term of employment.',NULL),(1452,640,'Unwelcome sexual behavior that is not directed at the employee personally, but is part of his or her work environment.',1),(1453,640,'Requests for sexual favors',NULL),(1454,641,'True',1),(1455,641,'False',NULL),(1456,642,'Get in their face to make sure they understand you point clearly.',NULL),(1457,642,'Use the \"buddy\" system anytime you think that your personal safety may be at stake Take Precautions - Defuse the Situation',NULL),(1458,642,'Report all threats to your supervisor',NULL),(1459,642,'B and C',1),(1460,642,'All of the above',NULL),(1467,645,'True',NULL),(1468,645,'False',1),(1469,644,'True',1),(1470,644,'False',NULL),(1471,646,'True',1),(1472,646,'False',NULL),(1473,647,'True',1),(1474,647,'False',NULL),(1475,648,'True',1),(1476,648,'False',NULL),(1477,649,'Self- disclosure',NULL),(1478,649,'Giving or receiving significant gifts',NULL),(1479,649,'Becoming friends',NULL),(1480,649,'Physical Contact',NULL),(1481,649,'All of the above',1),(1492,650,'An injury resulting from a fall',NULL),(1493,650,'A break in procedure',NULL),(1494,650,'Suicide attempt or gesture',NULL),(1495,650,'All of the above',1),(1496,651,'True',1),(1497,651,'False',NULL),(1498,652,'True',1),(1499,652,'False',NULL),(1500,653,'Risk Manager',NULL),(1501,653,'Any Employee',1),(1502,653,'Clinical Director',NULL),(1503,654,'Yes',NULL),(1504,654,'No',1),(1507,655,'True',1),(1508,655,'False',NULL),(1509,656,'True',1),(1510,656,'False',NULL),(1511,657,'True',1),(1512,657,'False',NULL),(1513,658,'Discussing client issues only in private areas',NULL),(1514,658,'Requiring written authorization before releasing information',NULL),(1515,658,'Not utilizing client last names in public areas or medical record file covers',NULL),(1516,658,'All of the above.',1),(1517,659,'Health Information Property Accountability Association',NULL),(1518,659,'Human Insurance Process Accumulation Act',NULL),(1519,659,'Health Insurance Portability and Accountability Act',1),(1520,660,'Security',NULL),(1521,660,'Privacy',1),(1522,660,'Confidentiality',NULL),(1523,661,'Electronic Medical Record ',NULL),(1524,661,'Security ',NULL),(1525,661,'HITECH',1),(1526,661,'HHS',NULL),(1527,662,'Medical record number',NULL),(1528,662,'Telephone number',NULL),(1529,662,'Fax number',NULL),(1530,662,'Social security number',NULL),(1531,662,'All of the above',1),(1532,662,'a, b, d',NULL),(1533,663,'Disciplinary action',NULL),(1534,663,'Loss of access privileges',NULL),(1535,663,'Fines and penalties',NULL),(1536,663,'Imprisonment',NULL),(1537,663,'All of the above',1),(1538,664,'Yes',NULL),(1539,664,'No',1),(1540,665,'Yes, if he is an employee and you know him.',NULL),(1541,665,'Yes, if your manager says that it’s okay.',NULL),(1542,665,'No, sharing log-in IDs and passwords is a security violation.',1),(1543,665,'a and b',NULL),(1544,666,'I am only expected to complete the minimum requirements of my job.',NULL),(1545,666,' A workforce member\'s access to PHI is limited to only what is needed to perform his/her responsibilities.',NULL),(1546,666,'Requests for and disclosures of PHI are limited to what is needed to perform the task.',NULL),(1547,666,'A medical center is no longer allowed to provide information about patients to the media under any circumstances.',NULL),(1548,666,'b and c',1),(1549,667,'Yes.  They can be used interchangeably.',NULL),(1550,667,'No.  Consents are used to get the patient\'s permission to use or disclose health information for     treatment, payment or business operations. Authorizations are used to obtain permission to disclose PHI for activities outside the realm of treatment, payment or business operations.',1),(1551,668,'True',1),(1552,668,'False',NULL),(1553,669,'True',1),(1554,669,'False',NULL),(1555,670,'True',1),(1556,670,'False',NULL),(1557,671,'True',NULL),(1558,671,'False',1),(1561,673,'True',1),(1562,673,'False',NULL),(1563,674,'Management of Safe Devices and Systems.',NULL),(1564,674,'Maintenance and Storage of Devices and Systems.',NULL),(1565,674,'Material Safety Data Sheets.',1),(1566,674,'Management, Storage and Distribution of Substances.',NULL),(1567,675,'Tornado',NULL),(1568,675,'Medical',NULL),(1569,675,'Bomb',1),(1570,675,'Patient Emergency',NULL),(1571,676,'Code Hot',NULL),(1572,676,'Code Red',1),(1573,676,'Code Fire',NULL),(1574,677,'Code Yellow',NULL),(1575,677,'Code Grey',1),(1576,677,'Code Purple',NULL),(1577,677,'Code Pink',NULL),(1582,679,'Read, Act, Collect, Evacuate',NULL),(1583,679,'Read, Ask, Confine, Extinguish',NULL),(1584,679,'Rescue/Remove from danger, Alert/Alarm, Confine/Contain, Extinguish/Evacuate',1),(1585,680,'True',1),(1586,680,'False',NULL),(1591,682,'During a Fire Marshall\'s inspection.',NULL),(1592,682,'During a Code Blue.',NULL),(1593,682,'During times of renovation or construction if fire safety is significantly compromised.',1),(1594,683,'True',1),(1595,683,'False',NULL),(1596,684,'True',1),(1597,684,'False',NULL),(1598,685,'True',1),(1599,685,'False',NULL),(1608,688,'Outside lighting',NULL),(1609,688,'Alarm system',NULL),(1610,688,'Employee picture ID badges',NULL),(1611,688,'All of the above.',1),(1612,689,'True',1),(1613,689,'False',NULL),(1614,690,'True',NULL),(1615,690,'False',1),(1616,691,'Gloves',1),(1617,691,'Mask Goggles',NULL),(1618,691,'Gowns',NULL),(1619,691,'All of the above.',NULL),(1620,692,'Call your supervisor.',NULL),(1621,692,'Call 911',NULL),(1622,692,'Put on gloves, wipe up spill (utilize Spill Kit) then disinfect with an EPA           registered disinfectant and/or a 1:10 sodium hypochlorite (bleach) solution.       ',1),(1623,693,'True',1),(1624,693,'False',NULL),(1625,694,'True',1),(1626,694,'False',NULL),(1627,695,'True',1),(1628,695,'False',NULL),(1629,696,'True',1),(1630,696,'False',NULL),(1631,697,'True',NULL),(1632,697,'False',1),(1633,698,'True',NULL),(1634,698,'False',1),(1637,700,'True',1),(1638,700,'False',NULL),(1639,701,'True',1),(1640,701,'False',NULL),(1647,26,'True',1),(1648,26,'False',NULL),(1649,48,'a) Sudden shift in mood or behavior',NULL),(1650,48,'b) Skin rash',NULL),(1651,48,'c) Muscle weakness',NULL),(1652,48,'d) Confusion',NULL),(1653,48,'a, c, and d ',1),(1659,88,'a) Airborne',NULL),(1660,88,'b) Droplet',NULL),(1661,88,'c) Contact',1),(1662,88,'A and B',NULL),(1668,79,'a) Viruses',NULL),(1669,79,'b) Parasites',NULL),(1670,79,'c) Bacteria',NULL),(1671,79,'d) Fungus',NULL),(1672,79,'All of the above',1),(1673,75,'a) Wear protective gloves',NULL),(1674,75,'b) Run away from spill in order to not get contaminated ',NULL),(1675,75,'c) Use a 1:100 or 1:10 bleach based dilution to decontaminate surfaces ',NULL),(1676,75,'d) A and B',NULL),(1677,75,'e) A and C',1),(1678,80,'a) Air',NULL),(1679,80,'b) Water',NULL),(1680,80,'c) Bodily fluids',NULL),(1681,80,'d) A and B',1),(1682,80,'e) A and C',NULL),(1683,74,'a) Gloves, gowns, respirators',NULL),(1684,74,'b) Face masks, goggles, face shields',NULL),(1685,74,'c) Shoes and socks',NULL),(1686,74,'d) A and B',1),(1687,74,'e) A and C',NULL),(1688,599,'True',NULL),(1689,599,'False',1),(1694,619,'Losing your job',NULL),(1695,619,'Prison time',NULL),(1696,619,'Legal issues',NULL),(1697,619,'All of the above',1),(1698,629,'True',NULL),(1699,629,'False',1),(1700,601,'Only A',NULL),(1701,601,'Only A and B',NULL),(1702,601,'Only B',NULL),(1703,601,'A, B and C',1),(1708,681,'Type A extinguisher',NULL),(1709,681,'Type A and B extinguisher',NULL),(1710,681,'Type B extinguisher',NULL),(1711,681,'Type A, B and C extinguisher',1),(1712,678,'True',NULL),(1713,678,'False',1),(1714,615,'a) Native Americans',NULL),(1715,615,'b) Asian',NULL),(1716,615,'c) Indian',NULL),(1717,615,'A and B',1),(1718,672,'True',1),(1719,672,'False',NULL),(1720,686,'Code Red',NULL),(1721,686,'Code Purple',NULL),(1722,686,'Code White',1),(1723,686,'Code Green',NULL),(1724,699,'Casual contact or contact with toilet seats, doorknobs, etc.',NULL),(1725,699,'Exposure to blood/body fluids by percutaneous exposure (needlesticks) and/or mucous membrane (mouth or eye) exposures.',1),(1726,687,'Ben Brafman',NULL),(1727,687,'Harvey Glotzer',NULL),(1728,687,'Andrew Merker',1),(1729,687,'Scott Smith',NULL),(1730,643,'True',1),(1731,643,'False',NULL),(1737,702,'Physical relapse',NULL),(1738,702,'Emotional relapse',NULL),(1739,702,'Mental relapse',NULL),(1740,702,'A & B',NULL),(1741,702,'All of the above',1),(1742,704,'Lying',NULL),(1743,704,'Fantasizing about using',NULL),(1744,704,'Mood swings',1),(1745,704,'Hanging out with old using friends',NULL),(1750,706,'Preparation',NULL),(1751,706,'Action',NULL),(1752,706,'Maintenance',1),(1753,706,'Contemplation',NULL),(1754,707,'True',NULL),(1755,707,'False',1),(1756,707,'Maintenance',NULL),(1757,708,'True',1),(1758,708,'False',NULL),(1759,708,'Maintenance',NULL),(1760,709,'Involvement of parents in their children’s lives',NULL),(1761,709,'Clear rules of conduct are consistently enforced within the family',NULL),(1762,709,'Strong and positive family bonds',NULL),(1763,709,'All of the above',1),(1766,710,'True',NULL),(1767,710,'False',1),(1768,711,'Parental monitoring of children’s activities and peers',NULL),(1769,711,'Home environments where parents abuse substances or suffer mental illness',NULL),(1770,711,'Poor social coping skills',NULL),(1771,711,'Failure in school performance',NULL),(1772,711,'A & C',NULL),(1773,711,'B, C, & D',1),(1774,705,'Precontemplation',NULL),(1775,705,'Comtemplation',1),(1776,705,'Preparation',NULL),(1777,705,'Action',NULL),(1778,712,'Precontemplation',NULL),(1779,712,'Comtemplation',NULL),(1780,712,'Preparation',1),(1781,712,'Action',NULL),(1782,633,'A client placing feelings about others from their lives onto the counselor',NULL),(1783,633,'A client focusing on their feelings for the counselor',NULL),(1784,633,'A client transferring their feelings with the feelings of the counselor',NULL),(1785,633,'A client falling in love with the counselor',NULL),(1786,633,'All of the above',1),(1787,634,'A counselor sharing their personal feelings with their client',NULL),(1788,634,'A counselor experiencing an emotional connection beyond what is acceptable in the client-counselor relationship.',1),(1789,634,'A client focusing on their feelings for the counselor',NULL),(1790,634,'A counselor having a dual relationship with their client',NULL),(1791,634,'A client placing feelings about others from their lives onto the counselor',NULL),(1796,123,'Any area of the Incident Report Form not requiring a response specific to the incident must be marked as “N/A” (Not applicable).',NULL),(1797,123,'Incident Report Forms are always included in the client’s medical records on file. ',1),(1798,123,'All staff members of a service provider are required to document all unusual events that occur to either a patient and/or staff member on an Incident Report Form ',NULL),(1799,123,'Incident Report Forms are confidential reports ',NULL),(1800,137,'Unauthorized taking of personal assets',NULL),(1801,137,'Sale of the vulnerable adults home without their authorization',NULL),(1802,137,'Caregiver failing to provide appropriate food to vulnerable adult',NULL),(1803,137,'A and B',1),(1804,137,'B and C',NULL),(1805,713,'Antipsychotics',NULL),(1806,713,'Antidepressents',NULL),(1807,713,'Anxiolytics',NULL),(1808,713,'Mood stabilizers',NULL),(1809,713,'Acid nuetralizers',NULL),(1810,713,'A, B, C, D',1),(1811,714,'Drowsiness',NULL),(1812,714,'Blurred vision',NULL),(1813,714,'Rapid heartbeat',NULL),(1814,714,'skin rashes',NULL),(1815,714,'sensitivity to the sun',NULL),(1816,714,'Increased hunger',1),(1819,716,'MSG',NULL),(1820,716,'Sugar',NULL),(1821,716,'Tyramine',1),(1822,716,'Sodium sulphite',NULL),(1823,716,'Potassium Bromate',NULL),(1828,717,'True',1),(1829,717,'False',NULL),(1830,718,'Serax',NULL),(1831,718,'Tranxene',NULL),(1832,718,'Asendin',NULL),(1833,718,'Lithium',1),(1834,719,'Right client',NULL),(1835,719,'Right medication',NULL),(1836,719,'Right look',1),(1837,719,'Right dosage',NULL),(1838,719,'Right time',NULL),(1839,719,'Right route',NULL),(1840,720,'Contact nursing',NULL),(1841,720,'Contact Supervisor',NULL),(1842,720,'Fill ouit incident report',NULL),(1843,720,'Call 911',NULL),(1844,720,'A, B and C',1),(1845,721,'Verify the clients picture in Kipu',NULL),(1846,721,'Verify date of birth verbally from client',NULL),(1847,721,'Check under tongue of client',NULL),(1848,721,'A, and B',1),(1849,722,'Clients bill of rights',NULL),(1850,722,'Intake sheet',NULL),(1851,722,'The client doctrine of medication observation',NULL),(1852,722,'MOR sheet',1),(1853,723,'Verify dosage against MOR in Kipu.',NULL),(1854,723,'Staff and client initials in Kipu after observation.',NULL),(1855,723,'Staff member asks the client to repeat the words, alligator alley.',NULL),(1856,723,'Staff member takes out correct dosage and hands to client.',1),(1857,724,'Late night sales clerk',NULL),(1858,724,'Emergency room nurse',NULL),(1859,724,'Family doctor',1),(1860,724,'Taxi cab driver',NULL),(1865,726,'Being absent in office meetings',NULL),(1866,726,'Leaving work early',NULL),(1867,726,'Complaining about the boss',NULL),(1868,726,'Swearing at other employees',1),(1869,727,'Do not lead to violence, so no caution is required',NULL),(1870,727,'Do not lead to violence, but still require some caution',NULL),(1871,727,'Lead to violence but require minimal caution',NULL),(1872,727,'Lead to violence and require strong caution',1),(1873,728,'Administrative control',NULL),(1874,728,'Behavioral control',NULL),(1875,728,'Environmental control',1),(1876,728,'Personal protective control',NULL),(1877,729,'True',NULL),(1878,729,'False',1),(1879,730,'Report the incident immediately',1),(1880,730,'Let it pass since they dont really mean it',NULL),(1881,730,'Tell this person to back off',NULL),(1882,730,'Respond back with a threat of your own',NULL),(1883,731,'Confusion',NULL),(1884,731,'Frustration',NULL),(1885,731,'Blame',NULL),(1886,731,'Hostility',1),(1887,732,'Ignore it',NULL),(1888,732,'Politely guide the customer out of the establishment',NULL),(1889,732,'Signal a co-employee to call security',1),(1890,732,'Fight backwith a threat',NULL),(1891,733,'Inform security to keep an eye out for the person',1),(1892,733,'Fearfully keep it a secret',NULL),(1893,733,'Use the side entrance instead of the main door to avoid being seen',NULL),(1894,733,'Find a different place to hang out to avoid the person',NULL),(1895,734,'Panic! Grab all of your belongings and run towards the door',NULL),(1896,734,'Hide and keep away from the shooters view',1),(1897,734,'Pretend you have a weapon and are prepared to use it',NULL),(1898,734,'Yell at them that \"Large Marge sent ya\"',NULL),(1899,735,'Ben Brafman',NULL),(1900,735,'Andrew Merker',NULL),(1901,735,'Harvey Glotzer',NULL),(1902,735,'Scott Smith',1);

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text NOT NULL,
  `course_id` int(11) NOT NULL,
  `correct_answer_id` int(11) DEFAULT NULL,
  `course_order` int(11) DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=736 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `question`
--

INSERT INTO `question` VALUES (6,'According to CDC estimates, what proportion of people in the United States who are infected with HIV are unaware of their infection?',1,5,NULL,NULL),(7,'Americans have become complacent about HIV/AIDS because:',1,8,NULL,NULL),(8,'The 2010 National AIDS Strategy has three overarching goals, one of which is:',1,12,NULL,NULL),(9,'The Florida population hardest hit by HIV/AIDS is:',1,18,NULL,NULL),(10,'Which risk groups account for 75 percent of new HIV/AIDS infections?',1,22,NULL,NULL),(11,'Higher than average rates of AIDS and other STDs among correctional populations could be reduced by following the World Health Organization recommendation to:',1,24,NULL,NULL),(12,'Florida state law requires HIV testing of inmates:',1,28,NULL,NULL),(13,'Health professionals may fail to recognize the signs of HIV/AIDS infection in seniors because:',1,32,NULL,NULL),(14,'Which body fluids have been proven to transmit HIV infection?',1,36,NULL,NULL),(15,'Which of the following would most likely transmit an HIV infection?',1,40,NULL,NULL),(16,'Coinfection with STDs such as syphilis, gonorrhea, and genital warts:',1,44,NULL,NULL),(17,'The most common and most deadly coinfection for HIV-positive individuals is:',1,48,NULL,NULL),(18,'Treatment of HIV/TB coinfected patients is:',1,52,NULL,NULL),(19,'Respiratory protection equipment for healthcare workers is:',1,56,NULL,NULL),(20,'One of the leading causes of death among HIV-infected people is:',1,60,NULL,NULL),(26,' More than 1 million people in the U.S. are living with HIV. ',3,1647,NULL,NULL),(27,'AIDS and HIV are the same',3,465,NULL,NULL),(28,'You can’t always tell by appearance if someone has HIV. ',3,467,NULL,NULL),(29,'Medications can cure HIV/AIDS.',3,469,NULL,NULL),(30,'All 50 states have people living with AIDS.',3,471,NULL,NULL),(31,'HIV is transmitted through casual contact such as sharing utensils. ',3,474,NULL,NULL),(32,'Abstinence is the only 100% effective method of not acquiring HIV/AIDS               ',3,475,NULL,NULL),(33,'Health care workers should assume that the blood and other body fluids               from all patients are potentially infectious.    \r\n               ',3,477,NULL,NULL),(34,'The results of HIV antibody tests are confidential and may not be publicly disclosed except with the resident’s written permission or as otherwise provided in Chapter 384, Florida Statues.\r\n',3,479,NULL,NULL),(35,'Way to protect yourself from HIV/AIDS include: \r\n',3,485,NULL,NULL),(36,'According to CDC estimates, what proportions of people in the United States who are infected with HIV are unaware of their infection?\r\n',3,1206,NULL,NULL),(37,'The Florida population hardest hit by HIV/AIDS is:',3,490,NULL,NULL),(38,'Which risk groups account for 75 percent of new HIV/AIDS infections?',3,500,NULL,NULL),(39,'Which body fluids have been proven to transmit HIV infection?',3,508,NULL,NULL),(40,'Which of the following would most likely transmit an HIV infection?',3,511,NULL,NULL),(41,'Under Florida law, parents of a child under 18:',3,515,NULL,NULL),(42,'Florida law mandates that all pregnant women:',3,533,NULL,NULL),(47,'A provider may test without consent in which of the following:',3,521,NULL,NULL),(48,'Symptoms of AIDS Dementia Complex (ADC) include:',3,1653,NULL,NULL),(49,'Need to know is outlined in section 64D-.003 F.A.C. and includes but is not limited to:',3,532,NULL,NULL),(53,'Staring a client down is a sign of being in charge and can help calm an aggressive person.',4,296,NULL,NULL),(54,'The amount of space required to allow someone to feel comfortable can depend on gender, mood, familiarity, or culture. ',4,449,NULL,NULL),(55,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation.',4,300,NULL,NULL),(57,'To paraphrase means?',4,452,NULL,NULL),(58,'Active listening involves:',4,414,NULL,NULL),(59,'How should staff act when faced with an aggressive person?',4,419,NULL,NULL),(60,'Assertive Communication is based on balance and mutual respect.',4,325,NULL,NULL),(61,'What can you do when you detect a language barrier between you and a client?',4,425,NULL,NULL),(62,'Power struggles are an example of a communication barrier.',4,327,NULL,NULL),(63,'What 4 stages of crisis management were discussed and listed in the correct occurrence?',4,331,NULL,NULL),(64,'You should avoid power struggles by offering a person choices.',4,333,NULL,NULL),(65,'During which stage of crisis management would the client challenge you, push buttons and not respond to your words?',4,458,NULL,NULL),(67,'The transmission of infectious agents requires?',5,540,NULL,NULL),(68,'What is true about infection prevention and control?',5,544,NULL,NULL),(69,'Which statement is NOT true about Droplet transmission?',5,546,NULL,NULL),(70,'Which of the following is NOT an example of a Bloodborne Pathogen?',5,551,NULL,NULL),(71,'When does Vector-borne transmission occur?',5,553,NULL,NULL),(72,'To protect yourself from airborne diseases, you should?',5,557,NULL,NULL),(73,' Bloodborne pathogens can be spread through',5,565,NULL,NULL),(74,'What is considered Personal Protective Equipment?',5,1686,NULL,NULL),(75,'When cleaning a spill:',5,1677,NULL,NULL),(78,'How long should you wash your hands for with soap and water?',5,582,NULL,NULL),(79,'Infectious diseases are caused by',5,1672,NULL,NULL),(80,'Infectious diseases are transmitted most quickly through:',5,1681,NULL,NULL),(81,'What is the body fluid NOT considered infectious?',5,576,NULL,NULL),(82,'Which of the following are signs of aggression?',4,343,NULL,NULL),(83,'What is/are possible risk factors to aggression?',4,347,NULL,NULL),(85,'Verbal de-escalation is the communication skills we use during a potentially dangerous, or threatening, situation in an attempt to prevent a person from causing harm to us, themselves or others. ',4,459,NULL,NULL),(88,'The most frequent mode of infection transmission in the healthcare setting is',5,1661,NULL,NULL),(89,'Precautions recommended by CDC for the care of all patients is known as:',5,600,NULL,NULL),(90,'A counselor and client can enter into a personal relationship after five years has elapsed.',6,603,NULL,NULL),(91,'What is a “Dual Relationship”?',6,604,NULL,NULL),(92,'Explain the purpose of HIPAA guidelines.',6,610,NULL,NULL),(93,'What does the acronym HIPAA stand for?',6,613,NULL,NULL),(94,'Counselors who are physically attracted to clients are only trying to fulfill an unmet need in their personal life.',6,617,NULL,NULL),(95,'What is the Right of Habeas Corpus?',6,619,NULL,NULL),(96,'Give two reason why maintaining proper boundaries is the responsibility of the staff.',6,626,NULL,NULL),(97,'Anger is a choice in a range of available behaviors',6,628,NULL,NULL),(98,'Your client owns a mechanic shop and offers to repair your car for free out of appreciation for your help.  This is an example of what type of relationship?',6,632,NULL,NULL),(99,'Give two instances when client confidential information can be disclosed without their consent.',6,639,NULL,NULL),(100,'Name 2 signs of Aggression',6,644,NULL,NULL),(101,'Staring a client down is a sign of being in charge and can help to calm an aggressive person',6,647,NULL,NULL),(102,'Name 2 Risk Factors to Aggression',6,648,NULL,NULL),(103,'Which of the following can inhibit communication?',6,655,NULL,NULL),(104,'How does DSMIV-TR characterize bipolar disorder?',6,659,NULL,NULL),(105,'Apologizing to an angry client simply validates their anger and perpetuates a stressful situation',6,661,NULL,NULL),(106,'Stage 3 of susbtance dependence is',6,663,NULL,NULL),(107,'Copying confidential information is:',6,668,NULL,NULL),(108,'Behavioral Healthcare facilities are able, by law to bill insurance companies without actual written consent from client',6,671,NULL,NULL),(109,'With written permission behavioral healthcare facilities can share information with parents and spouses',6,682,NULL,NULL),(110,'After a client has been discharged from treatment for five years it is no longer necessary to have written permission to discuss information',6,675,NULL,NULL),(111,'Oral information is not protected by HIPAA guidelines',6,677,NULL,NULL),(112,'There is a fine for healthcare facilities that violate HIPAA guidelines',6,678,NULL,NULL),(113,'It is permissible to discuss specifics of cases in 12 step meetings because the meetings are confidential',6,681,NULL,NULL),(114,'Why is infection control important?',6,685,NULL,NULL),(115,'What illnesses are spread through contact? ',6,688,NULL,NULL),(116,'The Florida Statute (FS) requiring a licensed public or private substance abuse service provider to create an internal quality improvement program is:',8,694,NULL,NULL),(117,'Incident Reporting is the affirmative duty of',8,699,NULL,NULL),(118,'According to Chapter 65D-30 of the Florida Administrative Code, Incident Reporting must include:',8,704,NULL,NULL),(119,'The staff member most immediately involved in and/or observing an unusual incident is required to complete an Incident Report Form.  ',8,707,NULL,NULL),(120,'If two staff members are involved in or witness an unusual event the staff members are required to',8,711,NULL,NULL),(121,'If a staff member is uncertain as to whether an event should be documented and reported, an Incident Report Form should NOT be completed.',8,714,NULL,NULL),(122,'If more than one client is involved in an unusual event staff must ',8,716,NULL,NULL),(123,'Which of the following statements is NOT true of Incident Reporting ',8,1797,NULL,NULL),(124,'When entering narrative documentation on an Incident Report Form staff MUST ',8,725,NULL,NULL),(125,'In accordance with The Children and Families Operating Procedure 215-6 Department licensed providers MUST',8,729,NULL,NULL),(126,'DCF has created an online reporting system called:',8,734,NULL,NULL),(127,'Providers who must report critical incidents through IRAS include:',8,738,NULL,NULL),(128,'The entry of the critical incident into IRAS DOES NOT substitute for a direct phone call to the Department’s leadership staff when the incident type or severity of the incident warrants such contact.',8,740,NULL,NULL),(129,'The Joint Commission adopted a formal Sentinel Event Policy to assist healthcare providers ',8,744,NULL,NULL),(130,'It is mandatory for all substance abuse providers  have to report sentinel events to The Joint Commission',8,747,NULL,NULL),(131,'If you reasonably suspect child abuse you are required:',9,750,NULL,NULL),(132,'If a child is deprived of clothing, shelter, or medical services it is called:',9,755,NULL,NULL),(133,'Who is considered a professional mandatory reporter?',9,872,NULL,NULL),(134,'What is the reason that victims may not report their abusers?',9,763,NULL,NULL),(135,'A False Report is a report of abuse, neglect, or abandonment of a child to the central abuse hotline, in which the report is made maliciously.',9,764,NULL,NULL),(136,'A person who is required to report, and who knowingly and willfully fails to do so, or who knowingly and willfully prevents another person from doing so, is guilty of a misdemeanor of the first degree.',9,827,NULL,NULL),(137,'What is considered exploitation of a vulnerable adult?',9,1803,NULL,NULL),(138,'Any willful act or threatened act by a relative, caregiver, or household member which causes or is likely to cause significant impairment to a vulnerable adult’s physical, mental, or emotional health is called',9,829,NULL,NULL),(139,'Providers shall adhere to the statutory requirements for reporting abuse, neglect, and deaths of children under:',9,779,NULL,NULL),(140,'The Abuse Hotline Phone Number is:',9,782,NULL,NULL),(141,'According to EEOC in order for behavior to be considered sexual harassment it must be ',10,786,NULL,NULL),(142,'A co-worker or supervisor can create a hostile work environment when they engage in one or more of the following behaviors:',10,792,NULL,NULL),(143,'The Quid Pro Quo theory of sexual harassment involves:',10,793,NULL,NULL),(144,'IF you feel you are the victim of unwelcome sexual behavior you are encouraged to:',10,801,NULL,NULL),(145,'It is illegal for an employer or other employees to retaliate against any individual who:',10,805,NULL,NULL),(146,'Sexual Harassment in employment is legally recognized as a form of sex discrimination and is illegal.',10,865,NULL,NULL),(147,'Sexual harassment can occur outside the work site and still be considered work related.',10,867,NULL,NULL),(148,'Quid Pro Quo harassment is a form of sexual harassment when there is a request or demand of sexual favors in exchange for employment benefits or threatening reprisals if the favors are not given.',10,810,NULL,NULL),(149,'Friendly flirting is not sexual harassment when flirting is practiced between mutually consenting individuals who are equal in power or authority.',10,812,NULL,NULL),(150,'An employee witnesses another employee being harassed. Even though this involved a co-worker, the witness can be considered a victim in this case.',10,814,NULL,NULL),(151,'In order for it to be determined sexual harassment, the victim has to be of the opposite sex of the harasser.',10,817,NULL,NULL),(152,'It is solely the company’s responsibility to prevent sexual harassment',10,819,NULL,NULL),(154,'Adella wants Antonio to feel part of the team and tries to encourage his participation. She approaches him more frequently than the other workers and she is constantly touching his shoulder and arm. Antonio feels uncomfortable with Adella invading his personal space and grimaces as she touches his shoulders. His facial and body expressions clearly indicate his annoyance. Could this be considered sexual harassment?”',10,820,NULL,NULL),(155,'Karen Linda and Elis have become good friends and sit together at lunch. They decided to have some fun by rating the men in the lunchroom. Joking, they rate the men who walk into the lunchroom and discuss the ratings with each other. Ted, a male therapist, who is sitting at a nearby table overhears their remarks. He finds the behavior offensive and unprofessional. Ted reports the incident to HR when he returns from lunch. Was the women’s behavior sexual harassment?',10,823,NULL,NULL),(156,'Susan, the director of marketing, has several employees reporting to her. One of the employees, John, has been called into her office right before lunch. Susan requests that John have lunch with her to discuss one of the major accounts that he is trying to acquire. John agrees to the lunch and realizes that this is a good opportunity to explain some of the problems he has encountered. While John and Susan are out at lunch she puts her hand on his leg and says she wants him to do well in the company and would like him to come over to her place tonight. Is this considered sexual harassment?',10,824,NULL,NULL),(157,'Who must comply with the ADA?',11,836,NULL,NULL),(158,'According to the ADA, a person with a disability has:',11,839,NULL,NULL),(159,'What is a condition not covered by the ADA?',11,845,NULL,NULL),(160,'Under the ADA, an employer is required to make a reasonable accommodation to the known disability of a qualified applicant or employee if it does not impose “undue hardship”?',11,846,NULL,NULL),(161,'What is an example of a “reasonable accommodation”?',11,851,NULL,NULL),(162,'Under Title V, ADA prohibits coercion and retaliation to anyone who has assisted, encouraged or made a charge under the Act.',11,852,NULL,NULL),(163,'The ADA requires that organizations hire the disabled.',11,855,NULL,NULL),(164,'If an employer believes that a medical condition is causing a performance or conduct problem, it may ask the employee how to solve the problem.',11,856,NULL,NULL),(165,'According to the ADA, all people with disabilities (or even all people with the same disability) will require the same accommodation.',11,859,NULL,NULL),(166,'According to the ADA, “major life activities” include',11,864,NULL,NULL),(169,'xsXZ',21,876,NULL,NULL),(170,'Domestic Violence is best conceptualized as:',23,1037,NULL,NULL),(171,'The four main types of Domestic Violence are:',23,1043,NULL,NULL),(172,'Risk factors for Domestic Violence victimization include all the following EXCEPT:',23,1046,NULL,NULL),(173,'What combination contributes to the risk of becoming a victim or a perpetrator of Domestic Violence?',23,1050,NULL,NULL),(174,'Children from violent homes may demonstrate:',23,1055,NULL,NULL),(175,'Patterns of controlling behavior can include:',23,1060,NULL,NULL),(176,'Signs of a potential abuser in a dating relationship include all of the following EXCEPT',23,1063,NULL,NULL),(177,'Which of the following are characteristics of a potential abuser:',23,1065,NULL,NULL),(178,'To gain power and control an abuser may:',23,1072,NULL,NULL),(179,'Tension building and making up are:',23,1074,NULL,NULL),(180,'In dealing with Domestic Violence the most important phone numbers are:',23,1080,NULL,NULL),(181,'The rate of Domestic Violence detection among behavioral health practitioners and healthcare workers is:',23,1081,NULL,NULL),(182,'Missed cases of Domestic Violence may be due to all of the following EXCEPT:',23,1086,NULL,NULL),(183,'Healthcare workers can help in detecting Domestic Violence by:',23,1089,NULL,NULL),(184,'Mental health staff can become effective advocates by:',23,1094,NULL,NULL),(185,'Advocating for Domestic Violence victims includes all of the following EXCEPT:',23,1098,NULL,NULL),(186,'In Florida, the Domestic Violence Hotline Number is:',23,1102,NULL,NULL),(187,'Safety plans cover: ',23,1108,NULL,NULL),(188,'Florida state reporting laws require:',23,1109,NULL,NULL),(189,'If a patient does not disclose Domestic Violence to a behavioral healthcare worker, the worker should document:',23,1115,NULL,NULL),(566,'What does co-occurring disorder mean?',24,1161,NULL,NULL),(567,'What mental conditions are more likely to abuse substances?',24,1166,NULL,NULL),(568,'Which of the following statements are False?',24,1171,NULL,NULL),(569,'What describes the term Denial?',24,1176,NULL,NULL),(570,'What are signs and symptoms of anxiety disorders?',24,1180,NULL,NULL),(571,'SAMSHA recommends the following treatment model for co-occurring disorders:',24,1183,NULL,NULL),(572,'Mental disorders are caused by:',24,1339,NULL,NULL),(573,'A common sign of binge eating disorder is:',24,1347,NULL,NULL),(574,'A common sign of bulimia nervosa is',24,1351,NULL,NULL),(575,'Hand-washing until your skin becomes raw is a sign of which of the following disorders:',24,1191,NULL,NULL),(576,'Hyperactivity is a symptom of which of the following disorders:',24,1195,NULL,NULL),(577,'Some people develop mental health issues after excessive drinking or drug use.',24,1197,NULL,NULL),(578,'A mental disorder can complicate the challenge in overcoming an addiction to drugs or alcohol.',24,1199,NULL,NULL),(579,'About 50% of people with severe mental disorders are affected by substance abuse.',24,1201,NULL,NULL),(580,'People with a mental health illness are more likely to experience an alcohol or substance use disorder than those not affected by a mental illness.',24,1203,NULL,NULL),(581,'Confidentiality is protected in the following manners',7,1212,NULL,NULL),(582,'What does HIPAA stand for?',7,1215,NULL,NULL),(583,'_________________ is the right of an individual to keep his/her individual health information from being disclosed.',7,1217,NULL,NULL),(584,'The __________ Act widens the scope of privacy and security protections under HIPAA for electronic protected health information (ePHI).',7,1221,NULL,NULL),(585,'What is an example/examples of PHI (Protected Health Information?',7,1227,NULL,NULL),(586,'What can happen to a person who knowingly violates patient privacy for personal gain or malicious harm?',7,1233,NULL,NULL),(587,'Are members of your organization who are not involved in a patient\'s care allowed to review the patient\'s chart out of curiosity?',7,1235,NULL,NULL),(588,'If someone forgets his log-in ID, can I let him use mine?',7,1238,NULL,NULL),(589,'What does \"minimum necessary\" mean?',7,1241,NULL,NULL),(590,'Are Consents and Authorizations the same?',7,1245,NULL,NULL),(591,'The organization\'s leadership has adopted a \'non-punitive\' approach to error reporting.',25,1246,NULL,NULL),(592,'All employees are required to report suspected and identified medical/health care errors.',25,1248,NULL,NULL),(593,'If you are injured or have an accident at work it is not necessary to inform your supervisor.',25,1251,NULL,NULL),(594,'MSDS is an abbreviation for which of the following?',25,1254,NULL,NULL),(595,'The safety code for a medical emergency is Code Blue.',25,1256,NULL,NULL),(596,'What type of an emergency is designated as a Code Green?',25,1260,NULL,NULL),(597,'The code if there is a fire is:',25,1263,NULL,NULL),(598,'The safety code indicating a staff member is in trouble is:',25,1267,NULL,NULL),(599,'Chemicals may be stored under the sink.',25,1689,NULL,NULL),(600,'During a fire emergency the acronym RACE stands for:',25,1276,NULL,NULL),(601,'Which TYPE of EXTINGUISHER is designed for extinguishing paper, flammable liquid and elec. fires?',25,1703,NULL,NULL),(602,'Following an evacuation, a role call is taken at the designated “safe area” to ensure everyone has been safely evacuated.',25,1281,NULL,NULL),(603,'There are two types of disasters - natural and technological/man made.',25,1283,NULL,NULL),(604,'During a tornado procedure everyone would go to a designated safe area within the building that is furthest away from windows and glass doors.',25,1285,NULL,NULL),(605,'If the safety officer feels the facility is in the path of a tornado he/she will call a:',25,1293,NULL,NULL),(607,'The following security measures are in place:',25,1302,NULL,NULL),(608,'The Security Management Plan identifies one of the \'high-risk\' areas the Medication Rooms.',25,1303,NULL,NULL),(609,' When you leave your workstation, DO NOT log off your workstation',25,1306,NULL,NULL),(610,'What is culture?  ',16,1310,NULL,NULL),(611,'Personal comfortable space/territorial space is usually the same for people with different cultural backgrounds.',16,1312,NULL,NULL),(612,'Pointing in Asian and Native American cultures represents a strong threat.',16,1313,NULL,NULL),(613,'Which statement is NOT true?',16,1316,NULL,NULL),(614,'Cultural Competency is the ability to incorporate one’s knowledge, skills, and expertise regarding an individual’s culture into the interactions one has with individuals and groups of differing cultures.',16,1319,NULL,NULL),(615,'In what culture would an individual consider direct eye contact to be rude?',16,1717,NULL,NULL),(616,'What word fits this definition?  Under this paradigm, culture and people are basically all alike, and what works with one culture therefore works well with another.',16,1327,NULL,NULL),(617,' Which of the following are personal attributes that indicate the development of cultural competency?',16,1333,NULL,NULL),(618,'Cultural Competency impacts the provision of services in the following manners:',16,1337,NULL,NULL),(619,'What are the ramifications for breaching confidentiality?',13,1697,NULL,NULL),(620,'Adhering to confidentiality',13,1359,NULL,NULL),(621,'Some dual roles are unavoidable. How do you deal with them?',13,1367,NULL,NULL),(622,'Which of the following is not generally a basis of decision making?',13,1372,NULL,NULL),(623,'Ethical decisions in treatment are:',13,1375,NULL,NULL),(624,'Dual relationships occur when',13,1380,NULL,NULL),(625,'Boundaries',13,1386,NULL,NULL),(626,'Professional Ethics:',13,1392,NULL,NULL),(627,'Ethical Nuances',13,1394,NULL,NULL),(628,'42 CFR applies to:',13,1398,NULL,NULL),(629,'Both HIPAA and 42 CFR are concerned with client confidentiality as it relates to substance use disorder exclusively',13,1699,NULL,NULL),(630,'Blurring boundaries',13,1406,NULL,NULL),(631,'Informed consent is:',13,1412,NULL,NULL),(632,'Counselor self-disclosure:',13,1417,NULL,NULL),(633,'Transference is:',13,1786,NULL,NULL),(634,'Counter-transference is:',13,1788,NULL,NULL),(635,'When a counselor is not aware of transference & counter-transference issues, the counselor:',13,1433,NULL,NULL),(636,'Which of the following are examples of dual relationships?',13,1438,NULL,NULL),(637,'Scope of Practice is defined as:',13,1441,NULL,NULL),(638,'Ethical considerations can typically be viewed from which of the following three different perspectives?',13,1445,NULL,NULL),(639,'Harassment is defined as making derogatory comments, including telling jokes, about someone\'s age, color, race, religion, sexual preference, national origin, disability, or sex.',22,1449,NULL,NULL),(640,'What is Third Party sexual harassment?',22,1452,NULL,NULL),(641,'Cultural competence includes examining the impact of attitudes on patient care, accepting different values, expanding communication styles to accommodate the needs of others, and the ability to intervene appropriately and effectively while demonstrating sensitivity.',22,1454,NULL,NULL),(642,'Violence can often be avoided if you take necessary precautions. When dealing with patients and visitors:',22,1459,NULL,NULL),(643,'Destination Hope has a policy of \"zero tolerance\" for workplace violence has been adopted. Any employee, regardless of position in the organization, will be disciplined up to and including termination for any violation of the workplace violence policy.',22,1730,NULL,NULL),(644,'The Performance Improvement Model is Design, Measure, Assess, and Improve.',22,1469,NULL,NULL),(645,'Performance Improvement (PI) is a one-time process.',22,1468,NULL,NULL),(646,'Two basic components included in the definition of quality are: Doing the right things, and doing them well and the degree to which we satisfy our clients\' and other customers\' needs.',22,1471,NULL,NULL),(647,'Employee involvement is required for a successful Performance Improvement Program.',22,1473,NULL,NULL),(648,'Most ethics violations occur because of poor boundaries that have been created.',22,1475,NULL,NULL),(649,'What are the area/areas where boundaries can be blurred?',22,1481,NULL,NULL),(650,'Some examples of adverse events include:',22,1495,NULL,NULL),(651,'Near misses - A Near Miss is an event or situation that could have resulted in an accident, injury or illness, but did not either by chance or through timely interventions.',22,1496,NULL,NULL),(652,'An Unusual Occurrence Report (Incident Report) is completed immediately by the person witnessing the event, given to your supervisor and forwarded to the Risk Manager/designee (no later than 24 hours).',22,1498,NULL,NULL),(653,'Who can fill out an incident report?',22,1501,NULL,NULL),(654,'You and your family are attending a home game. As you are walking to the\r\nstadium a client recognizes you and offers for you to join her tailgate party. The client also notices that your tickets are in the same area of the stadium as hers. Is it alright to join her in the tailgate party?\r\n',22,1504,NULL,NULL),(655,'All clients are informed of their rights upon admission in a language of their understanding and if necessary have their rights read to them to ensure understanding.\r\n',22,1507,NULL,NULL),(656,'All employees are required to report any suspected or alleged cases of abuse or neglect.',22,1509,NULL,NULL),(657,'In regards to the patient or family concern system, clients and/or families may express a concern either verbally or in writing.',22,1511,NULL,NULL),(658,'Confidentiality is protected in the following manners:',22,1516,NULL,NULL),(659,'What does HIPAA stand for?',22,1519,NULL,NULL),(660,'_________________ is the right of an individual to keep his/her individual health information from being disclosed.',22,1521,NULL,NULL),(661,'The __________ Act widens the scope of privacy and security protections under HIPAA for electronic protected health information (ePHI).',22,1525,NULL,NULL),(662,'What is an example/examples of PHI (Protected Health Information?',22,1531,NULL,NULL),(663,'What can happen to a person who knowingly violates patient privacy for personal gain or malicious harm?',22,1537,NULL,NULL),(664,'Are members of your organization who are not involved in a patient\'s care allowed to review the patient\'s chart out of curiosity?',22,1539,NULL,NULL),(665,'If someone forgets his log-in ID, can I let him use mine?',22,1542,NULL,NULL),(666,'What does \"minimum necessary\" mean?',22,1548,NULL,NULL),(667,'Are Consents and Authorizations the same?',22,1550,NULL,NULL),(668,'The organization\'s leadership has adopted a \'non-punitive\' approach to error reporting.',22,1551,NULL,NULL),(669,'All employees are required to report suspected and identified medical/health care errors.',22,1553,NULL,NULL),(670,'This organization supports the concept that errors occur due to a breakdown in systems and processes, and will focus on improving systems and processes, rather than disciplining those responsible for errors and occurrences.',22,1555,NULL,NULL),(671,'If you are injured or have an accident at work it is not necessary to inform your supervisor.',22,1558,NULL,NULL),(672,'The safety code for a disaster is Code D.',22,1718,NULL,NULL),(673,'The safety code for a medical emergency is Code Blue.',22,1561,NULL,NULL),(674,'MSDS is an abbreviation for which of the following?',22,1565,NULL,NULL),(675,'What type of an emergency is designated as a Code Green?',22,1569,NULL,NULL),(676,'The code if there is a fire is:',22,1572,NULL,NULL),(677,'The safety code indicating a staff member is in trouble is:',22,1575,NULL,NULL),(678,'Chemicals may be stored under the sink.',22,1713,NULL,NULL),(679,'During a fire emergency the acronym RACE stands for:',22,1584,NULL,NULL),(680,'When using a fire extinguisher, follow the acronym PASS (Pull, Aim, Squeeze, Sweep).',22,1585,NULL,NULL),(681,'Which type of extinguisher is designed for extinguishing paper, flammable liquid and elec. fires?',22,1711,NULL,NULL),(682,'When would interim life safety measures be implemented?',22,1593,NULL,NULL),(683,'Following an evacuation, a role call is taken at the designated “safe area” to ensure everyone has been safely evacuated.',22,1594,NULL,NULL),(684,'There are two types of disasters - natural and technological/man made.',22,1596,NULL,NULL),(685,'During a tornado procedure everyone would go to a designated safe area within the building that is furthest away from windows and glass doors.',22,1598,NULL,NULL),(686,'If the safety officer feels the facility is in the path of a tornado he/she will call a:',22,1722,NULL,NULL),(687,'The current safety officer at Destination Hope is',22,1728,NULL,NULL),(688,'The following security measures are in place:',22,1611,NULL,NULL),(689,'The Security Management Plan identifies one of the \'high-risk\' areas the Medication Rooms.',22,1612,NULL,NULL),(690,' When you leave your workstation, DO NOT log off your workstation  ',22,1615,NULL,NULL),(691,'What type of personal protective equipment (PPE) is needed when performing a task when touching of human blood/body fluid may occur?',22,1616,NULL,NULL),(692,'What is the correct response to clean up a spill containing blood/body fluids?',22,1622,NULL,NULL),(693,'The best way to protect yourself from Hepatitis B is to be vaccinated and utilize Standard Precautions with all patients.',22,1623,NULL,NULL),(694,'Good handwashing techniques keep you from transferring contamination to other areas of your body or the environment.  \r\n',22,1625,NULL,NULL),(695,'Every time you remove your gloves you must wash your hands with soap and running water.',22,1627,NULL,NULL),(696,'Never pick up broken glass with your hands. Use tongs or a brush and dust pan.',22,1629,NULL,NULL),(697,'Blood is the only body fluid that can carry blood-borne diseases.',22,1632,NULL,NULL),(698,'HIV can live on inanimate objects for up to 4 weeks.',22,1634,NULL,NULL),(699,'Hepatitis B virus (HBV) and Human Immunodeficiency virus (HIV) are spread through:',22,1725,NULL,NULL),(700,'Any task that involves human blood/body fluid, tissues and/or a needle or sharp contaminated with human blood/body fluids is a task where there is a chance of exposure to HBV OR HIV.',22,1637,NULL,NULL),(701,'Standard Precautions are utilized based on the premise that any contact with human blood/body fluids is potential infectious risk.',22,1639,NULL,NULL),(702,'What are the stages of relapse?\r\n',27,1741,0,NULL),(704,'All of the following are signs of mental relapse except?',27,1744,5,NULL),(705,'A man realizes that his excessive gambling is causing problems and he begins to think about changing his behavior.  According to the Stages of Change model, he would be at the stage of:',27,1775,10,NULL),(706,'Although your friend occasionally craves a cigarette, she has not smoked in a little more than 6 months.  According to Stages of Change model your friend would be at the stage of:',27,1752,15,NULL),(707,'According to Terrence Gorski, Behavior Change is the first level to recover from chemical dependence .',27,1755,20,NULL),(708,'Euphoric recall is when you remember and exaggerate the good times that you had when using drugs or alcohol while blocking out or minimizing the bad times.',27,1757,25,NULL),(709,'Which of the following are considered protective factors?',27,1763,30,NULL),(710,'Risk factors guarantee that someone will end up abusing substances.',27,1767,35,NULL),(711,'Which of the following are considered risk factors that increase likelihood of substance abuse problems?',27,1773,40,NULL),(712,'Your roommate has decided to do something about his unhealthy diet and begun to make small adjustments to grocery shopping and has begun to gather information on healthy food choices.  According to the Stages of Change model, your roommate would be at the stage of:',27,1780,11,NULL),(713,'What are the types of listed Psychotropic Medications',28,1810,NULL,NULL),(714,'Please select the incorrect side effect while using a antipsychotic drug',28,1816,NULL,NULL),(716,'People taking anti-depressants should be careful about eating food containing this chemical?',28,1821,NULL,NULL),(717,'Are anti-depressants like Ativan or Klonopin addictive?',28,1828,NULL,NULL),(718,'Which drug affects the flow of sodium through nerve and muscle cells?',28,1833,NULL,NULL),(719,'Please select the incorrect right for medication management.',28,1836,NULL,NULL),(720,'If you witness a medication error, please do the following.',28,1844,NULL,NULL),(721,'Before conducting a medication observation, do the following',28,1848,NULL,NULL),(722,'Which document is required before conducting medical observation',28,1852,NULL,NULL),(723,'Which is not a listed protocol for self-administering medication observation?',28,1856,NULL,NULL),(724,'Workplace violence is defined as any aggression or the threat of violence against employees. Which among the following people has the LOWEST risk for workplace violence while on their job?',31,1859,NULL,NULL),(726,'Which among the following behaviors may lead to violence?',31,1868,NULL,NULL),(727,'Anger and hostility are warning signs that:',31,1872,NULL,NULL),(728,'Installing surveillance cameras, alarms, or metal detectors is an example of  a(n)',31,1875,NULL,NULL),(729,'Telephone threats are not considered workplace violence since there is no physical contact between the person and the employee.',31,1878,NULL,NULL),(730,'If a fellow employee threatens you, what should you do?',31,1879,NULL,NULL),(731,'If an employee who is out-of-control begins to destroy office property, he/she is clearly demonstrating which behavior?',31,1886,NULL,NULL),(732,'If a customer threatens you, you should:',31,1889,NULL,NULL),(733,'If a person you know outside of work has been threatening you, what should you do?',31,1891,NULL,NULL),(734,'When there is an active shooter in the vicinity, what should you do?',31,1896,NULL,NULL),(735,'The current safety officer at DH is',25,1902,NULL,NULL);

--
-- Table structure for table `response`
--

CREATE TABLE `response` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `question_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `response` varchar(60) NOT NULL,
  `attempt` int(11) NOT NULL,
  `correct` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`question_id`,`course_id`),
  KEY `question_id` (`question_id`),
  KEY `test_id` (`course_id`),
  KEY `response` (`response`),
  CONSTRAINT `response_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `response_ibfk_4` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=70078 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `response`
--

INSERT INTO `response` VALUES (128,14,53,4,'168',1,NULL),(129,14,54,4,'171',1,NULL),(130,14,55,4,'175',1,NULL),(131,14,56,4,'180',1,NULL),(132,14,57,4,'184',1,NULL),(133,14,58,4,'190',1,NULL),(134,14,59,4,'193',1,NULL),(135,14,60,4,'196',1,NULL),(136,14,61,4,'199',1,NULL),(137,14,62,4,'203',1,NULL),(138,14,63,4,'210',1,NULL),(139,14,64,4,'212',1,NULL),(140,14,65,4,'215',1,NULL),(141,14,82,4,'283',1,NULL),(142,14,83,4,'291',1,NULL),(143,14,53,4,'167',2,NULL),(144,14,54,4,'171',2,NULL),(145,14,55,4,'175',2,NULL),(146,14,56,4,'179',2,NULL),(147,14,57,4,'183',2,NULL),(148,14,58,4,'187',2,NULL),(149,14,59,4,'191',2,NULL),(150,14,60,4,'195',2,NULL),(151,14,61,4,'202',2,NULL),(152,14,62,4,'203',2,NULL),(153,14,63,4,'207',2,NULL),(154,14,64,4,'212',2,NULL),(155,14,65,4,'215',2,NULL),(156,14,82,4,'287',2,NULL),(157,14,83,4,'290',2,NULL),(158,10,53,4,'296',1,1),(159,10,54,4,'297',1,1),(160,10,55,4,'299',1,NULL),(161,10,56,4,'301',1,1),(162,10,57,4,'313',1,NULL),(163,10,58,4,'310',1,NULL),(164,10,59,4,'320',1,1),(165,10,60,4,'325',1,1),(166,10,61,4,'321',1,NULL),(167,10,62,4,'327',1,1),(168,10,63,4,'329',1,NULL),(169,10,64,4,'333',1,1),(170,10,65,4,'337',1,NULL),(171,10,82,4,'343',1,1),(172,10,83,4,'347',1,1),(188,14,53,4,'296',3,1),(189,14,54,4,'297',3,1),(190,14,55,4,'300',3,1),(191,14,57,4,'314',3,1),(192,14,60,4,'325',3,1),(193,14,62,4,'327',3,1),(194,14,63,4,'331',3,1),(195,14,65,4,'338',3,1),(196,14,82,4,'343',3,1),(197,14,83,4,'347',3,1),(198,14,84,4,'402',3,1),(199,14,53,4,'296',4,1),(200,14,54,4,'297',4,1),(201,14,55,4,'300',4,1),(202,14,57,4,'314',4,1),(203,14,60,4,'325',4,1),(204,14,62,4,'327',4,1),(205,14,63,4,'331',4,1),(206,14,64,4,'333',4,1),(207,14,65,4,'338',4,1),(208,14,82,4,'343',4,1),(209,14,83,4,'347',4,1),(210,14,84,4,'402',4,1),(212,14,53,4,'296',5,1),(213,14,54,4,'449',5,1),(214,14,55,4,'300',5,1),(215,14,57,4,'452',5,1),(216,14,58,4,'414',5,1),(217,14,59,4,'419',5,1),(218,14,60,4,'325',5,1),(219,14,61,4,'425',5,1),(220,14,62,4,'327',5,1),(221,14,63,4,'331',5,1),(222,14,64,4,'333',5,1),(223,14,65,4,'458',5,1),(224,14,82,4,'343',5,1),(225,14,83,4,'347',5,1),(226,14,85,4,'459',5,1),(813,10,26,3,'80',1,NULL),(814,10,27,3,'84',1,NULL),(815,10,28,3,'88',1,NULL),(816,10,29,3,'92',1,NULL),(817,10,30,3,'96',1,NULL),(818,10,31,3,'101',1,NULL),(819,10,32,3,'104',1,NULL),(820,10,33,3,'108',1,NULL),(821,10,34,3,'112',1,NULL),(822,10,35,3,'430',1,1),(823,10,36,3,'121',1,NULL),(824,10,37,3,'124',1,NULL),(825,10,38,3,'130',1,NULL),(826,10,39,3,'134',1,NULL),(827,10,40,3,'137',1,NULL),(828,10,41,3,'141',1,NULL),(829,10,47,3,'150',1,NULL),(830,10,48,3,'435',1,1),(831,10,49,3,'441',1,1),(832,10,26,3,'463',2,1),(833,10,27,3,'465',2,1),(834,10,28,3,'467',2,1),(835,10,29,3,'469',2,1),(836,10,30,3,'471',2,1),(837,10,31,3,'474',2,1),(838,10,32,3,'475',2,1),(839,10,33,3,'477',2,1),(840,10,34,3,'479',2,1),(841,10,35,3,'485',2,1),(842,10,36,3,'487',2,1),(843,10,37,3,'490',2,1),(844,10,38,3,'500',2,1),(845,10,39,3,'508',2,1),(846,10,40,3,'511',2,1),(847,10,41,3,'515',2,1),(848,10,42,3,'518',2,1),(849,10,47,3,'521',2,1),(850,10,48,3,'526',2,1),(851,10,49,3,'532',2,1),(10776,14,26,3,'463',1,1),(10777,14,27,3,'465',1,1),(10778,14,28,3,'467',1,1),(10779,14,29,3,'469',1,1),(10780,14,30,3,'471',1,1),(10781,14,31,3,'474',1,1),(10782,14,32,3,'476',1,NULL),(10783,14,33,3,'477',1,1),(10784,14,34,3,'479',1,1),(10785,14,36,3,'1206',1,1),(10786,14,37,3,'490',1,1),(10787,14,38,3,'500',1,1),(10788,14,39,3,'508',1,1),(10789,14,40,3,'511',1,1),(10790,14,41,3,'517',1,NULL),(10791,14,42,3,'533',1,1),(10792,14,47,3,'521',1,1),(10793,14,48,3,'526',1,1),(10794,14,49,3,'532',1,1),(18172,14,67,5,'540',1,1),(18173,14,68,5,'544',1,1),(18174,14,69,5,'546',1,1),(18175,14,70,5,'551',1,1),(18176,14,71,5,'553',1,1),(18177,14,72,5,'557',1,1),(18178,14,73,5,'565',1,1),(18179,14,74,5,'1686',1,1),(18180,14,75,5,'1677',1,1),(18181,14,78,5,'582',1,1),(18182,14,79,5,'1672',1,1),(18183,14,80,5,'1681',1,1),(18184,14,81,5,'576',1,1),(18185,14,88,5,'1661',1,1),(18186,14,89,5,'600',1,1),(49594,10,116,8,'694',1,1),(49595,10,117,8,'699',1,1),(49596,10,118,8,'704',1,1),(49597,10,119,8,'707',1,1),(49598,10,120,8,'711',1,1),(49599,10,121,8,'714',1,1),(49600,10,122,8,'716',1,1),(49601,10,123,8,'720',1,1),(49602,10,124,8,'725',1,1),(49603,10,125,8,'729',1,1),(49604,10,126,8,'734',1,1),(49605,10,127,8,'738',1,1),(49606,10,128,8,'740',1,1),(49607,10,129,8,'744',1,1),(49608,10,130,8,'747',1,1),(49757,10,67,5,'537',1,NULL),(49758,10,68,5,'541',1,NULL),(49759,10,69,5,'545',1,NULL),(49760,10,70,5,'549',1,NULL),(49761,10,71,5,'553',1,1),(49762,10,72,5,'557',1,1),(49763,10,73,5,'561',1,NULL),(49764,10,74,5,'1683',1,NULL),(49765,10,75,5,'1673',1,NULL),(49766,10,78,5,'580',1,NULL),(49767,10,79,5,'1668',1,NULL),(49768,10,80,5,'1678',1,NULL),(49769,10,81,5,'576',1,1),(49770,10,88,5,'1659',1,NULL),(49771,10,89,5,'598',1,NULL),(49772,10,67,5,'540',2,1),(49773,10,68,5,'544',2,1),(49774,10,69,5,'546',2,1),(49775,10,70,5,'551',2,1),(49776,10,71,5,'553',2,1),(49777,10,72,5,'557',2,1),(49778,10,73,5,'565',2,1),(49779,10,74,5,'1686',2,1),(49780,10,75,5,'1677',2,1),(49781,10,78,5,'582',2,1),(49782,10,79,5,'1672',2,1),(49783,10,80,5,'1681',2,1),(49784,10,81,5,'576',2,1),(49785,10,88,5,'1661',2,1),(49786,10,89,5,'600',2,1),(50647,14,116,8,'694',1,1),(50648,14,117,8,'699',1,1),(50649,14,118,8,'704',1,1),(50650,14,119,8,'707',1,1),(50651,14,120,8,'711',1,1),(50652,14,121,8,'714',1,1),(50653,14,122,8,'716',1,1),(50654,14,123,8,'1797',1,1),(50655,14,124,8,'725',1,1),(50656,14,125,8,'729',1,1),(50657,14,126,8,'734',1,1),(50658,14,127,8,'738',1,1),(50659,14,128,8,'740',1,1),(50660,14,129,8,'744',1,1),(50661,14,130,8,'747',1,1),(50662,14,116,8,'694',2,1),(50663,14,117,8,'699',2,1),(50664,14,118,8,'704',2,1),(50665,14,119,8,'707',2,1),(50666,14,120,8,'711',2,1),(50667,14,121,8,'714',2,1),(50668,14,122,8,'716',2,1),(50669,14,123,8,'1797',2,1),(50670,14,124,8,'725',2,1),(50671,14,125,8,'729',2,1),(50672,14,126,8,'734',2,1),(50673,14,127,8,'738',2,1),(50674,14,128,8,'740',2,1),(50675,14,129,8,'744',2,1),(50676,14,130,8,'747',2,1),(50677,14,116,8,'692',3,NULL),(50678,14,117,8,'698',3,NULL),(50679,14,118,8,'701',3,NULL),(50680,14,119,8,'705',3,NULL),(50681,14,120,8,'712',3,NULL),(50682,14,121,8,'713',3,NULL),(50683,14,122,8,'718',3,NULL),(50684,14,123,8,'1798',3,NULL),(50685,14,124,8,'724',3,NULL),(50686,14,125,8,'729',3,1),(50687,14,126,8,'732',3,NULL),(50688,14,127,8,'739',3,NULL),(50689,14,128,8,'740',3,1),(50690,14,129,8,'745',3,NULL),(50691,14,130,8,'746',3,NULL),(50692,14,116,8,'693',4,NULL),(50693,14,117,8,'699',4,1),(50694,14,118,8,'703',4,NULL),(50695,14,119,8,'707',4,1),(50696,14,120,8,'711',4,1),(50697,14,121,8,'714',4,1),(50698,14,122,8,'716',4,1),(50699,14,123,8,'1797',4,1),(50700,14,124,8,'726',4,NULL),(50701,14,125,8,'729',4,1),(50702,14,126,8,'733',4,NULL),(50703,14,127,8,'738',4,1),(50704,14,128,8,'740',4,1),(50705,14,129,8,'743',4,NULL),(50706,14,130,8,'747',4,1),(50707,14,116,8,'694',5,1),(50708,14,117,8,'699',5,1),(50709,14,118,8,'704',5,1),(50710,14,119,8,'707',5,1),(50711,14,120,8,'711',5,1),(50712,14,121,8,'714',5,1),(50713,14,122,8,'716',5,1),(50714,14,123,8,'1797',5,1),(50715,14,124,8,'725',5,1),(50716,14,125,8,'729',5,1),(50717,14,126,8,'734',5,1),(50718,14,127,8,'738',5,1),(50719,14,128,8,'740',5,1),(50720,14,129,8,'744',5,1),(50721,14,130,8,'747',5,1),(55863,14,141,10,'785',1,NULL),(55864,14,142,10,'789',1,NULL),(55865,14,143,10,'793',1,1),(55866,14,144,10,'797',1,NULL),(55867,14,145,10,'802',1,NULL),(55868,14,146,10,'865',1,1),(55869,14,147,10,'867',1,1),(55870,14,148,10,'810',1,1),(55871,14,149,10,'812',1,1),(55872,14,150,10,'814',1,1),(55873,14,151,10,'816',1,NULL),(55874,14,154,10,'821',1,NULL),(55875,14,155,10,'823',1,1),(55876,14,156,10,'824',1,1),(70038,10,724,31,'1859',1,1),(70039,10,726,31,'1868',1,1),(70040,10,727,31,'1872',1,1),(70041,10,728,31,'1875',1,1),(70042,10,729,31,'1878',1,1),(70043,10,730,31,'1879',1,1),(70044,10,731,31,'1886',1,1),(70045,10,732,31,'1889',1,1),(70046,10,733,31,'1891',1,1),(70047,10,734,31,'1896',1,1),(70048,10,724,31,'1859',2,1),(70049,10,726,31,'1868',2,1),(70050,10,727,31,'1872',2,1),(70051,10,728,31,'1875',2,1),(70052,10,729,31,'1878',2,1),(70053,10,730,31,'1879',2,1),(70054,10,731,31,'1886',2,1),(70055,10,732,31,'1889',2,1),(70056,10,733,31,'1891',2,1),(70057,10,734,31,'1896',2,1),(70058,10,724,31,'1859',3,1),(70059,10,726,31,'1868',3,1),(70060,10,727,31,'1872',3,1),(70061,10,728,31,'1875',3,1),(70062,10,729,31,'1878',3,1),(70063,10,730,31,'1879',3,1),(70064,10,731,31,'1886',3,1),(70065,10,732,31,'1889',3,1),(70066,10,733,31,'1891',3,1),(70067,10,734,31,'1896',3,1),(70068,10,724,31,'1859',4,1),(70069,10,726,31,'1868',4,1),(70070,10,727,31,'1872',4,1),(70071,10,728,31,'1875',4,1),(70072,10,729,31,'1878',4,1),(70073,10,730,31,'1879',4,1),(70074,10,731,31,'1886',4,1),(70075,10,732,31,'1889',4,1),(70076,10,733,31,'1891',4,1),(70077,10,734,31,'1896',4,1);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `access_code` varchar(60) DEFAULT NULL,
  `staff_type_select` varchar(60) DEFAULT NULL,
  `footer_column_1` blob,
  `footer_column_2` blob,
  `payment_activated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'DestHope2015',NULL,'6555 NW 9th Avenue, Suite 210<br>\nFt. Lauderdale, FL 33309<br>\nPhone: (877) 944-4235<br>\nFax: (954) 771-2098','',0);

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `title` varchar(90) DEFAULT NULL,
  `date_completed` int(90) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `training_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `training`
--


--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `fname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `lname` varchar(60) CHARACTER SET utf8 NOT NULL,
  `email` varchar(60) CHARACTER SET utf8 NOT NULL,
  `pass` char(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `birthdate_day` int(11) NOT NULL,
  `birthdate_month` int(11) NOT NULL,
  `birthdate_year` int(11) NOT NULL,
  `join_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `confirmation_code` int(11) DEFAULT NULL,
  `confirmed` int(1) NOT NULL DEFAULT '1',
  `CEU_count` int(11) DEFAULT NULL,
  `access_level` int(11) DEFAULT '0',
  `staff_type` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `hired_date` int(60) DEFAULT NULL,
  `active` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES (10,'John','Sheppard','jcshep@gmail.com','a01f4764797802f98caba116dfc0c25a0691f95d02c107adeff267ceb478b379',0,0,0,'2014-03-04 20:52:18',46863347,1,2,1,'a:1:{i:3;s:1:\"3\";}',1375243200,0),(14,'Cornell','Peters','fortriscorp@gmail.com','02ddfa996b303cd6e1f57c9a51243e5f2b9ef3c5133959cda431d4395f39b3db',2,6,1948,'2014-08-06 02:19:45',60313016,1,10,1,'a:2:{i:1;s:1:\"1\";i:2;s:1:\"2\";}',1375243200,0);

--
-- Table structure for table `user_course_access`
--

CREATE TABLE `user_course_access` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `status` varchar(60) CHARACTER SET utf8mb4 DEFAULT NULL,
  `time_completed` int(11) unsigned DEFAULT NULL,
  `evaluated` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `user_course_access_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `user_course_access_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_course_access`
--


--
-- Current Database: `cap_school`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cap_school` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `cap_school`;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  `short_description` text CHARACTER SET utf8,
  `description` text CHARACTER SET utf8,
  `passing_percentage` int(11) DEFAULT NULL,
  `cost` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `instruction_methods` text CHARACTER SET utf8,
  `evaluation_method` text CHARACTER SET utf8,
  `study_guide` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `study_guide_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `case_study` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `powerpoint_2` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `syllabus` varchar(60) CHARACTER SET utf8 DEFAULT NULL,
  `video` text CHARACTER SET utf8,
  `ceu_credit` int(11) unsigned DEFAULT '0',
  `promo_code` varchar(60) DEFAULT NULL,
  `frequency_required` varchar(90) DEFAULT NULL,
  `staff_requirement` varchar(90) DEFAULT NULL,
  `required_within_time` varchar(90) DEFAULT NULL,
  `in_person` varchar(11) DEFAULT NULL,
  `essay_question` int(1) DEFAULT NULL,
  `essay_question_content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course`
--

INSERT INTO `course` VALUES (27,'AAP001: Clinical Evaluation','<p>This course will provide a comprehensive overview of the various processes that are involved in conducting a thorough, clinically-­‐based evaluation. The readings will explain, define and give examples of screening, intakes, assessments, stage of change, the ASAM and much more!</p>','<p>This course will provide a comprehensive overview of the various processes that are involved in conducting a thorough, clinically-­‐based evaluation. The readings will explain, define and give examples of screening, intakes, assessments, stage of change, the ASAM and much more!</p><p>Clinical Evaluation is one of the Practice Dimensions in the TAP-­‐21, which is the guideline used throughout your course work. Clinical Evaluation sets the stage for determining diagnosis, treatment level, treatment planning, discharge planning, case management need etc. In other words Clinical Evaluations serve as the platform for basically everything on behalf of the client and the counselor.</p>',80,'0','',NULL,'Clinical-Evaluation-Outline.pdf',NULL,'Clinical+Evlauation+Case+Study.pdf','AAP001-Clinical-Evaluation-Presentation.pps',NULL,'AAP001-Clinical-Evaluation-Syllabus.pdf',NULL,35,'','',NULL,'','0',1,'Please write at least 1000 words each on the following two topics. If your essay does not meet the minimum word count requirement it will not be considered for grading.\r\n \r\na) How addiction and mental health correlates to suicidal behavior and\r\n\r\nb) How and why do we assess substance abusers for co-occurring disorders?\r\n'),(28,'AAP002: Treatment Planning','<p>This course will provide the knowledge and skills for the preparation, implementation, and continual update of the addiction treatment plan.</p>','<p>This course will provide the knowledge and skills for the preparation, implementation, and continual update of the addiction treatment plan . Each section of this 30 hour course will be guided by the Florida Certification Board (FCB) adopted National Standards for Substance Abuse Treatment Planning and Continued Assessment and Treatment Planning indicated in the Center for Substance Abuse Treatment/Substance Abuse and Mental Health Services Administration (CSAT/SAMHSA) Technical Assistance Publication (TAP) 21, Addiction Counseling Competencies: The Knowledge, Skills, and Attitudes of Professional Practice.</p>',80,'0','',NULL,'AAP-002-Treatment-Planning-Outline.pdf','Example-Treatment-Plan.pdf','Case-Study.pdf','AAP002-Treatment-Planning-Presentation.ppsx',NULL,'AAP002-Treatment-Planning-Syllabus.pdf',NULL,30,'','',NULL,'','0',1,'Please write at least 500 words on the following topic. If your essay does not meet the word requirement it will not be considered for grading.\r\n \r\nWhat is a treatment plan and why is it important?\r\n\r\nand\r\n\r\nPlease write at least 1000 words on the following topic. If your essay does not meet the word requirement it will not be considered for grading.\r\n \r\nHow do you develop a “Problem List” and how do you approach client “Buy-In” to the problem?'),(29,'AAP003: Case Management and Referral','<p>This course will provide a concise definition and professional skills for best practice of case management (service coordination) specific to the treatment of addiction.</p>','<p>This course will provide a concise definition and professional skills for best practice of case management (service coordination) specific to the treatment of addiction. Each section of this 15 hour course will be guided by the Florida Certification Board (FCB) adopted National Standards for Substance Abuse Case Management including: Service Coordination, Consultation, and Referrals indicated in the Center for Substance Abuse Treatment/Substance Abuse and Mental Health Services Administration (CSAT/SAMHSA) Technical Assistance Publication (TAP) 21, Addiction Counseling Competencies: The Knowledge, Skills, and Attitudes of Professional Practice, pages 43-54.</p>',80,'','',NULL,'AAP003-Case-Management-Outline.pdf',NULL,NULL,'AP003CM-Referral-Service-Coordination.ppsx',NULL,'AAP003-Case-Management-Syllabus.pdf',NULL,15,'','',NULL,'','0',1,'Please write at least 1000 words on each of the following topics. If your essay does not meet the minimum word requirement, it will not be considered for grading.\r\n \r\na) Explain the importance of a multi-disciplinary approach to service coordination and\r\n\r\nb) What are the benefits of case management to the substance abuser?\r\n');

--
-- Table structure for table `course_category`
--

CREATE TABLE `course_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_category`
--

INSERT INTO `course_category` VALUES (1,'Continuing Education'),(2,'Personal Development'),(3,'Communication'),(4,'Management & Leadership'),(5,'Marketing'),(6,'Organizational Efficiency'),(7,'Certified Behavioral Health Technician (CBHT)');

--
-- Table structure for table `course_has_category`
--

CREATE TABLE `course_has_category` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  `course_offering_id` int(11) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  KEY `course_offering_id` (`course_offering_id`),
  KEY `course_category_id` (`course_category_id`),
  CONSTRAINT `course_has_category_ibfk_3` FOREIGN KEY (`course_offering_id`) REFERENCES `offerings` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_5` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `course_has_category_ibfk_6` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `course_has_category`
--

INSERT INTO `course_has_category` VALUES (25,27,4,1),(26,28,4,1),(27,29,4,1);

--
-- Table structure for table `evaluation`
--

CREATE TABLE `evaluation` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` int(11) DEFAULT NULL,
  `date` int(11) NOT NULL,
  `student_name` varchar(60) DEFAULT NULL,
  `question_1` text,
  `question_2` text,
  `question_3` text,
  `question_4` text,
  `question_5` text,
  `rating` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `evaluation`
--


--
-- Table structure for table `exam_results`
--

CREATE TABLE `exam_results` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `course_id` int(11) unsigned NOT NULL,
  `grade` float NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `exam_results_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `exam_results_ibfk_3` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `exam_results`
--


--
-- Table structure for table `materials`
--

CREATE TABLE `materials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `course_id` int(11) unsigned NOT NULL,
  `name` varchar(60) NOT NULL,
  `filename` varchar(60) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `course_id` (`course_id`),
  CONSTRAINT `materials_ibfk_1` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `materials`
--


--
-- Table structure for table `offering_has_category`
--

CREATE TABLE `offering_has_category` (
  `offering_id` int(11) unsigned NOT NULL,
  `course_category_id` int(11) unsigned NOT NULL,
  KEY `offering_id` (`offering_id`),
  KEY `course_id` (`course_category_id`),
  CONSTRAINT `offering_has_category_ibfk_1` FOREIGN KEY (`offering_id`) REFERENCES `offerings` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  CONSTRAINT `offering_has_category_ibfk_2` FOREIGN KEY (`course_category_id`) REFERENCES `course_category` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offering_has_category`
--

INSERT INTO `offering_has_category` VALUES (1,1),(1,2),(1,3),(1,4),(1,5);

--
-- Table structure for table `offerings`
--

CREATE TABLE `offerings` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `offerings`
--

INSERT INTO `offerings` VALUES (1,'Professional Development');

--
-- Table structure for table `option`
--

