-- MySQL dump 10.13  Distrib 5.7.25, for Linux (x86_64)
--
-- Host: localhost    Database: new_41x
-- ------------------------------------------------------
-- Server version	5.7.25-0ubuntu0.16.04.2
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Dumping data for table `codes`
--
-- WHERE:  code_type = 32

INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107581,'IUD Copper 10 yr','iud','4550',32,'',NULL,0.00,'','IPPF:113172110;IPPF2:1132120000000','',4.6,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107580,'IUD Hormone 5 yr','iud','4540',32,'',NULL,0.00,'','IPPF:113171110;IPPF2:1132120000000','',3.3,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107820,'Oral Contraceptives (progestin only)','or','4361',32,'',NULL,0.00,'','IPPF:111101110;IPPF2:1121120000000','',0.066667,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107575,'Spermicides','sp','4490',32,'',NULL,0.00,'','IPPF:112160000;IPPF2:1126020000000','',0.133333,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107574,'Cervical Cap','dia','4480',32,'',NULL,0.00,'','IPPF:112152010;IPPF2:1125020000000','',1,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107573,'Diaphragm','dia','4470',32,'',NULL,0.00,'','IPPF:112151110;IPPF2:1125020000000','',1,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107572,'Condoms (Female)','con','4460',32,'',NULL,0.00,'','IPPF:112142110;IPPF2:1124220000000','',0.008333,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107571,'Condoms (Male)','con','4450',32,'',NULL,0.00,'','IPPF:112141110;IPPF2:1124120000000','',0.008333,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107570,'Ring','pat','4440',32,'',NULL,0.00,'','IPPF:111133110;IPPF2:1123020000000','',0.066667,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107569,'Patch','pat','4430',32,'',NULL,0.00,'','IPPF:111132110;IPPF2:1123020000000','',0.066667,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107568,'Implants (3 year)','imp','4420',32,'',NULL,0.00,'','IPPF:111124110;IPPF2:1131120000000','',2.5,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107567,'Implants (4 year)','imp','4410',32,'',NULL,0.00,'','IPPF:111123110;IPPF2:1131120000000','',3.2,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107566,'Implants (5 year)','imp','4400',32,'',NULL,0.00,'','IPPF:111122110;IPPF2:1131120000000','',3.8,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107565,'Injectable (3 month)','inj','4390',32,'',NULL,0.00,'','IPPF:111113110;IPPF2:1122120000000','',0.25,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107564,'Injectable (2 month)','inj','4380',32,'',NULL,0.00,'','IPPF:111112110;IPPF2:1122120000000','',0.166667,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107563,'Injectables (1 month)','inj','4370',32,'',NULL,0.00,'','IPPF:111111110;IPPF2:1122120000000','',0.076923,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107562,'Oral Contraceptives (combined)','or','4360',32,'',NULL,0.00,'','IPPF:111101110;IPPF2:1121120000000','',0.066667,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107582,'Voluntary Surgical Contraception - Female','fvsc','4560',32,'',NULL,0.00,'','IPPF:121181000;IPPF2:1141130000800','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107583,'Voluntary Surgical Contraception - Male','mvsc','4570',32,'',NULL,0.00,'','IPPF:122182000;IPPF2:1142030000800','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107584,'Awareness-Based Methods - CMM','fab','4580',32,'',NULL,0.00,'','','',0,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107585,'Awareness-Based Methods - CBM','fab','4590',32,'',NULL,0.00,'','','',0,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107586,'Awareness-Based Methods - STM','fab','4600',32,'',NULL,0.00,'','','',0,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107587,'Awareness-Based Methods - SDM','fab','4610',32,'',NULL,0.00,'','','',0,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (107588,'Emergency Contraception (progestin only pills)','ec','4620',32,'',NULL,0.00,'','IPPF:145212000;IPPF2:1151020000000','',0.05,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247730,'MVSC - Incisional Vasectomy','mvsc','4572',32,'',NULL,0.00,'','IPPF2:1142030302201','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247731,'MVSC - No Scalpel Vasectomy','mvsc','4574',32,'',NULL,0.00,'','IPPF2:1142030302202','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247732,'VSC – Minilaparotomy','fvsc','4561',32,'',NULL,0.00,'','IPPF2:1141130302102','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247733,'VSC – Laparoscopy','fvsc','4562',32,'',NULL,0.00,'','IPPF2:1141130302103','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247734,'VSC - Laparotomy','fvsc','4563',32,'',NULL,0.00,'','IPPF2:1141130302104','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247735,'VSC - Hysteroscopy (ESSURE)','fvsc','4565',32,'',NULL,0.00,'','IPPF2:1141130302105','',10,1,0,0,4);
INSERT INTO `codes` (`id`, `code_text`, `code_text_short`, `code`, `code_type`, `modifier`, `units`, `fee`, `superbill`, `related_code`, `taxrates`, `cyp_factor`, `active`, `reportable`, `financial_reporting`, `sex`) VALUES (247736,'VSC - Trans-Vaginal Tubal Ligation','fvsc','4567',32,'',NULL,0.00,'','IPPF2:1141130302106','',10,1,0,0,4);
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2019-01-30  3:08:19