| blob | ce64abb9ad75f7ec7d245c0a21bfc22e9e09c0b4 |
1 DELETE FROM list_options WHERE list_id = 'ab_location';
2 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','proc' ,'Procedure at this site' , 1);
3 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','ma' ,'Followup procedure from this site' , 2);
4 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','part' ,'Followup procedure from partner site', 3);
5 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','oth' ,'Followup procedure from other site' , 4);
7 DELETE FROM list_options WHERE list_id = 'lbfnames';
8 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lbfnames','LBFgcac','IPPF GCAC',1);
9 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lbfnames','LBFsrh' ,'IPPF SRH' ,2);
11 DELETE FROM layout_options WHERE form_id = 'LBFsrh';
12 INSERT INTO layout_options VALUES ('LBFsrh','usertext15' ,'1Gynecology' ,'Menstrual History' , 1,22,1, 0, 0,'genmenhist' ,1,3,'','H','');
13 INSERT INTO layout_options VALUES ('LBFsrh','men_hist' ,'1Gynecology' ,'Recent Menstrual History' , 2,21,1, 2, 0,'menhist' ,1,3,'','','Recent Menstrual History');
14 INSERT INTO layout_options VALUES ('LBFsrh','men_compl' ,'1Gynecology' ,'Menstrual Complications' , 3,21,1, 2, 0,'men_compl' ,1,3,'','','Menstrual Complications');
15 INSERT INTO layout_options VALUES ('LBFsrh','pap_hist' ,'1Gynecology' ,'Pap Smear Recent History' , 4,22,1, 0, 0,'pap_hist' ,1,3,'','','Pap Smear Recent History');
16 INSERT INTO layout_options VALUES ('LBFsrh','gyn_exams' ,'1Gynecology' ,'Gynecological Tests' , 5,23,1, 0, 0,'gyn_exams' ,1,1,'','','Gynecological test results');
17 INSERT INTO layout_options VALUES ('LBFsrh','pr_status' ,'2Obstetrics' ,'Pregnancy Status Confirmed' , 1, 1,1, 0, 0,'pr_status' ,1,3,'','','Pregnancy Status Confirmed');
18 INSERT INTO layout_options VALUES ('LBFsrh','gest_age_by','2Obstetrics' ,'Gestational Age Confirmed By' , 2, 1,1, 0, 0,'gest_age_by' ,1,3,'','','Gestational Age Confirmed By');
19 INSERT INTO layout_options VALUES ('LBFsrh','usertext12' ,'2Obstetrics' ,'Blood Group' , 3, 1,1, 0, 0,'bloodgroup' ,1,3,'','H','');
20 INSERT INTO layout_options VALUES ('LBFsrh','usertext13' ,'2Obstetrics' ,'RH Factor' , 4, 1,1, 0, 0,'rh_factor' ,1,3,'','H','');
21 INSERT INTO layout_options VALUES ('LBFsrh','obs_exams' ,'2Obstetrics' ,'Obstetric Tests' , 5,23,1, 0, 0,'obs_exams' ,1,1,'','','Obstetric test results');
22 INSERT INTO layout_options VALUES ('LBFsrh','usertext16' ,'2Obstetrics' ,'Obstetric History' , 6,22,1, 0, 0,'genobshist' ,1,1,'','H','');
23 INSERT INTO layout_options VALUES ('LBFsrh','pr_outcome' ,'2Obstetrics' ,'Outcome of Last Pregnancy' , 7,21,1, 2, 0,'pr_outcome' ,1,3,'','','Outcome of Last Pregnancy');
24 INSERT INTO layout_options VALUES ('LBFsrh','pr_compl' ,'2Obstetrics' ,'Pregnancy Complications' , 8,21,1, 2, 0,'pr_compl' ,1,3,'','','Pregnancy Complications');
25 INSERT INTO layout_options VALUES ('LBFsrh','usertext17' ,'3Basic RH (female only)' ,'Abortion Basic History' , 1,22,1, 0, 0,'genabohist' ,1,1,'','H','');
26 INSERT INTO layout_options VALUES ('LBFsrh','abo_exams' ,'3Basic RH (female only)' ,'Abortion Tests' , 2,23,1, 0, 0,'abo_exams' ,1,1,'','','Abortion test results');
27 INSERT INTO layout_options VALUES ('LBFsrh','usertext18' ,'4Basic RH (female and male)','HIV/AIDS Basic History' , 1,21,1, 0, 0,'genhivhist' ,1,1,'','H','');
28 INSERT INTO layout_options VALUES ('LBFsrh','hiv_exams' ,'4Basic RH (female and male)','HIV/AIDS Tests' , 2,23,1, 0, 0,'hiv_exams' ,1,1,'','','HIV/AIDS test results');
29 INSERT INTO layout_options VALUES ('LBFsrh','usertext19' ,'4Basic RH (female and male)','ITS/ITR Basic History' , 3,21,1, 0, 0,'genitshist' ,1,1,'','H','');
30 INSERT INTO layout_options VALUES ('LBFsrh','its_exams' ,'4Basic RH (female and male)','ITS/ITR Tests' , 4,23,1, 0, 0,'its_exams' ,1,1,'','','ITS/ITR test results');
31 INSERT INTO layout_options VALUES ('LBFsrh','usertext20' ,'4Basic RH (female and male)','Fertility Basic History' , 5,21,1, 0, 0,'genferhist' ,1,1,'','H','');
32 INSERT INTO layout_options VALUES ('LBFsrh','fer_exams' ,'4Basic RH (female and male)','Fertility Tests' , 6,23,1, 0, 0,'fer_exams' ,1,1,'','','Infertility/subfertility test results');
33 INSERT INTO layout_options VALUES ('LBFsrh','fer_causes' ,'4Basic RH (female and male)','Causes of Infertility' , 7,21,1, 2, 0,'fer_causes' ,1,3,'','','Causes of Infertility');
34 INSERT INTO layout_options VALUES ('LBFsrh','fer_treat' ,'4Basic RH (female and male)','Infertility Treatment' , 8,21,1, 2, 0,'fer_treat' ,1,3,'','','Infertility Treatment');
35 INSERT INTO layout_options VALUES ('LBFsrh','usertext21' ,'4Basic RH (female and male)','Urology Basic History' , 9,21,1, 0, 0,'genurohist' ,1,1,'','H','');
36 INSERT INTO layout_options VALUES ('LBFsrh','uro_exams' ,'4Basic RH (female and male)','Urology Tests' ,10,23,1, 0, 0,'uro_exams' ,1,1,'','','Urology test results');
37 INSERT INTO layout_options VALUES ('LBFsrh','uro_disease','4Basic RH (female and male)','Male Genitourinary diseases' ,11,21,1, 2, 0,'uro_disease' ,1,3,'','','Male Genitourinary diseases');
39 DELETE FROM layout_options WHERE form_id = 'GCA';
40 INSERT INTO layout_options VALUES ('GCA','reason' ,'2Counseling' ,'Reason for Termination' , 1,21,1, 0, 0,'abreasons' ,1,3,'','' ,'Reasons for Termination of Pregnancy');
41 INSERT INTO layout_options VALUES ('GCA','exp_p_i' ,'2Counseling' ,'Explanation of Procedures/Issues', 2,21,1, 2, 0,'exp_p_i' ,1,3,'','' ,'Explanation of Procedures and Issues');
42 INSERT INTO layout_options VALUES ('GCA','exp_pop' ,'2Counseling' ,'Explanation of Pregnancy Options', 3,21,1, 2, 0,'exp_pop' ,1,3,'','' ,'Explanation of Pregnancy Options');
43 INSERT INTO layout_options VALUES ('GCA','ab_contraind' ,'2Counseling' ,'Contraindications' , 4,21,1, 2, 0,'ab_contraind',1,3,'','' ,'Contraindications');
44 INSERT INTO layout_options VALUES ('GCA','screening' ,'2Counseling' ,'Screening for SRHR Concerns' , 5,21,1, 2, 0,'screening' ,1,3,'','' ,'Screening for SRHR Concerns');
45 INSERT INTO layout_options VALUES ('GCA','in_ab_proc' ,'3Admission' ,'Induced Abortion Procedure' , 2, 1,1, 0, 0,'in_ab_proc' ,1,3,'','' ,'Abortion Procedure Accepted or Performed');
46 INSERT INTO layout_options VALUES ('GCA','ab_types' ,'3Admission' ,'Abortion Types' , 3,21,1, 2, 0,'ab_types' ,1,3,'','' ,'Abortion Types');
47 INSERT INTO layout_options VALUES ('GCA','pr_status' ,'4Preparatory' ,'Pregnancy Status Confirmed' , 1, 1,1, 0, 0,'pr_status' ,1,3,'','' ,'Pregnancy Status Confirmed');
48 INSERT INTO layout_options VALUES ('GCA','gest_age_by' ,'4Preparatory' ,'Gestational Age Confirmed By' , 2, 1,1, 0, 0,'gest_age_by' ,1,3,'','' ,'Gestational Age Confirmed By');
49 INSERT INTO layout_options VALUES ('GCA','usertext12' ,'4Preparatory' ,'Blood Group' , 3, 1,1, 0, 0,'bloodgroup' ,1,3,'','H','');
50 INSERT INTO layout_options VALUES ('GCA','usertext13' ,'4Preparatory' ,'RH Factor' , 4, 1,1, 0, 0,'rh_factor' ,1,3,'','H','');
51 INSERT INTO layout_options VALUES ('GCA','prep_procs' ,'4Preparatory' ,'Preparation Procedures' , 6,21,1, 0, 0,'prep_procs' ,1,3,'','' ,'Preparation Procedures');
52 INSERT INTO layout_options VALUES ('GCA','pre_op' ,'5Intervention','Pre-Surgery Procedures' , 1,21,1, 2, 0,'pre_op' ,1,3,'','' ,'Pre-Surgery Procedures');
53 INSERT INTO layout_options VALUES ('GCA','anesthesia' ,'5Intervention','Anesthesia' , 2, 1,1, 0, 0,'anesthesia' ,1,3,'','' ,'Type of Anesthesia Used');
54 INSERT INTO layout_options VALUES ('GCA','side_eff' ,'5Intervention','Immediate Side Effects' , 3,21,1, 2, 0,'side_eff' ,1,3,'','' ,'Immediate Side Effects (observed at intervention');
55 INSERT INTO layout_options VALUES ('GCA','post_op' ,'5Intervention','Post-Surgery Procedures' , 5,21,1, 2, 0,'post_op' ,1,3,'','' ,'Post-Surgery Procedures');
56 INSERT INTO layout_options VALUES ('GCA','qc_ind' ,'6Followup' ,'Quality of Care Indicators' , 1,21,1, 0, 0,'qc_ind' ,1,3,'','' ,'Quality of Care Indicators');
58 DELETE FROM layout_options WHERE form_id = 'LBFgcac';
59 INSERT INTO layout_options VALUES ('LBFgcac','client_status','1Basic Information','Client Status' , 1,27,2, 0, 0,'clientstatus',1,1,'','' ,'Client Status');
60 INSERT INTO layout_options VALUES ('LBFgcac','ab_location' ,'1Basic Information','Type of Visit' , 2,27,2, 0, 0,'ab_location' ,1,1,'','' ,'Nature of this visit');
61 INSERT INTO layout_options VALUES ('LBFgcac','in_ab_proc' ,'1Basic Information','Associated Induced Procedure', 3,27,1, 0, 0,'in_ab_proc' ,1,3,'','' ,'Applies regardless of when or where done');
62 INSERT INTO layout_options VALUES ('LBFgcac','complications','2Complications','Complications' , 1,21,1, 2, 0,'complication',1,3,'','' ,'Post-Abortion Complications');
63 INSERT INTO layout_options VALUES ('LBFgcac','main_compl' ,'2Complications','Main Complication' , 2, 1,1, 2, 0,'complication',1,3,'','' ,'Primary Complication');
64 INSERT INTO layout_options VALUES ('LBFgcac','contrameth' ,'3Contraception','New Method' , 1,21,1, 2, 0,'contrameth' ,1,3,'','' ,'New method adopted');
66 #IfNotRow list_options list_id occupations
67 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('occupations','oth','Other', 1);
68 DELETE FROM list_options WHERE list_id = 'lists' AND option_id = 'occupations';
69 INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','occupations','Occupations',61);
70 #endIf
72 UPDATE layout_options SET data_type = 26, list_id = 'occupations' WHERE form_id = 'DEM' AND field_id = 'occupation';
73 UPDATE layout_options SET data_type = 26, title = 'Religion' WHERE form_id = 'DEM' AND field_id = 'userlist5';
74 UPDATE layout_options SET data_type = 26, title = 'Monthly Income' WHERE form_id = 'DEM' AND field_id = 'userlist3';
75 UPDATE layout_options SET data_type = 26 WHERE form_id = 'DEM' AND field_id = 'ethnoracial';
76 UPDATE layout_options SET data_type = 26 WHERE form_id = 'DEM' AND field_id = 'language';
77 UPDATE layout_options SET data_type = 26 WHERE form_id = 'DEM' AND field_id = 'status';
78 UPDATE layout_options SET uor = 0 WHERE form_id = 'DEM' AND field_id = 'providerID';
79 UPDATE layout_options SET seq = 3 WHERE form_id = 'REF' AND field_id = 'refer_external' AND seq = 5;
80 UPDATE layout_options SET seq = 4 WHERE form_id = 'REF' AND field_id = 'refer_to' AND seq = 3;
81 UPDATE layout_options SET seq = 5 WHERE form_id = 'REF' AND field_id = 'body' AND seq = 4;
83 UPDATE layout_options AS a, list_options AS i SET a.group_name = '1Basic Data', a.title = 'Transgender', a.seq = 13, a.data_type = 26, a.uor = 1, a.description = 'Transgender', i.title = 'Transgender' WHERE a.form_id = 'DEM' AND a.field_id = 'userlist6' AND a.uor = 0 AND i.list_id = 'lists' AND i.option_id = 'userlist6';
85 UPDATE list_options SET title = 'Retention of Product' WHERE title = 'Incomplete Abortion or Retention of Prod';
87 UPDATE list_options SET title = 'Surgical - MVA/EVA' WHERE list_id = 'in_ab_proc' AND title = 'Surgical - MVA';
88 DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'abs';
89 DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'eva';
90 DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'oth';
91 DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'wd';
92 UPDATE list_options SET mapping = ':2522231' WHERE list_id = 'in_ab_proc' AND option_id = 's_dnc';
93 UPDATE list_options SET mapping = ':2522232' WHERE list_id = 'in_ab_proc' AND option_id = 's_dne';
94 UPDATE list_options SET mapping = ':2522233' WHERE list_id = 'in_ab_proc' AND option_id = 's_mva';
95 UPDATE list_options SET mapping = ':2522239' WHERE list_id = 'in_ab_proc' AND option_id = 's_oth';
96 UPDATE list_options SET mapping = ':2522242' WHERE list_id = 'in_ab_proc' AND option_id = 'm_mis';
97 UPDATE list_options SET mapping = ':2522241' WHERE list_id = 'in_ab_proc' AND option_id = 'm_mm';
98 UPDATE list_options SET mapping = ':2522249' WHERE list_id = 'in_ab_proc' AND option_id = 'm_oth';
99 UPDATE list_options SET mapping = ':11214' WHERE list_id = 'contrameth' AND option_id = 'con';
100 UPDATE list_options SET mapping = ':11215' WHERE list_id = 'contrameth' AND option_id = 'dia';
101 UPDATE list_options SET mapping = ':14521' WHERE list_id = 'contrameth' AND option_id = 'ec';
102 UPDATE list_options SET mapping = ':13119' WHERE list_id = 'contrameth' AND option_id = 'fab';
103 UPDATE list_options SET mapping = ':11216' WHERE list_id = 'contrameth' AND option_id = 'fc';
104 UPDATE list_options SET mapping = ':11113' WHERE list_id = 'contrameth' AND option_id = 'pat';
105 UPDATE list_options SET mapping = ':11112' WHERE list_id = 'contrameth' AND option_id = 'imp';
106 UPDATE list_options SET mapping = ':11111' WHERE list_id = 'contrameth' AND option_id = 'inj';
107 UPDATE list_options SET mapping = ':11317' WHERE list_id = 'contrameth' AND option_id = 'iud';
108 UPDATE list_options SET mapping = ':11110' WHERE list_id = 'contrameth' AND option_id = 'or';
109 UPDATE list_options SET mapping = ':11215' WHERE list_id = 'contrameth' AND option_id = 'cap';
110 UPDATE list_options SET mapping = ':11216' WHERE list_id = 'contrameth' AND option_id = 'sp';
111 UPDATE list_options SET mapping = ':12.18' WHERE list_id = 'contrameth' AND option_id = 'vsc';
112 UPDATE list_options SET mapping = ':00000' WHERE list_id = 'contrameth' AND option_id = 'no';