SET character_set_client = utf8;
DELETE FROM codes WHERE code_type = 31;
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1110010900000', '', 'Contraceptives - Counselling - General' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1121120000000', '', 'Oral Contraceptives - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1122120000000', '', 'Injectable - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1123020000000', '', 'Patch / Ring - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1124020000800', '', 'Male / Female condom - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1124120000000', '', 'Male condom - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1124220000000', '', 'Female condom - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1125020000000', '', 'Diaphragm / Cervical cap - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1126020000000', '', 'Spermicides - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1131020211000', '', 'Implant - Consultation - Removal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1131120000000', '', 'Implant - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1132020211000', '', 'IUD - Consultation - Removal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1132120000000', '', 'IUD - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141000000800', '', 'F / MVSC - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141110000000', '', 'FVSC - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141120000000', '', 'FVSC - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302101', '', 'FVSC - Management - Surgical - Reversal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302102', '', 'FVSC - Management - Surgical - Minilaparotomy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302103', '', 'FVSC - Management - Surgical - Laparoscopy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302104', '', 'FVSC - Management - Surgical - Laparotomy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302105', '', 'FVSC - Management - Surgical - Hysteroscopy (ESSURE®)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302106', '', 'FVSC - Management - Surgical - Trans vaginal tubal ligation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130302107', '', 'FVSC - Management - Surgical - FVSC follow up' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1141130000800', '', 'FVSC - Management - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142010000000', '', 'MVSC - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142020000000', '', 'MVSC - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142030302101', '', 'MVSC - Management - Surgical - Reversal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142030302201', '', 'MVSC - Management - Surgical - Incisional Vasectomy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142030302202', '', 'MVSC - Management - Surgical - No-scalpel Vasectomy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142030302203', '', 'MVSC - Management - Surgical - MVSC follow up' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1142030000800', '', 'MVSC - Management - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1151010000000', '', 'EC - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1151020000000', '', 'EC - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '1210020000000', '', 'FAB - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2111010121000', '', 'Abortion - Counselling - Pre-abortion / Options Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2111010122000', '', 'Abortion - Counselling - Post-abortion' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2111010000800', '', 'Abortion - Counselling - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2112020200000', '', 'Abortion - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2112020201101', '', 'Abortion - Consultation - Initial consultation - Harm reduction model' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2112020202101', '', 'Abortion - Consultation - Follow up consultation - Harm reduction model' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2112020000800', '', 'Abortion - Consultation - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301101', '', 'Abortion - Management - Medical - Misoprostol only - up to 12 weeks gestation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301105', '', 'Abortion - Management - Medical - Misoprostol only - over 12 weeks gestation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301102', '', 'Abortion - Management - Medical - Mifepristone and misoprostol - up to 12 weeks gestation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301106', '', 'Abortion - Management - Medical - Mifepristone and misoprostol - over 12 weeks gestation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301110', '', 'Abortion - Management - Medical - Treatment of complications' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301800', '', 'Abortion - Management - Medical -  Unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113130301104', '', 'Abortion - Management - Medical - follow up' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113230302301', '', 'Abortion - Management - Surgical - D&C' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113230302302', '', 'Abortion - Management - Surgical - D&E' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113230302304', '', 'Abortion - Management - Surgical - Vacuum aspiration' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113230302310', '', 'Abortion - Management - Surgical - Treatment of complications' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113230302800', '', 'Abortion - Management - Surgical - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2113230302307', '', 'Abortion - Management - Surgical - follow up' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2114030301101', '', 'Incomplete abortion - Management - Medical - Misoprostol' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2114030302303', '', 'Incomplete abortion - Management - Surgical - D&E' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2114030302305', '', 'Incomplete abortion - Management - Surgical - D&C' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2114030302304', '', 'Incomplete abortion - Management - Surgical - Vacuum aspiration' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2114030302800', '', 'Incomplete abortion - Management - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2116020201101', '', 'Abortion – Self-Care – Counselling and information' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2116020201102', '', 'Abortion – Self-Care – Provision of quality medical abortion medication' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2116020201103', '', 'Abortion – Self-Care – Support' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2121010111000', '', 'HIV and AIDS - Counselling - Pre-test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2121010112000', '', 'HIV and AIDS - Counselling - Post-test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2121010123000', '', 'HIV and AIDS - Counselling - Risk reduction' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2121010124000', '', 'HIV and AIDS - Counselling - Psycho-social support' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2121010000800', '', 'HIV and AIDS - Counselling - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2122020200000', '', 'HIV and AIDS - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2123030301301', '', 'HIV and AIDS - Management - Medical - ART' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2123030301501', '', 'HIV and AIDS - Management - Medical - OI (TB)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2123030301502', '', 'HIV and AIDS - Management - Medical - OI (Malaria)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2123030301509', '', 'HIV and AIDS - Management - Medical - OI (Other)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2123030000800', '', 'HIV and AIDS - Management - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2124040401102', '', 'HIV and AIDS - Prevention - Prophylaxis - ARVs - PEP' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2124040401103', '', 'HIV and AIDS - Prevention - Prophylaxis - ARVs - Prevention of vertical transmission' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2124040401104', '', 'HIV and AIDS - Prevention - Prophylaxis - ARVs - Oral PrEP' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2124040401105', '', 'HIV and AIDS - Prevention - Prophylaxis - ARVs - Injectable PrEP' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2124040401106', '', 'HIV and AIDS - Prevention - Prophylaxis - ARVs - Vaginal ring' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2124040402100', '', 'HIV and AIDS - Prevention - Circumcision - Biomedical HIV prevention' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050502000', '', 'HIV and AIDS - Investigation - Examination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503101', '', 'HIV and AIDS - Investigation - Lab test - Diagnostic Ab test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503102', '', 'HIV and AIDS - Investigation - Lab test - Diagnostic Ag test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503103', '', 'HIV and AIDS - Investigation - Lab test - Diagnostic PCR test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503104', '', 'HIV and AIDS - Investigation - Lab test - Diagnostic Rapid test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503105', '', 'HIV and AIDS - Investigation - Lab test - Monitoring viral load test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503106', '', 'HIV and AIDS - Investigation - Lab test - Monitoring CD4 count test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050503888', '', 'HIV and AIDS - Investigation - Lab test - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2125050504000', '', 'HIV and AIDS - Investigation - Sampling procedure' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2131010111000', '', 'STI / RTI - Counselling - Pre-test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2131010112000', '', 'STI / RTI - Counselling - Post-test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2131010123000', '', 'STI / RTI - Counselling - Risk reduction' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2131010000800', '', 'STI / RTI - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2132020200000', '', 'STI / RTI - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303008', '', 'STI/RTI - Management - Syndromic - Other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303001', '', 'STI/RTI - Management - Syndromic - Urethral discharge' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303002', '', 'STI/RTI - Management - Syndromic - Vaginal discharge' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303003', '', 'STI/RTI - Management - Syndromic - Anorectal infection' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303004', '', 'STI/RTI - Management - Syndromic - Genital ulcer disease (Herpes)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303005', '', 'STI/RTI - Management - Syndromic - Genital ulcer disease (non-Herpes);' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303006', '', 'STI/RTI - Management - Syndromic - Inguinal bubo/swelling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133130303007', '', 'STI/RTI - Management - Syndromic - Lower abdominal pain/ Pelvic Inflammatory Disease (PID)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304000', '', 'STI/RTI - Management - Etiological - Other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304101', '', 'STI/RTI - Management - Etiological - Chlamydia' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304102', '', 'STI/RTI - Management - Etiological - Chancroid' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304103', '', 'STI/RTI - Management - Etiological - Gonorrhoea' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304104', '', 'STI/RTI - Management - Etiological - Syphilis' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304105', '', 'STI/RTI - Management - Etiological - Human Papillomavirus (HPV)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304106', '', 'STI/RTI - Management - Etiological - Herpes simplex' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2133230304800', '', 'STI/RTI - Management - Etiological - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2134040401201', '', 'STI/RTI - Prevention - Prophylaxis - Hep A vaccination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2134040401202', '', 'STI/RTI - Prevention - Prophylaxis - Hep B vaccination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2134040401203', '', 'STI/RTI - Prevention - Prophylaxis - HPV vaccination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2134040401800', '', 'STI / RTI - Prevention - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2135050502000', '', 'STI/RTI - Investigation - Examination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2135050503000', '', 'STI/RTI - Investigation - Lab test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2135050505000', '', 'STI/RTI - Investigation - Lab test HPV' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2135050504000', '', 'STI/RTI - Investigation - Sampling procedure' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2135050000800', '', 'STI / RTI - Investigation - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2141010111101', '', 'Gynecology - Counselling - Pre test - Cervical cancer' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2141010112101', '', 'Gynecology - Counselling - Post test - Cervical cancer' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2141010900102', '', 'Gynecology - Counselling - General - Breast cancer' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2141010900999', '', 'Gynecology - Counselling - General - other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2141010000800', '', 'Gynecology - Counselling - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2142020200000', '', 'Gynecology - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2142020000800', '', 'Gynecology - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143130301201', '', 'Gynecology - Management - Medical - Menstrual Regulation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143130301202', '', 'Gynecology - Management - Medical - Erratic mensturation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143130301999', '', 'Gynecology - Management - Medical - Other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143130000800', '', 'Gynecology - Management - Medical - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302401', '', 'Gynecology - Management - Surgical - Cryosurgery' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302402', '', 'Gynecology - Management - Surgical - Cauterisation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302501', '', 'Gynecology - Management - Surgical - Cervical Cancer Related - Loop Electrosurgical Excision Procedure (LEEP)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302701', '', 'Gynecology - Management - Surgical - Breast cancer' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302306', '', 'Gynecology - Management - Surgical - Menstrual Regulation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302999', '', 'Gynecology - Management - Surgical - other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2143230302800', '', 'Gynecology - Management - Surgical - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2144040402101', '', 'Gynecology - Prevention - Screening - PAP (sampling procedure)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2144040402102', '', 'Gynecology - Prevention - Screening - PAP (lab test)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2144040402103', '', 'Gynecology - Prevention - Screening - Visual inspection (VIA or VILI)' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2144040402800', '', 'Gynecology - Prevention - Screening - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050501000', '', 'Gynecology - Investigation - Diagnostic Imaging - other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050501101', '', 'Gynecology - Investigation - Diagnostic Imaging - Mamography' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050501102', '', 'Gynecology - Investigation - Diagnostic Imaging - Colposcopy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050502101', '', 'Gynecology - Investigation - Examination - Manual breast exam' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050502102', '', 'Gynecology - Investigation - Examination - Bimanual pelvic exam' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050502999', '', 'Gynecology - Investigation - Examination - other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050503000', '', 'Gynecology - Investigation - Lab test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050504000', '', 'Gynecology - Investigation - Sampling procedure' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2145050000800', '', 'Gynecology - Investigation - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2151010131000', '', 'Obstetrics - Counselling - Ante natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2151010132000', '', 'Obstetrics - Counselling - Post natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2151010000800', '', 'Obstetrics - Counselling - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2152020221000', '', 'Obstetrics - Consultation - Ante natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2152020222000', '', 'Obstetrics - Consultation - Post natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2152020000800', '', 'Obstetrics - Consultation - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2153130301401', '', 'Obstetrics -Management - Medical - Vaginal Delivery' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2153130301402', '', 'Obstetrics -Management - Medical - EmOC' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2153130301800', '', 'Obstetrics - management - Medical - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2153230302501', '', 'Obstetrics - Management - Surgical - C-Section' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2153230302800', '', 'Obstetrics - Management - Surgical - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2154040401301', '', 'Obstetrics - Prevention - Prophylaxis - Ante-natal vaccinations' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050501201', '', 'Obstetrics - Investigations - Diagnostic imaging - Ante natal ultrasound' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050501202', '', 'Obstetrics - Investigations - Diagnostic imaging - Post natal ultrasound' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2152088000000', '', 'Obstetrics - Investigations - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050502201', '', 'Obstetrics - Investigations - Examination - Ante natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050503202', '', 'Obstetrics - Investigations - Examination - Post natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050503301', '', 'Obstetrics - Investigations - Lab tests - Pregnancy test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050503401', '', 'Obstetrics - Investigations - Lab tests - Ante natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050503402', '', 'Obstetrics - Investigations - Lab tests - Post natal' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2155050504000', '', 'Obstetrics - Investigations - Sampling procedure' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2161010100000', '', 'Urology - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2162020200000', '', 'Urology - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2163130301000', '', 'Urology - Management - Medical' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2163230302601', '', 'Urology - Management - Surgery - Male Circumcision' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2163230302999', '', 'Urology - Management - Surgery - other' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2163230000800', '', 'Urology - Management - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2164040402201', '', 'Urology - Prevention - Screening - Prostate cancer' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2165050501000', '', 'Urology - Investigations - Diagnostic Imaging' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2165050502000', '', 'Urology - Investigations - Examination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2165050503000', '', 'Urology - Investigations - Lab test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2165050504000', '', 'Urology - Investigations - Sampling procedure' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2165050000800', '', 'Urology - Investigations - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2171110000000', '', 'Subfertility - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2171110000800', '', 'Subfertility - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2172120000000', '', 'Subfertility - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2173130301203', '', 'Subfertility - Management - Medical - Hormone / ovulation therapy' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2173130301403', '', 'Subfertility - Management - Medical - Assisted Conception' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2173130301800', '', 'Subfertility - Management - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2173230302000', '', 'Subfertility - Management - Surgery' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2174040501000', '', 'Subfertility - Investigations - Diagnostic imaging' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2174040502000', '', 'Subfertility - Investigations - Examination' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2174040503000', '', 'Subfertility - Investigations - Lab test' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2174040504000', '', 'Subfertility - Investigations - Sampling procedure' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2174040000800', '', 'Subfertility - Investigations - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2181110141001', '', 'Specialised SRH services - Consultation - First line support' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2181110141002', '', 'Specialised SRH services - Consultation - Referral for clinical, psychosocial and protection services for survivors of violence' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2181110141000', '', 'Specialised SRH services - Counselling - GBV' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2181210142000', '', 'Specialised SRH services - Counselling - Relationship' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2181310143000', '', 'Specialised SRH services - Counselling - Sexuality' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2181310144000', '', 'Specialised SRH services - Counselling - Menstrual health' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2184140100301', '', 'Specialised SRH services - Prevention - Screening - GBV' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2184100000800', '', 'Specialised SRH Services - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2191010000000', '', 'Paediatrics - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2192020000000', '', 'Paediatrics - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2193030000000', '', 'Paediatrics - Management' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2194040000000', '', 'Paediatrics - Prevention' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2195050000000', '', 'Paediatrics - Investigations' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2196000000800', '', 'Paediatrics - unable to categorise' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2201010000000', '', 'SRH - Other - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2202020000000', '', 'SRH - Other - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2203030000000', '', 'SRH - Other - Management' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2204040000000', '', 'SRH - Other - Prevention' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '2205050000000', '', 'SRH - Other - Investigation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '4100000000000', '', 'Administration' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010000000', '', 'Non-SRH Medical - Counselling' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010900201', '', 'Non-SRH Medical - Counselling - General - Diabetes' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010900202', '', 'Non-SRH Medical - Counselling - General - Hypertension' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010900203', '', 'Non-SRH Medical - Counselling - General - Hyperlipidemia' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010900301', '', 'Non-SRH Medical - Counselling - General - Mental health' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010900401', '', 'Non-SRH Medical - Counselling - General - Obesity' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010123201', '', 'Non-SRH Medical - Counselling - Risk reduction - Diabetes' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010123202', '', 'Non-SRH Medical - Counselling - Risk reduction - Hypertension' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010123203', '', 'Non-SRH Medical - Counselling - Risk reduction - Hyperlipidemia' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010123204', '', 'Non-SRH Medical - Counselling - Risk reduction - COPD' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3110010123501', '', 'Non-SRH Medical - Counselling - Risk reduction - Alcohol' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3120020000000', '', 'Non-SRH Medical - Consultation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3120020900201', '', 'Non-SRH Medical - Consultation - General - Diabetes' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3120020900202', '', 'Non-SRH Medical - Consultation - General - Hypertension' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3120020900203', '', 'Non-SRH Medical - Consultation - General - Hyperlipidemia' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3130030000000', '', 'Non-SRH Medical - Management' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3130030101201', '', 'Non-SRH Medical - Management - Medical - Diabetes' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3130030101202', '', 'Non-SRH Medical - Management - Medical - Hypertension' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3130030101203', '', 'Non-SRH Medical - Management - Medical - Hyperlipidemia' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3130030101204', '', 'Non-SRH Medical - Management - Medical - COPD' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3130030101301', '', 'Non-SRH Medical - Management - Medical - Mental health' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3140040000000', '', 'Non-SRH Medical - Prevention' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3140040402201', '', 'Non-SRH Medical - Prevention - Screening - Diabetes' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3140040402202', '', 'Non-SRH Medical - Prevention - Screening - Hypertension' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3140040402203', '', 'Non-SRH Medical - Prevention - Screening - Hyperlipidemia' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3150050000000', '', 'Non-SRH Medical - Investigation' );
INSERT INTO codes ( code_type, code, modifier, code_text ) VALUES ( 31, '3150000000800', '', 'Non-SRH Medical - unable to categorise' );
