DELETE FROM list_options WHERE list_id = 'ab_location'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','proc' ,'Procedure at this site' , 1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','ma' ,'Followup procedure from this site' , 2); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','part' ,'Followup procedure from partner site', 3); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('ab_location','oth' ,'Followup procedure from other site' , 4); DELETE FROM list_options WHERE list_id = 'lbfnames'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lbfnames','LBFgcac','IPPF GCAC',1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lbfnames','LBFsrh' ,'IPPF SRH' ,2); DELETE FROM layout_options WHERE form_id = 'LBFsrh'; INSERT INTO layout_options VALUES ('LBFsrh','usertext15' ,'1Gynecology' ,'Menstrual History' , 1,22,1, 0, 0,'genmenhist' ,1,3,'','H',''); INSERT INTO layout_options VALUES ('LBFsrh','men_hist' ,'1Gynecology' ,'Recent Menstrual History' , 2,21,1, 2, 0,'menhist' ,1,3,'','','Recent Menstrual History'); INSERT INTO layout_options VALUES ('LBFsrh','men_compl' ,'1Gynecology' ,'Menstrual Complications' , 3,21,1, 2, 0,'men_compl' ,1,3,'','','Menstrual Complications'); 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'); INSERT INTO layout_options VALUES ('LBFsrh','gyn_exams' ,'1Gynecology' ,'Gynecological Tests' , 5,23,1, 0, 0,'gyn_exams' ,1,1,'','','Gynecological test results'); INSERT INTO layout_options VALUES ('LBFsrh','pr_status' ,'2Obstetrics' ,'Pregnancy Status Confirmed' , 1, 1,1, 0, 0,'pr_status' ,1,3,'','','Pregnancy Status Confirmed'); 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'); INSERT INTO layout_options VALUES ('LBFsrh','usertext12' ,'2Obstetrics' ,'Blood Group' , 3, 1,1, 0, 0,'bloodgroup' ,1,3,'','H',''); INSERT INTO layout_options VALUES ('LBFsrh','usertext13' ,'2Obstetrics' ,'RH Factor' , 4, 1,1, 0, 0,'rh_factor' ,1,3,'','H',''); INSERT INTO layout_options VALUES ('LBFsrh','obs_exams' ,'2Obstetrics' ,'Obstetric Tests' , 5,23,1, 0, 0,'obs_exams' ,1,1,'','','Obstetric test results'); INSERT INTO layout_options VALUES ('LBFsrh','usertext16' ,'2Obstetrics' ,'Obstetric History' , 6,22,1, 0, 0,'genobshist' ,1,1,'','H',''); 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'); INSERT INTO layout_options VALUES ('LBFsrh','pr_compl' ,'2Obstetrics' ,'Pregnancy Complications' , 8,21,1, 2, 0,'pr_compl' ,1,3,'','','Pregnancy Complications'); INSERT INTO layout_options VALUES ('LBFsrh','usertext17' ,'3Basic RH (female only)' ,'Abortion Basic History' , 1,22,1, 0, 0,'genabohist' ,1,1,'','H',''); 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'); 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',''); 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'); 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',''); 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'); INSERT INTO layout_options VALUES ('LBFsrh','usertext20' ,'4Basic RH (female and male)','Fertility Basic History' , 5,21,1, 0, 0,'genferhist' ,1,1,'','H',''); 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'); 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'); 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'); INSERT INTO layout_options VALUES ('LBFsrh','usertext21' ,'4Basic RH (female and male)','Urology Basic History' , 9,21,1, 0, 0,'genurohist' ,1,1,'','H',''); 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'); 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'); DELETE FROM layout_options WHERE form_id = 'GCA'; INSERT INTO layout_options VALUES ('GCA','reason' ,'2Counseling' ,'Reason for Termination' , 1,21,1, 0, 0,'abreasons' ,1,3,'','' ,'Reasons for Termination of Pregnancy'); 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'); 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'); INSERT INTO layout_options VALUES ('GCA','ab_contraind' ,'2Counseling' ,'Contraindications' , 4,21,1, 2, 0,'ab_contraind',1,3,'','' ,'Contraindications'); INSERT INTO layout_options VALUES ('GCA','screening' ,'2Counseling' ,'Screening for SRHR Concerns' , 5,21,1, 2, 0,'screening' ,1,3,'','' ,'Screening for SRHR Concerns'); 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'); INSERT INTO layout_options VALUES ('GCA','ab_types' ,'3Admission' ,'Abortion Types' , 3,21,1, 2, 0,'ab_types' ,1,3,'','' ,'Abortion Types'); INSERT INTO layout_options VALUES ('GCA','pr_status' ,'4Preparatory' ,'Pregnancy Status Confirmed' , 1, 1,1, 0, 0,'pr_status' ,1,3,'','' ,'Pregnancy Status Confirmed'); 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'); INSERT INTO layout_options VALUES ('GCA','usertext12' ,'4Preparatory' ,'Blood Group' , 3, 1,1, 0, 0,'bloodgroup' ,1,3,'','H',''); INSERT INTO layout_options VALUES ('GCA','usertext13' ,'4Preparatory' ,'RH Factor' , 4, 1,1, 0, 0,'rh_factor' ,1,3,'','H',''); INSERT INTO layout_options VALUES ('GCA','prep_procs' ,'4Preparatory' ,'Preparation Procedures' , 6,21,1, 0, 0,'prep_procs' ,1,3,'','' ,'Preparation Procedures'); INSERT INTO layout_options VALUES ('GCA','pre_op' ,'5Intervention','Pre-Surgery Procedures' , 1,21,1, 2, 0,'pre_op' ,1,3,'','' ,'Pre-Surgery Procedures'); INSERT INTO layout_options VALUES ('GCA','anesthesia' ,'5Intervention','Anesthesia' , 2, 1,1, 0, 0,'anesthesia' ,1,3,'','' ,'Type of Anesthesia Used'); 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'); INSERT INTO layout_options VALUES ('GCA','post_op' ,'5Intervention','Post-Surgery Procedures' , 5,21,1, 2, 0,'post_op' ,1,3,'','' ,'Post-Surgery Procedures'); 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'); DELETE FROM layout_options WHERE form_id = 'LBFgcac'; INSERT INTO layout_options VALUES ('LBFgcac','client_status','1Basic Information','Client Status' , 1,27,2, 0, 0,'clientstatus',1,1,'','' ,'Client Status'); 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'); 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'); INSERT INTO layout_options VALUES ('LBFgcac','complications','2Complications','Complications' , 1,21,1, 2, 0,'complication',1,3,'','' ,'Post-Abortion Complications'); INSERT INTO layout_options VALUES ('LBFgcac','main_compl' ,'2Complications','Main Complication' , 2, 1,1, 2, 0,'complication',1,3,'','' ,'Primary Complication'); INSERT INTO layout_options VALUES ('LBFgcac','contrameth' ,'3Contraception','New Method' , 1,21,1, 2, 0,'contrameth' ,1,3,'','' ,'New method adopted'); #IfNotRow list_options list_id occupations INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('occupations','oth','Other', 1); DELETE FROM list_options WHERE list_id = 'lists' AND option_id = 'occupations'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','occupations','Occupations',61); #EndIf UPDATE layout_options SET data_type = 26, list_id = 'occupations' WHERE form_id = 'DEM' AND field_id = 'occupation'; UPDATE layout_options SET data_type = 26, title = 'Religion' WHERE form_id = 'DEM' AND field_id = 'userlist5'; UPDATE layout_options SET data_type = 26, title = 'Monthly Income' WHERE form_id = 'DEM' AND field_id = 'userlist3'; UPDATE layout_options SET data_type = 26 WHERE form_id = 'DEM' AND field_id = 'ethnoracial'; UPDATE layout_options SET data_type = 26 WHERE form_id = 'DEM' AND field_id = 'language'; UPDATE layout_options SET data_type = 26 WHERE form_id = 'DEM' AND field_id = 'status'; UPDATE layout_options SET uor = 0 WHERE form_id = 'DEM' AND field_id = 'providerID'; UPDATE layout_options SET seq = 3 WHERE form_id = 'REF' AND field_id = 'refer_external' AND seq = 5; UPDATE layout_options SET seq = 4 WHERE form_id = 'REF' AND field_id = 'refer_to' AND seq = 3; UPDATE layout_options SET seq = 5 WHERE form_id = 'REF' AND field_id = 'body' AND seq = 4; 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'; UPDATE list_options SET title = 'Retention of Product' WHERE title = 'Incomplete Abortion or Retention of Prod'; UPDATE list_options SET title = 'Surgical - MVA/EVA' WHERE list_id = 'in_ab_proc' AND title = 'Surgical - MVA'; DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'abs'; DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'eva'; DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'oth'; DELETE FROM list_options where list_id = 'contrameth' AND option_id = 'wd'; UPDATE list_options SET mapping = ':2522231' WHERE list_id = 'in_ab_proc' AND option_id = 's_dnc'; UPDATE list_options SET mapping = ':2522232' WHERE list_id = 'in_ab_proc' AND option_id = 's_dne'; UPDATE list_options SET mapping = ':2522233' WHERE list_id = 'in_ab_proc' AND option_id = 's_mva'; UPDATE list_options SET mapping = ':2522239' WHERE list_id = 'in_ab_proc' AND option_id = 's_oth'; UPDATE list_options SET mapping = ':2522242' WHERE list_id = 'in_ab_proc' AND option_id = 'm_mis'; UPDATE list_options SET mapping = ':2522241' WHERE list_id = 'in_ab_proc' AND option_id = 'm_mm'; UPDATE list_options SET mapping = ':2522249' WHERE list_id = 'in_ab_proc' AND option_id = 'm_oth'; UPDATE list_options SET mapping = ':11214' WHERE list_id = 'contrameth' AND option_id = 'con'; UPDATE list_options SET mapping = ':11215' WHERE list_id = 'contrameth' AND option_id = 'dia'; UPDATE list_options SET mapping = ':14521' WHERE list_id = 'contrameth' AND option_id = 'ec'; UPDATE list_options SET mapping = ':13119' WHERE list_id = 'contrameth' AND option_id = 'fab'; UPDATE list_options SET mapping = ':11216' WHERE list_id = 'contrameth' AND option_id = 'fc'; UPDATE list_options SET mapping = ':11113' WHERE list_id = 'contrameth' AND option_id = 'pat'; UPDATE list_options SET mapping = ':11112' WHERE list_id = 'contrameth' AND option_id = 'imp'; UPDATE list_options SET mapping = ':11111' WHERE list_id = 'contrameth' AND option_id = 'inj'; UPDATE list_options SET mapping = ':11317' WHERE list_id = 'contrameth' AND option_id = 'iud'; UPDATE list_options SET mapping = ':11110' WHERE list_id = 'contrameth' AND option_id = 'or'; UPDATE list_options SET mapping = ':11215' WHERE list_id = 'contrameth' AND option_id = 'cap'; UPDATE list_options SET mapping = ':11216' WHERE list_id = 'contrameth' AND option_id = 'sp'; UPDATE list_options SET mapping = ':12.18' WHERE list_id = 'contrameth' AND option_id = 'vsc'; UPDATE list_options SET mapping = ':00000' WHERE list_id = 'contrameth' AND option_id = 'no'; UPDATE list_options SET mapping = 'F' WHERE list_id = 'sex' AND option_id = 'Female'; UPDATE list_options SET mapping = 'M' WHERE list_id = 'sex' AND option_id = 'Male'; #IfNotRow2D list_options list_id userlist2 mapping 1 UPDATE list_options SET title = 'Education' WHERE list_id = 'lists' AND option_id = 'userlist2'; DELETE FROM list_options WHERE list_id = 'userlist2'; INSERT INTO list_options ( list_id, option_id, title, seq, is_default, mapping ) VALUES ('userlist2','1','Illiterate',1,0,'0'); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, mapping ) VALUES ('userlist2','2','Basic Schooling',2,1,'1'); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, mapping ) VALUES ('userlist2','3','Advanced Schooling',3,0,'2'); #EndIf #IfNotRow lang_constants constant_name (New Patient) insert into lang_constants ( constant_name ) values ( '(New Patient)' ); #EndIf #IfNotRow lang_constants constant_name Active Encounter insert into lang_constants ( constant_name ) values ( 'Active Encounter' ); #EndIf #IfNotRow lang_constants constant_name Active Patient insert into lang_constants ( constant_name ) values ( 'Active Patient' ); #EndIf #IfNotRow lang_constants constant_name Active Patient: insert into lang_constants ( constant_name ) values ( 'Active Patient:' ); #EndIf #IfNotRow lang_constants constant_name Add Copay insert into lang_constants ( constant_name ) values ( 'Add Copay' ); #EndIf #IfNotRow lang_constants constant_name Add Drug insert into lang_constants ( constant_name ) values ( 'Add Drug' ); #EndIf #IfNotRow lang_constants constant_name Add Patient Record insert into lang_constants ( constant_name ) values ( 'Add Patient Record' ); #EndIf #IfNotRow lang_constants constant_name Appointments and Encounters insert into lang_constants ( constant_name ) values ( 'Appointments and Encounters' ); #EndIf #IfNotRow lang_constants constant_name Appointments and Visits insert into lang_constants ( constant_name ) values ( 'Appointments and Visits' ); #EndIf #IfNotRow lang_constants constant_name Appt-Enc insert into lang_constants ( constant_name ) values ( 'Appt-Enc' ); #EndIf #IfNotRow lang_constants constant_name Cash Rec insert into lang_constants ( constant_name ) values ( 'Cash Rec' ); #EndIf #IfNotRow lang_constants constant_name Cash Receipts insert into lang_constants ( constant_name ) values ( 'Cash Receipts' ); #EndIf #IfNotRow lang_constants constant_name Chart insert into lang_constants ( constant_name ) values ( 'Chart' ); #EndIf #IfNotRow lang_constants constant_name Chief Complaint insert into lang_constants ( constant_name ) values ( 'Chief Complaint' ); #EndIf #IfNotRow lang_constants constant_name Chief Compliant insert into lang_constants ( constant_name ) values ( 'Chief Compliant' ); #EndIf #IfNotRow lang_constants constant_name Client insert into lang_constants ( constant_name ) values ( 'Client' ); #EndIf #IfNotRow lang_constants constant_name CO-PAY insert into lang_constants ( constant_name ) values ( 'CO-PAY' ); #EndIf #IfNotRow lang_constants constant_name Collections insert into lang_constants ( constant_name ) values ( 'Collections' ); #EndIf #IfNotRow lang_constants constant_name COPAY insert into lang_constants ( constant_name ) values ( 'COPAY' ); #EndIf #IfNotRow lang_constants constant_name CPT4 insert into lang_constants ( constant_name ) values ( 'CPT4' ); #EndIf #IfNotRow lang_constants constant_name Encounter insert into lang_constants ( constant_name ) values ( 'Encounter' ); #EndIf #IfNotRow lang_constants constant_name Encounter Forms to Include in this Report: insert into lang_constants ( constant_name ) values ( 'Encounter Forms to Include in this Report:' ); #EndIf #IfNotRow lang_constants constant_name Encounters insert into lang_constants ( constant_name ) values ( 'Encounters' ); #EndIf #IfNotRow lang_constants constant_name Encounters Report insert into lang_constants ( constant_name ) values ( 'Encounters Report' ); #EndIf #IfNotRow lang_constants constant_name Facility insert into lang_constants ( constant_name ) values ( 'Facility' ); #EndIf #IfNotRow lang_constants constant_name Fee Sheet insert into lang_constants ( constant_name ) values ( 'Fee Sheet' ); #EndIf #IfNotRow lang_constants constant_name Find Patient insert into lang_constants ( constant_name ) values ( 'Find Patient' ); #EndIf #IfNotRow lang_constants constant_name ID insert into lang_constants ( constant_name ) values ( 'ID' ); #EndIf #IfNotRow lang_constants constant_name IPPF SRH Data insert into lang_constants ( constant_name ) values ( 'IPPF SRH Data' ); #EndIf #IfNotRow lang_constants constant_name IPPF SRH Data for insert into lang_constants ( constant_name ) values ( 'IPPF SRH Data for' ); #EndIf #IfNotRow lang_constants constant_name Last insert into lang_constants ( constant_name ) values ( 'Last' ); #EndIf #IfNotRow lang_constants constant_name New Encounter insert into lang_constants ( constant_name ) values ( 'New Encounter' ); #EndIf #IfNotRow lang_constants constant_name New Encounter Form insert into lang_constants ( constant_name ) values ( 'New Encounter Form' ); #EndIf #IfNotRow lang_constants constant_name New Patient insert into lang_constants ( constant_name ) values ( 'New Patient' ); #EndIf #IfNotRow lang_constants constant_name Past Encounters and Documents insert into lang_constants ( constant_name ) values ( 'Past Encounters and Documents' ); #EndIf #IfNotRow lang_constants constant_name Patient insert into lang_constants ( constant_name ) values ( 'Patient' ); #EndIf #IfNotRow lang_constants constant_name Patient Appointment insert into lang_constants ( constant_name ) values ( 'Patient Appointment' ); #EndIf #IfNotRow lang_constants constant_name Patient Encounter Form insert into lang_constants ( constant_name ) values ( 'Patient Encounter Form' ); #EndIf #IfNotRow lang_constants constant_name Patient Notes insert into lang_constants ( constant_name ) values ( 'Patient Notes' ); #EndIf #IfNotRow lang_constants constant_name Patient Number insert into lang_constants ( constant_name ) values ( 'Patient Number' ); #EndIf #IfNotRow lang_constants constant_name Patient Record Report insert into lang_constants ( constant_name ) values ( 'Patient Record Report' ); #EndIf #IfNotRow lang_constants constant_name Patient Report insert into lang_constants ( constant_name ) values ( 'Patient Report' ); #EndIf #IfNotRow lang_constants constant_name Patient Transactions insert into lang_constants ( constant_name ) values ( 'Patient Transactions' ); #EndIf #IfNotRow lang_constants constant_name Patient/Client insert into lang_constants ( constant_name ) values ( 'Patient/Client' ); #EndIf #IfNotRow lang_constants constant_name PID insert into lang_constants ( constant_name ) values ( 'PID' ); #EndIf #IfNotRow lang_constants constant_name Prepay insert into lang_constants ( constant_name ) values ( 'Prepay' ); #EndIf #IfNotRow lang_constants constant_name Provider insert into lang_constants ( constant_name ) values ( 'Provider' ); #EndIf #IfNotRow lang_constants constant_name Pt Notes/Auth insert into lang_constants ( constant_name ) values ( 'Pt Notes/Auth' ); #EndIf #IfNotRow lang_constants constant_name Rendering insert into lang_constants ( constant_name ) values ( 'Rendering' ); #EndIf #IfNotRow lang_constants constant_name Rx insert into lang_constants ( constant_name ) values ( 'Rx' ); #EndIf #IfNotRow lang_constants constant_name Sales by Item insert into lang_constants ( constant_name ) values ( 'Sales by Item' ); #EndIf #IfNotRow lang_constants constant_name Save Patient Demographic insert into lang_constants ( constant_name ) values ( 'Save Patient Demographic' ); #EndIf #IfNotRow lang_constants constant_name Search or Add Patient insert into lang_constants ( constant_name ) values ( 'Search or Add Patient ' ); #EndIf #IfNotRow lang_constants constant_name Select Patient insert into lang_constants ( constant_name ) values ( 'Select Patient' ); #EndIf #IfNotRow lang_constants constant_name Select Patient by Last insert into lang_constants ( constant_name ) values ( 'Select Patient by Last' ); #EndIf #IfNotRow lang_constants constant_name Sensitivity insert into lang_constants ( constant_name ) values ( 'Sensitivity' ); #EndIf #IfNotRow lang_constants constant_name SSN insert into lang_constants ( constant_name ) values ( 'SSN' ); #EndIf #IfNotRow lang_constants constant_name Superbill insert into lang_constants ( constant_name ) values ( 'Superbill' ); #EndIf #IfNotRow lang_constants constant_name This Encounter insert into lang_constants ( constant_name ) values ( 'This Encounter' ); #EndIf #IfNotRow lang_constants constant_name Transact insert into lang_constants ( constant_name ) values ( 'Transact' ); #EndIf #IfNotRow lang_constants constant_name User & Group Administration insert into lang_constants ( constant_name ) values ( 'User & Group Administration' ); #EndIf #IfNotRow lang_constants constant_name View Comprehensive Patient Report insert into lang_constants ( constant_name ) values ( 'View Comprehensive Patient Report' ); #EndIf #IfNotRow lang_constants constant_name Procedures insert into lang_constants ( constant_name ) values ( 'Procedures' ); #EndIf #IfNotRow lang_constants constant_name Layout Based insert into lang_constants ( constant_name ) values ( 'Layout Based' ); #EndIf insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'New Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = '(New Patient)' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Active visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Active Encounter' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Active Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Active Patient' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Active Client:' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Active Patient:' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Add Payment' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Add Copay' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Add Product' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Add Drug' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Create a new OpenEMR record' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Add Patient Record' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Appointments and Visits' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Appointments and Encounters' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Charges by Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Appointments and Visits' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Appt-Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Appt-Enc' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Svcs Provider Cash Rec' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Cash Rec' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Service Provider Cash Receipts' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Cash Receipts' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'System ID' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Chart' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Reason of Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Chief Complaint' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Reason of Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Chief Compliant' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Cliente' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Client' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Payment' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'CO-PAY' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Collection Report' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Collections' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Payment' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'COPAY' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'C3' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'CPT4' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Encounter' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Visit Forms to include in this Report:' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Encounter Forms to Include in this Report:' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Visits' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Encounters' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Visits Report' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Encounters Report' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Clinic ID' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Facility' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Tally Sheet' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Fee Sheet' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Find Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Find Patient' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'ID' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'ID' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'GCAC Form (example)' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'IPPF SRH Data' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'GCAC Form (example) for' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'IPPF SRH Data for' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Last name' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Last' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'New Encounter' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'New Visit Form' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'New Encounter Form' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'New Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'New Patient' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Past Visits and Documents' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Past Encounters and Documents' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client Appointment' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Appointment' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client Visit Form' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Encounter Form' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client Notes' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Notes' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client number' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Number' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client Record Report' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Record Report' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client Report' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Report' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Referrals and Other Transactions' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient Transactions' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Patient/Client' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client ID (assign by the system)' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'PID' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Payments' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Prepay' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Service Provider' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Provider' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Client notes/Auth' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Pt Notes/Auth' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Default' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Rendering' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Prescp & Disp' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Rx' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Sales by Item' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Sales by Item' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Save Demographic Client Data' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Save Patient Demographic' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Search or Add Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Search or Add Patient ' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Select Client' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Select Patient' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Select Client by Last' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Select Patient by Last' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Risk' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Sensitivity' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'National ID' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'SSN' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Tally Sheet' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Superbill' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'This Visit' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'This Encounter' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Referrals' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Transact' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'User Administration' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'User & Group Administration' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'View Comprehensive Client Report' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'View Comprehensive Patient Report' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Diagnostic Labs & Orders' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Procedures' and ld.cons_id is null; insert into lang_definitions ( cons_id, lang_id, definition ) select lc.cons_id, 1, 'Program' from lang_constants as lc left join lang_definitions as ld on ld.cons_id = lc.cons_id and ld.lang_id = 1 where lc.constant_name = 'Layout Based' and ld.cons_id is null; UPDATE openemr_postcalendar_categories SET pc_catname = '1 Admission', pc_catcolor = '#FFFFFF' WHERE pc_catid = 10 AND pc_catname = 'New Patient'; UPDATE openemr_postcalendar_categories SET pc_catname = '2 Re-Visit', pc_catcolor = '#CCFFFF' WHERE pc_catid = 9 AND pc_catname = 'Established Patient'; #IfNotRow openemr_postcalendar_categories pc_catid 12 INSERT INTO `openemr_postcalendar_categories` VALUES (12,'3 Counselling Only','#FFFFCC','Counselling',1,NULL,'a:5:{s:17:\"event_repeat_freq\";s:1:\"1\";s:22:\"event_repeat_freq_type\";s:1:\"4\";s:19:\"event_repeat_on_num\";s:1:\"1\";s:19:\"event_repeat_on_day\";s:1:\"0\";s:20:\"event_repeat_on_freq\";s:1:\"0\";}',0,900,0,3,2,0,0); #EndIf #IfNotRow openemr_postcalendar_categories pc_catid 13 INSERT INTO `openemr_postcalendar_categories` VALUES (13,'4 Supply/Re-Supply','#CCCCCC','Supply/Re-Supply',1,NULL,'a:5:{s:17:\"event_repeat_freq\";s:1:\"1\";s:22:\"event_repeat_freq_type\";s:1:\"4\";s:19:\"event_repeat_on_num\";s:1:\"1\";s:19:\"event_repeat_on_day\";s:1:\"0\";s:20:\"event_repeat_on_freq\";s:1:\"0\";}',0,900,0,3,2,0,0); #EndIf #IfNotRow openemr_postcalendar_categories pc_catid 14 INSERT INTO `openemr_postcalendar_categories` VALUES (14,'5 Administrative','#FFFFFF','Supply/Re-Supply',1,NULL,'a:5:{s:17:\"event_repeat_freq\";s:1:\"1\";s:22:\"event_repeat_freq_type\";s:1:\"4\";s:19:\"event_repeat_on_num\";s:1:\"1\";s:19:\"event_repeat_on_day\";s:1:\"0\";s:20:\"event_repeat_on_freq\";s:1:\"0\";}',0,900,0,3,2,0,0); #EndIf #IfNotRow globals gl_name full_new_patient_form INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'full_new_patient_form' , 0, '3' ); #EndIf #IfNotRow globals gl_name patient_search_results_style INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'patient_search_results_style', 0, '1' ); #EndIf #IfNotRow globals gl_name simplified_demographics INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'simplified_demographics' , 0, '1' ); #EndIf #IfNotRow globals gl_name online_support_link INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'online_support_link' , 0, '' ); #EndIf #IfNotRow globals gl_name units_of_measurement INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'units_of_measurement' , 0, '2' ); #EndIf #IfNotRow globals gl_name specific_application INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'specific_application' , 0, '2' ); #EndIf #IfNotRow globals gl_name inhouse_pharmacy INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'inhouse_pharmacy' , 0, '2' ); #EndIf #IfNotRow globals gl_name configuration_import_export INSERT INTO globals ( gl_name, gl_index, gl_value ) VALUES ( 'configuration_import_export' , 0, '1' ); #EndIf #IfNotRow code_types ct_id 11 DELETE FROM code_types; INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('MA' ,12, 1, 0, '', 1, 1, 0, 0); INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('IPPF',11, 2, 0, '', 0, 0, 1, 0); INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('ICD9', 2, 3, 2, '', 0, 0, 0, 1); INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag ) VALUES ('ACCT',13, 4, 0, '', 0, 0, 1, 0); #EndIf #IfNotRow2D layout_options form_id LBFgcac field_id gc_rreason DELETE FROM layout_options WHERE form_id = 'LBFgcac'; INSERT INTO layout_options VALUES ('LBFgcac','client_status','1Basic Information','Client Status' , 1,27,2, 0, 0,'clientstatus',1,1,'','' ,'Client Status'); 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'); 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'); INSERT INTO layout_options VALUES ('LBFgcac','complications','2Complications','Complications' , 1,21,1, 2, 0,'complication',1,3,'','' ,'Post-Abortion Complications'); INSERT INTO layout_options VALUES ('LBFgcac','main_compl' ,'2Complications','Main Complication' , 2, 1,1, 2, 0,'complication',1,3,'','' ,'Primary Complication'); INSERT INTO layout_options VALUES ('LBFgcac','gc_rreason' ,'3IPPA CAC Section','Reason when Rejected/Referred', 1, 1,0, 0, 0,'gc_rreason' ,1,3,'','','Reason for rejecting or referring services'); INSERT INTO layout_options VALUES ('LBFgcac','gc_reason' ,'3IPPA CAC Section','Main Reason for MR Services' , 1, 1,0, 0, 0,'gc_reason' ,1,3,'','' ,'Main reason for requesting MR services'); INSERT INTO layout_options VALUES ('LBFgcac','gc_condition' ,'3IPPA CAC Section','Aborted Conception Condition' , 2, 1,0, 0 ,0,'gc_condition',1,3,'','' ,'Condition of Aborted Conception'); INSERT INTO layout_options VALUES ('LBFgcac','gc_efforts' ,'3IPPA CAC Section','Efforts Prior to Visit' , 3, 1,0, 0, 0,'gc_efforts' ,1,3,'','' ,'Other efforts conducted before visiting the clinic'); INSERT INTO layout_options VALUES ('LBFgcac','gc_complaint' ,'3IPPA CAC Section','Complaint from Client' , 4, 1,0, 0, 0,'gc_complaint',1,3,'','' ,'Complaint from Client'); #EndIf #IfNotRow2D list_options list_id lists option_id gc_rreason INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','gc_rreason','GCAC Reason to Reject/Refer Services',88); DELETE FROM list_options WHERE list_id = 'gc_rreason'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_rreason','1' ,'Service not available', 1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_rreason','2' ,'Cost of service' , 2); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_rreason','3' ,'Single' , 3); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_rreason','4' ,'Medical reason' , 4); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_rreason','5' ,'No responsible person', 5); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_rreason','6' ,'Weeks of pregnancy' , 6); #EndIf #IfNotRow2D list_options list_id lists option_id gc_reason INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','gc_reason','GCAC Main Reason for MR Services',88); DELETE FROM list_options WHERE list_id = 'gc_reason'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','1' ,'Have already enough children' , 1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','2' ,'The children are still babies' , 2); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','3' ,'Too young to have baby' , 3); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','4' ,'Too old to have other child' , 4); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','5' ,'Not / not yet married' , 5); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','6' ,'Still goes to school / college' , 6); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','7' ,'Engage with Official' , 7); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','8' ,'Could not stand pain / sickness of pregnancy', 8); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_reason','9' ,'Others' , 9); #EndIf #IfNotRow2D list_options list_id lists option_id gc_condition INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','gc_condition','GCAC Aborted Conception Condition',88); DELETE FROM list_options WHERE list_id = 'gc_condition'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_condition','1' ,'Fresh' , 1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_condition','2' ,'Dark' , 2); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_condition','3' ,'Sticky', 3); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_condition','4' ,'Others', 4); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_condition','5' ,'N/A' , 0); #EndIf #IfNotRow2D list_options list_id lists option_id gc_efforts INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','gc_efforts','GCAC Prior Efforts',88); DELETE FROM list_options WHERE list_id = 'gc_efforts'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_efforts','1' ,'None' , 1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_efforts','2' ,'Drinking herbs / medicines' , 2); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_efforts','3' ,'Had been taken care by paramedic' , 3); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_efforts','4' ,'Massage / went to traditional birth attendant', 4); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_efforts','5' ,'Other efforts' , 5); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_efforts','6' ,'Emergency' , 6); #EndIf #IfNotRow2D list_options list_id lists option_id gc_complaint INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('lists','gc_complaint','GCAC Complaint from Client',88); DELETE FROM list_options WHERE list_id = 'gc_complaint'; INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_complaint','1' ,'Facility' , 1); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_complaint','2' ,'Time of Queue' , 2); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_complaint','3' ,'Charge of Service', 3); INSERT INTO list_options ( list_id, option_id, title, seq ) VALUES ('gc_complaint','4' ,'None' , 4); #EndIf #IfNotRow2D list_options list_id clientstatus option_id defer DELETE FROM list_options WHERE list_id = 'clientstatus'; INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('clientstatus','maaa' ,'MA Client Accepting Abortion', 1,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('clientstatus','mara' ,'MA Client Refusing Abortion' , 2,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('clientstatus','refin' ,'Inbound Referral' , 3,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('clientstatus','self' ,'Self Referred' , 4,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('clientstatus','defer' ,'Deferring / Undecided' , 5,0,0); #EndIf #IfNotRow2D list_options list_id ab_location option_id na DELETE FROM list_options WHERE list_id = 'ab_location'; INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('ab_location','proc' ,'Procedure at this site' , 1,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('ab_location','ma' ,'Followup procedure from this site' , 2,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('ab_location','part' ,'Followup procedure from partner site', 3,0,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default, option_value ) VALUES ('ab_location','oth' ,'Followup procedure from other site' , 4,0,0); #EndIf #IfNotRow2D layout_options form_id REF field_id reply_related_code DELETE FROM layout_options WHERE form_id = 'REF'; INSERT INTO layout_options VALUES ('REF','refer_date' ,'1Referral','Referral Date' , 5, 4,2, 0, 0,'' ,1,1,'C','D','Date of referral'); INSERT INTO layout_options VALUES ('REF','refer_from' ,'1Referral','Referred By' ,10,10,2, 0, 0,'' ,1,1,'' ,'' ,'Referral By'); INSERT INTO layout_options VALUES ('REF','refer_external' ,'1Referral','External Referral' ,15, 1,2, 0, 0,'boolean' ,1,1,'' ,'' ,'External referral?'); INSERT INTO layout_options VALUES ('REF','refer_to' ,'1Referral','Referred To' ,20,14,2, 0, 0,'' ,1,1,'' ,'' ,'Referral To'); INSERT INTO layout_options VALUES ('REF','body' ,'1Referral','Reason' ,25, 3,2,30, 3,'' ,1,1,'' ,'' ,'Reason for referral'); INSERT INTO layout_options VALUES ('REF','refer_risk_level' ,'1Referral','Risk Level' ,30, 1,1, 0, 0,'risklevel',1,1,'' ,'' ,'Level of urgency'); INSERT INTO layout_options VALUES ('REF','refer_vitals' ,'1Referral','Include Vital Signs' ,35, 1,1, 0, 0,'boolean' ,1,1,'' ,'' ,'Include vitals data?'); INSERT INTO layout_options VALUES ('REF','refer_reply_date' ,'1Referral','Expected Reply Date' ,40, 4,2, 0, 0,'' ,1,1,'' ,'D','Expected date of reply'); INSERT INTO layout_options VALUES ('REF','refer_related_code','1Referral','Requested Service' ,45,15,2,30,255,'' ,1,1,'' ,'' ,'Billing Code for Requested Service'); INSERT INTO layout_options VALUES ('REF','refer_diag' ,'1Referral','Preliminary Diagnosis' ,50, 2,1,30,255,'' ,1,1,'' ,'X','Referrer diagnosis'); INSERT INTO layout_options VALUES ('REF','reply_date' ,'2Counter-Referral','Reply Date' , 5, 4,1, 0, 0,'' ,1,1,'' ,'D','Date of reply'); INSERT INTO layout_options VALUES ('REF','reply_from' ,'2Counter-Referral','Reply From' ,10, 2,1,30,255,'' ,1,1,'' ,'' ,'Who replied?'); INSERT INTO layout_options VALUES ('REF','reply_init_diag' ,'2Counter-Referral','Presumed Diagnosis' ,15, 2,0,30,255,'' ,1,1,'' ,'' ,'Presumed diagnosis by specialist'); INSERT INTO layout_options VALUES ('REF','reply_final_diag' ,'2Counter-Referral','Final Diagnosis' ,20, 2,1,30,255,'' ,1,1,'' ,'' ,'Final diagnosis by specialist'); INSERT INTO layout_options VALUES ('REF','reply_documents' ,'2Counter-Referral','Documents' ,25, 2,1,30,255,'' ,1,1,'' ,'' ,'Where may related scanned or paper documents be found?'); INSERT INTO layout_options VALUES ('REF','reply_findings' ,'2Counter-Referral','Findings' ,30, 3,1,30, 3,'' ,1,1,'' ,'' ,'Findings by specialist'); INSERT INTO layout_options VALUES ('REF','reply_services' ,'2Counter-Referral','Services Provided' ,35, 3,0,30, 3,'' ,1,1,'' ,'' ,'Service provided by specialist'); INSERT INTO layout_options VALUES ('REF','reply_related_code','2Counter-Referral','Service Provided' ,40,15,1,30,255,'' ,1,1,'' ,'' ,'Billing Code for actual services provided'); INSERT INTO layout_options VALUES ('REF','reply_recommend' ,'2Counter-Referral','Recommendations' ,45, 3,1,30, 3,'' ,1,1,'' ,'' ,'Recommendations by specialist'); INSERT INTO layout_options VALUES ('REF','reply_rx_refer' ,'2Counter-Referral','Prescriptions/Referrals',50, 3,1,30, 3,'' ,1,1,'' ,'' ,'Prescriptions and/or referrals by specialist'); #EndIf #IfNotRow code_types ct_key REF INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag) VALUES ('REF',16, 5, 0, '', 0, 1, 1, 0); #EndIf #IfMissingColumn patient_data usertext11 ALTER TABLE patient_data ADD usertext11 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext12 ALTER TABLE patient_data ADD usertext12 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext13 ALTER TABLE patient_data ADD usertext13 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext14 ALTER TABLE patient_data ADD usertext14 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext15 ALTER TABLE patient_data ADD usertext15 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext16 ALTER TABLE patient_data ADD usertext16 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext17 ALTER TABLE patient_data ADD usertext17 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext18 ALTER TABLE patient_data ADD usertext18 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext19 ALTER TABLE patient_data ADD usertext19 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfMissingColumn patient_data usertext20 ALTER TABLE patient_data ADD usertext20 varchar(255) NOT NULL DEFAULT ''; #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext11 INSERT INTO `layout_options` VALUES ('DEM', 'usertext11', '6Misc', 'User Defined Text 11', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext12 INSERT INTO `layout_options` VALUES ('DEM', 'usertext12', '6Misc', 'User Defined Text 12', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext13 INSERT INTO `layout_options` VALUES ('DEM', 'usertext13', '6Misc', 'User Defined Text 13', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext14 INSERT INTO `layout_options` VALUES ('DEM', 'usertext14', '6Misc', 'User Defined Text 14', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext15 INSERT INTO `layout_options` VALUES ('DEM', 'usertext15', '6Misc', 'User Defined Text 15', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext16 INSERT INTO `layout_options` VALUES ('DEM', 'usertext16', '6Misc', 'User Defined Text 16', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext17 INSERT INTO `layout_options` VALUES ('DEM', 'usertext17', '6Misc', 'User Defined Text 17', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext18 INSERT INTO `layout_options` VALUES ('DEM', 'usertext18', '6Misc', 'User Defined Text 18', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext19 INSERT INTO `layout_options` VALUES ('DEM', 'usertext19', '6Misc', 'User Defined Text 19', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D layout_options form_id DEM field_id usertext20 INSERT INTO `layout_options` VALUES ('DEM', 'usertext20', '6Misc', 'User Defined Text 20', 8,2,0,10,63,'',1,1,'','','User Defined'); #EndIf #IfNotRow2D list_options list_id lists option_id actorest INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES ('lists','actorest','Actual or Estimated', 1,0); INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES ('actorest','act' ,'Actual' ,10,1); INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES ('actorest','est' ,'Estimated',20,0); UPDATE layout_options SET group_name = '1Who', title='', seq = 7, data_type = 1, uor = 1, fld_length = 0, list_id = 'actorest', titlecols = 0, datacols = 0, description = 'Indicates if DOB is estimated' WHERE form_id = 'DEM' AND field_id = 'usertext3' AND uor = 0; #EndIf