1 DELETE FROM list_options WHERE list_id = 'contrameth';
2 INSERT INTO list_options VALUES ('contrameth','abs','Abstinence' , 1,0,0);
3 INSERT INTO list_options VALUES ('contrameth','con','Condom (Male or Female)' , 2,0,0);
4 INSERT INTO list_options VALUES ('contrameth','dia','Diaphragm' , 3,0,0);
5 INSERT INTO list_options VALUES ('contrameth','ec' ,'Emergency Contraception' , 4,0,0);
6 INSERT INTO list_options VALUES ('contrameth','fab','Fertility Awareness Based' , 5,0,0);
7 INSERT INTO list_options VALUES ('contrameth','fc' ,'Foam & Condom' , 6,0,0);
8 INSERT INTO list_options VALUES ('contrameth','pat','Hormonal Patch' , 7,0,0);
9 INSERT INTO list_options VALUES ('contrameth','imp','Implant' , 8,0,0);
10 INSERT INTO list_options VALUES ('contrameth','inj','Injectable' , 9,0,0);
11 INSERT INTO list_options VALUES ('contrameth','iud','IUCD' ,10,0,0);
12 INSERT INTO list_options VALUES ('contrameth','or' ,'Oral' ,11,0,0);
13 INSERT INTO list_options VALUES ('contrameth','cap','Pessary/Cervicap Cap' ,12,0,0);
14 INSERT INTO list_options VALUES ('contrameth','sp' ,'Spermicides' ,13,0,0);
15 INSERT INTO list_options VALUES ('contrameth','vsc','Voluntary Surgical Contraception',14,0,0);
16 INSERT INTO list_options VALUES ('contrameth','wd' ,'Withdrawl' ,15,0,0);
17 INSERT INTO list_options VALUES ('contrameth','no' ,'None' ,16,0,0);
18 INSERT INTO list_options VALUES ('contrameth','oth','Other (specify)' ,17,0,0);
20 DELETE FROM list_options WHERE list_id = 'mcreason';
21 INSERT INTO list_options VALUES ('mcreason' ,'sef','Side Effects of Current Method' , 1,0,0);
22 INSERT INTO list_options VALUES ('mcreason' ,'pop','Partner Opposes' , 2,0,0);
23 INSERT INTO list_options VALUES ('mcreason' ,'eco','Economic (cost)' , 3,0,0);
24 INSERT INTO list_options VALUES ('mcreason' ,'com','Method Too Complicated' , 4,0,0);
25 INSERT INTO list_options VALUES ('mcreason' ,'med','Medical/Health Condition' , 5,0,0);
26 INSERT INTO list_options VALUES ('mcreason' ,'men','Menopause' , 6,0,0);
27 INSERT INTO list_options VALUES ('mcreason' ,'rel','Religious' , 7,0,0);
28 INSERT INTO list_options VALUES ('mcreason' ,'mov','Personal - Moved Away' , 8,0,0);
29 INSERT INTO list_options VALUES ('mcreason' ,'prv','Personal - Privacy' , 9,0,0);
30 INSERT INTO list_options VALUES ('mcreason' ,'oop','Personal - Social/Family Pressure',10,0,0);
31 INSERT INTO list_options VALUES ('mcreason' ,'con','Personal - Lacks Confidence' ,11,0,0);
32 INSERT INTO list_options VALUES ('mcreason' ,'prg','Wants to Become Pregnant' ,12,0,0);
33 INSERT INTO list_options VALUES ('mcreason' ,'oth','Other' ,13,0,0);
35 DELETE FROM list_options WHERE list_id = 'abreasons';
36 INSERT INTO list_options VALUES ('abreasons' ,'lif','Danger to life of pregnant woman' , 1,0,0);
37 INSERT INTO list_options VALUES ('abreasons' ,'phy','Grave injury to physical health of pregnant woman' , 2,0,0);
38 INSERT INTO list_options VALUES ('abreasons' ,'men','Grave injury to mental health of pregnant woman' , 3,0,0);
39 INSERT INTO list_options VALUES ('abreasons' ,'rap','Pregnancy caused by rape' , 4,0,0);
40 INSERT INTO list_options VALUES ('abreasons' ,'abn','Substantial risk that child would be severely handicapped by abnormalities', 5,0,0);
41 INSERT INTO list_options VALUES ('abreasons' ,'con','Failure of contraceptive device or method' , 6,0,0);
42 INSERT INTO list_options VALUES ('abreasons' ,'env','Risk to health of woman in current or forseeable environment' , 7,0,0);
43 INSERT INTO list_options VALUES ('abreasons' ,'oth','Other (specify)' , 8,0,0);
45 DELETE FROM list_options WHERE list_id = 'flowtype';
46 INSERT INTO list_options VALUES ('flowtype' ,'lit','Light' , 1,0,0);
47 INSERT INTO list_options VALUES ('flowtype' ,'mod','Moderate', 2,0,0);
48 INSERT INTO list_options VALUES ('flowtype' ,'hvy','Heavy' , 3,0,0);
50 DELETE FROM list_options WHERE list_id = 'lists' AND seq > 50;
51 INSERT INTO list_options VALUES ('lists' ,'contrameth','Contraceptive Methods' ,51,0,0);
52 INSERT INTO list_options VALUES ('lists' ,'mcreason' ,'Reason for Method Change/Termination',52,0,0);
53 INSERT INTO list_options VALUES ('lists' ,'abreasons' ,'Reasons for Abortion' ,58,0,0);
54 INSERT INTO list_options VALUES ('lists' ,'flowtype' ,'Flow Types' ,59,0,0);
56 UPDATE layout_options SET data_type = 1, list_id = 'occupations' WHERE form_id = 'DEM' AND field_id = 'occupation';
57 DELETE FROM list_options WHERE list_id = 'occupations' AND option_id = 'oth';
58 INSERT INTO list_options VALUES ('occupations','oth','Other', 1,0,0);
59 INSERT INTO list_options VALUES ('lists','occupations','Occupations',61,0,0);
61 UPDATE layout_options SET title = 'Religion' WHERE form_id = 'DEM' AND field_id = 'userlist5';
62 UPDATE layout_options SET title = 'Monthly Income' WHERE form_id = 'DEM' AND field_id = 'userlist3';
64 DELETE FROM codes WHERE code_type = '11';
65 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'FAMILY PLANNING METHODS - TOTAL', '110000000', 11, '' );
66 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - ORAL CONTRACEPTIVES - TOTAL', '111100000', 11, '' );
67 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Oral Contraceptives - OC - Method Specific Counselling', '111100119', 11, '' );
68 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Oral Contraceptives - OC - OTHER', '111100999', 11, '' );
69 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - COMBINED & PROGESTOGEN-ONLY ORAL CONTRACEPTIVES - TOTAL', '111101000', 11, '' );
70 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Oral Contraceptives - COC & POC - Initial Consultation', '111101110', 11, '' );
71 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Oral Contraceptives - COC & POC - Follow up/Resupply', '111101111', 11, '' );
72 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Oral Contraceptives - COC & POC - OTHER', '111101999', 11, '' );
73 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - INJECTABLE CONTRACEPTIVES - TOTAL', '111110000', 11, '' );
74 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Injectable Contraceptives - Method Specific Counselling', '111110119', 11, '' );
75 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Injectable Contraceptives - OTHER', '111110999', 11, '' );
76 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - COMBINED INJECTABLE CONTRACEPTIVES - CIC - TOTAL', '111111000', 11, '' );
77 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Combined Injectable Contraceptives (1 month) - Initial Consultation', '111111110', 11, '' );
78 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Combined Injectable Contraceptives (1 month) - Follow up/Resupply', '111111111', 11, '' );
79 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Combined Injectable Contraceptives (1 month) - OTHER', '111111999', 11, '' );
80 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - PROGESTOGEN ONLY INJECTABLES (2 MONTHS) - TOTAL', '111112000', 11, '' );
81 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Progestogen Only Injectables (2 months) - Initial Consultation', '111112110', 11, '' );
82 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Progestogen Only Injectables (2 months) - Follow up/Resupply', '111112111', 11, '' );
83 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Progestogen Only Injectables (2 months) - OTHER', '111112999', 11, '' );
84 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - PROGESTOGEN ONLY INJECTABLES (3 MONTHS) - TOTAL', '111113000', 11, '' );
85 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Progestogen Only Injectables (3 months) - Initial Consultation', '111113110', 11, '' );
86 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Progestogen Only Injectables (3 months) - Follow up/Resupply', '111113111', 11, '' );
87 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Progestogen Only Injectables (3 months) - OTHER', '111113999', 11, '' );
88 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SUBDERMAL IMPLANTS - TOTAL', '111120000', 11, '' );
89 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal Implants - Removal', '111120112', 11, '' );
90 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal Implants - Method Specific Counselling', '111120119', 11, '' );
91 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal Implants - OTHER', '111120999', 11, '' );
92 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SUBDERMAL IMPLANTS 6 rods - TOTAL', '111122000', 11, '' );
93 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 6 rods - Initial Consultation/Insertion', '111122110', 11, '' );
94 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 6 rods - Follow up/Reinsertion', '111122111', 11, '' );
95 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 6 rods - OTHER', '111122999', 11, '' );
96 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SUBDERMAL IMPLANTS 2 rods - TOTAL', '111123000', 11, '' );
97 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 2 rods - Initial Consultation/Insertion', '111123110', 11, '' );
98 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 2 rods - Follow up/Reinsertion', '111123111', 11, '' );
99 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 2 rods - OTHER', '111123999', 11, '' );
100 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SUBDERMAL IMPLANTS 1 rods - TOTAL', '111124000', 11, '' );
101 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 1 rod - Initial Consultation/Insertion', '111124110', 11, '' );
102 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 1 rod - Follow up/Reinsertion', '111124111', 11, '' );
103 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Subdermal implants 1 rod - OTHER', '111124999', 11, '' );
104 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - OTHER HORMONAL METHODS - TOTAL', '111130000', 11, '' );
105 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other hormonal methods - OTHER', '111130999', 11, '' );
106 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - OTHER - TRANSDERMAL PATCH (1 month) - TOTAL', '111132000', 11, '' );
107 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Transdermal Patch (1 month) - Initial Consultation', '111132110', 11, '' );
108 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Transdermal Patch (1 month) - Follow up/Resupply', '111132111', 11, '' );
109 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Transdermal Patch (1 month) - Method Specific Counselling', '111132119', 11, '' );
110 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Transdermal Patch (1 month) - OTHER', '111132999', 11, '' );
111 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - OTHER - VAGINAL RING (1 month) - TOTAL', '111133000', 11, '' );
112 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Vaginal Ring (1 month) - Initial Consultation', '111133110', 11, '' );
113 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Vaginal Ring (1 month) - Follow up/Resupply', '111133111', 11, '' );
114 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Vaginal Ring (1 month) - Method Specific Counselling', '111133119', 11, '' );
115 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Other methods - Vaginal Ring (1 month) - OTHER', '111133999', 11, '' );
116 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - CONDOMS - TOTAL', '112140000', 11, '' );
117 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms (Male and Female) - OTHER', '112140999', 11, '' );
118 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - MALE CONDOMS - TOTAL', '112141000', 11, '' );
119 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Male Condom - Initial Consultation', '112141110', 11, '' );
120 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Male Condom - Follow up/Resupply', '112141111', 11, '' );
121 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Male Condom - Method Specific Counselling', '112141119', 11, '' );
122 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Male Condom - OTHER', '112141999', 11, '' );
123 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - FEMALE CONDOMS - TOTAL', '112142000', 11, '' );
124 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Female Condom - Initial Consultation', '112142110', 11, '' );
125 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Female Condom - Follow up/Resupply', '112142111', 11, '' );
126 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Female Condom - Method Specific Counselling', '112142119', 11, '' );
127 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Condoms - Female Condom - OTHER', '112142999', 11, '' );
128 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - TYPES OF DIAPHRAGMS / CERVICAL CAPS - TOTAL', '112150000', 11, '' );
129 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Diaphragm / Cervical Cap - Method Specific Counselling', '112150119', 11, '' );
130 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Diaphragm / Cervical Cap - OTHER', '112150999', 11, '' );
131 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - DIAPHRAGMS - TOTAL', '112151000', 11, '' );
132 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Diaphragm - Initial Consultation', '112151110', 11, '' );
133 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Diaphragm - Follow up/Resupply', '112151111', 11, '' );
134 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Diaphragm - OTHER', '112151999', 11, '' );
135 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - CERVICAL CAPS - TOTAL', '112152000', 11, '' );
136 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Cervical Cap - Initial Consultation', '112152010', 11, '' );
137 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Cervical Cap - Follow up/Resupply', '112152011', 11, '' );
138 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Cervical Cap - OTHER', '112152999', 11, '' );
139 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SPERMICIDES - TOTAL', '112160000', 11, '' );
140 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Method Specific Counselling', '112160119', 11, '' );
141 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - OTHER', '112160999', 11, '' );
142 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SPERMICIDES - FOAM TABS/TUBE/SUPPOSITIORIES - TOTAL', '112161000', 11, '' );
143 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Tabs/Tube/Suppositories - Initial Consultation', '112161110', 11, '' );
144 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Tabs/Tube/Suppositories - Follow up/Resupply', '112161111', 11, '' );
145 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Tabs/Tube/Suppositories - OTHER', '112161999', 11, '' );
146 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SPERMICIDES - FOAM TAB/STRIPS - TOTAL', '112162000', 11, '' );
147 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Tabs/Strip - Initial Consultation', '112162110', 11, '' );
148 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Tabs/Strip - Follow up/Resupply', '112162111', 11, '' );
149 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Tabs/Strip - OTHER', '112162999', 11, '' );
150 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SPERMICIDES - FOAM CANS - TOTAL', '112163000', 11, '' );
151 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Cans - Initial Consultation', '112163110', 11, '' );
152 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Cans - Follow up/Resupply', '112163111', 11, '' );
153 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Foam Cans - OTHER', '112163999', 11, '' );
154 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SPERMICIDES - CREAM & JELLY - TOTAL', '112164000', 11, '' );
155 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Cream & Jelly - Initial Consultation', '112164110', 11, '' );
156 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Cream & Jelly - Follow up/Resupply', '112164111', 11, '' );
157 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Cream & Jelly - OTHER', '112164999', 11, '' );
158 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - SPERMICIDES - PESSARIES / C-FILM - TOTAL', '112165000', 11, '' );
159 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Pessaries / C-film - Initial Consultation', '112165110', 11, '' );
160 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Pessaries / C-film - Follow up/Resupply', '112165111', 11, '' );
161 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - Spermicides - Pessaries / C-film - OTHER', '112165999', 11, '' );
162 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - IUD - TOTAL', '113170000', 11, '' );
163 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Removal', '113170112', 11, '' );
164 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Method Specific Counselling', '113170119', 11, '' );
165 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - OTHER', '113170999', 11, '' );
166 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - IUD Hormone releasing IUD (5 years) - TOTAL', '113171000', 11, '' );
167 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Hormone releasing IUD (5 years) - Initial Consultation/Insertion', '113171110', 11, '' );
168 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Hormone releasing IUD (5 years) - Follow up/Reinsertion', '113171111', 11, '' );
169 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Hormone releasing IUD (5 years) - OTHER', '113171999', 11, '' );
170 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTIVES - IUD Copper releasing IUD (10 years) - TOTAL', '113172000', 11, '' );
171 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Copper releasing IUD (10 years) - Initial Consultation/Insertion', '113172110', 11, '' );
172 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Copper releasing IUD (10 years) - Follow up/Reinsertion', '113172111', 11, '' );
173 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraceptives - IUD - Copper releasing IUD (10 years) - OTHER', '113172999', 11, '' );
174 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTION - VOLUNTARY SURGICAL CONTRACEPTION (VSC) - TOTAL', '120180000', 11, '' );
175 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception - Voluntary Surgical Contraception (VSC) - OTHER', '120180999', 11, '' );
176 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTION - FEMALE VOLUNTARY SURGICAL CONTRACEPTION (FVSC) - TOTAL', '121181000', 11, '' );
177 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Reversal', '121181112', 11, '' );
178 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Method Specific Counselling', '121181119', 11, '' );
179 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Minilaparatomy - Follow up', '121181211', 11, '' );
180 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Minilaparatomy - Contraceptive Surgery', '121181213', 11, '' );
181 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Laparoscopy - Follow up', '121181311', 11, '' );
182 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Laparoscopy - Contraceptive Surgery', '121181313', 11, '' );
183 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Laparotomy - Follow up', '121181411', 11, '' );
184 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - Laparotomy - Contraceptive Surgery', '121181413', 11, '' );
185 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Female VSC - OTHER', '121181999', 11, '' );
186 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTION - MALE VOLUNTARY SURGICAL CONTRACEPTION (MVSC) - TOTAL', '122182000', 11, '' );
187 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - Reversal', '122182112', 11, '' );
188 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - Method Specific Counselling', '122182119', 11, '' );
189 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - Incisional vasectomy - Follow up (Sperm count)', '122182211', 11, '' );
190 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - Incisional vasectomy - Contraceptive Surgery', '122182213', 11, '' );
191 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - No-scalpel Vasectomy - Follow up (Sperm count)', '122182311', 11, '' );
192 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - No-scalpel Vasectomy - Contraceptive Surgery', '122182313', 11, '' );
193 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception Surgical - Male VSC - OTHER', '122182999', 11, '' );
194 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTION - AWARENESS-BASED METHODS - TOTAL', '130190000', 11, '' );
195 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception - Awareness-Based Methods - OTHER', '130190999', 11, '' );
196 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CONTRACEPTION - FERTILITY AWARENESS-BASED METHODS (FABM) - TOTAL', '131191000', 11, '' );
197 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Method Specific Counselling', '131191119', 11, '' );
198 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Cervical Mucous Method (CMM) - Initial Consultation/Training', '131191210', 11, '' );
199 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Cervical Mucous Method (CMM) - Follow up/Training', '131191211', 11, '' );
200 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Calendar Based Method (CBM) - Initial Consultation/Training', '131191310', 11, '' );
201 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Calendar Based Method (CBM) - Follow up/Training', '131191311', 11, '' );
202 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Sympto-thermal method - Initial Consultation/Training', '131191410', 11, '' );
203 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Sympto-thermal method - Follow up/Training', '131191411', 11, '' );
204 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Standard days method - Initial Consultation/Training', '131191510', 11, '' );
205 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Standard days method - Follow up/Training', '131191511', 11, '' );
206 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Basal Body Temperature (BBT) - Initial Consultation/Training', '131191610', 11, '' );
207 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception FAB Methods - Basal Body Temperature (BBT) - Follow up/Training', '131191611', 11, '' );
208 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception - FAB Methods - OTHER', '131191999', 11, '' );
209 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'FAMILY PLANNING GENERAL COUNSELLING - TOTAL', '141200000', 11, '' );
210 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception - FP General Counselling', '141200118', 11, '' );
211 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception - FP General Counselling - Combined Counselling (FP - HIV/AIDS incl. Dual protection', '141200218', 11, '' );
212 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Contraception - FP General Counselling - OTHER', '141200999', 11, '' );
213 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EMERGENCY CONTRACEPTION SERVICES - TOTAL', '145210000', 11, '' );
214 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Emergency Contraception Services - OTHER', '145210999', 11, '' );
215 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - COUNSELLING - TOTAL', '145211000', 11, '' );
216 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - Counselling', '145211119', 11, '' );
217 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - Counselling - OTHER', '145211999', 11, '' );
218 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - THERAPEUTIC - TOTAL', '145212000', 11, '' );
219 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - Combined Oral Contraceptives - Yuzpe - Contraceptive Supply (Treatment)', '145212110', 11, '' );
220 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - Combined Oral Contraceptives - Yuzpe - Follow Up', '145212111', 11, '' );
221 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC Progestogen Only Pills - Contraceptive Supply (Treatment)', '145212210', 11, '' );
222 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC Progestogen Only Pills - Follow Up', '145212211', 11, '' );
223 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC Dedicated Product - Contraceptive Supply (Treatment)', '145212310', 11, '' );
224 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC Dedicated Product - Follow Up', '145212311', 11, '' );
225 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC Copper releasing IUD - DIU Insertion (Treatment)', '145212410', 11, '' );
226 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC Copper releasing IUD - Follow Up', '145212411', 11, '' );
227 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EC - Therapeutic - OTHER', '145212999', 11, '' );
228 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'SRH (NON FAMILY PLANNING) SERVICES - TOTAL', '250000000', 11, '' );
229 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION SERVICES - TOTAL', '252220000', 11, '' );
230 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Services - OTHER', '252220999', 11, '' );
231 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION / PRE ABORTION COUNSELLING - TOTAL', '252221000', 11, '' );
232 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Counselling - Pre - Abortion Counseling', '252221129', 11, '' );
233 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Counselling - Counselling on HIV Testing', '252221229', 11, '' );
234 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Counselling - OTHER', '252221999', 11, '' );
235 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION / PRE-ABORTION CONSULTATION (DIAGNOSTICS) - TOTAL', '252222000', 11, '' );
236 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Diagnosis - Exclusion of Anaemia (Haemoglobin/Hematocrit tests)', '252222121', 11, '' );
237 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Diagnosis - Tests for ABO and Rhesus (Rh) blood groups typing', '252222221', 11, '' );
238 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Diagnosis - Exclusion of ectopic pregnancy (through ultrasound)', '252222321', 11, '' );
239 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Diagnosis - Cervical cytology (Pap smear citology test)', '252222421', 11, '' );
240 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Diagnosis - HIV testing', '252222521', 11, '' );
241 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Diagnosis - OTHER', '252222999', 11, '' );
242 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION / INDUCED ABORTION (SURGICAL) - TOTAL', '252223000', 11, '' );
243 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Induced (Surgical) - Dilatation And Curettage (D&C)', '252223123', 11, '' );
244 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Induced (Surgical) - Dilatation And Evacuation (D&E) (2nd trimester of pregnancy)', '252223223', 11, '' );
245 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Induced (Surgical) - Manual Vacuum Aspiration (MVA)', '252223323', 11, '' );
246 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Induced (Surgical) - OTHER', '252223999', 11, '' );
247 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION (MEDICAL) - TOTAL', '252224000', 11, '' );
248 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Care - Induced Abortion (Medical) - Pharmaceutical/Medical', '252224122', 11, '' );
249 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Care - Induced Abortion (Medical) - OTHER', '252224999', 11, '' );
250 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION / INCOMPLETE ABORTION TREATMENT (SURGICAL/MEDICAL) - TOTAL', '252225000', 11, '' );
251 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion (Incomplete Abortion) - Surgical / D&C', '252225123', 11, '' );
252 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion (Incomplete Abortion) - Surgical / MVA', '252225223', 11, '' );
253 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion (Incomplete Abortion) - Medical / Pharmaceutical', '252225722', 11, '' );
254 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion (Incomplete Abortion) - Surgical/Medical OTHER', '252225999', 11, '' );
255 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION / POST ABORTION CARE - TOTAL', '252226000', 11, '' );
256 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Care - Post - Follow-up incl. Uterine Involution Monitoring & Bimanual Pelvic Exam.', '252226120', 11, '' );
257 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Care - Post - OTHER', '252226999', 11, '' );
258 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ABORTION / POST ABORTION COUNSELLING - TOTAL', '252227000', 11, '' );
259 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Counselling - Post Abortion Counseling - Including Family Planning', '252227129', 11, '' );
260 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Abortion Counselling - Post Abortion Counseling - OTHER', '252227999', 11, '' );
261 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS SERVICES - TOTAL', '253230000', 11, '' );
262 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Services - OTHER', '253230999', 11, '' );
263 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS TREATMENT CONSULTATION - TOTAL', '253231000', 11, '' );
264 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Consult - Treatment- Anti Retro Viral (ARV)', '253231122', 11, '' );
265 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Consult - Treatment - Opportunistic Infection (OI)', '253231222', 11, '' );
266 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Consult - Treatment - Post Exposure Prophylaxis (PEP)', '253231322', 11, '' );
267 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Consult - Treatment - Psycho-Social Support', '253231422', 11, '' );
268 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Consult - Treatment - Home Care', '253231522', 11, '' );
269 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Consult - Treatment - OTHER', '253231999', 11, '' );
270 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS SERO STATUS LAB TESTS - TOTAL', '253232000', 11, '' );
271 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Antibody Lab Tests - ELISA (Blood) Test', '253232121', 11, '' );
272 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Antibody Lab Tests - Western Blot (WB) Assay', '253232221', 11, '' );
273 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Antibody Lab Tests - Indirect Immunofluorescence Assay (IFA)', '253232321', 11, '' );
274 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Other Lab Tests - Rapid Test (Murex-SUDS)', '253232421', 11, '' );
275 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Other Lab Tests - OTHER', '253232999', 11, '' );
276 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS LAB TESTS (OTHER) - TOTAL', '253233000', 11, '' );
277 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Other Lab Tests - Urine Test for HIV', '253233121', 11, '' );
278 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Other Lab Tests - Assessment of Immunologic Function (Viral Load)', '253233221', 11, '' );
279 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Other Lab Tests - Assessment of Immunologic Function (CD4 count)', '253233321', 11, '' );
280 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Other Lab Tests - OTHER', '253233999', 11, '' );
281 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS PREVENTION COUNSELING - TOTAL', '253234000', 11, '' );
282 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Prevention Counselling', '253234129', 11, '' );
283 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Prevention Counselling - OTHER', '253234999', 11, '' );
284 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS PRE/POST TEST COUNSELLING - TOTAL', '253235000', 11, '' );
285 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Counselling - PRE Voluntary Counselling & Testing (VCT)', '253235129', 11, '' );
286 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Counselling - POST Test (Positive) - Clients Only', '253235229', 11, '' );
287 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Counseling - POST Test (Negative)', '253235329', 11, '' );
288 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Counseling - POST Test (Positive) - Sexual Partners', '253235429', 11, '' );
289 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HIV/AIDS Counseling - OTHER', '253235999', 11, '' );
290 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI SERVICES - TOTAL', '254240000', 11, '' );
291 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Services - OTHER', '254240999', 11, '' );
292 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI COUNSELLING - TOTAL', '254241000', 11, '' );
293 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Counseling - Prevention Counseling', '254241129', 11, '' );
294 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Counseling - POST Test', '254241229', 11, '' );
295 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Counseling - OTHER', '254241999', 11, '' );
296 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI CONSULTATION - TOTAL', '254242000', 11, '' );
297 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Consultation - Follow Up', '254242120', 11, '' );
298 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Consultation - OTHER', '254242999', 11, '' );
299 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI LAB TESTS - TOTAL', '254243000', 11, '' );
300 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Bacterial Vaginosis', '254243121', 11, '' );
301 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Candidiasis', '254243221', 11, '' );
302 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Chancroid', '254243321', 11, '' );
303 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Chlamydia', '254243421', 11, '' );
304 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Gonorrhea', '254243521', 11, '' );
305 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - OTHER', '254243999', 11, '' );
306 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI LAB TESTS - TOTAL', '254244000', 11, '' );
307 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Herpes Simplex (HSV)', '254244121', 11, '' );
308 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Human Papillomavirus (HPV)', '254244221', 11, '' );
309 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Syphilis', '254244321', 11, '' );
310 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Trichomoniasis', '254244421', 11, '' );
311 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Hepatitis B', '254244521', 11, '' );
312 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Test - Part I & II OTHER', '254244999', 11, '' );
313 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI TREATMENT - TOTAL', '254245000', 11, '' );
314 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Treatment - Syndromic diagnosis with clinical treatment', '254245122', 11, '' );
315 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Treatment - Etiological diagnosis with clinical treatment', '254245222', 11, '' );
316 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'STI/RTI Treatment - OTHER', '254245999', 11, '' );
317 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL SERVICES - TOTAL', '255250000', 11, '' );
318 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Services - OTHER', '255250999', 11, '' );
319 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL BIOPSY - TOTAL', '255251000', 11, '' );
320 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Biopsy - Conization', '255251123', 11, '' );
321 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Biopsy - Needle Biopsy', '255251223', 11, '' );
322 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Biopsy - Aspiration Biopsy', '255251323', 11, '' );
323 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Biopsy - Dilatation & Curretage (D&C)', '255251423', 11, '' );
324 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Biopsy - OTHER', '255251999', 11, '' );
325 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL ENDOSCOPY - TOTAL', '255252000', 11, '' );
326 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Colposcopy', '255252123', 11, '' );
327 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Laparoscopy', '255252223', 11, '' );
328 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Hysteroscopy', '255252323', 11, '' );
329 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Culdoscopy', '255252423', 11, '' );
330 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Hysteretomy', '255252523', 11, '' );
331 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Ovariectomy', '255252623', 11, '' );
332 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Mastectomy', '255252723', 11, '' );
333 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - Lumpectomy', '255252823', 11, '' );
334 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Endoscopy - OTHER', '255252999', 11, '' );
335 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL DIAGNOSTIC IMAGING - TOTAL', '255253000', 11, '' );
336 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Diagnostic Imaging - Radiography - Hysterosalpingography', '255253121', 11, '' );
337 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Diagnostic Imaging - Radiography - Mammography', '255253221', 11, '' );
338 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Diagnostic Imaging - Ultrasonography', '255253321', 11, '' );
339 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Diagnostic Imaging - Tomography', '255253421', 11, '' );
340 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Diagnostic Imaging - Dexa, Bone Density Scan', '255253521', 11, '' );
341 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Diagnostic Imaging - OTHER', '255253999', 11, '' );
342 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL EXAM DIAGNOSIS - TOTAL', '255254000', 11, '' );
343 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Exam - Manual Pelvic Exam (includes Palpation)', '255254121', 11, '' );
344 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Exam - Manual Breast Exam', '255254221', 11, '' );
345 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Exam - Vaginal Smears Sampling (Pap smear)', '255254321', 11, '' );
346 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Exam - Consultation without pelvic exam', '255254421', 11, '' );
347 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Exam - OTHER', '255254999', 11, '' );
348 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL CYTOLOGIC TESTS - TOTAL', '255255000', 11, '' );
349 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Lab Test - Cytology Analysis', '255255121', 11, '' );
350 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Lab Test - OTHER', '255255999', 11, '' );
351 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL THERAPIES - TOTAL', '255256000', 11, '' );
352 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Therapies - Menopause Consultations, Hormonal Replacement Therapy', '255256122', 11, '' );
353 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Therapies - Menstrual regulation', '255256222', 11, '' );
354 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Therapies - Female Genital Mutilation Treatment of Complications', '255256322', 11, '' );
355 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Therapies - OTHER', '255256999', 11, '' );
356 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL SURGERIES - TOTAL', '255257000', 11, '' );
357 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Surgeries - Cryosurgery - Cervical', '255257123', 11, '' );
358 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Surgeries - Cauterization (Cervical / Vaginal)', '255257223', 11, '' );
359 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Surgeries - Female Genital Mutilation Reconstructive Surgery', '255257323', 11, '' );
360 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Surgeries - OTHER', '255257999', 11, '' );
361 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GYNECOLOGICAL COUNSELLING - TOTAL', '255258000', 11, '' );
362 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Counselling - Menopause Consultations, Counseling', '255258129', 11, '' );
363 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Counselling - Pap Smear, Importance (pre test guidance)', '255258229', 11, '' );
364 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Counselling - Pap Smear, Abnormal Results (post test follow-up guidance)', '255258329', 11, '' );
365 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Counselling - Breast Exam Results, Mammography/Biopsy', '255258429', 11, '' );
366 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Counselling - Female Genital Mutilation', '255258529', 11, '' );
367 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gynecological Counselling - OTHER', '255258999', 11, '' );
368 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS SERVICES - TOTAL', '256260000', 11, '' );
369 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetric Services - OTHER', '256260999', 11, '' );
370 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - PRE NATAL DIAGNOSTIC PROCEDURES - TOTAL', '256261000', 11, '' );
371 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Diagnosis - Fetoscopy', '256261121', 11, '' );
372 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Diagnosis - Ultrasonography, Pre-natal', '256261221', 11, '' );
373 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Diagnosis - Pelvimetry', '256261321', 11, '' );
374 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Diagnosis - Placental Function Tests', '256261421', 11, '' );
375 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Diagnosis - OTHER', '256261999', 11, '' );
376 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - PRE NATAL CARE - TOTAL', '256262000', 11, '' );
377 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Care - Uterine Monitoring', '256262121', 11, '' );
378 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Care - Fetal Monitoring', '256262221', 11, '' );
379 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Care - Immunisations', '256262422', 11, '' );
380 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Care - OTHER', '256262999', 11, '' );
381 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - PRE NATAL COUNSELLING - TOTAL', '256263000', 11, '' );
382 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Counselling - Pre Natal Care Info', '256263129', 11, '' );
383 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Counselling - Unplanned Pregnancy', '256263229', 11, '' );
384 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Counselling - HIV Prevention and Testing', '256263329', 11, '' );
385 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre natal Counselling - OTHER', '256263999', 11, '' );
386 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - PREGNANCY TESTS - TOTAL', '256264000', 11, '' );
387 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Lab Tests - Pregnancy Tests - Agglutination Inhibition - Urine 1 test', '256264121', 11, '' );
388 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Lab Tests - Pregnancy Tests - Radioimmunoasays - Blood test', '256264221', 11, '' );
389 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Lab Tests - Pregnancy Tests - OTHER', '256264999', 11, '' );
390 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - PRE NATAL LAB TESTS - TOTAL', '256265000', 11, '' );
391 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - Urine 1', '256265121', 11, '' );
392 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - Glicemia de Jejum', '256265221', 11, '' );
393 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - Hemoglobin (HB)', '256265321', 11, '' );
394 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - Blood Type', '256265421', 11, '' );
395 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - VDRL', '256265521', 11, '' );
396 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - HIV', '256265621', 11, '' );
397 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - Amniocentesis', '256265721', 11, '' );
398 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - Chorionic Villi Sampling', '256265821', 11, '' );
399 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Pre-Natal Lab Tests - OTHER', '256265999', 11, '' );
400 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - SURGERY CHILD BIRTH - TOTAL', '256267000', 11, '' );
401 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Surgery - Child Birth, Vaginal Delivery', '256267123', 11, '' );
402 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Surgery - Child Birth, Cesarean Delivery', '256267223', 11, '' );
403 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Surgery - Emergency Obstetric Care (EmOC)', '256267323', 11, '' );
404 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Surgery - OTHER', '256267999', 11, '' );
405 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - POST NATAL CARE - TOTAL', '256268000', 11, '' );
406 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Post natal Care - Consultation including Uterine Involution Monitoring', '256268120', 11, '' );
407 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Post natal Care - OTHER', '256268999', 11, '' );
408 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OBSTETRICS - POST NATAL COUNSELLING - TOTAL', '256269000', 11, '' );
409 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Post-Natal Counselling - FP Methods', '256269129', 11, '' );
410 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Post-Natal Counselling - Breastfeeding Advice', '256269229', 11, '' );
411 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Post-Natal Counselling - HIV Counselling', '256269329', 11, '' );
412 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Obstetrics - Post-Natal Counselling - OTHER', '256269999', 11, '' );
413 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'UROLOGICAL SERVICES - TOTAL', '257270000', 11, '' );
414 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Services - OTHER', '257270999', 11, '' );
415 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'UROLOGICAL ENDOSCOPY - TOTAL', '257271000', 11, '' );
416 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Endoscopy - Cystoscopy', '257271123', 11, '' );
417 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Endoscopy - Ureteroscopy', '257271223', 11, '' );
418 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Endoscopy - OTHER', '257271999', 11, '' );
419 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'UROLOGICAL DIAGNOSTIC IMAGING - TOTAL', '257272000', 11, '' );
420 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnostic Imaging - Urography', '257272121', 11, '' );
421 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnostic Imaging - OTHER', '257272999', 11, '' );
422 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'UROLOGICAL DIAGNOSIS (OTHER ) - TOTAL', '257273000', 11, '' );
423 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnosis Other - Exam', '257273121', 11, '' );
424 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnosis Other - Prostate Cancer Screening', '257273221', 11, '' );
425 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnosis Other - Peniscopy', '257273321', 11, '' );
426 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnosis Other - Other Urogenital Services', '257273421', 11, '' );
427 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Diagnosis Other - OTHER', '257273999', 11, '' );
428 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'UROLOGICAL SURGERY - TOTAL', '257274000', 11, '' );
429 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Male Surgery - Biopsy', '257274123', 11, '' );
430 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Male Surgery - Circumcision', '257274223', 11, '' );
431 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Male Surgery - Other Surgical Services', '257274323', 11, '' );
432 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Urological Male Surgery - OTHER', '257274999', 11, '' );
433 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY SERVICES - TOTAL', '258280000', 11, '' );
434 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility/Subfertility - OTHER', '258280999', 11, '' );
435 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY BIOPSY - TOTAL', '258281000', 11, '' );
436 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Biopsy - Endometrial biopsy', '258281123', 11, '' );
437 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Biopsy - Testicular biopsy', '258281223', 11, '' );
438 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Biopsy - OTHER', '258281999', 11, '' );
439 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY ENDOSCOPY - TOTAL', '258282000', 11, '' );
440 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Endoscopy - Laparoscopy', '258282123', 11, '' );
441 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Endoscopy - Histeroscopy', '258282223', 11, '' );
442 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Endoscopy - OTHER', '258282999', 11, '' );
443 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY DIAGNOSTIC IMAGING - TOTAL', '258283000', 11, '' );
444 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Diagnostic Imaging - Histerosalpingography', '258283121', 11, '' );
445 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Diagnostic Imaging - Ovarian ultrasound', '258283221', 11, '' );
446 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Diagnostic Imaging - Transvaginal ecography', '258283321', 11, '' );
447 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Diagnostic Imaging - OTHER', '258283999', 11, '' );
448 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY LAB TESTS - TOTAL', '258284000', 11, '' );
449 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Post-coital test or Sims-Huhner test', '258284121', 11, '' );
450 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Fallopian Tube Patency Tests', '258284221', 11, '' );
451 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Clomiphene citrate challenge test (CCCT)', '258284321', 11, '' );
452 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Semen analysis', '258284421', 11, '' );
453 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Basal Temperature', '258284521', 11, '' );
454 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Mucose Analysis', '258284621', 11, '' );
455 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Sperm Count', '258284721', 11, '' );
456 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Spermiogram', '258284821', 11, '' );
457 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - Hormonal analysis', '258284921', 11, '' );
458 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Lab Test - OTHER', '258284999', 11, '' );
459 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY TREATMENT - TOTAL', '258286000', 11, '' );
460 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Ovulation Induction', '258286122', 11, '' );
461 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Embryo Transfer', '258286222', 11, '' );
462 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Fertilization in Vitro', '258286322', 11, '' );
463 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Gamete Intrafallopian Transfer', '258286422', 11, '' );
464 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Artificial Insemination', '258286522', 11, '' );
465 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Oocyte Donation', '258286622', 11, '' );
466 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - Zygote Intrafallopian Transfer', '258286722', 11, '' );
467 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility Treatment - OTHER', '258286999', 11, '' );
468 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY CONSULTATION - TOTAL', '258288000', 11, '' );
469 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility/Subfertility Consultation', '258288120', 11, '' );
470 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility/Subfertility Consultation - OTHER', '258288999', 11, '' );
471 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'INFERTILITY COUNSELLING - TOTAL', '258289000', 11, '' );
472 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility/Subfertility Counseling', '258289129', 11, '' );
473 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Infertility/Subfertility Counseling - OTHER', '258289999', 11, '' );
474 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OTHER SPECIALIZED COUNSELLING SERVICES - TOTAL', '260290000', 11, '' );
475 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Specialized Counselling Services - OTHER', '260290999', 11, '' );
476 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING - GBV - TOTAL', '261291000', 11, '' );
477 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Individual Counseling', '261291129', 11, '' );
478 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Support Groups for Survivors', '261291229', 11, '' );
479 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Legal Counseling', '261291329', 11, '' );
480 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Intimate Partner Sexual Abuse', '261291429', 11, '' );
481 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Intimate Partner Physical Abuse', '261291529', 11, '' );
482 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Intimate Partner Emotional Abuse', '261291629', 11, '' );
483 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - NonIntimate Partner Sexual Assalt/Rape', '261291729', 11, '' );
484 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - Screening Only - Gender Based Violence (GBV)', '261291829', 11, '' );
485 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - GBV - OTHER', '261291999', 11, '' );
486 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING - DOMESTIC VIOLENCE - TOTAL', '262292000', 11, '' );
487 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Domestic Violence, Child Abuse', '262292129', 11, '' );
488 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Domestic Violence, Screening Only Child Abuse', '262292229', 11, '' );
489 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Domestic Violence - OTHER', '262292999', 11, '' );
490 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING - FAMILY - TOTAL', '262293000', 11, '' );
491 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Family - Parent/Child Relationship', '262293129', 11, '' );
492 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Family- Family Conflict', '262293229', 11, '' );
493 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Family, Delinquency', '262293329', 11, '' );
494 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Family - OTHER', '262293999', 11, '' );
495 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING - PRE-MARITAL / MARITAL - TOTAL', '262294000', 11, '' );
496 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Pre-Marital including Pre-Marital Family Planning', '262294129', 11, '' );
497 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Marital - Relationship, Partner Negotiation', '262294229', 11, '' );
498 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Marital - Sexuality / Sexual Disfunction', '262294329', 11, '' );
499 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Marital - OTHER', '262294999', 11, '' );
500 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING - YOUTH (less than 25 yrs) - TOTAL', '262295000', 11, '' );
501 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Youth - Life Skills Counseling', '262295129', 11, '' );
502 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Youth - Sexuality', '262295229', 11, '' );
503 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Youth - Telephone / Internet Hotline Counseling', '262295329', 11, '' );
504 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Youth - SRH Counselling', '262295429', 11, '' );
505 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Youth - OTHER', '262295999', 11, '' );
506 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING - MALE - TOTAL', '262296000', 11, '' );
507 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Male - SRH Counselling', '262296129', 11, '' );
508 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Male - Sexuality', '262296229', 11, '' );
509 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Male - GBV', '262296329', 11, '' );
510 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counselling - Male - OTHER', '262296999', 11, '' );
511 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'COUNSELLING SERVICES (OTHER) - TOTAL', '263297000', 11, '' );
512 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counseling - Other - Sexuality Issues ( 25 years and over)', '263297129', 11, '' );
513 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Counseling - OTHER', '263297999', 11, '' );
514 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OTHER SRH MEDICAL SERVICES - TOTAL', '269298000', 11, '' );
515 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other SRH Medical Services - Consultation', '269298120', 11, '' );
516 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other SRH Medical Services - Diagnostic Test', '269298221', 11, '' );
517 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other SRH Medical Services - Therapy / Treatment', '269298322', 11, '' );
518 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other SRH Medical Services - Surgery', '269298423', 11, '' );
519 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other SRH Medical Services - OTHER', '269298999', 11, '' );
520 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MEDICAL SPECIALTY SERVICIES - TOTAL', '370000000', 11, '' );
521 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MEDICAL SPECIALTIES - SYSTEM ORIENTED SERVICES - TOTAL', '371300000', 11, '' );
522 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Medical Specialties - System Oriented Services - OTHER', '371300999', 11, '' );
523 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ANGIOLOGY - TOTAL', '371301000', 11, '' );
524 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Angiology - Consultation', '371301130', 11, '' );
525 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Angiology - Diagnostic Test', '371301231', 11, '' );
526 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Angiology - Therapy / Treatment', '371301332', 11, '' );
527 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Angiology - Surgery', '371301433', 11, '' );
528 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Angiology - OTHER', '371301999', 11, '' );
529 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CARDIOLOGY - TOTAL', '371311000', 11, '' );
530 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Cardiology - Consultation', '371311130', 11, '' );
531 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Cardiology - Diagnostic EKG', '371311231', 11, '' );
532 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Cardiology - Therapy / Treatment', '371311332', 11, '' );
533 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Cardiology - Surgery', '371311433', 11, '' );
534 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Cardiology - OTHER', '371311999', 11, '' );
535 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'DENTISTRY - TOTAL', '371321000', 11, '' );
536 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dentistry - Diagnosis', '371321131', 11, '' );
537 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dentistry -Therapy / Treatment', '371321232', 11, '' );
538 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dentistry - Orthodontics', '371321332', 11, '' );
539 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dentistry - Periodontics', '371321432', 11, '' );
540 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dentistry - Surgery', '371321533', 11, '' );
541 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dentistry - OTHER', '371321999', 11, '' );
542 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'DERMATOLOGY - TOTAL', '371331000', 11, '' );
543 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dermatology - Consultation', '371331130', 11, '' );
544 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dermatology - Diagnostic Test', '371331231', 11, '' );
545 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dermatology - Therapy / Treatment', '371331332', 11, '' );
546 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dermatology - Surgery', '371331433', 11, '' );
547 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Dermatology - OTHER', '371331999', 11, '' );
548 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ENDOCRINOLOGY - TOTAL', '371341000', 11, '' );
549 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Endocrinology - Consultation', '371341130', 11, '' );
550 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Endocrinology - Diagnostic Test', '371341231', 11, '' );
551 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Endocrinology - Therapy / Treatment', '371341332', 11, '' );
552 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Endocrinology - Surgery', '371341433', 11, '' );
553 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Endocrinology - OTHER', '371341999', 11, '' );
554 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GASTROENTEROLOGY - TOTAL', '371351000', 11, '' );
555 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gastroenterology - Consultation', '371351130', 11, '' );
556 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gastroenterology - Diagnostic Test', '371351231', 11, '' );
557 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gastroenterology - Therapy / Treatment', '371351332', 11, '' );
558 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gastroenterology - Surgery', '371351433', 11, '' );
559 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Gastroenterology - OTHER', '371351999', 11, '' );
560 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GENETICS - TOTAL', '371361000', 11, '' );
561 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Genetics - Counselling', '371361129', 11, '' );
562 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Genetics - Consultation', '371361230', 11, '' );
563 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Genetics - Diagnostic Test', '371361331', 11, '' );
564 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Genetics - Therapy / Treatment', '371361432', 11, '' );
565 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Genetics - OTHER', '371361999', 11, '' );
566 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'NEPHROLOGY - TOTAL', '371371000', 11, '' );
567 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Nephrology - Consultation', '371371130', 11, '' );
568 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Nephrology - Diagnostic Test', '371371231', 11, '' );
569 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Nephrology - Therapy / Treatment', '371371332', 11, '' );
570 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Nephrology - Surgery', '371371433', 11, '' );
571 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Nephrology - OTHER', '371371999', 11, '' );
572 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'NEUMOLOGY - TOTAL', '371381000', 11, '' );
573 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neumology - Consultation', '371381130', 11, '' );
574 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neumology - Diagnostic Test', '371381231', 11, '' );
575 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neumology - Therapy / Treatment', '371381332', 11, '' );
576 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neumology - Surgery', '371381433', 11, '' );
577 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neumology - OTHER', '371381999', 11, '' );
578 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'NEUROLOGY - TOTAL', '371391000', 11, '' );
579 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neurology - Consultation', '371391130', 11, '' );
580 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neurology - Diagnostic Exam', '371391231', 11, '' );
581 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neurology - Therapy / Treatment', '371391332', 11, '' );
582 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neurology - Surgery', '371391433', 11, '' );
583 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Neurology - OTHER', '371391999', 11, '' );
584 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OPHTALMOLOGY - TOTAL', '371401000', 11, '' );
585 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Ophtalmology - Consultation', '371401130', 11, '' );
586 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Ophtalmology - Diagnostic Exam', '371401231', 11, '' );
587 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Ophtalmology - Therapy / Treatment', '371401332', 11, '' );
588 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Ophtalmology - Surgery', '371401433', 11, '' );
589 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Ophtalmology - OTHER', '371401999', 11, '' );
590 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ORTHOPEDICS - TOTAL', '371411000', 11, '' );
591 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Orthopedics - Consultation', '371411130', 11, '' );
592 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Orthopedics - Diagnostic Exam', '371411231', 11, '' );
593 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Orthopedics - Therapy / Treatment', '371411332', 11, '' );
594 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Orthopedics - Surgery', '371411433', 11, '' );
595 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Orthopedics - OTHER', '371411999', 11, '' );
596 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OTHORHINOLARINGOLOGY - TOTAL', '371421000', 11, '' );
597 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Othorhinolaringology - Consultation', '371421130', 11, '' );
598 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Othorhinolaringology - Diagnostic Exam', '371421231', 11, '' );
599 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Othorhinolaringology - Therapy / Treatment', '371421332', 11, '' );
600 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Othorhinolaringology - Surgery', '371421433', 11, '' );
601 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Othorhinolaringology - OTHER', '371421999', 11, '' );
602 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PODOLOGY - TOTAL', '371431000', 11, '' );
603 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Podology - Consultation', '371431130', 11, '' );
604 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Podology - Diagnostic Exam', '371431231', 11, '' );
605 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Podology - Therapy / Treatment', '371431332', 11, '' );
606 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Podology - Surgery', '371431433', 11, '' );
607 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Podology - OTHER', '371431999', 11, '' );
608 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'RHEUMATOLOGY - TOTAL', '371441000', 11, '' );
609 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rheumatology - Consultation', '371441130', 11, '' );
610 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rheumatology - Diagnostic Exam', '371441231', 11, '' );
611 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rheumatology - Therapy / Treatment', '371441332', 11, '' );
612 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rheumatology - Surgery', '371441433', 11, '' );
613 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rheumatology - OTHER', '371441999', 11, '' );
614 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MEDICAL SPECIALTIES - DISEASE ORIENTED SERVICES - TOTAL', '372500000', 11, '' );
615 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Medical Specialties - Disease Oriented Services - OTHER', '372500999', 11, '' );
616 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OPTOMETRY - TOTAL', '372501000', 11, '' );
617 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Optometry - Consultation', '372501130', 11, '' );
618 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Optometry - Diagnostic Exam', '372501231', 11, '' );
619 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Optometry - OTHER', '372501999', 11, '' );
620 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PSYCHIATRY - TOTAL', '372511000', 11, '' );
621 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Psychiatry - Diagnostic consultation', '372511131', 11, '' );
622 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Psychiatry - Therapy / Treatment', '372511232', 11, '' );
623 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Psychiatry - OTHER', '372511999', 11, '' );
624 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PSYCHOLOGY - TOTAL', '372521000', 11, '' );
625 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Psychology - Diagnostic consultation', '372521131', 11, '' );
626 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Psychology - Therapy / Treatment', '372521232', 11, '' );
627 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Psychology - OTHER', '372521999', 11, '' );
628 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'RADIOLOGY - TOTAL', '372531000', 11, '' );
629 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Radiology - Diagnostic Imaging', '372531131', 11, '' );
630 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Radiology - Therapy / Treatment', '372531232', 11, '' );
631 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Radiology - OTHER', '372531999', 11, '' );
632 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ONCOLOGY - TOTAL', '372541000', 11, '' );
633 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Oncology - Diagnostic Test', '372541131', 11, '' );
634 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Oncology - Therapy / Treatment', '372541232', 11, '' );
635 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Oncology - Surgery', '372541333', 11, '' );
636 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Oncology - OTHER', '372541999', 11, '' );
637 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ALLERGY - TOTAL', '372551000', 11, '' );
638 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Allergy - Consultation', '372551130', 11, '' );
639 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Allergy - Diagnostic Test', '372551231', 11, '' );
640 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Allergy - Therapy / Treatment', '372551332', 11, '' );
641 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Allergy - OTHER', '372551999', 11, '' );
642 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'IMMUNOLOGY - TOTAL', '372561000', 11, '' );
643 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Immunology - Consultation', '372561130', 11, '' );
644 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Immunology - Diagnostic Test', '372561231', 11, '' );
645 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Immunology - OTHER', '372561999', 11, '' );
646 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MEDICAL SPECIALTIES - COMMUNITY ORIENTED SERVICES - TOTAL', '373600000', 11, '' );
647 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Medical Specialties - Community Oriented Services - OTHER', '373600999', 11, '' );
648 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'FAMILY HEALTH - TOTAL', '373601000', 11, '' );
649 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Hypertension Screening', '373601131', 11, '' );
650 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Physical Exam', '373601231', 11, '' );
651 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Weight & Vital Signs', '373601331', 11, '' );
652 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Diabetes Screening', '373601431', 11, '' );
653 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Urinalysis', '373601531', 11, '' );
654 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Cholesterol screening', '373601631', 11, '' );
655 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Nutrition Counseling', '373601729', 11, '' );
656 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - Diet/Weight Control Counseling', '373601829', 11, '' );
657 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Family Health - OTHER', '373601999', 11, '' );
658 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'GERIATRICS - TOTAL', '373621000', 11, '' );
659 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Geriatrics - Consultation', '373621130', 11, '' );
660 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Geriatrics - Diagnostic Test', '373621231', 11, '' );
661 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Geriatrics - Therapy / Treatment', '373621332', 11, '' );
662 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Geriatrics - OTHER', '373621999', 11, '' );
663 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PEDIATRICS - TOTAL', '373641000', 11, '' );
664 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Consultation', '373641130', 11, '' );
665 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Diagnostic - Neonatal Screening (at Birth)', '373641231', 11, '' );
666 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Diagnostic - Well Baby Care / Infant Health Check', '373641331', 11, '' );
667 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Therapy / Treatment - Nutrition', '373641432', 11, '' );
668 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Therapy / Treatment - Immunization', '373641532', 11, '' );
669 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Therapy / Treatment - Oral rehydration (ORT/ORS)', '373641632', 11, '' );
670 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Therapy / Treatment - Neonatal Intensive Care', '373641732', 11, '' );
671 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - Surgery - Circumcision', '373641833', 11, '' );
672 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pediatrics - OTHER', '373641999', 11, '' );
673 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PHYSICAL MEDICINE & REHABILITATION - TOTAL', '373661000', 11, '' );
674 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Physical Medicine & Rehabilitation - Consultation', '373661130', 11, '' );
675 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Physical Medicine & Rehabilitation - Diagnostic Test', '373661231', 11, '' );
676 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Physical Medicine & Rehabilitation - Therapy / Treatment', '373661332', 11, '' );
677 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Physical Medicine & Rehabilitation - Surgery', '373661433', 11, '' );
678 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Physical Medicine & Rehabilitation - OTHER', '373661999', 11, '' );
679 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PREVENTIVE MEDICINE - TOTAL', '373671000', 11, '' );
680 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Preventive Medicine - Consultation', '373671130', 11, '' );
681 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Preventive Medicine - Diagnostic Test', '373671231', 11, '' );
682 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Preventive Medicine - OTHER', '373671999', 11, '' );
683 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'EMERGENCY MEDICINE - TOTAL', '373681000', 11, '' );
684 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Emergency Medicine - Evaluation', '373681131', 11, '' );
685 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Emergency Medicine - Initial Treatment', '373681232', 11, '' );
686 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Emergency Medicine - Emergency Surgery', '373681333', 11, '' );
687 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Emergency Medicine - OTHER', '373681999', 11, '' );
688 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HOSPITALIZATION - TOTAL', '373691000', 11, '' );
689 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hospitalization - Ambulatory (1 day)', '373691140', 11, '' );
690 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hospitalization - Extended (>1day)', '373691241', 11, '' );
691 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hospitalization - OTHER', '373691999', 11, '' );
692 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MEDICAL SPECIALTIES DIAGNOSTIC/THERAPEUTIC PROCEDURES - TOTAL', '374700000', 11, '' );
693 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Medical Specialties - Diagnostic/Therapeutic Procedures - OTHER', '374700999', 11, '' );
694 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'HEMATOLOGY - TOTAL', '374701000', 11, '' );
695 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hematology - Consultation', '374701130', 11, '' );
696 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hematology - Diagnostic Test', '374701231', 11, '' );
697 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hematology - Therapy / Treatment', '374701332', 11, '' );
698 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Hematology - OTHER', '374701999', 11, '' );
699 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'TOXICOLOGY - TOTAL', '374721000', 11, '' );
700 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Toxicology - Consultation', '374721130', 11, '' );
701 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Toxicology - Diagnostic tests', '374721231', 11, '' );
702 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Toxicology - Therapy / Treatment', '374721332', 11, '' );
703 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Toxicology - OTHER', '374721999', 11, '' );
704 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CHEMICAL PATHOLOGY LAB TESTS - TOTAL', '374741000', 11, '' );
705 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Chemical Patology - Consultation', '374741130', 11, '' );
706 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Chemical Patology - Diagnostic Test', '374741231', 11, '' );
707 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Chemical Patology - OTHER', '374751999', 11, '' );
708 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PATHOLOGY LAB TESTS - TOTAL', '374761000', 11, '' );
709 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pathology - Consultation', '374761130', 11, '' );
710 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pathology - Diagnostic Test', '374761231', 11, '' );
711 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Pathology - OTHER', '374761999', 11, '' );
712 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MICROBIOLOGY - TOTAL', '374781000', 11, '' );
713 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Microbiology - Consultation', '374781130', 11, '' );
714 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Microbiology - Diagnostic Test', '374781231', 11, '' );
715 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Microbiology - OTHER', '374781999', 11, '' );
716 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'MEDICAL SPECIALTIES - OTHER SERVICES - TOTAL', '375800000', 11, '' );
717 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Medical Specialties - Other Services - OTHER', '375800999', 11, '' );
718 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'CHIROPRACTICE - TOTAL', '375801000', 11, '' );
719 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Chiropractice - Consultation', '375801130', 11, '' );
720 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Chiropractice - Therapy / Treatment', '375801232', 11, '' );
721 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Chiropractice - OTHER', '375801999', 11, '' );
722 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OSTEOPHATY - TOTAL', '375811000', 11, '' );
723 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Osteophaty - Consultation', '375811130', 11, '' );
724 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Osteophaty - Therapy / Treatment', '375811232', 11, '' );
725 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Osteophaty - Diagnostic Test', '375811331', 11, '' );
726 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Osteophaty - OTHER', '375811999', 11, '' );
727 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'PLASTIC SURGERY - TOTAL', '375821000', 11, '' );
728 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Plastic Surgery - Consultation', '375821130', 11, '' );
729 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Plastic Surgery - Therapy / Treatment', '375821232', 11, '' );
730 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Plastic Surgery - Surgery', '375821333', 11, '' );
731 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Plastic Surgery - OTHER', '375821999', 11, '' );
732 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OTHER NON SRH MEDICAL SERVICES - TOTAL', '375831000', 11, '' );
733 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non SRH Medical Services - Consultation', '375831130', 11, '' );
734 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non SRH Medical Services - Diagnostic Test', '375831231', 11, '' );
735 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non SRH Medical Services - Therapy / Treatment', '375831332', 11, '' );
736 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non SRH Medical Services - Surgery', '375831433', 11, '' );
737 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non SRH Medical Services - Counselling', '375831539', 11, '' );
738 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non SRH Medical Services - OTHER', '375831999', 11, '' );
739 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OTHER NON SRH SERVICES - TOTAL', '380910000', 11, '' );
740 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'ALL OTHER NON SRH SERVICES - OTHER', '380910999', 11, '' );
741 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'SALES & RENTALS - TOTAL', '380911000', 11, '' );
742 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Sales & Rentals - OTHER', '380911999', 11, '' );
743 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'SALES OF MEDICINES, SUPPLIES AND EQUIPMENT - TOTAL', '381912000', 11, '' );
744 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Sales of Medicines', '381912150', 11, '' );
745 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Sales Medical Supplies', '381912250', 11, '' );
746 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Sales Medical Equipment', '381912350', 11, '' );
747 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Sales - OTHER', '381913999', 11, '' );
748 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'RENTAL OF MEDICAL EQUIPMENT / INFRASTRUCTURE - TOTAL', '382914000', 11, '' );
749 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rental Medical Infrastructure', '382914450', 11, '' );
750 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rental Medical Infrastructure', '382914450', 11, '' );
751 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Rental Medical Equipment / Infrastructure - OTHER', '382915999', 11, '' );
752 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'NON-MEDICAL PRODUCTS AND SERVICES - TOTAL', '490000000', 11, '' );
753 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'OTHER NON MEDICAL PRODUCTS & SERVICES - TOTAL', '491990000', 11, '' );
754 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non Medical Products & Services - Sales of IEC Materials', '491990190', 11, '' );
755 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non Medical Products & Services - Other Generic Products', '491990999', 11, '' );
756 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non Medical Products & Services - Sales of IEC Services', '492992090', 11, '' );
757 INSERT INTO codes ( code_text, code, code_type, modifier ) VALUES ( 'Other Non Medical Products & Services - OTHER', '492992999', 11, '' );
759 CREATE TABLE IF NOT EXISTS lists_ippf_gcac (
760 id bigint(20) NOT NULL,
761 client_status varchar(255) NOT NULL DEFAULT '',
762 in_ab_proc varchar(255) NOT NULL DEFAULT '',
763 ab_types varchar(255) NOT NULL DEFAULT '',
764 ab_location varchar(255) NOT NULL DEFAULT '',
765 pr_status varchar(255) NOT NULL DEFAULT '',
766 gest_age_by varchar(255) NOT NULL DEFAULT '',
767 blood_group varchar(255) NOT NULL DEFAULT '',
768 sti varchar(255) NOT NULL DEFAULT '',
769 rh_factor varchar(255) NOT NULL DEFAULT '',
770 prep_procs varchar(255) NOT NULL DEFAULT '',
771 reason varchar(255) NOT NULL DEFAULT '',
772 exp_p_i varchar(255) NOT NULL DEFAULT '',
773 exp_pop varchar(255) NOT NULL DEFAULT '',
774 ab_contraind varchar(255) NOT NULL DEFAULT '',
775 screening varchar(255) NOT NULL DEFAULT '',
776 pre_op varchar(255) NOT NULL DEFAULT '',
777 anesthesia varchar(255) NOT NULL DEFAULT '',
778 side_eff varchar(255) NOT NULL DEFAULT '',
779 rec_compl varchar(255) NOT NULL DEFAULT '',
780 post_op varchar(255) NOT NULL DEFAULT '',
781 qc_ind varchar(255) NOT NULL DEFAULT '',
782 contrameth varchar(255) NOT NULL DEFAULT '',
783 fol_compl varchar(255) NOT NULL DEFAULT '',
787 DELETE FROM list_options WHERE list_id = 'clientstatus';
788 INSERT INTO list_options VALUES ('clientstatus','maaa' ,'MA Client Accepting Abortion', 1,0,0);
789 INSERT INTO list_options VALUES ('clientstatus','mara' ,'MA Client Refusing Abortion' , 2,0,0);
790 INSERT INTO list_options VALUES ('clientstatus','refout','Outbound Referral' , 3,0,0);
791 INSERT INTO list_options VALUES ('clientstatus','refin' ,'Inbound Referral' , 4,0,0);
792 DELETE FROM list_options WHERE list_id = 'in_ab_proc';
793 INSERT INTO list_options VALUES ('in_ab_proc','s_dnc','Surgical - D&C' , 1,0,0);
794 INSERT INTO list_options VALUES ('in_ab_proc','s_dne','Surgical - D&E' , 2,0,0);
795 INSERT INTO list_options VALUES ('in_ab_proc','s_mva','Surgical - MVA' , 3,0,0);
796 INSERT INTO list_options VALUES ('in_ab_proc','s_eva','Surgical - EVA' , 4,0,0);
797 INSERT INTO list_options VALUES ('in_ab_proc','s_oth','Surgical - Other' , 5,0,0);
798 INSERT INTO list_options VALUES ('in_ab_proc','m_mis','Medical - Misoprostol' , 6,0,0);
799 INSERT INTO list_options VALUES ('in_ab_proc','m_mm' ,'Medical - Mifepristone + Misoprostol', 7,0,0);
800 INSERT INTO list_options VALUES ('in_ab_proc','m_oth','Medical - Other' , 8,0,0);
801 DELETE FROM list_options WHERE list_id = 'ab_types';
802 INSERT INTO list_options VALUES ('ab_types','missed' ,'Missed Abortion' , 1,0,0);
803 INSERT INTO list_options VALUES ('ab_types','spon' ,'Spontaneous Abortion' , 2,0,0);
804 INSERT INTO list_options VALUES ('ab_types','legin' ,'Legally Induced Abortion' , 3,0,0);
805 INSERT INTO list_options VALUES ('ab_types','illegal','Illegal Abortion' , 4,0,0);
806 INSERT INTO list_options VALUES ('ab_types','unspec' ,'Unspecified Type of Abortion' , 5,0,0);
807 INSERT INTO list_options VALUES ('ab_types','legun' ,'Legally Unspecified Type of Abortion', 6,0,0);
808 INSERT INTO list_options VALUES ('ab_types','threat' ,'Threatened Abortion' , 7,0,0);
809 INSERT INTO list_options VALUES ('ab_types','fail' ,'Failed Attempted Abortion' , 8,0,0);
810 DELETE FROM list_options WHERE list_id = 'ab_location';
811 INSERT INTO list_options VALUES ('ab_location','ma' ,'MA Clinic' , 1,0,0);
812 INSERT INTO list_options VALUES ('ab_location','part' ,'Partner Site', 2,0,0);
813 INSERT INTO list_options VALUES ('ab_location','oth' ,'Other Site' , 3,0,0);
814 DELETE FROM list_options WHERE list_id = 'pr_status';
815 INSERT INTO list_options VALUES ('pr_status','n_u' ,'Normal - Urine Test' , 1,0,0);
816 INSERT INTO list_options VALUES ('pr_status','n_bpe' ,'Normal - Bimanual Pelvic Exam' , 2,0,0);
817 INSERT INTO list_options VALUES ('pr_status','a_ep' ,'Abnormal - Ectopic Pregnancy' , 3,0,0);
818 INSERT INTO list_options VALUES ('pr_status','a_mp' ,'Abnormal - Molar Pregnancy' , 4,0,0);
819 INSERT INTO list_options VALUES ('pr_status','dis' ,'Discarded' , 5,0,0);
820 DELETE FROM list_options WHERE list_id = 'gest_age_by';
821 INSERT INTO list_options VALUES ('gest_age_by','lmp','Last Monthly Period', 1,0,0);
822 INSERT INTO list_options VALUES ('gest_age_by','son','Sonogram' , 2,0,0);
823 INSERT INTO list_options VALUES ('gest_age_by','oth','Other' , 3,0,0);
824 DELETE FROM list_options WHERE list_id = 'bloodgroup';
825 INSERT INTO list_options VALUES ('bloodgroup','a' ,'A' , 1,0,0);
826 INSERT INTO list_options VALUES ('bloodgroup','b' ,'B' , 2,0,0);
827 INSERT INTO list_options VALUES ('bloodgroup','ab','AB', 3,0,0);
828 INSERT INTO list_options VALUES ('bloodgroup','o' ,'O' , 4,0,0);
829 -- DELETE FROM list_options WHERE list_id = 'sti';
830 -- INSERT INTO list_options VALUES ('sti','hiv' ,'HIV' , 1,0,0);
831 -- INSERT INTO list_options VALUES ('sti','chla','Chlamydia' , 2,0,0);
832 -- INSERT INTO list_options VALUES ('sti','gono','Gonorrhea' , 3,0,0);
833 -- INSERT INTO list_options VALUES ('sti','syph','Syphilis' , 4,0,0);
834 -- INSERT INTO list_options VALUES ('sti','hpv' ,'HPV' , 5,0,0);
835 -- INSERT INTO list_options VALUES ('sti','herp','Herpes (Type 1 and 2)', 6,0,0);
836 -- INSERT INTO list_options VALUES ('sti','tric','Trichomoniasis' , 7,0,0);
837 -- INSERT INTO list_options VALUES ('sti','oth' ,'Other' , 8,0,0);
838 DELETE FROM list_options WHERE list_id = 'rh_factor';
839 INSERT INTO list_options VALUES ('rh_factor', 'pos' ,'Positive', 1,0,0);
840 INSERT INTO list_options VALUES ('rh_factor', 'neg' ,'Negative', 2,0,0);
841 DELETE FROM list_options WHERE list_id = 'prep_procs';
842 INSERT INTO list_options VALUES ('prep_procs', 'cons','Informed Consent Signed' , 1,0,0);
843 INSERT INTO list_options VALUES ('prep_procs', 'imm' ,'Immunoglobin Given to RH(-) Patients' , 2,0,0);
844 INSERT INTO list_options VALUES ('prep_procs', 'hcg' ,'Initial HCG Level Verifying Pregnancy Status', 3,0,0);
845 INSERT INTO list_options VALUES ('prep_procs', 'hema','Hematocrit Taken for Risk Assessment' , 4,0,0);
846 INSERT INTO list_options VALUES ('prep_procs', 'vit' ,'Vital Signs Recorded' , 5,0,0);
847 DELETE FROM list_options WHERE list_id = 'exp_p_i';
848 INSERT INTO list_options VALUES ('exp_p_i', 'med' , 'Medical Procedures Explained' , 1,0,0);
849 INSERT INTO list_options VALUES ('exp_p_i', 'sur' , 'Surgical Procedures Explained' , 2,0,0);
850 INSERT INTO list_options VALUES ('exp_p_i', 'risk', 'Risks and Complications Explained', 3,0,0);
851 INSERT INTO list_options VALUES ('exp_p_i', 'side', 'Common Side Effects Explained' , 4,0,0);
852 INSERT INTO list_options VALUES ('exp_p_i', 'rec' , 'Recovery Process Explained' , 5,0,0);
853 DELETE FROM list_options WHERE list_id = 'exp_pop';
854 INSERT INTO list_options VALUES ('exp_pop', 'cont' , 'Continue Pregnancy' , 1,0,0);
855 INSERT INTO list_options VALUES ('exp_pop', 'adopt', 'Explore Adoption' , 2,0,0);
856 INSERT INTO list_options VALUES ('exp_pop', 'term' , 'Termination of Pregnancy', 3,0,0);
857 INSERT INTO list_options VALUES ('exp_pop', 'oth' , 'Other' , 4,0,0);
858 DELETE FROM list_options WHERE list_id = 'ab_contraind';
859 INSERT INTO list_options VALUES ('ab_contraind','iud' ,'IUD in Place' , 1,0,0);
860 INSERT INTO list_options VALUES ('ab_contraind','allergy' ,'Allergy to Prostaglandins/Mifepristone', 2,0,0);
861 INSERT INTO list_options VALUES ('ab_contraind','adrenal' ,'Chronic adrenal failure' , 3,0,0);
862 INSERT INTO list_options VALUES ('ab_contraind','steroid' ,'Long term corticosteroid treatment' , 4,0,0);
863 INSERT INTO list_options VALUES ('ab_contraind','anticoag','Concurrent anticouagulant therapy' , 5,0,0);
864 INSERT INTO list_options VALUES ('ab_contraind','ectopic' ,'Ectopic pregnancy' , 6,0,0);
865 INSERT INTO list_options VALUES ('ab_contraind','hem' ,'Hemorrhagic disorder' , 7,0,0);
866 INSERT INTO list_options VALUES ('ab_contraind','oth' ,'Other' , 8,0,0);
867 DELETE FROM list_options WHERE list_id = 'screening';
868 INSERT INTO list_options VALUES ('screening','gb_viol' ,'Gender-Based Violence', 1,0,0);
869 INSERT INTO list_options VALUES ('screening','fam_viol','Family Violence' , 2,0,0);
870 INSERT INTO list_options VALUES ('screening','hiv' ,'HIV' , 3,0,0);
871 INSERT INTO list_options VALUES ('screening','sti' ,'STI' , 4,0,0);
872 INSERT INTO list_options VALUES ('screening','discrim' ,'Stigma/Discrimination', 5,0,0);
873 DELETE FROM list_options WHERE list_id = 'pre_op';
874 INSERT INTO list_options VALUES ('pre_op','exam' ,'Pelvic Exam' , 1,0,0);
875 INSERT INTO list_options VALUES ('pre_op','analg' ,'Analgesic Provided' , 2,0,0);
876 INSERT INTO list_options VALUES ('pre_op','antis' ,'Antiseptic Provided' , 3,0,0);
877 INSERT INTO list_options VALUES ('pre_op','clean' ,'Cervix/Vagina Cleaned', 4,0,0);
878 INSERT INTO list_options VALUES ('pre_op','vitals','Vital Signs Recorded' , 5,0,0);
879 DELETE FROM list_options WHERE list_id = 'anesthesia';
880 INSERT INTO list_options VALUES ('anesthesia','local' ,'Local' , 1,0,0);
881 INSERT INTO list_options VALUES ('anesthesia','locsed','Local + Sedation' , 2,0,0);
882 INSERT INTO list_options VALUES ('anesthesia','sed' ,'Sedation Only' , 3,0,0);
883 INSERT INTO list_options VALUES ('anesthesia','gen' ,'General Anesthesia' , 4,0,0);
884 INSERT INTO list_options VALUES ('anesthesia','parac' ,'Paracervical Anesthesia', 5,0,0);
885 DELETE FROM list_options WHERE list_id = 'side_eff';
886 INSERT INTO list_options VALUES ('side_eff','incomp','Procedure Incomplete, Abandoned', 1,0,0);
887 INSERT INTO list_options VALUES ('side_eff','bleed' ,'Extra Bleeding' , 2,0,0);
888 INSERT INTO list_options VALUES ('side_eff','injury','Injury/Perforation' , 3,0,0);
889 INSERT INTO list_options VALUES ('side_eff','shock' ,'Shock' , 4,0,0);
890 INSERT INTO list_options VALUES ('side_eff','pain' ,'Severe Abdominal Pain' , 5,0,0);
891 INSERT INTO list_options VALUES ('side_eff','card' ,'Cardiac Arrest' , 6,0,0);
892 INSERT INTO list_options VALUES ('side_eff','anes' ,'Anesthesia Complications' , 7,0,0);
893 INSERT INTO list_options VALUES ('side_eff','oth' ,'Other, Specify' , 8,0,0);
894 DELETE FROM list_options WHERE list_id = 'complication';
895 INSERT INTO list_options VALUES ('complication','incomp' ,'Incomplete Abortion or Retention of Prod', 1,0,0);
896 INSERT INTO list_options VALUES ('complication','bleed' ,'Excessive Bleeding/Hemorrhage' , 2,0,0);
897 INSERT INTO list_options VALUES ('complication','trauma' ,'Trauma to Vagina, Cervix, or Uterus' , 3,0,0);
898 INSERT INTO list_options VALUES ('complication','shock' ,'Shock' , 4,0,0);
899 INSERT INTO list_options VALUES ('complication','infect' ,'Infection' , 5,0,0);
900 INSERT INTO list_options VALUES ('complication','ectopic','Ectopic/Molar Pregnancy' , 6,0,0);
901 INSERT INTO list_options VALUES ('complication','failed' ,'Continuing Pregnancy (Failed Attempt)' , 7,0,0);
902 INSERT INTO list_options VALUES ('complication','oth' ,'Other Complications' , 8,0,0);
903 DELETE FROM list_options WHERE list_id = 'post_op';
904 INSERT INTO list_options VALUES ('post_op','texam' ,'Tissue Examination' , 1,0,0);
905 INSERT INTO list_options VALUES ('post_op','tpath' ,'Tissue Sent for Pathology' , 2,0,0);
906 INSERT INTO list_options VALUES ('post_op','confirm','Confirmation of Completion', 3,0,0);
907 DELETE FROM list_options WHERE list_id = 'qc_ind';
908 INSERT INTO list_options VALUES ('qc_ind','eprov' ,'Emergency Written Instructions Provided', 1,0,0);
909 INSERT INTO list_options VALUES ('qc_ind','eaware','Client Aware of Emergency Procedures' , 2,0,0);
910 INSERT INTO list_options VALUES ('qc_ind','couns' ,'Contraceptive Counseling Provided' , 3,0,0);
911 INSERT INTO list_options VALUES ('qc_ind','appt' ,'Followup Appointment Recorded' , 4,0,0);
913 DELETE FROM list_options WHERE list_id = 'lists' AND seq > 69;
914 INSERT INTO list_options VALUES ('lists','clientstatus','GCAC Client Statuses' ,70,0,0);
915 INSERT INTO list_options VALUES ('lists','in_ab_proc' ,'GCAC Induced Abortion Procedures' ,71,0,0);
916 INSERT INTO list_options VALUES ('lists','ab_types' ,'GCAC Abortion Types' ,72,0,0);
917 INSERT INTO list_options VALUES ('lists','ab_location' ,'GCAC Abortion Locations' ,73,0,0);
918 INSERT INTO list_options VALUES ('lists','pr_status' ,'GCAC Pregnancy Statuses' ,74,0,0);
919 INSERT INTO list_options VALUES ('lists','gest_age_by' ,'GCAC Gestational Age Confirmed By' ,75,0,0);
920 INSERT INTO list_options VALUES ('lists','bloodgroup' ,'GCAC Blood Groups' ,76,0,0);
921 INSERT INTO list_options VALUES ('lists','sti' ,'GCAC Detection of STI' ,77,0,0);
922 INSERT INTO list_options VALUES ('lists','rh_factor' ,'GCAC RH Factor' ,78,0,0);
923 INSERT INTO list_options VALUES ('lists','prep_procs' ,'GCAC Preparation Procedures' ,79,0,0);
924 INSERT INTO list_options VALUES ('lists','exp_p_i' ,'GCAC Explanations of Procedures and Issues',81,0,0);
925 INSERT INTO list_options VALUES ('lists','exp_pop' ,'GCAC Explanations of Pregnancy Options' ,82,0,0);
926 INSERT INTO list_options VALUES ('lists','ab_contraind','GCAC Contraindications' ,83,0,0);
927 INSERT INTO list_options VALUES ('lists','screening' ,'GCAC Screening for SRHR Concerns' ,84,0,0);
928 INSERT INTO list_options VALUES ('lists','pre_op' ,'GCAC Pre-Surgery Procedures' ,85,0,0);
929 INSERT INTO list_options VALUES ('lists','anesthesia' ,'GCAC Types of Anesthesia' ,86,0,0);
930 INSERT INTO list_options VALUES ('lists','side_eff' ,'GCAC Immediate Side Effects' ,87,0,0);
931 INSERT INTO list_options VALUES ('lists','complication','GCAC Post Abortion Complications' ,88,0,0);
932 INSERT INTO list_options VALUES ('lists','post_op' ,'GCAC Post-Surgery Procedures' ,89,0,0);
933 INSERT INTO list_options VALUES ('lists','qc_ind' ,'GCAC Quality of Care Indicators' ,90,0,0);
935 CREATE TABLE IF NOT EXISTS lists_ippf_con (
936 id bigint(20) NOT NULL,
937 prev_method varchar(255) NOT NULL DEFAULT '',
938 new_method varchar(255) NOT NULL DEFAULT '',
939 reason_chg varchar(255) NOT NULL DEFAULT '',
940 reason_term varchar(255) NOT NULL DEFAULT '',
941 -- risks varchar(255) NOT NULL DEFAULT '',
942 hor_history varchar(255) NOT NULL DEFAULT '',
943 hor_lmp varchar(255) NOT NULL DEFAULT '',
944 hor_flow varchar(255) NOT NULL DEFAULT '',
945 hor_bleeding varchar(255) NOT NULL DEFAULT '',
946 hor_contra varchar(255) NOT NULL DEFAULT '',
947 iud_history varchar(255) NOT NULL DEFAULT '',
948 iud_lmp varchar(255) NOT NULL DEFAULT '',
949 iud_pain varchar(255) NOT NULL DEFAULT '',
950 iud_upos varchar(255) NOT NULL DEFAULT '',
951 iud_contra varchar(255) NOT NULL DEFAULT '',
952 sur_screen varchar(255) NOT NULL DEFAULT '',
953 sur_anes varchar(255) NOT NULL DEFAULT '',
954 sur_type varchar(255) NOT NULL DEFAULT '',
955 sur_post_ins varchar(255) NOT NULL DEFAULT '',
956 sur_contra varchar(255) NOT NULL DEFAULT '',
957 nat_reason varchar(255) NOT NULL DEFAULT '',
958 nat_method varchar(255) NOT NULL DEFAULT '',
959 emg_reason varchar(255) NOT NULL DEFAULT '',
960 emg_method varchar(255) NOT NULL DEFAULT '',
964 DELETE FROM list_options WHERE list_id = 'menhist';
965 INSERT INTO list_options VALUES ('menhist','normen' ,'Normal Menarche' , 1,0,0);
966 INSERT INTO list_options VALUES ('menhist','norlen' ,'Normal Length of Menstrual Cycle', 2,0,0);
967 INSERT INTO list_options VALUES ('menhist','norflow','Normal Flow' , 3,0,0);
968 INSERT INTO list_options VALUES ('menhist','bleed' ,'Intermenstrual Bleeding' , 4,0,0);
969 INSERT INTO list_options VALUES ('menhist','dysmen' ,'Dysmenorrhea' , 5,0,0);
970 INSERT INTO list_options VALUES ('menhist','disch' ,'Discharge' , 6,0,0);
971 INSERT INTO list_options VALUES ('menhist','oth' ,'Other' , 7,0,0);
973 DELETE FROM list_options WHERE list_id = 'lmp';
974 INSERT INTO list_options VALUES ('lmp','lw' ,'Last week' , 1,0,0);
975 INSERT INTO list_options VALUES ('lmp','lm' ,'Last month' , 2,0,0);
976 INSERT INTO list_options VALUES ('lmp','1to3','Between 1 and 3 months ago', 3,0,0);
977 INSERT INTO list_options VALUES ('lmp','gt3' ,'More than 3 months ago' , 4,0,0);
978 INSERT INTO list_options VALUES ('lmp','oth' ,'Other' , 5,0,0);
980 DELETE FROM list_options WHERE list_id = 'bleeding';
981 INSERT INTO list_options VALUES ('bleeding','none' ,'None' , 1,0,0);
982 INSERT INTO list_options VALUES ('bleeding','mod' ,'Moderate', 2,0,0);
983 INSERT INTO list_options VALUES ('bleeding','stain','Staining', 3,0,0);
984 INSERT INTO list_options VALUES ('bleeding','mild' ,'Mild' , 4,0,0);
985 INSERT INTO list_options VALUES ('bleeding','heavy','Heavy' , 5,0,0);
986 INSERT INTO list_options VALUES ('bleeding','spot' ,'Spotting', 6,0,0);
987 INSERT INTO list_options VALUES ('bleeding','sev' ,'Severe' , 7,0,0);
988 INSERT INTO list_options VALUES ('bleeding','oth' ,'Other' , 8,0,0);
990 DELETE FROM list_options WHERE list_id = 'hor_contra';
991 INSERT INTO list_options VALUES ('hor_contra','bfeed','Breast-feeding' , 1,0,0);
992 INSERT INTO list_options VALUES ('hor_contra','heart','Ishaemic Heart Disease or Stroke' , 2,0,0);
993 INSERT INTO list_options VALUES ('hor_contra','smoke','Smoking if 35 Years or More' , 3,0,0);
994 INSERT INTO list_options VALUES ('hor_contra','ht' ,'Raised Blood Pressure' , 4,0,0);
995 INSERT INTO list_options VALUES ('hor_contra','htvd' ,'Hypertension with Vascular Disease' , 5,0,0);
996 INSERT INTO list_options VALUES ('hor_contra','mig' ,'Migraine with Aura' , 6,0,0);
997 INSERT INTO list_options VALUES ('hor_contra','dia' ,'Diabetes Mellitus w/Vascular Complications' , 7,0,0);
998 INSERT INTO list_options VALUES ('hor_contra','throm','Deep Vein Thrombosis or Pulmonary' , 8,0,0);
999 INSERT INTO list_options VALUES ('hor_contra','immob','Major Surgery with Prolonged Immobilization', 9,0,0);
1000 INSERT INTO list_options VALUES ('hor_contra','tmut' ,'Known Thrombogenic Mutations' ,10,0,0);
1001 INSERT INTO list_options VALUES ('hor_contra','cvhd' ,'Complicated Valvular Heart Disease' ,11,0,0);
1002 INSERT INTO list_options VALUES ('hor_contra','bcan' ,'Breast Cancer within the Past 5 Years' ,12,0,0);
1003 INSERT INTO list_options VALUES ('hor_contra','hep' ,'Active Viral Hepatitis' ,13,0,0);
1004 INSERT INTO list_options VALUES ('hor_contra','liver','Benign or Malignant Liver Tumour' ,14,0,0);
1005 INSERT INTO list_options VALUES ('hor_contra','cirr' ,'Severe (Decompensated) Cirrhosis' ,15,0,0);
1007 DELETE FROM list_options WHERE list_id = 'menpain';
1008 INSERT INTO list_options VALUES ('menpain','none','None' , 1,0,0);
1009 INSERT INTO list_options VALUES ('menpain','lb' ,'Low Back' , 2,0,0);
1010 INSERT INTO list_options VALUES ('menpain','ab' ,'Abdominal', 3,0,0);
1011 INSERT INTO list_options VALUES ('menpain','oth' ,'Other' , 4,0,0);
1013 DELETE FROM list_options WHERE list_id = 'uteruspos';
1014 INSERT INTO list_options VALUES ('uteruspos','ant','Anteverted' , 1,0,0);
1015 INSERT INTO list_options VALUES ('uteruspos','rev','Reverted' , 2,0,0);
1016 INSERT INTO list_options VALUES ('uteruspos','mid','Mid Position', 3,0,0);
1017 INSERT INTO list_options VALUES ('uteruspos','oth','Other' , 4,0,0);
1019 DELETE FROM list_options WHERE list_id = 'iud_contra';
1020 INSERT INTO list_options VALUES ('iud_contra','preg','Known or Suspected Pregnancy' , 1,0,0);
1021 INSERT INTO list_options VALUES ('iud_contra','sep' ,'Puerperal or Post-Abortion Sepsis' , 2,0,0);
1022 INSERT INTO list_options VALUES ('iud_contra','mon' ,'Months' , 3,0,0);
1023 INSERT INTO list_options VALUES ('iud_contra','pid' ,'Pelvic Inflammatory Disease (PID)' , 4,0,0);
1024 INSERT INTO list_options VALUES ('iud_contra','sti' ,'Sexually Transmitted Infection (STI)' , 5,0,0);
1025 INSERT INTO list_options VALUES ('iud_contra','pcer','Purulent Cervicitis' , 6,0,0);
1026 INSERT INTO list_options VALUES ('iud_contra','mgt' ,'Malignancy of the Genital Tract' , 7,0,0);
1027 INSERT INTO list_options VALUES ('iud_contra','uvb' ,'Unexplained Vaginal Bleeding' , 8,0,0);
1028 INSERT INTO list_options VALUES ('iud_contra','ccan','Cervical Cancer Awaiting Treatment' , 9,0,0);
1029 INSERT INTO list_options VALUES ('iud_contra','ecan','Endometrial Cancer' ,10,0,0);
1030 INSERT INTO list_options VALUES ('iud_contra','uter','Congenital Uterine Abnormalities or Benign Tumours of the Uterus',11,0,0);
1031 INSERT INTO list_options VALUES ('iud_contra','iud' ,'IUD Placement' ,12,0,0);
1032 INSERT INTO list_options VALUES ('iud_contra','mgtd','Malignant Gestational Trophoblastic Disease' ,13,0,0);
1033 INSERT INTO list_options VALUES ('iud_contra','ptur','Known Pelvic Tuberculosis' ,14,0,0);
1035 DELETE FROM list_options WHERE list_id = 'sur_screen';
1036 INSERT INTO list_options VALUES ('sur_screen','vol' ,'The client is making a voluntary and informed choice without coercion' , 1,0,0);
1037 INSERT INTO list_options VALUES ('sur_screen','regret','Any non-medical factors likely to cause regret are identified' , 2,0,0);
1038 INSERT INTO list_options VALUES ('sur_screen','fit' ,'Clients fitness for sterilization' , 3,0,0);
1039 INSERT INTO list_options VALUES ('sur_screen','risks' ,'Conditions present that may increase the risks are identified' , 4,0,0);
1040 INSERT INTO list_options VALUES ('sur_screen','app' ,'The most appropriate surgical approach, anaesthetic regimen and type of facility are determined', 5,0,0);
1041 INSERT INTO list_options VALUES ('sur_screen','couns' ,'Counselling specific to method' , 6,0,0);
1043 DELETE FROM list_options WHERE list_id = 'sur_type';
1044 INSERT INTO list_options VALUES ('sur_type','mini','Minilaparotomy' , 1,0,0);
1045 INSERT INTO list_options VALUES ('sur_type','lap' ,'Laparoscopy' , 2,0,0);
1046 INSERT INTO list_options VALUES ('sur_type','oth' ,'Other Surgical Approaches', 3,0,0);
1048 DELETE FROM list_options WHERE list_id = 'sur_post_ins';
1049 INSERT INTO list_options VALUES ('sur_post_ins','care','How to Care for the Wound' , 1,0,0);
1050 INSERT INTO list_options VALUES ('sur_post_ins','meds','How to Use any Post-Operative Medications that are Given' , 2,0,0);
1051 INSERT INTO list_options VALUES ('sur_post_ins','rest','Instructions to Rest at Home for the Rest of the Day' , 3,0,0);
1052 INSERT INTO list_options VALUES ('sur_post_ins','warn','What Warning Signs to Look for and What to Do about Each of Them' , 4,0,0);
1053 INSERT INTO list_options VALUES ('sur_post_ins','act' ,'When to Resume Normal Activities, including Sexual Intercourse' , 5,0,0);
1054 INSERT INTO list_options VALUES ('sur_post_ins','emg' ,'Where to Go and Whom to Contact in Case of Emergency' , 6,0,0);
1055 INSERT INTO list_options VALUES ('sur_post_ins','foll','When and Where to Return for a Follow-up Visit' , 7,0,0);
1057 DELETE FROM list_options WHERE list_id = 'sur_contra';
1058 INSERT INTO list_options VALUES ('sur_contra','preg' ,'Pregnancy' , 1,0,0);
1059 INSERT INTO list_options VALUES ('sur_contra','ppart' ,'Postpartum (7 to <42 days)' , 2,0,0);
1060 INSERT INTO list_options VALUES ('sur_contra','eclam' ,'Severe pre-eclampsia/eclampsia' , 3,0,0);
1061 INSERT INTO list_options VALUES ('sur_contra','rupt' ,'Prolonged rupture of membranes (24 hours or more)' , 4,0,0);
1062 INSERT INTO list_options VALUES ('sur_contra','psep' ,'Puerperal sepsis or intrapartum/puerperal fever' , 5,0,0);
1063 INSERT INTO list_options VALUES ('sur_contra','phem' ,'Severe antepartum or postpartum haemorrhage' , 6,0,0);
1064 INSERT INTO list_options VALUES ('sur_contra','dtraum','Severe trauma to the genital tract at the time of delivery', 7,0,0);
1065 INSERT INTO list_options VALUES ('sur_contra','asep' ,'Post-abortion sepsis' , 8,0,0);
1066 INSERT INTO list_options VALUES ('sur_contra','ahem' ,'Severe post-abortion haemorrhage' , 9,0,0);
1067 INSERT INTO list_options VALUES ('sur_contra','atraum','Severe trauma to the genital tract at the time of abortion',10,0,0);
1068 INSERT INTO list_options VALUES ('sur_contra','haema' ,'Acute haematometra' ,11,0,0);
1069 INSERT INTO list_options VALUES ('sur_contra','throm' ,'Deep vein thrombosis /pulmonary embolism' ,12,0,0);
1070 INSERT INTO list_options VALUES ('sur_contra','immob' ,'Major surgery with prolonged immobilization' ,13,0,0);
1071 INSERT INTO list_options VALUES ('sur_contra','ihd' ,'Current ischaemic heart disease' ,14,0,0);
1072 INSERT INTO list_options VALUES ('sur_contra','uvb' ,'Unexplained vaginal bleeding before evaluation' ,15,0,0);
1073 INSERT INTO list_options VALUES ('sur_contra','mgtd' ,'Malignant gestational trophoblastic disease' ,16,0,0);
1074 INSERT INTO list_options VALUES ('sur_contra','ccan' ,'Cervical cancer awaiting treatment' ,17,0,0);
1075 INSERT INTO list_options VALUES ('sur_contra','pid' ,'Pelvic inflammatory disease (PID)' ,18,0,0);
1076 INSERT INTO list_options VALUES ('sur_contra','sti' ,'Sexually transmitted infection' ,19,0,0);
1077 INSERT INTO list_options VALUES ('sur_contra','gall' ,'Current gallbladder disease' ,20,0,0);
1078 INSERT INTO list_options VALUES ('sur_contra','hep' ,'Active viral hepatitis' ,21,0,0);
1079 INSERT INTO list_options VALUES ('sur_contra','iron' ,'Iron deficiency anaemia' ,22,0,0);
1080 INSERT INTO list_options VALUES ('sur_contra','asi' ,'Local abdominal skin infection' ,23,0,0);
1081 INSERT INTO list_options VALUES ('sur_contra','brpn' ,'Acute bronchitis or pneumonia' ,24,0,0);
1082 INSERT INTO list_options VALUES ('sur_contra','sig' ,'Systemic infection or gastroenteritis' ,25,0,0);
1083 INSERT INTO list_options VALUES ('sur_contra','absur' ,'Sterilization concurrent with abdominal surgery' ,26,0,0);
1085 DELETE FROM list_options WHERE list_id = 'nat_reason';
1086 INSERT INTO list_options VALUES ('nat_reason','side','Fear of side-effects' , 1,0,0);
1087 INSERT INTO list_options VALUES ('nat_reason','god' ,'Religious or other cultural constraints', 2,0,0);
1088 INSERT INTO list_options VALUES ('nat_reason','acc' ,'Difficult access to other methods' , 3,0,0);
1089 INSERT INTO list_options VALUES ('nat_reason','oth' ,'Other' , 4,0,0);
1091 DELETE FROM list_options WHERE list_id = 'nat_method';
1092 INSERT INTO list_options VALUES ('nat_method','bbt' ,'Basal body temperature (BBT)' , 1,0,0);
1093 INSERT INTO list_options VALUES ('nat_method','bill','Cervical mucus or ovulation (Billings)', 2,0,0);
1094 INSERT INTO list_options VALUES ('nat_method','ok' ,'Calendar or rhythm (Ogino-Klaus)' , 3,0,0);
1095 INSERT INTO list_options VALUES ('nat_method','stm' ,'Sympto-thermal method' , 4,0,0);
1096 INSERT INTO list_options VALUES ('nat_method','sdm' ,'Standard days method (SDM)' , 5,0,0);
1097 INSERT INTO list_options VALUES ('nat_method','oth' ,'Other' , 6,0,0);
1099 DELETE FROM list_options WHERE list_id = 'emg_reason';
1100 INSERT INTO list_options VALUES ('emg_reason','mcop','Three or more combined oral contraceptive pills missed in consecutive days' , 1,0,0);
1101 INSERT INTO list_options VALUES ('emg_reason','mpro','One progestogen-only contraceptive pill taken 3 or more hours late' , 2,0,0);
1102 INSERT INTO list_options VALUES ('emg_reason','con' ,'Condom rupture or slippage' , 3,0,0);
1103 INSERT INTO list_options VALUES ('emg_reason','dia' ,'Diaphragm dislodgement or early removal' , 4,0,0);
1104 INSERT INTO list_options VALUES ('emg_reason','fci' ,'Failed coitus interruptus (e.g. ejaculation in vagina or on external genitalia)', 5,0,0);
1105 INSERT INTO list_options VALUES ('emg_reason','fabm','Miscalculation of the safe period when using a FABM' , 6,0,0);
1106 INSERT INTO list_options VALUES ('emg_reason','iud' ,'IUD expulsion' , 7,0,0);
1107 INSERT INTO list_options VALUES ('emg_reason','vsa' ,'victim of sexual assault' , 8,0,0);
1108 INSERT INTO list_options VALUES ('emg_reason','oth' ,'Other' , 9,0,0);
1110 DELETE FROM list_options WHERE list_id = 'emg_method';
1111 INSERT INTO list_options VALUES ('emg_method','ecp' ,'Emergency contraceptive pills (ECPs): progestogen-only or combined', 1,0,0);
1112 INSERT INTO list_options VALUES ('emg_method','opoc','Oestrogen/progestogen oral contraceptives' , 2,0,0);
1113 INSERT INTO list_options VALUES ('emg_method','iud' ,'Copper-releasing IUDs' , 3,0,0);
1114 INSERT INTO list_options VALUES ('emg_method','oth' ,'Other' , 4,0,0);
1116 INSERT INTO list_options VALUES ('lists','menhist' ,'Contraceptive Menstrual History' , 92,0,0);
1117 INSERT INTO list_options VALUES ('lists','lmp' ,'Contraceptive Last Menstrual Period' , 93,0,0);
1118 INSERT INTO list_options VALUES ('lists','bleeding' ,'Menstrual Bleeding Characteristics' , 94,0,0);
1119 INSERT INTO list_options VALUES ('lists','hor_contra' ,'Contraindications of Hormonal Contraception' , 95,0,0);
1120 INSERT INTO list_options VALUES ('lists','menpain' ,'Type of Menstrual Pain' , 96,0,0);
1121 INSERT INTO list_options VALUES ('lists','uteruspos' ,'Uterus Positions' , 97,0,0);
1122 INSERT INTO list_options VALUES ('lists','iud_contra' ,'Contraindications of Barrier/IUD Contraception' , 98,0,0);
1123 INSERT INTO list_options VALUES ('lists','sur_screen' ,'Pre-Operative Screening for Surgical Contraception', 99,0,0);
1124 INSERT INTO list_options VALUES ('lists','sur_type' ,'Types of Contraceptive Surgery' ,100,0,0);
1125 INSERT INTO list_options VALUES ('lists','sur_post_ins','Post-Operative Instructions' ,101,0,0);
1126 INSERT INTO list_options VALUES ('lists','sur_contra' ,'Contraindications of Surgical Contraception' ,102,0,0);
1127 INSERT INTO list_options VALUES ('lists','nat_reason' ,'Reasons for Adopting Natural (FABM) Contraception' ,103,0,0);
1128 INSERT INTO list_options VALUES ('lists','nat_method' ,'Types of Natural (FABM) Contraception' ,104,0,0);
1129 INSERT INTO list_options VALUES ('lists','emg_reason' ,'Reasons for Using Emergency Contraception' ,105,0,0);
1130 INSERT INTO list_options VALUES ('lists','emg_method' ,'Types of Emergency Contraception' ,106,0,0);
1132 -- The following added on 2009-01-04.
1133 -- Note history_data includes usertext11-30, userdate11-15, userarea11-12.
1135 DELETE FROM layout_options WHERE form_id = 'HIS';
1137 INSERT INTO layout_options VALUES ('HIS','usertext12' ,'1Personal','Blood Group' , 1, 1,1, 0, 0,'bloodgroup' ,1,1,'','' ,'Blood Group');
1138 INSERT INTO layout_options VALUES ('HIS','usertext13' ,'1Personal','RH Factor' , 2, 1,1, 0, 0,'rh_factor' ,1,1,'','' ,'RH Factor');
1139 INSERT INTO layout_options VALUES ('HIS','usertext11' ,'1Personal','Risk Factors' , 3,21,1, 0, 0,'riskfactors',1,1,'','' ,'Risk Factors');
1140 INSERT INTO layout_options VALUES ('HIS','exams' ,'1Personal','Exams/Tests' , 4,23,1, 0, 0,'exams' ,1,1,'','' ,'Exam and test results');
1141 INSERT INTO layout_options VALUES ('HIS','usertext14' ,'1Personal','Surgical History' , 5,25,1, 0, 0,'surghist' ,1,3,'','' ,'Surgeries with dates/notes');
1142 INSERT INTO layout_options VALUES ('HIS','coffee' ,'1Personal','Coffee' , 6, 2,1,20,255,'' ,1,1,'','' ,'Caffeine consumption');
1143 INSERT INTO layout_options VALUES ('HIS','tobacco' ,'1Personal','Tobacco' , 7, 2,1,20,255,'' ,1,1,'','' ,'Tobacco use');
1144 INSERT INTO layout_options VALUES ('HIS','alcohol' ,'1Personal','Alcohol' , 8, 2,1,20,255,'' ,1,1,'','' ,'Alcohol consumption');
1145 INSERT INTO layout_options VALUES ('HIS','sleep_patterns' ,'1Personal','Sleep Patterns' , 9, 2,1,20,255,'' ,1,1,'','' ,'Sleep patterns');
1146 INSERT INTO layout_options VALUES ('HIS','exercise_patterns' ,'1Personal','Exercise Patterns' ,10, 2,1,20,255,'' ,1,1,'','' ,'Exercise patterns');
1147 INSERT INTO layout_options VALUES ('HIS','seatbelt_use' ,'1Personal','Seatbelt Use' ,11, 2,1,20,255,'' ,1,1,'','' ,'Seatbelt use');
1148 INSERT INTO layout_options VALUES ('HIS','counseling' ,'1Personal','Counseling' ,12, 2,1,20,255,'' ,1,1,'','' ,'Counseling activities');
1149 INSERT INTO layout_options VALUES ('HIS','hazardous_activities','1Personal','Hazardous Activities',13, 2,1,20,255,'' ,1,1,'','' ,'Hazardous activities');
1151 INSERT INTO layout_options VALUES ('HIS','history_father' ,'2Relatives','Father' , 1, 2,1,20,255,'',1,1,'','' ,'');
1152 INSERT INTO layout_options VALUES ('HIS','history_mother' ,'2Relatives','Mother' , 2, 2,1,20,255,'',1,1,'','' ,'');
1153 INSERT INTO layout_options VALUES ('HIS','history_siblings' ,'2Relatives','Siblings' , 3, 2,1,20,255,'',1,1,'','' ,'');
1154 INSERT INTO layout_options VALUES ('HIS','history_spouse' ,'2Relatives','Spouse' , 4, 2,1,20,255,'',1,1,'','' ,'');
1155 INSERT INTO layout_options VALUES ('HIS','history_offspring' ,'2Relatives','Offspring' , 5, 2,1,20,255,'',1,3,'','' ,'');
1156 INSERT INTO layout_options VALUES ('HIS','relatives_cancer' ,'2Relatives','Cancer' , 6, 2,1,20,255,'',1,1,'','' ,'');
1157 INSERT INTO layout_options VALUES ('HIS','relatives_tuberculosis' ,'2Relatives','Tuberculosis' , 7, 2,1,20,255,'',1,1,'','' ,'');
1158 INSERT INTO layout_options VALUES ('HIS','relatives_diabetes' ,'2Relatives','Diabetes' , 8, 2,1,20,255,'',1,1,'','' ,'');
1159 INSERT INTO layout_options VALUES ('HIS','relatives_high_blood_pressure','2Relatives','High Blood Pressure', 9, 2,1,20,255,'',1,1,'','' ,'');
1160 INSERT INTO layout_options VALUES ('HIS','relatives_heart_problems' ,'2Relatives','Heart Problems' ,10, 2,1,20,255,'',1,1,'','' ,'');
1161 INSERT INTO layout_options VALUES ('HIS','relatives_stroke' ,'2Relatives','Stroke' ,11, 2,1,20,255,'',1,1,'','' ,'');
1162 INSERT INTO layout_options VALUES ('HIS','relatives_epilepsy' ,'2Relatives','Epilepsy' ,12, 2,1,20,255,'',1,1,'','' ,'');
1163 INSERT INTO layout_options VALUES ('HIS','relatives_mental_illness' ,'2Relatives','Mental Illness' ,13, 2,1,20,255,'',1,1,'','' ,'');
1164 INSERT INTO layout_options VALUES ('HIS','relatives_suicide' ,'2Relatives','Suicide' ,14, 2,1,20,255,'',1,3,'','' ,'');
1166 INSERT INTO layout_options VALUES ('HIS','usertext15','3Reproductive Women','Menstrual', 1,22,1, 0, 0,'genmenhist',1,1,'','' ,'Menstrual History');
1167 INSERT INTO layout_options VALUES ('HIS','usertext16','3Reproductive Women','Obstetric', 2,22,1, 0, 0,'genobshist',1,1,'','' ,'Obstetric History');
1168 INSERT INTO layout_options VALUES ('HIS','usertext17','3Reproductive Women','Abortion' , 3,22,1, 0, 0,'genabohist',1,1,'','' ,'Abortion History');
1170 INSERT INTO layout_options VALUES ('HIS','usertext18','4Reproductive General','HIV/AIDS' , 1,21,1, 0, 0,'genhivhist',1,1,'','' ,'HIV/AIDS History');
1171 INSERT INTO layout_options VALUES ('HIS','usertext19','4Reproductive General','ITS/ITR' , 2,21,1, 0, 0,'genitshist',1,1,'','' ,'ITS/ITR History');
1172 INSERT INTO layout_options VALUES ('HIS','usertext20','4Reproductive General','Fertility', 3,21,1, 0, 0,'genferhist',1,1,'','' ,'Infertility/Subfertility History');
1173 INSERT INTO layout_options VALUES ('HIS','usertext21','4Reproductive General','Urology' , 4,21,1, 0, 0,'genurohist',1,1,'','' ,'Urology History');
1175 INSERT INTO layout_options VALUES ('HIS','name_1' ,'5Other','Name/Value' ,1, 2,1,10,255,'',1,1,'','' ,'Name 1' );
1176 INSERT INTO layout_options VALUES ('HIS','value_1' ,'5Other','' ,2, 2,1,10,255,'',0,0,'','' ,'Value 1');
1177 INSERT INTO layout_options VALUES ('HIS','name_2' ,'5Other','Name/Value' ,3, 2,1,10,255,'',1,1,'','' ,'Name 2' );
1178 INSERT INTO layout_options VALUES ('HIS','value_2' ,'5Other','' ,4, 2,1,10,255,'',0,0,'','' ,'Value 2');
1179 INSERT INTO layout_options VALUES ('HIS','additional_history','5Other','Additional History',5, 3,1,30, 3,'',1,3,'' ,'' ,'Additional history notes');
1180 INSERT INTO layout_options VALUES ('HIS','userarea11','5Other','User Defined Area 11',6,3,0,30,3,'',1,3,'','','User Defined');
1181 INSERT INTO layout_options VALUES ('HIS','userarea12','5Other','User Defined Area 12',7,3,0,30,3,'',1,3,'','','User Defined');
1183 DELETE FROM list_options WHERE list_id = 'surghist';
1184 INSERT INTO list_options VALUES ('surghist','gi' ,'Gastrointestinal Tract', 1,0,0);
1185 INSERT INTO list_options VALUES ('surghist','bil' ,'Biliary System' , 2,0,0);
1186 INSERT INTO list_options VALUES ('surghist','spleen','Spleen' , 3,0,0);
1187 INSERT INTO list_options VALUES ('surghist','liver' ,'Liver' , 4,0,0);
1188 INSERT INTO list_options VALUES ('surghist','pan' ,'Pancreas' , 5,0,0);
1189 INSERT INTO list_options VALUES ('surghist','hernia','Hernia' , 6,0,0);
1190 INSERT INTO list_options VALUES ('surghist','endo' ,'Endocrine Glands' , 7,0,0);
1191 INSERT INTO list_options VALUES ('surghist','thorax','Thorax' , 8,0,0);
1192 INSERT INTO list_options VALUES ('surghist','oth' ,'Others' , 9,0,0);
1193 INSERT INTO list_options VALUES ('lists','surghist','Surgical History',110,0,0);
1195 DELETE FROM list_options WHERE list_id = 'genmenhist';
1196 INSERT INTO list_options VALUES ('genmenhist','agemen' ,'Age of Menarche' , 1,0,0);
1197 INSERT INTO list_options VALUES ('genmenhist','durabs' ,'Duration of Absence (days)' , 2,0,0);
1198 INSERT INTO list_options VALUES ('genmenhist','days' ,'Average No. of Days' , 3,0,0);
1199 INSERT INTO list_options VALUES ('genmenhist','lmp' ,'Last Normal Period (date)' , 4,0,0);
1200 INSERT INTO list_options VALUES ('genmenhist','cyclen' ,'Cycle Length (days)' , 5,0,0);
1201 INSERT INTO list_options VALUES ('genmenhist','flowlen' ,'Flow Length (days)' , 6,0,0);
1202 INSERT INTO list_options VALUES ('genmenhist','bleedflow','Flow Bleeding (L/M/H)' , 7,0,0);
1203 INSERT INTO list_options VALUES ('genmenhist','bleedslp' ,'Bleeding/spotting since last period?', 8,0,0);
1204 INSERT INTO list_options VALUES ('lists','genmenhist','General Menstrual History',111,0,0);
1206 DELETE FROM list_options WHERE list_id = 'genobshist';
1207 INSERT INTO list_options VALUES ('genobshist','npreg','Total No. of Pregnancies' , 1,0,0);
1208 INSERT INTO list_options VALUES ('genobshist','agefp','Age at First Pregnancy' , 2,0,0);
1209 INSERT INTO list_options VALUES ('genobshist','nlc' ,'Number of Living Children' , 3,0,0);
1210 INSERT INTO list_options VALUES ('genobshist','nacw' ,'How Many More Children Wanted' , 4,0,0);
1211 INSERT INTO list_options VALUES ('genobshist','nclw' ,'No. Children Now Living with You', 5,0,0);
1212 INSERT INTO list_options VALUES ('genobshist','nlb' ,'Number of Live Births' , 6,0,0);
1213 INSERT INTO list_options VALUES ('genobshist','nvd' ,'Number of Vaginal Deliveries' , 7,0,0);
1214 INSERT INTO list_options VALUES ('genobshist','ncs' ,'Number of C Sections' , 8,0,0);
1215 INSERT INTO list_options VALUES ('genobshist','dlpe' ,'Date Last Pregnancy Ended' , 9,0,0);
1216 INSERT INTO list_options VALUES ('lists','genobshist','General Obstetric History',112,0,0);
1218 DELETE FROM list_options WHERE list_id = 'genabohist';
1219 INSERT INTO list_options VALUES ('genabohist','age1st','Age at First Abortion' , 1,0,0);
1220 INSERT INTO list_options VALUES ('genabohist','nmis' ,'No. Miscarriages/Spontaneous Abortions', 2,0,0);
1221 INSERT INTO list_options VALUES ('genabohist','nstill','Number of Stillbirths' , 3,0,0);
1222 INSERT INTO list_options VALUES ('genabohist','ntubal','No. of Tubal Pregnancies (Ectopic)' , 4,0,0);
1223 INSERT INTO list_options VALUES ('genabohist','nia' ,'Number of Induced Abortions' , 5,0,0);
1224 INSERT INTO list_options VALUES ('lists','genabohist','General Abortion History',113,0,0);
1226 DELETE FROM list_options WHERE list_id = 'genhivhist';
1227 INSERT INTO list_options VALUES ('genhivhist','info' ,'Client is informed about HIV transmission' , 1,0,0);
1228 INSERT INTO list_options VALUES ('genhivhist','couns' ,'Client has received HIV Test Counselling' , 2,0,0);
1229 INSERT INTO list_options VALUES ('genhivhist','test' ,'Client has been HIV tested' , 3,0,0);
1230 INSERT INTO list_options VALUES ('genhivhist','hpos' ,'Client has tested HIV positive' , 4,0,0);
1231 INSERT INTO list_options VALUES ('genhivhist','apos' ,'Client has developed AIDS' , 5,0,0);
1232 INSERT INTO list_options VALUES ('genhivhist','infect','Client has developed an oportunistic infection' , 6,0,0);
1233 INSERT INTO list_options VALUES ('genhivhist','treat' ,'Client has received HIV/AIDS treatment' , 7,0,0);
1234 INSERT INTO list_options VALUES ('genhivhist','psych' ,'Client has received psycho-social support' , 8,0,0);
1235 INSERT INTO list_options VALUES ('genhivhist','discr' ,'Client has been victim of stigma/discrimination', 9,0,0);
1236 INSERT INTO list_options VALUES ('lists','genhivhist','HIV/AIDS Basic History',114,0,0);
1238 DELETE FROM list_options WHERE list_id = 'genitshist';
1239 INSERT INTO list_options VALUES ('genitshist','info' ,'Client is informed about ITS transmission', 1,0,0);
1240 INSERT INTO list_options VALUES ('genitshist','couns','Client has received ITS Counselling' , 2,0,0);
1241 INSERT INTO list_options VALUES ('genitshist','test' ,'Client has been ITS tested' , 3,0,0);
1242 INSERT INTO list_options VALUES ('genitshist','pos' ,'Client has tested ITS positive' , 4,0,0);
1243 INSERT INTO list_options VALUES ('genitshist','treat','Client has received ITS treatment' , 5,0,0);
1244 INSERT INTO list_options VALUES ('lists','genitshist','ITS/ITR Basic History',115,0,0);
1246 DELETE FROM list_options WHERE list_id = 'genferhist';
1247 INSERT INTO list_options VALUES ('genferhist','nc12','No conception after 12 months w/o FP & female <34 years', 1,0,0);
1248 INSERT INTO list_options VALUES ('genferhist','nc6' ,'No conception after 6 months w/o FP & female >35 years' , 2,0,0);
1249 INSERT INTO list_options VALUES ('genferhist','finc','Female is incapable of carrying a pregnancy to term' , 3,0,0);
1250 INSERT INTO list_options VALUES ('genferhist','year','Tried unsuccessfully to have a child for a year or more', 4,0,0);
1251 INSERT INTO list_options VALUES ('lists','genferhist','Infertility/Subfertility Basic History',116,0,0);
1253 DELETE FROM list_options WHERE list_id = 'genurohist';
1254 INSERT INTO list_options VALUES ('genurohist','ucon' ,'Client reports urinary concerns' , 1,0,0);
1255 INSERT INTO list_options VALUES ('genurohist','icon' ,'Client reports incontinency concerns' , 2,0,0);
1256 INSERT INTO list_options VALUES ('genurohist','infect','Client reports genital infection' , 3,0,0);
1257 INSERT INTO list_options VALUES ('genurohist','pain' ,'Client reports genital pain' , 4,0,0);
1258 INSERT INTO list_options VALUES ('genurohist','treat' ,'Client has undergone genital treatment', 5,0,0);
1259 INSERT INTO list_options VALUES ('genurohist','sur' ,'Client has undergone genital surgery' , 6,0,0);
1260 INSERT INTO list_options VALUES ('lists','genurohist','Urology Basic History',117,0,0);
1262 DELETE FROM list_options WHERE list_id = 'conrisks';
1263 DELETE FROM list_options WHERE list_id = 'lists' AND option_id = 'conrisks';
1265 -- The following added/moved/revised on 2009-01-16.
1267 DELETE FROM list_options WHERE list_id = 'sti';
1268 DELETE FROM list_options WHERE list_id = 'lists' AND option_id = 'sti';
1270 DELETE FROM layout_options WHERE form_id = 'GCA';
1271 INSERT INTO layout_options VALUES ('GCA','reason' ,'aCounseling' ,'Reason for Termination' , 1,21,1, 0, 0,'abreasons' ,1,3,'','' ,'Reasons for Termination of Pregnancy');
1272 INSERT INTO layout_options VALUES ('GCA','exp_p_i' ,'aCounseling' ,'Explanation of Procedures/Issues', 2,21,1, 2, 0,'exp_p_i' ,1,3,'','' ,'Explanation of Procedures and Issues');
1273 INSERT INTO layout_options VALUES ('GCA','exp_pop' ,'aCounseling' ,'Explanation of Pregnancy Options', 3,21,1, 2, 0,'exp_pop' ,1,3,'','' ,'Explanation of Pregnancy Options');
1274 INSERT INTO layout_options VALUES ('GCA','ab_contraind','aCounseling' ,'Contraindications' , 4,21,1, 2, 0,'ab_contraind',1,3,'','' ,'Contraindications');
1275 INSERT INTO layout_options VALUES ('GCA','screening' ,'aCounseling' ,'Screening for SRHR Concerns' , 5,21,1, 2, 0,'screening' ,1,3,'','' ,'Screening for SRHR Concerns');
1276 INSERT INTO layout_options VALUES ('GCA','client_status','bAdmission' ,'Client Status' , 1, 1,1, 0, 0,'clientstatus',1,3,'','' ,'Client Status');
1277 INSERT INTO layout_options VALUES ('GCA','in_ab_proc' ,'bAdmission' ,'Induced Abortion Procedure' , 2, 1,1, 0, 0,'in_ab_proc' ,1,3,'','' ,'Abortion Procedure Accepted or Performed');
1278 INSERT INTO layout_options VALUES ('GCA','ab_types' ,'bAdmission' ,'Abortion Types' , 3,21,1, 2, 0,'ab_types' ,1,3,'','' ,'Abortion Types');
1279 INSERT INTO layout_options VALUES ('GCA','ab_location' ,'bAdmission' ,'Abortion Location' , 4, 1,1, 0, 0,'ab_location' ,1,3,'','' ,'Where Services are Performed');
1280 INSERT INTO layout_options VALUES ('GCA','pr_status' ,'cPreparatory','Pregnancy Status Confirmed' , 1, 1,1, 0, 0,'pr_status' ,1,3,'','' ,'Pregnancy Status Confirmed');
1281 INSERT INTO layout_options VALUES ('GCA','gest_age_by' ,'cPreparatory','Gestational Age Confirmed By', 2, 1,1, 0, 0,'gest_age_by' ,1,3,'','' ,'Gestational Age Confirmed By');
1282 INSERT INTO layout_options VALUES ('GCA','usertext12' ,'cPreparatory','Blood Group' , 3, 1,1, 0, 0,'bloodgroup' ,1,3,'','H','');
1283 INSERT INTO layout_options VALUES ('GCA','usertext13' ,'cPreparatory','RH Factor' , 4, 1,1, 0, 0,'rh_factor' ,1,3,'','H','');
1284 INSERT INTO layout_options VALUES ('GCA','prep_procs' ,'cPreparatory','Preparation Procedures' , 6,21,1, 0, 0,'prep_procs' ,1,3,'','' ,'Preparation Procedures');
1285 INSERT INTO layout_options VALUES ('GCA','pre_op' ,'dIntervention','Pre-Surgery Procedures' , 1,21,1, 2, 0,'pre_op' ,1,3,'','' ,'Pre-Surgery Procedures');
1286 INSERT INTO layout_options VALUES ('GCA','anesthesia' ,'dIntervention','Anesthesia' , 2, 1,1, 0, 0,'anesthesia' ,1,3,'','' ,'Type of Anesthesia Used');
1287 INSERT INTO layout_options VALUES ('GCA','side_eff' ,'dIntervention','Immediate Side Effects' , 3,21,1, 2, 0,'side_eff' ,1,3,'','' ,'Immediate Side Effects (observed at intervention');
1288 INSERT INTO layout_options VALUES ('GCA','rec_compl' ,'dIntervention','Post-Abortion Complications' , 4,21,1, 2, 0,'complication',1,3,'','' ,'Post-Abortion Complications (observed in recovery');
1289 INSERT INTO layout_options VALUES ('GCA','post_op' ,'dIntervention','Post-Surgery Procedures' , 5,21,1, 2, 0,'post_op' ,1,3,'','' ,'Post-Surgery Procedures');
1290 INSERT INTO layout_options VALUES ('GCA','qc_ind' ,'eFollowup' ,'Quality of Care Indicators' , 1,21,1, 0, 0,'qc_ind' ,1,3,'','' ,'Quality of Care Indicators');
1291 INSERT INTO layout_options VALUES ('GCA','contrameth' ,'eFollowup' ,'Contraceptive Method' , 2,21,1, 2, 0,'contrameth' ,1,3,'','' ,'Post Abortion Contraceptive Method');
1292 INSERT INTO layout_options VALUES ('GCA','fol_compl' ,'eFollowup' ,'Post-Abortion Complications' , 3,21,1, 2, 0,'complication',1,3,'','' ,'Post-Abortion Complications (observed at followup');
1294 DELETE FROM layout_options WHERE form_id = 'CON';
1295 INSERT INTO layout_options VALUES ('CON','prev_method' ,'aStatistics' ,'Last Method Used' , 1,21,1, 2, 0,'contrameth' ,1,3,'','' ,'Last Contraceptive Method Used');
1296 INSERT INTO layout_options VALUES ('CON','new_method' ,'aStatistics' ,'New Method Adopted' , 2,21,1, 2, 0,'contrameth' ,1,3,'','' ,'Contraceptive Method Adopted at This Visit');
1297 INSERT INTO layout_options VALUES ('CON','reason_chg' ,'aStatistics' ,'Reason for Method Change' , 3,21,1, 2, 0,'mcreason' ,1,3,'','' ,'Reasons for Method Change');
1298 INSERT INTO layout_options VALUES ('CON','reason_term' ,'aStatistics' ,'Reason for Method Termination', 4,21,1, 2, 0,'mcreason' ,1,3,'','' ,'Reasons for Method Termination');
1299 INSERT INTO layout_options VALUES ('CON','usertext11' ,'aStatistics' ,'General Risk Factors' , 5,21,1, 2, 0,'riskfactors' ,1,3,'','H','');
1300 INSERT INTO layout_options VALUES ('CON','hor_history' ,'bHormonal' ,'Menstrual History' , 1,21,1, 2, 0,'menhist' ,1,3,'','' ,'Menstrual History');
1301 INSERT INTO layout_options VALUES ('CON','hor_lmp' ,'bHormonal' ,'Last Menstrual Period' , 2, 1,1, 0, 0,'lmp' ,1,3,'','' ,'Last Menstrual Period');
1302 INSERT INTO layout_options VALUES ('CON','hor_flow' ,'bHormonal' ,'Nature of Menstrual Flow' , 3,21,1, 4, 0,'flowtype' ,1,3,'','' ,'Nature of Menstrual Flow');
1303 INSERT INTO layout_options VALUES ('CON','hor_bleeding' ,'bHormonal' ,'Bleeding' , 4,21,1, 4, 0,'bleeding' ,1,3,'','' ,'Menstrual Bleeding Characteristics');
1304 INSERT INTO layout_options VALUES ('CON','hor_contra' ,'bHormonal' ,'Contraindications' , 5,21,1, 1, 0,'hor_contra' ,1,3,'','' ,'Contraindications of Hormonal Contraception');
1305 INSERT INTO layout_options VALUES ('CON','iud_history' ,'cBarrier/IUD','Menstrual History' , 1,21,1, 2, 0,'menhist' ,1,3,'','' ,'Menstrual History');
1306 INSERT INTO layout_options VALUES ('CON','iud_lmp' ,'cBarrier/IUD','Last Menstrual Period' , 2, 1,1, 0, 0,'lmp' ,1,3,'','' ,'Last Menstrual Period');
1307 INSERT INTO layout_options VALUES ('CON','iud_pain' ,'cBarrier/IUD','Pain during Menses' , 3,21,1, 2, 0,'menpain' ,1,3,'','' ,'Type of Pain during Menses');
1308 INSERT INTO layout_options VALUES ('CON','iud_upos' ,'cBarrier/IUD','Uterus Position' , 4, 1,1, 0, 0,'uteruspos' ,1,3,'','' ,'Uterus Position');
1309 INSERT INTO layout_options VALUES ('CON','iud_contra' ,'cBarrier/IUD','Contraindications' , 5,21,1, 0, 0,'iud_contra' ,1,3,'','' ,'Contraindications of Barrier/IUD Contraception');
1310 INSERT INTO layout_options VALUES ('CON','sur_screen' ,'dSurgical' ,'Pre-Operative Screening' , 1,21,1, 1, 0,'sur_screen' ,1,3,'','' ,'Pre-Operative Screening for Surgical Contraception');
1311 INSERT INTO layout_options VALUES ('CON','sur_anes' ,'dSurgical' ,'Type of Anesthesia' , 2, 1,1, 0, 0,'anesthesia' ,1,3,'','' ,'Type of Anesthesia for Surgical Contraception');
1312 INSERT INTO layout_options VALUES ('CON','sur_type' ,'dSurgical' ,'Type of Surgical Approach' , 3, 1,1, 0, 0,'sur_type' ,1,3,'','' ,'Type of Contraceptive Surgery');
1313 INSERT INTO layout_options VALUES ('CON','sur_post_ins' ,'dSurgical' ,'Post-Operative Instructions' , 4,21,1, 0, 0,'sur_post_ins',1,3,'','' ,'Post-Operative Instructions');
1314 INSERT INTO layout_options VALUES ('CON','sur_contra' ,'dSurgical' ,'Contraindications' , 5,21,1, 0, 0,'sur_contra' ,1,3,'','' ,'Contraindications of Surgical Contraception');
1315 INSERT INTO layout_options VALUES ('CON','nat_reason' ,'eNatural' ,'Reason for Adopting a FABM' , 1,21,1, 2, 0,'nat_reason' ,1,3,'','' ,'Reasons for Adopting Natural Contracepation');
1316 INSERT INTO layout_options VALUES ('CON','nat_method' ,'eNatural' ,'FABM Method Adopted' , 2, 1,1, 0, 0,'nat_method' ,1,3,'','' ,'Type of Natural Contraception');
1317 INSERT INTO layout_options VALUES ('CON','emg_reason' ,'fEmergency' ,'Reason for Using EC' , 1,21,1, 1, 0,'emg_reason' ,1,3,'','' ,'Reasons for Using Emergency Contracepation');
1318 INSERT INTO layout_options VALUES ('CON','emg_method' ,'fEmergency' ,'EC Method Adopted' , 2, 1,1, 0, 0,'emg_method' ,1,3,'','' ,'Type of Emergency Contraception');
1320 CREATE TABLE IF NOT EXISTS lists_ippf_srh (
1321 id bigint(20) NOT NULL,
1322 men_hist varchar(255) NOT NULL DEFAULT '',
1323 men_compl varchar(255) NOT NULL DEFAULT '',
1324 pap_hist varchar(255) NOT NULL DEFAULT '',
1325 gyn_exams varchar(255) NOT NULL DEFAULT '',
1326 pr_status varchar(255) NOT NULL DEFAULT '',
1327 gest_age_by varchar(255) NOT NULL DEFAULT '',
1328 obs_exams varchar(255) NOT NULL DEFAULT '',
1329 pr_outcome varchar(255) NOT NULL DEFAULT '',
1330 pr_compl varchar(255) NOT NULL DEFAULT '',
1331 abo_exams varchar(255) NOT NULL DEFAULT '',
1332 hiv_exams varchar(255) NOT NULL DEFAULT '',
1333 its_exams varchar(255) NOT NULL DEFAULT '',
1334 fer_exams varchar(255) NOT NULL DEFAULT '',
1335 fer_causes varchar(255) NOT NULL DEFAULT '',
1336 fer_treat varchar(255) NOT NULL DEFAULT '',
1337 uro_exams varchar(255) NOT NULL DEFAULT '',
1338 uro_disease varchar(255) NOT NULL DEFAULT '',
1342 DELETE FROM layout_options WHERE form_id = 'SRH';
1343 INSERT INTO layout_options VALUES ('SRH','usertext15' ,'aGynecology' ,'Menstrual History' , 1,22,1, 0, 0,'genmenhist' ,1,3,'','H','');
1344 INSERT INTO layout_options VALUES ('SRH','men_hist' ,'aGynecology' ,'Recent Menstrual History' , 2,21,1, 2, 0,'menhist' ,1,3,'','','Recent Menstrual History');
1345 INSERT INTO layout_options VALUES ('SRH','men_compl' ,'aGynecology' ,'Menstrual Complications' , 3,21,1, 2, 0,'men_compl' ,1,3,'','','Menstrual Complications');
1346 INSERT INTO layout_options VALUES ('SRH','pap_hist' ,'aGynecology' ,'Pap Smear Recent History' , 4,22,1, 0, 0,'pap_hist' ,1,3,'','','Pap Smear Recent History');
1347 INSERT INTO layout_options VALUES ('SRH','gyn_exams' ,'aGynecology' ,'Gynecological Tests' , 5,23,1, 0, 0,'gyn_exams' ,1,1,'','','Gynecological test results');
1348 INSERT INTO layout_options VALUES ('SRH','pr_status' ,'bObstetrics' ,'Pregnancy Status Confirmed' , 1, 1,1, 0, 0,'pr_status' ,1,3,'','','Pregnancy Status Confirmed');
1349 INSERT INTO layout_options VALUES ('SRH','gest_age_by','bObstetrics' ,'Gestational Age Confirmed By' , 2, 1,1, 0, 0,'gest_age_by' ,1,3,'','','Gestational Age Confirmed By');
1350 INSERT INTO layout_options VALUES ('SRH','usertext12' ,'bObstetrics' ,'Blood Group' , 3, 1,1, 0, 0,'bloodgroup' ,1,3,'','H','');
1351 INSERT INTO layout_options VALUES ('SRH','usertext13' ,'bObstetrics' ,'RH Factor' , 4, 1,1, 0, 0,'rh_factor' ,1,3,'','H','');
1352 INSERT INTO layout_options VALUES ('SRH','obs_exams' ,'bObstetrics' ,'Obstetric Tests' , 5,23,1, 0, 0,'obs_exams' ,1,1,'','','Obstetric test results');
1353 INSERT INTO layout_options VALUES ('SRH','usertext16' ,'bObstetrics' ,'Obstetric History' , 6,22,1, 0, 0,'genobshist' ,1,1,'','H','');
1354 INSERT INTO layout_options VALUES ('SRH','pr_outcome' ,'bObstetrics' ,'Outcome of Last Pregnancy' , 7,21,1, 2, 0,'pr_outcome' ,1,3,'','','Outcome of Last Pregnancy');
1355 INSERT INTO layout_options VALUES ('SRH','pr_compl' ,'bObstetrics' ,'Pregnancy Complications' , 8,21,1, 2, 0,'pr_compl' ,1,3,'','','Pregnancy Complications');
1356 INSERT INTO layout_options VALUES ('SRH','usertext17' ,'cBasic RH (female only)' ,'Abortion Basic History' , 1,22,1, 0, 0,'genabohist' ,1,1,'','H','');
1357 INSERT INTO layout_options VALUES ('SRH','abo_exams' ,'cBasic RH (female only)' ,'Abortion Tests' , 2,23,1, 0, 0,'abo_exams' ,1,1,'','','Abortion test results');
1358 INSERT INTO layout_options VALUES ('SRH','usertext18' ,'dBasic RH (female and male)','HIV/AIDS Basic History' , 1,21,1, 0, 0,'genhivhist' ,1,1,'','H','');
1359 INSERT INTO layout_options VALUES ('SRH','hiv_exams' ,'dBasic RH (female and male)','HIV/AIDS Tests' , 2,23,1, 0, 0,'hiv_exams' ,1,1,'','','HIV/AIDS test results');
1360 INSERT INTO layout_options VALUES ('SRH','usertext19' ,'dBasic RH (female and male)','ITS/ITR Basic History' , 3,21,1, 0, 0,'genitshist' ,1,1,'','H','');
1361 INSERT INTO layout_options VALUES ('SRH','its_exams' ,'dBasic RH (female and male)','ITS/ITR Tests' , 4,23,1, 0, 0,'its_exams' ,1,1,'','','ITS/ITR test results');
1362 INSERT INTO layout_options VALUES ('SRH','usertext20' ,'dBasic RH (female and male)','Fertility Basic History' , 5,21,1, 0, 0,'genferhist' ,1,1,'','H','');
1363 INSERT INTO layout_options VALUES ('SRH','fer_exams' ,'dBasic RH (female and male)','Fertility Tests' , 6,23,1, 0, 0,'fer_exams' ,1,1,'','','Infertility/subfertility test results');
1364 INSERT INTO layout_options VALUES ('SRH','fer_causes' ,'dBasic RH (female and male)','Causes of Infertility' , 7,21,1, 2, 0,'fer_causes' ,1,3,'','','Causes of Infertility');
1365 INSERT INTO layout_options VALUES ('SRH','fer_treat' ,'dBasic RH (female and male)','Infertility Treatment' , 8,21,1, 2, 0,'fer_treat' ,1,3,'','','Infertility Treatment');
1366 INSERT INTO layout_options VALUES ('SRH','usertext20' ,'dBasic RH (female and male)','Urology Basic History' , 9,21,1, 0, 0,'genurohist' ,1,1,'','H','');
1367 INSERT INTO layout_options VALUES ('SRH','uro_exams' ,'dBasic RH (female and male)','Urology Tests' ,10,23,1, 0, 0,'uro_exams' ,1,1,'','','Urology test results');
1368 INSERT INTO layout_options VALUES ('SRH','uro_disease','dBasic RH (female and male)','Male Genitourinary diseases' ,11,21,1, 2, 0,'uro_disease' ,1,3,'','','Male Genitourinary diseases');
1370 DELETE FROM list_options WHERE list_id = 'men_compl';
1371 INSERT INTO list_options VALUES ('men_compl','bleed' ,'Heavy Menstrual Bleeding' , 1,0,0);
1372 INSERT INTO list_options VALUES ('men_compl','nomen' ,'Absence of Menstruation' , 2,0,0);
1373 INSERT INTO list_options VALUES ('men_compl','abn' ,'Abnormal Menstrual Periods', 3,0,0);
1374 INSERT INTO list_options VALUES ('men_compl','perpain' ,'Painful Periods' , 4,0,0);
1375 INSERT INTO list_options VALUES ('men_compl','menpain' ,'Painful Menstruation' , 5,0,0);
1376 INSERT INTO list_options VALUES ('men_compl','oth' ,'Other' , 6,0,0);
1377 INSERT INTO list_options VALUES ('lists' ,'men_compl','Menstrual Complications' ,118,0,0);
1379 DELETE FROM list_options WHERE list_id = 'pap_hist';
1380 INSERT INTO list_options VALUES ('pap_hist','dtlast' ,'Date of Last Pap Smear' , 1,0,0);
1381 INSERT INTO list_options VALUES ('pap_hist','results' ,'Results of Last Pap Smear' , 2,0,0);
1382 INSERT INTO list_options VALUES ('pap_hist','treat' ,'Treatment for cervical cancer', 3,0,0);
1383 INSERT INTO list_options VALUES ('pap_hist','dtnext' ,'Date of Next Pap Smear' , 4,0,0);
1384 INSERT INTO list_options VALUES ('lists' ,'pap_hist' ,'Pap Smear History' ,119,0,0);
1386 DELETE FROM list_options WHERE list_id = 'gyn_exams';
1387 INSERT INTO list_options VALUES ('gyn_exams' ,'pap','Pap / Cytology' , 1,0,0);
1388 INSERT INTO list_options VALUES ('gyn_exams' ,'img','Diagnostic Imaging' , 2,0,0);
1389 INSERT INTO list_options VALUES ('gyn_exams' ,'hys','Hysterosalpingography' , 3,0,0);
1390 INSERT INTO list_options VALUES ('gyn_exams' ,'mam','Mammography' , 4,0,0);
1391 INSERT INTO list_options VALUES ('gyn_exams' ,'son','Ultrasonography' , 5,0,0);
1392 INSERT INTO list_options VALUES ('gyn_exams' ,'tom','Tomography' , 6,0,0);
1393 INSERT INTO list_options VALUES ('gyn_exams' ,'bds','Dexa, Bone Density Scan', 7,0,0);
1394 INSERT INTO list_options VALUES ('gyn_exams' ,'man','Manual exams' , 8,0,0);
1395 INSERT INTO list_options VALUES ('gyn_exams' ,'mpe','Manual Pelvic Exam' , 9,0,0);
1396 INSERT INTO list_options VALUES ('gyn_exams' ,'mbe','Manual Breast Exam' ,10,0,0);
1397 INSERT INTO list_options VALUES ('gyn_exams' ,'oth','Other' ,11,0,0);
1398 INSERT INTO list_options VALUES ('lists' ,'gyn_exams','Gynecological Tests',120,0,0);
1400 DELETE FROM list_options WHERE list_id = 'obs_exams';
1401 INSERT INTO list_options VALUES ('obs_exams' ,'fet','Fetoscopy' , 1,0,0);
1402 INSERT INTO list_options VALUES ('obs_exams' ,'son','Ultrasonography, Pre-natal' , 1,0,0);
1403 INSERT INTO list_options VALUES ('obs_exams' ,'pel','Pelvimetry' , 1,0,0);
1404 INSERT INTO list_options VALUES ('obs_exams' ,'pla','Placental Function Tests' , 1,0,0);
1405 INSERT INTO list_options VALUES ('obs_exams' ,'utm','Uterine Monitoring' , 1,0,0);
1406 INSERT INTO list_options VALUES ('obs_exams' ,'fem','Fetal Monitoring' , 1,0,0);
1407 INSERT INTO list_options VALUES ('obs_exams' ,'pnc','Pre natal Care - Immunisations', 1,0,0);
1408 INSERT INTO list_options VALUES ('lists' ,'obs_exams','Obstetric Tests',121,0,0);
1410 DELETE FROM list_options WHERE list_id = 'pr_outcome';
1411 INSERT INTO list_options VALUES ('pr_outcome' ,'live','Live birth' , 1,0,0);
1412 INSERT INTO list_options VALUES ('pr_outcome' ,'still','Still birth', 1,0,0);
1413 INSERT INTO list_options VALUES ('pr_outcome' ,'abo','Abortion' , 1,0,0);
1414 INSERT INTO list_options VALUES ('pr_outcome' ,'ect','Ectopic' , 1,0,0);
1415 INSERT INTO list_options VALUES ('pr_outcome' ,'oth','Other' , 1,0,0);
1416 INSERT INTO list_options VALUES ('lists','pr_outcome','Pregnancy Outcomes',122,0,0);
1418 DELETE FROM list_options WHERE list_id = 'pr_compl';
1419 INSERT INTO list_options VALUES ('pr_compl' ,'vag' ,'Bacterial Vaginosis' , 1,0,0);
1420 INSERT INTO list_options VALUES ('pr_compl' ,'rest' ,'Bed Rest' , 2,0,0);
1421 INSERT INTO list_options VALUES ('pr_compl' ,'bleed' ,'Bleeding During Pregnancy' , 3,0,0);
1422 INSERT INTO list_options VALUES ('pr_compl' ,'bofum' ,'Blighted Ovum' , 4,0,0);
1423 INSERT INTO list_options VALUES ('pr_compl' ,'cercl' ,'Cervical Cerclage' , 5,0,0);
1424 INSERT INTO list_options VALUES ('pr_compl' ,'cpox' ,'Chicken Pox' , 6,0,0);
1425 INSERT INTO list_options VALUES ('pr_compl' ,'chol' ,'Cholestasis of Pregnancy' , 7,0,0);
1426 INSERT INTO list_options VALUES ('pr_compl' ,'compl' ,'Common Pregnancy Complications' , 8,0,0);
1427 INSERT INTO list_options VALUES ('pr_compl' ,'confet' ,'Concerns regarding Early Fetal Development', 9,0,0);
1428 INSERT INTO list_options VALUES ('pr_compl' ,'cytomeg','Cytomegalovirus (CMV) Infection' ,10,0,0);
1429 INSERT INTO list_options VALUES ('pr_compl' ,'dnc' ,'D&C procedure after a Miscarriage' ,11,0,0);
1430 INSERT INTO list_options VALUES ('pr_compl' ,'ect' ,'Ectopic Pregnancy' ,12,0,0);
1431 INSERT INTO list_options VALUES ('pr_compl' ,'fasd' ,'Fetal Alcohol Spectrum Disorders' ,13,0,0);
1432 INSERT INTO list_options VALUES ('pr_compl' ,'fgr' ,'Fetal Growth Restriction' ,14,0,0);
1433 INSERT INTO list_options VALUES ('pr_compl' ,'dia' ,'Gestational Diabetes' ,15,0,0);
1434 INSERT INTO list_options VALUES ('pr_compl' ,'strep' ,'Group B Strep Infection' ,16,0,0);
1435 INSERT INTO list_options VALUES ('pr_compl' ,'hafl' ,'High Amniotic Fluid Levels: Polyhydramnios',17,0,0);
1436 INSERT INTO list_options VALUES ('pr_compl' ,'hiv' ,'HIV/AIDS during Pregnancy' ,18,0,0);
1437 INSERT INTO list_options VALUES ('pr_compl' ,'hyperm' ,'Hyperemesis Gravidarum' ,19,0,0);
1438 INSERT INTO list_options VALUES ('pr_compl' ,'incerv' ,'Incompetent Cervix' ,20,0,0);
1439 INSERT INTO list_options VALUES ('pr_compl' ,'iugr' ,'Intrauterine Growth Restriction (IUGR)' ,21,0,0);
1440 INSERT INTO list_options VALUES ('pr_compl' ,'sga' ,'Small for Gestational Age (SGA)' ,22,0,0);
1441 INSERT INTO list_options VALUES ('pr_compl' ,'list' ,'Listeria' ,23,0,0);
1442 INSERT INTO list_options VALUES ('pr_compl' ,'lafl' ,'Low Amniotic Fluid Levels: Oligohydramnios',24,0,0);
1443 INSERT INTO list_options VALUES ('pr_compl' ,'mis' ,'Miscarriage' ,25,0,0);
1444 INSERT INTO list_options VALUES ('pr_compl' ,'molar' ,'Molar Pregnancy' ,26,0,0);
1445 INSERT INTO list_options VALUES ('pr_compl' ,'accr' ,'Placenta Accreta' ,27,0,0);
1446 INSERT INTO list_options VALUES ('pr_compl' ,'prev' ,'Placenta Previa' ,28,0,0);
1447 INSERT INTO list_options VALUES ('pr_compl' ,'abrup' ,'Placental Abruption' ,29,0,0);
1448 INSERT INTO list_options VALUES ('pr_compl' ,'preecl' ,'Preeclampsia' ,30,0,0);
1449 INSERT INTO list_options VALUES ('pr_compl' ,'pih' ,'Pregnancy Induced Hypertension (PIH)' ,31,0,0);
1450 INSERT INTO list_options VALUES ('pr_compl' ,'rhf' ,'RH Factor' ,32,0,0);
1451 INSERT INTO list_options VALUES ('pr_compl' ,'sti' ,'STDs/STIs During Pregnancy' ,33,0,0);
1452 INSERT INTO list_options VALUES ('pr_compl' ,'tip' ,'Tipped Uterus' ,34,0,0);
1453 INSERT INTO list_options VALUES ('pr_compl' ,'tox' ,'Toxoplasmosis' ,35,0,0);
1454 INSERT INTO list_options VALUES ('pr_compl' ,'uti' ,'Urinary Tract Infection' ,36,0,0);
1455 INSERT INTO list_options VALUES ('pr_compl' ,'vts' ,'Vanishing Twin Syndrome' ,37,0,0);
1456 INSERT INTO list_options VALUES ('pr_compl' ,'yeast' ,'Yeast Infection' ,38,0,0);
1457 INSERT INTO list_options VALUES ('lists','pr_compl','Pregnancy Complications',123,0,0);
1459 DELETE FROM list_options WHERE list_id = 'abo_exams';
1460 INSERT INTO list_options VALUES ('abo_exams' ,'ane','Exclusion of Anaemia' , 1,0,0);
1461 INSERT INTO list_options VALUES ('abo_exams' ,'bgr','ABO and Rh blood groups' , 2,0,0);
1462 INSERT INTO list_options VALUES ('abo_exams' ,'ect','Exclusion of ectopic pregnancy', 3,0,0);
1463 INSERT INTO list_options VALUES ('abo_exams' ,'cer','Cervical cytology' , 4,0,0);
1464 INSERT INTO list_options VALUES ('abo_exams' ,'hiv','HIV testing' , 5,0,0);
1465 INSERT INTO list_options VALUES ('abo_exams' ,'oth','Other' , 6,0,0);
1466 INSERT INTO list_options VALUES ('lists' ,'abo_exams','Abortion Tests',124,0,0);
1468 DELETE FROM list_options WHERE list_id = 'hiv_exams';
1469 INSERT INTO list_options VALUES ('hiv_exams' ,'eli','ELISA (Blood) Test', 1,0,0);
1470 INSERT INTO list_options VALUES ('hiv_exams' ,'wba','Western Blot Assay', 2,0,0);
1471 INSERT INTO list_options VALUES ('hiv_exams' ,'ifa','IFA' , 3,0,0);
1472 INSERT INTO list_options VALUES ('hiv_exams' ,'rat','Rapid Test' , 4,0,0);
1473 INSERT INTO list_options VALUES ('hiv_exams' ,'uri','Urine Test for HIV', 5,0,0);
1474 INSERT INTO list_options VALUES ('hiv_exams' ,'vil','Viral Load' , 6,0,0);
1475 INSERT INTO list_options VALUES ('hiv_exams' ,'cd4','CD4 count' , 7,0,0);
1476 INSERT INTO list_options VALUES ('hiv_exams' ,'oth','Other' , 8,0,0);
1477 INSERT INTO list_options VALUES ('lists','hiv_exams','HIV/AIDS Tests',125,0,0);
1479 DELETE FROM list_options WHERE list_id = 'its_exams';
1480 INSERT INTO list_options VALUES ('its_exams' ,'vag','Bacterial Vaginosis' , 1,0,0);
1481 INSERT INTO list_options VALUES ('its_exams' ,'can','Candidiasis' , 2,0,0);
1482 INSERT INTO list_options VALUES ('its_exams' ,'cha','Chancroid' , 3,0,0);
1483 INSERT INTO list_options VALUES ('its_exams' ,'chl','Chlamydia' , 4,0,0);
1484 INSERT INTO list_options VALUES ('its_exams' ,'gon','Gonorrhea' , 5,0,0);
1485 INSERT INTO list_options VALUES ('its_exams' ,'hsv','Herpes Simplex (HSV)' , 6,0,0);
1486 INSERT INTO list_options VALUES ('its_exams' ,'hpv','Human Papillomavirus (HPV)', 7,0,0);
1487 INSERT INTO list_options VALUES ('its_exams' ,'syp','Syphilis' , 8,0,0);
1488 INSERT INTO list_options VALUES ('its_exams' ,'tri','Trichomoniasis' , 9,0,0);
1489 INSERT INTO list_options VALUES ('its_exams' ,'hep','Hepatitis B' ,10,0,0);
1490 INSERT INTO list_options VALUES ('its_exams' ,'oth','Other' ,11,0,0);
1491 INSERT INTO list_options VALUES ('lists','its_exams','ITS/ITR Tests',126,0,0);
1493 DELETE FROM list_options WHERE list_id = 'fer_exams';
1494 INSERT INTO list_options VALUES ('fer_exams' ,'end','Endometrial biopsy' , 1,0,0);
1495 INSERT INTO list_options VALUES ('fer_exams' ,'tes','Testicular biopsy' , 2,0,0);
1496 INSERT INTO list_options VALUES ('fer_exams' ,'lap','Laparoscopy' , 3,0,0);
1497 INSERT INTO list_options VALUES ('fer_exams' ,'hsc','Histeroscopy' , 4,0,0);
1498 INSERT INTO list_options VALUES ('fer_exams' ,'hsa','Histerosalpingography' , 5,0,0);
1499 INSERT INTO list_options VALUES ('fer_exams' ,'ova','Ovarian ultrasound' , 6,0,0);
1500 INSERT INTO list_options VALUES ('fer_exams' ,'tve','Transvaginal ecography' , 7,0,0);
1501 INSERT INTO list_options VALUES ('fer_exams' ,'pct','Post-coital test' , 8,0,0);
1502 INSERT INTO list_options VALUES ('fer_exams' ,'ftp','Fallopian Tube Patency Tests', 9,0,0);
1503 INSERT INTO list_options VALUES ('fer_exams' ,'ccc','CCCT' ,10,0,0);
1504 INSERT INTO list_options VALUES ('fer_exams' ,'sem','Semen analysis' ,11,0,0);
1505 INSERT INTO list_options VALUES ('fer_exams' ,'bas','Basal Temperature' ,12,0,0);
1506 INSERT INTO list_options VALUES ('fer_exams' ,'muc','Mucose Analysis' ,13,0,0);
1507 INSERT INTO list_options VALUES ('fer_exams' ,'spc','Sperm Count' ,14,0,0);
1508 INSERT INTO list_options VALUES ('fer_exams' ,'spg','Spermiogram' ,15,0,0);
1509 INSERT INTO list_options VALUES ('fer_exams' ,'hor','Hormonal analysis' ,16,0,0);
1510 INSERT INTO list_options VALUES ('fer_exams' ,'oth','Other' ,17,0,0);
1511 INSERT INTO list_options VALUES ('lists','fer_exams','Infertility/Subfertility Tests',127,0,0);
1513 DELETE FROM list_options WHERE list_id = 'fer_causes';
1514 INSERT INTO list_options VALUES ('fer_causes' ,'edy','Male erectile dysfunction' , 1,0,0);
1515 INSERT INTO list_options VALUES ('fer_causes' ,'end','Female Endometriosis' , 2,0,0);
1516 INSERT INTO list_options VALUES ('fer_causes' ,'pos','Female Polycystic ovarian syndrome', 3,0,0);
1517 INSERT INTO list_options VALUES ('fer_causes' ,'alc','Alcohol Abuse and Alcoholism' , 4,0,0);
1518 INSERT INTO list_options VALUES ('fer_causes' ,'dep','Depression' , 5,0,0);
1519 INSERT INTO list_options VALUES ('fer_causes' ,'dia','Diabetes' , 6,0,0);
1520 INSERT INTO list_options VALUES ('fer_causes' ,'hyp','High Blood Pressure' , 7,0,0);
1521 INSERT INTO list_options VALUES ('fer_causes' ,'kid','Kidney Failure' , 8,0,0);
1522 INSERT INTO list_options VALUES ('fer_causes' ,'msc','Multiple Sclerosis' , 9,0,0);
1523 INSERT INTO list_options VALUES ('fer_causes' ,'prc','Prostate Cancer' ,10,0,0);
1524 INSERT INTO list_options VALUES ('fer_causes' ,'smo','Smoking (How to Quit Smoking)' ,11,0,0);
1525 INSERT INTO list_options VALUES ('fer_causes' ,'str','Stress' ,12,0,0);
1526 INSERT INTO list_options VALUES ('fer_causes' ,'ath','Atherosclerosis' ,13,0,0);
1527 INSERT INTO list_options VALUES ('fer_causes' ,'ins','Injuries or Surgery' ,14,0,0);
1528 INSERT INTO list_options VALUES ('fer_causes' ,'med','Medications' ,15,0,0);
1529 INSERT INTO list_options VALUES ('fer_causes' ,'oth','Other' ,16,0,0);
1530 INSERT INTO list_options VALUES ('lists','fer_causes','Causes of Infertility/Subfertility',128,0,0);
1532 DELETE FROM list_options WHERE list_id = 'fer_treat';
1533 INSERT INTO list_options VALUES ('fer_treat' ,'ovi','Ovulation Induction' , 1,0,0);
1534 INSERT INTO list_options VALUES ('fer_treat' ,'emb','Embryo Transfer' , 2,0,0);
1535 INSERT INTO list_options VALUES ('fer_treat' ,'fer','Fertilization in Vitro' , 3,0,0);
1536 INSERT INTO list_options VALUES ('fer_treat' ,'git','Gamete Intrafallopian Transfer', 4,0,0);
1537 INSERT INTO list_options VALUES ('fer_treat' ,'sem','Artificial Insemination' , 5,0,0);
1538 INSERT INTO list_options VALUES ('fer_treat' ,'ocd','Oocyte Donation' , 6,0,0);
1539 INSERT INTO list_options VALUES ('fer_treat' ,'zit','Zygote Intrafallopian Transfer', 7,0,0);
1540 INSERT INTO list_options VALUES ('fer_treat' ,'oth','Other' , 8,0,0);
1541 INSERT INTO list_options VALUES ('lists','fer_treat','Infertility/Subfertility Treatments',129,0,0);
1543 DELETE FROM list_options WHERE list_id = 'uro_exams';
1544 INSERT INTO list_options VALUES ('uro_exams' ,'cys','Cystoscopy' , 1,0,0);
1545 INSERT INTO list_options VALUES ('uro_exams' ,'ure','Ureteroscopy' , 2,0,0);
1546 INSERT INTO list_options VALUES ('uro_exams' ,'uro','Urography' , 3,0,0);
1547 INSERT INTO list_options VALUES ('uro_exams' ,'pro','Prostate Cancer Screening', 4,0,0);
1548 INSERT INTO list_options VALUES ('uro_exams' ,'pen','Peniscopy' , 5,0,0);
1549 INSERT INTO list_options VALUES ('uro_exams' ,'oth','Other' , 6,0,0);
1550 INSERT INTO list_options VALUES ('lists','uro_exams','Urology Tests',130,0,0);
1552 DELETE FROM list_options WHERE list_id = 'uro_disease';
1553 INSERT INTO list_options VALUES ('uro_disease' ,'bal','Balanitis' , 1,0,0);
1554 INSERT INTO list_options VALUES ('uro_disease' ,'cry','Cryptorchidism' , 2,0,0);
1555 INSERT INTO list_options VALUES ('uro_disease' ,'ect','Ectopia Testis' , 3,0,0);
1556 INSERT INTO list_options VALUES ('uro_disease' ,'eps','Epispadias' , 4,0,0);
1557 INSERT INTO list_options VALUES ('uro_disease' ,'epd','Epididymitis' , 5,0,0);
1558 INSERT INTO list_options VALUES ('uro_disease' ,'edy','Erectile Dysfunction' , 6,0,0);
1559 INSERT INTO list_options VALUES ('uro_disease' ,'fre','Frenulum Breve' , 7,0,0);
1560 INSERT INTO list_options VALUES ('uro_disease' ,'hyd','Hydrocele' , 8,0,0);
1561 INSERT INTO list_options VALUES ('uro_disease' ,'hyp','Hypospadias' , 9,0,0);
1562 INSERT INTO list_options VALUES ('uro_disease' ,'mic','Micropenis' ,10,0,0);
1563 INSERT INTO list_options VALUES ('uro_disease' ,'orc','Orchitis' ,11,0,0);
1564 INSERT INTO list_options VALUES ('uro_disease' ,'par','Paraphimosis' ,12,0,0);
1565 INSERT INTO list_options VALUES ('uro_disease' ,'pec','Penile Cancer' ,13,0,0);
1566 INSERT INTO list_options VALUES ('uro_disease' ,'pef','Penile Fracture' ,14,0,0);
1567 INSERT INTO list_options VALUES ('uro_disease' ,'pey','Peyronies Disease' ,15,0,0);
1568 INSERT INTO list_options VALUES ('uro_disease' ,'phi','Phimosis' ,16,0,0);
1569 INSERT INTO list_options VALUES ('uro_disease' ,'pre','Premature Ejaculation',17,0,0);
1570 INSERT INTO list_options VALUES ('uro_disease' ,'prt','Prostatitis' ,18,0,0);
1571 INSERT INTO list_options VALUES ('uro_disease' ,'prc','Prostate Cancer' ,19,0,0);
1572 INSERT INTO list_options VALUES ('uro_disease' ,'spe','Spermatocele' ,20,0,0);
1573 INSERT INTO list_options VALUES ('uro_disease' ,'tec','Testicular Cancer' ,21,0,0);
1574 INSERT INTO list_options VALUES ('uro_disease' ,'tet','Testicular Torsion' ,22,0,0);
1575 INSERT INTO list_options VALUES ('uro_disease' ,'var','Varicocele' ,23,0,0);
1576 INSERT INTO list_options VALUES ('lists','uro_disease','Male Genitourinary diseases',131,0,0);