Failure to upgrade to Openemr 5 from 4.2.2

[system]

jhunyan wrote on Friday, February 17, 2017:

Hi,

I have problem with upgrading Openemr to the latest version. I seem to be getting the error message. I followed the steps in http://www.open-emr.org/wiki/index.php/Windows_Upgrade_4.2.2_to_5.0.0

The error message is as below.

OpenEMR Database Upgrade
Processing 4_2_2-to-5_0_0_upgrade.sql …
Starting conversion of TEXT types to use default NULL.
amendments.amendment_desc sql column was successfully converted to text with default NULL setting.
amendments_history.amendment_note sql column was successfully converted to text with default NULL setting.
ar_activity.follow_up_note sql column was successfully converted to text with default NULL setting.
ar_session.description sql column was successfully converted to text with default NULL setting.
audit_details.field_value sql column was successfully converted to text with default NULL setting.
audit_master.comments sql column was successfully converted to text with default NULL setting.
automatic_notification.message sql column was successfully converted to text with default NULL setting.
clinical_rules_log.value sql column was successfully converted to text with default NULL setting.
clinical_rules_log.new_value sql column was successfully converted to text with default NULL setting.
customlists.cl_list_item_long sql column was successfully converted to text with default NULL setting.
documents_legal_detail.dld_denial_reason sql column was successfully converted to longtext with default NULL setting.
facility_user_ids.field_value sql column was successfully converted to text with default NULL setting.
history_data.exams sql column was successfully converted to text with default NULL setting.
history_data.usertext11 sql column was successfully converted to text with default NULL setting.
history_data.userarea11 sql column was successfully converted to text with default NULL setting.
history_data.userarea12 sql column was successfully converted to text with default NULL setting.
lang_custom.constant_name sql column was successfully converted to mediumtext with default NULL setting.
lang_custom.definition sql column was successfully converted to mediumtext with default NULL setting.
layout_options.conditions sql column was successfully converted to text with default NULL setting.
lbf_data.field_value sql column was successfully converted to text with default NULL setting.
lbt_data.field_value sql column was successfully converted to text with default NULL setting.
log_comment_encrypt.checksum sql column was successfully converted to longtext with default NULL setting.
notification_log.message sql column was successfully converted to text with default NULL setting.
notification_log.patient_info sql column was successfully converted to text with default NULL setting.
patient_data.billing_note sql column was successfully converted to text with default NULL setting.
patient_data.industry sql column was successfully converted to text with default NULL setting.
procedure_order.patient_instructions sql column was successfully converted to text with default NULL setting.
procedure_order_code.diagnoses sql column was successfully converted to text with default NULL setting.
procedure_providers.notes sql column was successfully converted to text with default NULL setting.
procedure_questions.options sql column was successfully converted to text with default NULL setting.
procedure_report.report_notes sql column was successfully converted to text with default NULL setting.
procedure_result.comments sql column was successfully converted to text with default NULL setting.
rule_action_item.reminder_message sql column was successfully converted to text with default NULL setting.
shared_attributes.field_value sql column was successfully converted to text with default NULL setting.
solo_akeeba_common.value sql column was successfully converted to longtext with default NULL setting.
ALTER TABLE ar_activity MODIFY sequence_no int UNSIGNED NOT NULL COMMENT ‘Sequence_no, incremented in code’
ALTER TABLE ar_activity ENGINE=“InnoDB”
ALTER TABLE claims MODIFY version int(10) UNSIGNED NOT NULL COMMENT ‘Version, incremented in code’
ALTER TABLE claims ENGINE=“InnoDB”
ALTER TABLE procedure_answers MODIFY answer_seq int(11) NOT NULL COMMENT ‘Supports multiple-choice questions. Answer_seq, incremented in code’
ALTER TABLE procedure_answers ENGINE=“InnoDB”
ALTER TABLE procedure_order_code MODIFY procedure_order_seq int(11) NOT NULL COMMENT ‘Supports multiple tests per order. Procedure_order_seq incremented in code’
ALTER TABLE procedure_order_code ENGINE=“InnoDB”
Starting migration to InnoDB, please wait.
Table addresses migrated to InnoDB.
Table amc_misc_data migrated to InnoDB.
Table amendments migrated to InnoDB.
Table amendments_history migrated to InnoDB.
Table ar_session migrated to InnoDB.
Table array migrated to InnoDB.
Table audit_details migrated to InnoDB.
Table audit_master migrated to InnoDB.
Table background_services migrated to InnoDB.
Table batchcom migrated to InnoDB.
Table billing migrated to InnoDB.
Table categories migrated to InnoDB.
Table categories_seq migrated to InnoDB.
Table categories_to_documents migrated to InnoDB.
Table chart_tracker migrated to InnoDB.
Table clinical_plans migrated to InnoDB.
Table clinical_plans_rules migrated to InnoDB.
Table clinical_rules migrated to InnoDB.
Table clinical_rules_log migrated to InnoDB.
Table code_types migrated to InnoDB.
Table codes migrated to InnoDB.
Table config migrated to InnoDB.
Table config_seq migrated to InnoDB.
Table dated_reminders migrated to InnoDB.
Table dated_reminders_link migrated to InnoDB.
Table direct_message_log migrated to InnoDB.
Table documents migrated to InnoDB.
Table documents_legal_categories migrated to InnoDB.
Table documents_legal_detail migrated to InnoDB.
Table documents_legal_master migrated to InnoDB.
Table drug_inventory migrated to InnoDB.
Table drug_sales migrated to InnoDB.
Table drug_templates migrated to InnoDB.
Table drugs migrated to InnoDB.
Table eligibility_response migrated to InnoDB.
Table eligibility_verification migrated to InnoDB.
Table employer_data migrated to InnoDB.
Table enc_category_map migrated to InnoDB.
Table extended_log migrated to InnoDB.
Table facility migrated to InnoDB.
Table facility_user_ids migrated to InnoDB.
Table fee_sheet_options migrated to InnoDB.
Table form_dictation migrated to InnoDB.
Table form_encounter migrated to InnoDB.
Table form_eye_mag was purposefully skipped and NOT migrated to InnoDB.
Table form_misc_billing_options migrated to InnoDB.
Table form_reviewofs migrated to InnoDB.
Table form_ros migrated to InnoDB.
Table form_soap migrated to InnoDB.
Table form_vitals migrated to InnoDB.
Table forms migrated to InnoDB.
Table gacl_acl migrated to InnoDB.
Table gacl_acl_sections migrated to InnoDB.
Table gacl_acl_seq migrated to InnoDB.
Table gacl_aco migrated to InnoDB.
Table gacl_aco_map migrated to InnoDB.
Table gacl_aco_sections migrated to InnoDB.
Table gacl_aco_sections_seq migrated to InnoDB.
Table gacl_aco_seq migrated to InnoDB.
Table gacl_aro migrated to InnoDB.
Table gacl_aro_groups migrated to InnoDB.
Table gacl_aro_groups_id_seq migrated to InnoDB.
Table gacl_aro_groups_map migrated to InnoDB.
Table gacl_aro_map migrated to InnoDB.
Table gacl_aro_sections migrated to InnoDB.
Table gacl_aro_sections_seq migrated to InnoDB.
Table gacl_aro_seq migrated to InnoDB.
Table gacl_axo migrated to InnoDB.
Table gacl_axo_groups migrated to InnoDB.
Table gacl_axo_groups_map migrated to InnoDB.
Table gacl_axo_map migrated to InnoDB.
Table gacl_axo_sections migrated to InnoDB.
Table gacl_groups_aro_map migrated to InnoDB.
Table gacl_groups_axo_map migrated to InnoDB.
Table gacl_phpgacl migrated to InnoDB.
Table geo_country_reference migrated to InnoDB.
Table geo_zone_reference migrated to InnoDB.
Table globals migrated to InnoDB.
Table gprelations migrated to InnoDB.
Table groups migrated to InnoDB.
Table history_data migrated to InnoDB.
Table icd10_dx_order_code migrated to InnoDB.
Table icd10_gem_dx_10_9 migrated to InnoDB.
Table icd10_gem_dx_9_10 migrated to InnoDB.
Table icd10_gem_pcs_10_9 migrated to InnoDB.
Table icd10_gem_pcs_9_10 migrated to InnoDB.
Table icd10_pcs_order_code migrated to InnoDB.
Table icd10_reimbr_dx_9_10 migrated to InnoDB.
Table icd10_reimbr_pcs_9_10 migrated to InnoDB.
Table icd9_dx_code migrated to InnoDB.
Table icd9_dx_long_code migrated to InnoDB.
Table icd9_sg_code migrated to InnoDB.
Table icd9_sg_long_code migrated to InnoDB.
Table immunizations migrated to InnoDB.
Table insurance_companies migrated to InnoDB.
Table insurance_data migrated to InnoDB.
Table insurance_numbers migrated to InnoDB.
Table integration_mapping migrated to InnoDB.
Table issue_encounter migrated to InnoDB.
Table issue_types migrated to InnoDB.
Table lang_constants migrated to InnoDB.
Table lang_custom migrated to InnoDB.
Table lang_definitions migrated to InnoDB.
Table lang_languages migrated to InnoDB.
Table layout_options migrated to InnoDB.
Table lbf_data migrated to InnoDB.
Table lbt_data migrated to InnoDB.
Table list_options migrated to InnoDB.
Table lists migrated to InnoDB.
Table lists_touch migrated to InnoDB.
Table log migrated to InnoDB.
Table notes migrated to InnoDB.
Table onotes migrated to InnoDB.
Table openemr_module_vars migrated to InnoDB.
Table openemr_modules migrated to InnoDB.
Table openemr_postcalendar_categories migrated to InnoDB.
Table openemr_postcalendar_events migrated to InnoDB.
Table openemr_postcalendar_limits migrated to InnoDB.
Table openemr_postcalendar_topics migrated to InnoDB.
Table openemr_session_info migrated to InnoDB.
Table patient_access_offsite migrated to InnoDB.
Table patient_access_onsite migrated to InnoDB.
Table patient_data migrated to InnoDB.
Table patient_reminders migrated to InnoDB.
Table patient_tracker migrated to InnoDB.
Table patient_tracker_element migrated to InnoDB.
Table payments migrated to InnoDB.
Table pharmacies migrated to InnoDB.
Table phone_numbers migrated to InnoDB.
Table pma_bookmark migrated to InnoDB.
Table pma_column_info migrated to InnoDB.
Table pma_history migrated to InnoDB.
Table pma_pdf_pages migrated to InnoDB.
Table pma_relation migrated to InnoDB.
Table pma_table_coords migrated to InnoDB.
Table pma_table_info migrated to InnoDB.
Table pnotes migrated to InnoDB.
Table prescriptions migrated to InnoDB.
Table prices migrated to InnoDB.
Table procedure_order migrated to InnoDB.
Table procedure_providers migrated to InnoDB.
Table procedure_questions migrated to InnoDB.
Table procedure_report migrated to InnoDB.
Table procedure_result migrated to InnoDB.
Table procedure_type migrated to InnoDB.
Table product_warehouse migrated to InnoDB.
Table registry migrated to InnoDB.
Table report_itemized migrated to InnoDB.
Table report_results migrated to InnoDB.
Table rule_action migrated to InnoDB.
Table rule_action_item migrated to InnoDB.
Table rule_filter migrated to InnoDB.
Table rule_patient_data migrated to InnoDB.
Table rule_reminder migrated to InnoDB.
Table rule_target migrated to InnoDB.
Table sequences migrated to InnoDB.
Table shared_attributes migrated to InnoDB.
Table solo_ak_params migrated to InnoDB.
Table solo_ak_profiles migrated to InnoDB.
Table solo_ak_stats migrated to InnoDB.
Table solo_ak_storage migrated to InnoDB.
Table solo_ak_users migrated to InnoDB.
Table solo_akeeba_common migrated to InnoDB.
Table standardized_tables_track migrated to InnoDB.
Table supported_external_dataloads migrated to InnoDB.
Table syndromic_surveillance migrated to InnoDB.
Table template_users migrated to InnoDB.
Table transactions migrated to InnoDB.
Table user_settings migrated to InnoDB.
Table users migrated to InnoDB.
Table version migrated to InnoDB.
Table x12_partners migrated to InnoDB.
Skipping section #IfNotTable valueset
ALTER TABLE openemr_postcalendar_categories ADD pc_active tinyint(1) NOT NULL DEFAULT 1
ALTER TABLE openemr_postcalendar_categories ADD pc_seq int(11) NOT NULL DEFAULT ‘0’
UPDATE openemr_postcalendar_categories set pc_seq = pc_catid
SET @catid = (SELECT MAX(pc_catid) FROM openemr_postcalendar_categories)
INSERT INTO openemr_postcalendar_categories (pc_catid, pc_catname, pc_catcolor, pc_catdesc, pc_recurrtype, pc_enddate, pc_recurrspec, pc_recurrfreq, pc_duration, pc_end_date_flag, pc_end_date_type, pc_end_date_freq, pc_end_all_day, pc_dailylimit, pc_cattype, pc_active, pc_seq) VALUES (@catid+1, ‘Health and Behavioral Assessment’, ‘#C7C7C7’, ‘Health and Behavioral Assessment’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;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, 0, 0, 0, 0,0,1,@catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_hea_and_beh’, @catid+1)
SET @catid = (SELECT MAX(pc_catid) FROM openemr_postcalendar_categories)
INSERT INTO openemr_postcalendar_categories (pc_catid, pc_catname, pc_catcolor, pc_catdesc, pc_recurrtype, pc_enddate, pc_recurrspec, pc_recurrfreq, pc_duration, pc_end_date_flag, pc_end_date_type, pc_end_date_freq, pc_end_all_day, pc_dailylimit, pc_cattype, pc_active, pc_seq) VALUES (@catid+1, ‘Preventive Care Services’, ‘#CCCCFF’, ‘Preventive Care Services’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;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, 0, 0, 0, 0,0,1,@catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_pre_ind_counsel’, @catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_pre_med_group_counsel’, @catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_pre_med_other_serv’, @catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_pre_med_ser_18_older’, @catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_pre_med_ser_40_older’, @catid+1)
SET @max_seq = (select max(seq) from list_options where list_id = ‘order_type’)
INSERT INTO list_options (list_id,option_id,title,seq,is_default) values (‘order_type’,‘enc_checkup_procedure’,‘Encounter Checkup Procedure’,@max_seq+10,0)
UPDATE clinical_rules set cqm_nqf_code = ‘0018’ where id = ‘rule_htn_bp_measure_cqm’
Skipping section #IfNotTable calendar_external
INSERT INTO openemr_postcalendar_categories (pc_catid, pc_catname, pc_catcolor, pc_catdesc, pc_recurrtype, pc_enddate, pc_recurrspec, pc_recurrfreq, pc_duration, pc_end_date_flag, pc_end_date_type, pc_end_date_freq, pc_end_all_day, pc_dailylimit, pc_cattype, pc_active, pc_seq)VALUES (6,‘Holidays’,’#9676DB’,‘Clinic holiday’,0,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,86400,1,3,2,0,0,2,1,6)
INSERT INTO openemr_postcalendar_categories (pc_catid, pc_catname, pc_catcolor, pc_catdesc, pc_recurrtype, pc_enddate, pc_recurrspec, pc_recurrfreq, pc_duration, pc_end_date_flag, pc_end_date_type, pc_end_date_freq, pc_end_all_day, pc_dailylimit, pc_cattype, pc_active, pc_seq)VALUES (7,‘Closed’,’#2374AB’,‘Clinic closed’,0,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,86400,1,3,2,0,0,2,1,7)
ALTER TABLE immunizations ADD COLUMN information_source VARCHAR(31) DEFAULT NULL
ALTER TABLE immunizations ADD COLUMN refusal_reason VARCHAR(31) DEFAULT NULL
ALTER TABLE immunizations ADD COLUMN ordering_provider INT(11) DEFAULT NULL
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’,‘immunization_registry_status’,‘Immunization Registry Status’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_registry_status’,‘active’,‘Active’,‘A’, ‘10’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_registry_status’,‘inactive_lost_to_follow_up’,‘Inactive - Lost to follow - up’,‘L’, ‘20’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_registry_status’,‘inactive_moved_gone_elsewhere’,‘Inactive - Moved or gone elsewhere’,‘M’, ‘30’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_registry_status’,‘inactive_permanently_inactive’,‘Inactive - Permanently inactive’,‘P’, ‘40’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_registry_status’,‘inactive_unspecified’,‘Inactive - Unspecified’,‘I’, ‘50’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_registry_status’,‘unknown’,‘Unknown’,‘U’, ‘60’)
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’,‘publicity_code’,‘Publicity Code’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘no_reminder_recall’,‘No reminder/recall’,‘SI’, ‘10’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_recall_any_method’,‘Reminder/recall - any method’,‘02’, ‘20’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_recall_no_calls’,‘Reminder/recall - no calls’,‘03’, ‘30’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_only_any_method’,‘Reminder only - any method’,‘04’, ‘40’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_only_no_calls’,‘Reminder only - no calls’,‘05’, ‘50’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘recall_only_any_method’,‘Recall only - any method’,‘06’, ‘60’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘recall_only_no_calls’,‘Recall only - no calls’,‘07’, ‘70’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_recall_to_provider’,‘Reminder/recall - to provider’,‘08’, ‘80’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_to_provider’,‘Reminder to provider’,‘09’, ‘90’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘reminder_to_provider_no_recall’,‘Only reminder to provider, no recall’,‘10’, ‘100’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘recall_to_provider’,‘Recall to provider’,‘11’, ‘110’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘publicity_code’,‘recall_to_provider_no_reminder’,‘Only recall to provider, no reminder’,‘12’, ‘120’)
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’,‘immunization_refusal_reason’,‘Immunization Refusal Reason’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_refusal_reason’,‘parental_decision’,‘Parental decision’,‘00’, ‘10’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_refusal_reason’,‘religious_exemption’,‘Religious exemption’,‘01’, ‘20’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_refusal_reason’,‘other’,‘Other’,‘02’, ‘30’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_refusal_reason’,‘patient_decision’,‘Patient decision’,‘03’, ‘40’)
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’,‘immunization_informationsource’,‘Immunization Information Source’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘new_immunization_record’,‘New Immunization Record’,‘00’, ‘10’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘hist_inf_src_unspecified’,‘Historical information -source unspecified’,‘01’, ‘20’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘other_provider’,‘Other Provider’,‘02’, ‘30’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘parent_written_record’,‘Parent Written Record’,‘03’, ‘40’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘parent_recall’,‘Parent Recall’,‘04’, ‘50’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘other_registry’,‘Other Registry’,‘05’, ‘60’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘birth_certificate’,‘Birth Certificate’,‘06’, ‘70’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘school_record’,‘School Record’,‘07’, ‘80’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_informationsource’,‘public_agency’,‘Public Agency’,‘08’, ‘90’)
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’,‘next_of_kin_relationship’,‘Next of Kin Relationship’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘associate’,‘Associate’,‘10’,‘ASC’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) values (‘next_of_kin_relationship’,‘brother’,‘Brother’,‘20’,‘BRO’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘care_giver’,‘Care giver’,‘30’,‘CGV’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘child’,‘Child’,‘40’,‘CHD’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘handicapped_dependent’,‘Handicapped dependent’,‘50’,‘DEP’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘life_partner’,‘Life partner’,‘60’,‘DOM’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘emergency_contact’,‘Emergency contact’,‘70’,‘EMC’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘employee’,‘Employee’,‘80’,‘EME’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘employer’,‘Employer’,‘90’,‘EMR’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘extended_family’,‘Extended family’,‘100’,‘EXF’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘foster_child’,‘Foster Child’,‘110’,‘FCH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘friend’,‘Friend’,‘120’,‘FND’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘father’,‘Father’,‘130’,‘FTH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘grandchild’,‘Grandchild’,‘140’,‘GCH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘guardian’,‘Guardian’,‘150’,‘GRD’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘grandparent’,‘Grandparent’,‘160’,‘GRP’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘manager’,‘Manager’,‘170’,‘MGR’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘mother’,‘Mother’,‘180’,‘MTH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘natural_child’,‘Natural child’,‘190’,‘NCH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘none’,‘None’,‘200’,‘NON’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘other_adult’,‘Other adult’,‘210’,‘OAD’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘other’,‘Other’,‘220’,‘OTH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘owner’,‘Owner’,‘230’,‘OWN’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘parent’,‘Parent’,‘240’,‘PAR’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘stepchild’,‘Stepchild’,‘250’,‘SCH’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘self’,‘Self’,‘260’,‘SEL’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘sibling’,‘Sibling’,‘270’,‘SIB’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘sister’,‘Sister’,‘280’,‘SIS’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘spouse’,‘Spouse’,‘290’,‘SPO’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘trainer’,‘Trainer’,‘300’,‘TRA’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘unknown’,‘Unknown’,‘310’,‘UNK’)
INSERT INTO list_options (list_id, option_id, title, seq, notes) VALUES (‘next_of_kin_relationship’,‘ward_of_court’,‘Ward of court’,‘320’,‘WRD’)
INSERT INTO list_options (list_id, option_id, title) VALUES (‘lists’,‘immunization_administered_site’,‘Immunization Administered Site’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘left_thigh’,‘Left Thigh’,‘LT’, ‘10’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘left_arm’,‘Left Arm’,‘LA’, ‘20’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘left_deltoid’,‘Left Deltoid’,‘LD’, ‘30’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘left_gluteus_medius’,‘Left Gluteus Medius’,‘LG’, ‘40’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘left_vastus_lateralis’,‘Left Vastus Lateralis’,‘LVL’, ‘50’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘left_lower_forearm’,‘Left Lower Forearm’,‘LLFA’, ‘60’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘nose’,‘Nose’,‘Nose’, ‘70’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘right_arm’,‘Right Arm’,‘RA’, ‘80’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘right_thigh’,‘Right Thigh’,‘RT’, ‘90’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘right_vastus_lateralis’,‘Right Vastus Lateralis’,‘RVL’, ‘100’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘right_gluteus_medius’,‘Right Gluteus Medius’,‘RG’, ‘110’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘right_deltoid’,‘Right Deltoid’,‘RD’, ‘120’)
INSERT INTO list_options (list_id, option_id, title, notes, seq) VALUES (‘immunization_administered_site’,‘right_lower_forearm’,‘Right Lower Forearm’,‘RLFA’, ‘130’)
INSERT INTO list_options(list_id, option_id, title) VALUES (‘lists’,‘immunization_observation’,‘Immunization Observation Criteria’)
INSERT INTO list_options(list_id, option_id, title, seq, notes, codes) VALUES (‘immunization_observation’,‘funding_program_eligibility’,‘Vaccine funding program eligibility category’,‘10’,‘LN’,‘LOINC:64994-7’)
INSERT INTO list_options(list_id, option_id, title, seq, notes, codes) VALUES (‘immunization_observation’,‘vaccine_type’,‘Vaccine Type’,‘20’,‘LN’,‘LOINC:30956-7’)
INSERT INTO list_options(list_id, option_id, title, seq, notes, codes) VALUES (‘immunization_observation’,‘disease_with_presumed_immunity’,‘Disease with presumed immunity’,‘30’,‘LN’,‘LOINC:59784-9’)
INSERT INTO list_options(list_id, option_id, title) VALUES (‘lists’,‘imm_vac_eligibility_results’,‘Immunization Vaccine Eligibility Results’)
INSERT INTO list_options(list_id, option_id, title, seq, notes) VALUES (‘imm_vac_eligibility_results’,‘not_vfc_eligible’,‘Not VFC eligible’,‘10’,‘V01’)
INSERT INTO list_options(list_id, option_id, title, seq, notes) VALUES (‘imm_vac_eligibility_results’,‘medicaid_managed_care’,‘VFC eligible-Medicaid/Medicaid Managed Care’,‘20’,‘V02’)
INSERT INTO list_options(list_id, option_id, title, seq, notes) VALUES (‘imm_vac_eligibility_results’,‘uninsured’,‘VFC eligible- Uninsured’,‘30’,‘V03’)
INSERT INTO list_options(list_id, option_id, title, seq, notes) VALUES (‘imm_vac_eligibility_results’,‘american_indian_alaskan_native’,‘VFC eligible- American Indian/Alaskan Native’,‘40’,‘V04’)
INSERT INTO list_options(list_id, option_id, title, seq, notes) VALUES (‘imm_vac_eligibility_results’,‘health_center_patient’,‘VFC eligible-Federally Qualified Health Center Patient (under-insured)’,‘50’,‘V05’)
Skipping section #IfNotTable immunization_observation
SET @group_name = (SELECT group_name FROM layout_options WHERE form_id=‘DEM’ AND group_name LIKE ‘%Choices’ LIMIT 1)
SET @backup_group_name = (SELECT group_name FROM layout_options WHERE field_id=‘hipaa_notice’ AND form_id=‘DEM’)
SET @seq = (SELECT MAX(seq) FROM layout_options WHERE group_name = IFNULL(@group_name,@backup_group_name) AND form_id=‘DEM’)
INSERT INTO layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows) VALUES (‘DEM’, ‘imm_reg_status’, IFNULL(@group_name,@backup_group_name), ‘Immunization Registry Status’, @seq+1, 1, 1, 1, 0, ‘immunization_registry_status’, 1, 1, ‘’, ‘’, ‘Immunization Registry Status’, 0)
ALTER TABLE patient_data ADD COLUMN imm_reg_status TEXT
SET @group_name = (SELECT group_name FROM layout_options WHERE form_id=‘DEM’ AND group_name LIKE ‘%Choices’ LIMIT 1)
SET @backup_group_name = (SELECT group_name FROM layout_options WHERE field_id=‘hipaa_notice’ AND form_id=‘DEM’)
SET @seq = (SELECT MAX(seq) FROM layout_options WHERE group_name = IFNULL(@group_name,@backup_group_name) AND form_id=‘DEM’)
INSERT INTO layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows) VALUES (‘DEM’, ‘imm_reg_stat_effdate’, IFNULL(@group_name,@backup_group_name), ‘Immunization Registry Status Effective Date’, @seq+1, 4, 1, 10, 10, ‘’, 1, 1, ‘’, ‘’, ‘Immunization Registry Status Effective Date’, 0)
ALTER TABLE patient_data ADD COLUMN imm_reg_stat_effdate TEXT
SET @group_name = (SELECT group_name FROM layout_options WHERE form_id=‘DEM’ AND group_name LIKE ‘%Choices’ LIMIT 1)
SET @backup_group_name = (SELECT group_name FROM layout_options WHERE field_id=‘hipaa_notice’ AND form_id=‘DEM’)
SET @seq = (SELECT MAX(seq) FROM layout_options WHERE group_name = IFNULL(@group_name,@backup_group_name) AND form_id=‘DEM’)
INSERT INTO layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows) VALUES (‘DEM’, ‘publicity_code’, IFNULL(@group_name,@backup_group_name), ‘Publicity Code’, @seq+1, 1, 1, 1, 0, ‘publicity_code’, 1, 1, ‘’, ‘’, ‘Publicity Code’, 0)
ALTER TABLE patient_data ADD COLUMN publicity_code TEXT
SET @group_name = (SELECT group_name FROM layout_options WHERE form_id=‘DEM’ AND group_name LIKE ‘%Choices’ LIMIT 1)
SET @backup_group_name = (SELECT group_name FROM layout_options WHERE field_id=‘hipaa_notice’ AND form_id=‘DEM’)
SET @seq = (SELECT MAX(seq) FROM layout_options WHERE group_name = IFNULL(@group_name,@backup_group_name) AND form_id=‘DEM’)
INSERT INTO layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows) VALUES (‘DEM’, ‘publ_code_eff_date’, IFNULL(@group_name,@backup_group_name), ‘Publicity Code Effective Date’, @seq+1, 4, 1, 10, 10, ‘’, 1, 1, ‘’, ‘’, ‘Publicity Code Effective Date’, 0)
ALTER TABLE patient_data ADD COLUMN publ_code_eff_date TEXT
SET @group_name = (SELECT group_name FROM layout_options WHERE form_id=‘DEM’ AND group_name LIKE ‘%Choices’ LIMIT 1)
SET @backup_group_name = (SELECT group_name FROM layout_options WHERE field_id=‘hipaa_notice’ AND form_id=‘DEM’)
SET @seq = (SELECT MAX(seq) FROM layout_options WHERE group_name = IFNULL(@group_name,@backup_group_name) AND form_id=‘DEM’)
INSERT INTO layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows) VALUES (‘DEM’, ‘protect_indicator’, IFNULL(@group_name,@backup_group_name), ‘Protection Indicator’, @seq+1, 1, 1, 1, 0, ‘yesno’, 1, 1, ‘’, ‘’, ‘Protection Indicator’, 0)
ALTER TABLE patient_data ADD COLUMN protect_indicator TEXT
SET @group_name = (SELECT group_name FROM layout_options WHERE form_id=‘DEM’ AND group_name LIKE ‘%Choices’ LIMIT 1)
SET @backup_group_name = (SELECT group_name FROM layout_options WHERE field_id=‘hipaa_notice’ AND form_id=‘DEM’)
SET @seq = (SELECT MAX(seq) FROM layout_options WHERE group_name = IFNULL(@group_name,@backup_group_name) AND form_id=‘DEM’)
INSERT INTO layout_options (form_id, field_id, group_name, title, seq, data_type, uor, fld_length, max_length, list_id, titlecols, datacols, default_value, edit_options, description, fld_rows) VALUES (‘DEM’, ‘prot_indi_effdate’, IFNULL(@group_name,@backup_group_name), ‘Protection Indicator Effective Date’, @seq+1, 4, 1, 10, 10, ‘’, 1, 1, ‘’, ‘’, ‘Protection Indicator Effective Date’, 0)
ALTER TABLE patient_data ADD COLUMN prot_indi_effdate TEXT
UPDATE layout_options SET group_name=‘8Guardian’,title=‘Name’,seq=‘10’ WHERE form_id=‘DEM’ AND field_id=‘guardiansname’ AND group_name LIKE ‘%Contact’
ALTER TABLE patient_data MODIFY guardiansname TEXT
Skipping section #IfMissingColumn patient_data guardiansname
ALTER TABLE patient_data ADD COLUMN guardianrelationship TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianrelationship’ , ‘8Guardian’, ‘Relationship’ ,20, 1, 1,0,0, ‘next_of_kin_relationship’, 1, 1, ‘’, ‘’, ‘Relationship’, 0)
ALTER TABLE patient_data ADD COLUMN guardiansex TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardiansex’ , ‘8Guardian’, ‘Sex’ ,30, 1, 1,0,0, ‘sex’, 1, 1, ‘’, ‘’, ‘Sex’, 0)
ALTER TABLE patient_data ADD COLUMN guardianaddress TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianaddress’ , ‘8Guardian’, ‘Address’ ,40, 2, 1,25,63, ‘’, 1, 1, ‘’, ‘’, ‘Address’, 0)
ALTER TABLE patient_data ADD COLUMN guardiancity TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardiancity’ , ‘8Guardian’, ‘City’ ,50, 2, 1,15,63, ‘’, 1, 1, ‘’, ‘’, ‘City’, 0)
ALTER TABLE patient_data ADD COLUMN guardianstate TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianstate’ , ‘8Guardian’, ‘State’ ,60, 26, 1,0,0, ‘state’, 1, 1, ‘’, ‘’, ‘State’, 0)
ALTER TABLE patient_data ADD COLUMN guardianpostalcode TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianpostalcode’ , ‘8Guardian’, ‘Postal Code’ ,70, 2, 1,6,63, ‘’, 1, 1, ‘’, ‘’, ‘Postal Code’, 0)
ALTER TABLE patient_data ADD COLUMN guardiancountry TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardiancountry’ , ‘8Guardian’, ‘Country’ ,80, 26, 1,0,0, ‘country’, 1, 1, ‘’, ‘’, ‘Country’, 0)
ALTER TABLE patient_data ADD COLUMN guardianphone TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianphone’ , ‘8Guardian’, ‘Phone’ ,90, 2, 1,20,63, ‘’, 1, 1, ‘’, ‘’, ‘Phone’, 0)
ALTER TABLE patient_data ADD COLUMN guardianworkphone TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianworkphone’ , ‘8Guardian’, ‘Work Phone’ ,100, 2, 1,20,63, ‘’, 1, 1, ‘’, ‘’, ‘Work Phone’, 0)
ALTER TABLE patient_data ADD COLUMN guardianemail TEXT
INSERT INTO layout_options (form_id,field_id,group_name,title,seq,data_type,uor,fld_length,max_length,list_id,titlecols,datacols,default_value,edit_options,description,fld_rows) VALUES (‘DEM’, ‘guardianemail’ , ‘8Guardian’, ‘Email’ ,110, 2, 1,20,63, ‘’, 1, 1, ‘’, ‘’, ‘Guardian Email Address’, 0)
SET @option_id = (SELECT MAX(CAST(option_id AS UNSIGNED)) FROM list_options WHERE list_id = ‘drug_units’)
SET @seq = (SELECT MAX(seq) FROM list_options WHERE list_id = ‘drug_units’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘drug_units’, @option_id+1, ‘mL’, @seq+1, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default, notes, codes ) VALUES (‘drug_route’,‘intramuscular’,‘Intramuscular’ ,20, 0, ‘IM’, ‘NCI-CONCEPT-ID:C28161’)
UPDATE list_options SET notes=‘N’ WHERE list_id=‘yesno’ and option_id=‘NO’
UPDATE list_options SET notes=‘Y’ WHERE list_id=‘yesno’ and option_id=‘YES’
INSERT INTO list_options ( list_id, option_id, title, seq, codes ) VALUES (‘reaction’, ‘shortness_of_breath’, ‘Shortness of Breath’, 40, ‘SNOMED-CT:267036007’)
INSERT INTO list_options ( list_id, option_id, title, seq, notes, codes ) VALUES (‘drug_route’,‘inhale’,‘Inhale’ , 16, ‘RESPIR’, ‘NCI-CONCEPT-ID:C38216’)
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C38288’ WHERE list_id=‘drug_route’ and title=‘Per Oris’
ALTER TABLE immunizations MODIFY cvx_code varchar(10) default NULL
ALTER TABLE drugs ADD COLUMN drug_code VARCHAR(25) NULL
DROP TABLE IF EXISTS temp_table_one
CREATE TABLE temp_table_one (id int(11) NOT NULL DEFAULT ‘0’,seq int(11) NOT NULL DEFAULT ‘0’) ENGINE=MyISAM
INSERT INTO temp_table_one (id, seq) VALUES ( IF(((SELECT MAX(ct_id ) FROM code_types) >= 100), ((SELECT MAX(ct_id ) FROM code_types) + 1), 100), IF(((SELECT MAX(ct_seq) FROM code_types) >= 100), ((SELECT MAX(ct_seq) FROM code_types) + 1), 100))
INSERT INTO code_types (ct_key, ct_id, ct_seq, ct_mod, ct_just, ct_fee, ct_rel, ct_nofs, ct_diag, ct_active, ct_label, ct_external, ct_claim, ct_proc, ct_term, ct_problem ) VALUES (‘NCI-CONCEPT-ID’, (SELECT MAX(id) FROM temp_table_one), (SELECT MAX(seq) FROM temp_table_one), 0, ‘’, 0, 0, 1, 0, 1, ‘NCI CONCEPT ID’, 0, 0, 0, 0, 0)
INSERT INTO codes (code_text,code,code_type) VALUES (‘suspension’,‘C60928’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘tablet’,‘C42998’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘capsule’,‘C25158’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘solution’,‘C42986’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘tsp’,‘C48544’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘ml’,‘C28254’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘units’,‘C44278’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘inhalations’,‘C42944’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘gtts(drops)’,‘C48491’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘cream’,‘C28944’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘ointment’,‘C42966’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘Per Oris’,‘C38288’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘Inhale’,‘C38216’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘Intramuscular’,‘C28161’,(SELECT MAX(id ) FROM temp_table_one))
INSERT INTO codes (code_text,code,code_type) VALUES (‘mg’,‘C28253’,(SELECT MAX(id ) FROM temp_table_one))
DROP TABLE temp_table_one
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C28253’ WHERE list_id=‘drug_units’ and title=‘mg’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C60928’ WHERE list_id=‘drug_form’ and title=‘suspension’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C42998’ WHERE list_id=‘drug_form’ and title=‘tablet’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C25158’ WHERE list_id=‘drug_form’ and title=‘capsule’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C42986’ WHERE list_id=‘drug_form’ and title=‘solution’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C48544’ WHERE list_id=‘drug_form’ and title=‘tsp’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C28254’ WHERE list_id=‘drug_form’ and title=‘ml’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C44278’ WHERE list_id=‘drug_form’ and title=‘units’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C42944’ WHERE list_id=‘drug_form’ and title=‘inhalations’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C48491’ WHERE list_id=‘drug_form’ and title=‘gtts(drops)’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C28944’ WHERE list_id=‘drug_form’ and title=‘cream’
UPDATE list_options SET codes=‘NCI-CONCEPT-ID:C42966’ WHERE list_id=‘drug_form’ and title=‘ointment’
SET @option_id = (SELECT MAX(CAST(option_id AS UNSIGNED)) FROM list_options WHERE list_id = ‘drug_form’)
SET @seq = (SELECT MAX(seq) FROM list_options WHERE list_id = ‘drug_form’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default, codes ) VALUES (‘drug_form’, @option_id+1, ‘puff’, @seq+1, 0, ‘NCI-CONCEPT-ID:C42944’)
Skipping section #IfNotRow3D list_options list_id drug_route title Inhale codes NCI-CONCEPT-ID:C38216
SET @catid = (SELECT MAX(pc_catid) FROM openemr_postcalendar_categories)
INSERT INTO openemr_postcalendar_categories (pc_catid, pc_catname, pc_catcolor, pc_catdesc, pc_recurrtype, pc_enddate, pc_recurrspec, pc_recurrfreq, pc_duration, pc_end_date_flag, pc_end_date_type, pc_end_date_freq, pc_end_all_day, pc_dailylimit, pc_cattype, pc_active, pc_seq) VALUES (@catid+1, ‘Ophthalmological Services’, ‘#F89219’, ‘Ophthalmological Services’, 0, NULL, ‘a:5:{s:17:“event_repeat_freq”;s:1:“0”;s:22:“event_repeat_freq_type”;s:1:“0”;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, 0, 0, 0, 0,0,1,@catid+1)
INSERT INTO enc_category_map ( rule_enc_id, main_cat_id ) VALUES (‘enc_ophthal_serv’, @catid+1)
DELETE FROM enc_category_map where rule_enc_id = ‘enc_hea_and_beh’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_hea_and_beh’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_hea_and_beh’ and main_cat_id = 10
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_ser_18_older’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_ser_18_older’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_ser_18_older’ and main_cat_id = 10
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_ser_40_older’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_ser_40_older’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_ser_40_older’ and main_cat_id = 10
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_ind_counsel’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_ind_counsel’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_ind_counsel’ and main_cat_id = 10
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_group_counsel’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_group_counsel’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_group_counsel’ and main_cat_id = 10
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_other_serv’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_other_serv’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pre_med_other_serv’ and main_cat_id = 10
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pregnancy’ and main_cat_id = 5
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pregnancy’ and main_cat_id = 9
DELETE FROM enc_category_map where rule_enc_id = ‘enc_pregnancy’ and main_cat_id = 10
ALTER TABLE documents ADD thumb_url VARCHAR( 255 ) DEFAULT NULL
ALTER TABLE layout_options ADD COLUMN validation varchar(100) default NULL
INSERT INTO list_options ( list_id, option_id, title) VALUES ( ‘lists’,‘LBF_Validations’,‘LBF_Validations’)
INSERT INTO list_options (list_id,option_id,title,notes, seq) VALUES (‘LBF_Validations’,‘int1’,‘Integers1-100’,’{“numericality”: {“onlyInteger”: true,“greaterThanOrEqualTo”: 1,“lessThanOrEqualTo”:100}}’,‘10’)
INSERT INTO list_options (list_id,option_id,title,notes, seq) VALUES (‘LBF_Validations’,‘names’,‘Names’,’{“format”:{“pattern”:"[a-zA-z]+([ '-\\s][a-zA-Z]+)"}}’,‘20’)
INSERT INTO list_options (list_id,option_id,title,notes, seq) VALUES (‘LBF_Validations’,‘past_date’,‘Past Date’,’{“pastDate”:{“message”:“must be past date”}}’,‘30’)
INSERT INTO list_options (list_id,option_id,title,notes,seq) VALUES (‘LBF_Validations’,‘past_year’,‘Past Year’,’{“date”:{“dateOnly”:true},“pastDate”:{“onlyYear”:true}}’,‘35’)
INSERT INTO list_options (list_id,option_id,title,notes,seq) VALUES (‘LBF_Validations’,‘email’,‘E-Mail’,’{“email”:true}’,‘40’)
INSERT INTO list_options (list_id,option_id,title,notes,seq) VALUES (‘LBF_Validations’,‘url’,‘URL’,’{“url”:true}’,‘50’)
INSERT INTO list_options (list_id,option_id,title,notes,seq) VALUES (‘LBF_Validations’,‘luhn’,‘Luhn’,’{“numericality”: {“onlyInteger”: true}, “luhn”:true}’,‘80’)
ALTER TABLE facility ADD extra_validation tinyint(1) NOT NULL DEFAULT ‘1’
ALTER TABLE drugs ADD consumable tinyint(1) NOT NULL DEFAULT 0 COMMENT ‘1 = will not show on the fee sheet’
ALTER TABLE billing ADD COLUMN pricelevel varchar(31) default ‘’
UPDATE billing AS b, codes AS c, prices AS p SET b.pricelevel = p.pr_level WHERE b.code_type = ‘MA’ AND b.activity = 1 AND b.pricelevel = ‘’ AND b.units = 1 AND b.fee > 0.00 AND c.code_type = ‘12’ AND c.code = b.code AND c.modifier = b.modifier AND p.pr_id = c.id AND p.pr_selector = ‘’ AND p.pr_price = b.fee
ALTER TABLE drug_sales ADD COLUMN pricelevel varchar(31) default ‘’
ALTER TABLE drug_sales ADD COLUMN selector varchar(255) default ‘’ comment ‘references drug_templates.selector’
UPDATE drug_sales AS s, drug_templates AS t SET s.selector = t.selector WHERE s.pid != 0 AND s.selector = ‘’ AND t.drug_id = s.drug_id AND (SELECT COUNT() FROM drug_templates AS t2 WHERE t2.drug_id = s.drug_id) = 1
UPDATE drug_sales AS s, drug_templates AS t, prices AS p SET s.pricelevel = p.pr_level WHERE s.pid != 0 AND s.selector != ‘’ AND s.pricelevel = ‘’ AND t.drug_id = s.drug_id AND t.selector = s.selector AND t.quantity = s.quantity AND p.pr_id = s.drug_id AND p.pr_selector = s.selector AND p.pr_price = s.fee
ALTER TABLE drug_sales ADD COLUMN bill_date datetime default NULL
UPDATE drug_sales AS s, billing AS b SET s.bill_date = b.bill_date WHERE s.billed = 1 AND s.bill_date IS NULL AND b.pid = s.pid AND b.encounter = s.encounter AND b.bill_date IS NOT NULL AND b.activity = 1
UPDATE drug_sales AS s, ar_activity AS a SET s.bill_date = a.post_time WHERE s.billed = 1 AND s.bill_date IS NULL AND a.pid = s.pid AND a.encounter = s.encounter
UPDATE drug_sales AS s SET s.bill_date = s.sale_date WHERE s.billed = 1 AND s.bill_date IS NULL
Skipping section #IfNotTable voids
UPDATE drug_sales AS s, prescriptions AS p, form_encounter AS fe SET s.prescription_id = p.id WHERE s.pid > 0 AND s.encounter > 0 AND s.prescription_id = 0 AND fe.pid = s.pid AND fe.encounter = s.encounter AND p.patient_id = s.pid AND p.drug_id = s.drug_id AND p.start_date = fe.date
ALTER TABLE drugs ADD dispensable tinyint(1) NOT NULL DEFAULT 1 COMMENT ‘0 = pharmacy elsewhere, 1 = dispensed here’
ALTER TABLE list_options MODIFY notes TEXT
INSERT INTO list_options (list_id, option_id, title, seq) VALUES (‘lists’, ‘page_validation’, ‘Page Validation’, 298)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘add_edit_issue#theform’, ‘/interface/patient_file/summary/add_edit_issue.php’, 10, ‘{form_title:{presence: true}}’, 0)
ALTER TABLE procedure_order ADD COLUMN history_order enum(‘0’,‘1’) DEFAULT ‘0’
ALTER TABLE amc_misc_data add column soc_provided DATETIME default NULL
INSERT INTO clinical_rules(id, pid, active_alert_flag, passive_alert_flag, cqm_flag, cqm_nqf_code, cqm_pqri_code, amc_flag, amc_code, patient_reminder_flag, amc_2011_flag, amc_2014_flag, amc_code_2014, cqm_2011_flag, cqm_2014_flag, amc_2014_stage1_flag, amc_2014_stage2_flag) VALUES (‘cpoe_med_stage1_amc_alternative’, 0, 0, 0, 0, ‘’, ‘’, 1, ‘170.304(a)’, 0, 0, 1, ‘170.314(g)(1)/(2)–7’, 0, 0, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2) VALUES(‘clinical_rules’, ‘cpoe_med_stage1_amc_alternative’, ‘Use CPOE for medication orders.(Alternative)’, 48, 0, 0, ‘’, ‘’, ‘’, 0, 0)
UPDATE clinical_rules set amc_2014_stage1_flag = 0 where id=‘cpoe_med_stage2_amc’
UPDATE list_options set title = ‘Use CPOE for medication orders.’ where list_id = ‘clinical_rules’ and option_id = ‘cpoe_med_stage2_amc’
Skipping section #IfRow2D globals gl_name css_header gl_value style_tan_no_icons.css
ALTER TABLE users DROP COLUMN ssi_relayhealth
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘common#new_encounter’, ‘/interface/forms/newpatient/common.php’, 50, ‘{pc_catid:{exclusion: ["_blank"]}}’, 1)
ALTER TABLE insurance_companies CHANGE freeb_type ins_type_code tinyint(2) Default NULL
DROP TABLE IF EXISTS integration_mapping
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-PCS-Long-Abbrev-Titles.zip’, ‘4669c47f6a9ca34bf4c14d7f93b37993’)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-GEM-DC.zip’, ‘5a0affdc77a152e6971781233ee969c1’)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-ICD10-Code-Descriptions.zip’, ‘ed9c159cb4ac4ae4f145062e15f83291’)
INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2016-10-01’, ‘2017-GEM-PCS.zip’, ‘a4e08b08fb9a53c81385867c82aa8a9e’)
ALTER TABLE form_encounter ADD pos_code tinyint(4) default NULL
ALTER TABLE drugs CHANGE size size varchar(25) NOT NULL default ‘’
ALTER TABLE prescriptions CHANGE size size varchar(25) default NULL
ALTER TABLE user_settings CHANGE setting_label setting_label varchar(100) NOT NULL
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘add_edit_event#theform’, ‘/interface/main/calendar/add_edit_event.php’, 60, ‘{form_patient:{presence: {message: “Patient Name Required”}}}’, 1)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘usergroup_admin_add#new_user’, ‘/interface/usergroup/usergroup_admin_add.php’, 70, ‘{rumple:{presence: {message:“Required field missing: Please enter the User Name”}}, stiltskin:{presence: {message:“Please enter the password”}}, fname:{presence: {message:“Required field missing: Please enter the First name”}}, lname:{presence: {message:“Required field missing: Please enter the Last name”}}}’, 1)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘user_admin#user_form’, ‘/interface/usergroup/user_admin.php’, 80, ‘{fname:{presence: {message:“Required field missing: Please enter the First name”}}, lname:{presence: {message:“Required field missing: Please enter the Last name”}}}’, 1)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘facility_admin#facility-form’, ‘/interface/usergroup/facility_admin.php’, 90, ‘{facility:{presence: true}, ncolor:{presence: true}}’, 1)
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘facilities_add#facility-add’, ‘/interface/usergroup/facilities_add.php’, 100, ‘{facility:{presence: true}, ncolor:{presence: true}}’, 1)
Skipping section #IfNotTable form_eye_mag_dispense
Skipping section #IfNotTable form_eye_mag
Skipping section #IfNotTable form_eye_mag_prefs
Skipping section #IfNotTable form_eye_mag_orders
Skipping section #IfNotTable form_eye_mag_impplan
Skipping section #IfNotTable form_eye_mag_wearing
Skipping section #IfNotTable form_taskman
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Eye Module’, ‘’, 1, rght, rght + 25 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Communication - Eye’, ‘’, (select id from categories where name = ‘Eye Module’), rght + 1, rght + 2 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Encounters - Eye’, ‘’, (select id from categories where name = ‘Eye Module’), rght + 3, rght + 4 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Imaging - Eye’, ‘’, (select id from categories where name = ‘Eye Module’), rght + 5, rght + 24 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘OCT - Eye’, ‘POSTSEG’, (select id from categories where name = ‘Imaging - Eye’), rght + 6, rght + 7 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘FA/ICG - Eye’, ‘POSTSEG’, (select id from categories where name = ‘Imaging - Eye’), rght + 8, rght + 9 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘External Photos - Eye’, ‘EXT’, (select id from categories where name = ‘Imaging - Eye’), rght + 10, rght + 11 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘AntSeg Photos - Eye’, ‘ANTSEG’, (select id from categories where name = ‘Imaging - Eye’), rght + 12, rght + 13 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Optic Disc - Eye’, ‘POSTSEG’, (select id from categories where name = ‘Imaging - Eye’), rght + 14, rght + 15 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Fundus - Eye’, ‘POSTSEG’, (select id from categories where name = ‘Imaging - Eye’), rght + 16, rght + 17 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Radiology - Eye’, ‘NEURO’, (select id from categories where name = ‘Imaging - Eye’), rght + 18, rght + 19 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘VF - Eye’, ‘NEURO’, (select id from categories where name = ‘Imaging - Eye’), rght + 20, rght + 21 from categories where name = ‘Categories’
INSERT INTO categories select (select MAX(id) from categories) + 1, ‘Drawings - Eye’, ‘NEURO’, (select id from categories where name = ‘Imaging - Eye’), rght + 22, rght + 23 from categories where name = ‘Categories’
UPDATE categories SET rght = rght + 26 WHERE name = ‘Categories’
UPDATE categories_seq SET id = (select MAX(id) from categories)
UPDATE list_options SET codes = ‘ICD10:I10’ WHERE list_id = ‘medical_problem_issue_list’ AND option_id = ‘HTN’
UPDATE list_options SET codes = ‘ICD10:J45.909’ WHERE list_id = ‘medical_problem_issue_list’ AND option_id = ‘asthma’
UPDATE list_options SET codes = ‘ICD10:E78.5’ WHERE list_id = ‘medical_problem_issue_list’ AND option_id = ‘hyperlipidemia’
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘poag’,‘POAG’, 10,‘ICD10:H40.11X4’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘dermatochalasis’,‘Dermatochalasis’, 20,‘ICD10:H02.839’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘niddm_bdr’,‘NIDDM w/ BDR’, 30,’,ICD10:E11.319’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘ns_cataract’,‘NS Cataract’, 40,‘ICD10:H25.10’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘BCC’,‘BCC’, 50,‘ICD10:C44.191’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘iddm_bdr’,‘IDDM w/ BDR’, 60,‘ICD10:E10.329’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘Keratoconus’,‘Keratoconus’, 70,‘ICD10:H18.603’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘dry_eye’,‘Dry Eye’, 80,‘ICD10:H04.123’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘SCC’,‘SCC’, 90,‘ICD10:C44.191’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘medical_problem_issue_list’, ‘stye’,‘stye’, 100,‘ICD10:H00.029’,‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘Bleph_Upper’, ‘Blepharoplasty’, 40, ‘CPT4:15823-50’, ‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘Phaco_IOL_OD’, ‘Phaco/IOL OD’, 50, ‘CPT4:66984-RT’, ‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘Phaco_IOL_OS’, ‘Phaco/IOL OS’, 60, ‘CPT4:66984-LT’, ‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘LPI_OD’, ‘LPI OD’, 70, ‘CPT4:66761-RT’, ‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘LPI_OS’, ‘LPI OS’, 80, ‘CPT4:66761-LT’, ‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘ALT_OD’, ‘ALT OD’, 90, ‘CPT4:65855-RT’, ‘eye’)
INSERT INTO list_options(list_id,option_id,title,seq,codes,subtype) VALUES (‘surgery_issue_list’, ‘ALT_OS’, ‘ALT OS’, 100, ‘CPT4:65855-LT’, ‘eye’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’, ‘CTLManufacturer’, ‘Eye Contact Lens Manufacturer list’, 1, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLManufacturer’, ‘BNL’, ‘Bausch&Lomb’, 10, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLManufacturer’, ‘CibaVision’, ‘Ciba Vision’, 20, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLManufacturer’, ‘Cooper’, ‘CooperVision’, 30, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLManufacturer’, ‘JNJ’, ‘Johnson&Johnson’, 40, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘CTLSupplier’, ‘Eye Contact Lens Supplier list’, 1,0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLSupplier’, ‘ABB’, ‘ABB Optical’, 10, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLSupplier’, ‘JNJ’, ‘Johnson&Johnson’, 20, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLSupplier’, ‘LF’, ‘Lens Ferry’, 30, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘CTLBrand’, ‘Eye Contact Lens Brand list’, 1, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLBrand’, ‘Acuvue’, ‘Acuvue’, 10, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLBrand’, ‘Acuvue2’, ‘Acuvue 2’, 20, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLBrand’, ‘AcuvueOa’, ‘Acuvue Oasys’, 30, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLBrand’, ‘SF66’, ‘SofLens Toric’, 40, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘CTLBrand’, ‘PVMF’, ‘PureVision MultiFocal’, 50, 0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_Coding_Fields’, ‘Eye Coding Fields’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_Coding_Fields’, ‘RUL’, ‘RUL’, 10, 0, 0, ‘’, ‘right upper eyelid’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘RLL’, ‘RLL’, 20, 0, 0, ‘’, ‘right lower eyelid’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘LUL’, ‘LUL’, 30, 0, 0, ‘’, ‘left upper eyelid’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘LLL’, ‘LLL’, 40, 0, 0, ‘’, ‘left lower eyelid’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘RBROW’, ‘RBROW’, 50, 0, 0, ‘’, ‘forehead’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘LBROW’, ‘LBROW’, 60, 0, 0, ‘’, ‘forehead’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘RMCT’, ‘RMCT’, 70, 0, 0, ‘’, ‘canthus’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘LMCT’, ‘LMCT’, 80, 0, 0, ‘’, ‘canthus’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘RBROW_unspec’, ‘RBROW’, 90, 0, 0, ‘’, ‘unspecified’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘LBROW_unspec’, ‘LBROW’, 100, 0, 0, ‘’, ‘unspecified’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘RADNEXA’, ‘RADNEXA’, 110, 0, 0, ‘’, ‘unspecified’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘LADNEXA’, ‘LADNEXA’, 120, 0, 0, ‘’, ‘unspecified’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODCONJ’, ‘ODCONJ’, 130, 0, 0, ‘’, ‘right conjunctiva’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSCONJ’, ‘OSCONJ’, 140, 0, 0, ‘’, ‘left conjunctiva’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODCORNEA’, ‘ODCORNEA’, 150, 0, 0, ‘’, ‘right cornea’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSCORNEA’, ‘OSCORNEA’, 160, 0, 0, ‘’, ‘left cornea’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODAC’, ‘ODAC’, 170, 0, 0, ‘’, ‘right anterior chamber’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSAC’, ‘OSAC’, 180, 0, 0, ‘’, ‘left anterior chamber’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODLENS’, ‘ODLENS’, 190, 0, 0, ‘’, ‘right lens’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSLENS’, ‘OSLENS’, 200, 0, 0, ‘’, ‘left lens’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODIRIS’, ‘ODIRIS’, 210, 0, 0, ‘’, ‘right iris’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSIRIS’, ‘OSIRIS’, 220, 0, 0, ‘’, ‘left iris’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODDISC’, ‘ODDISC’, 230, 0, 0, ‘’, ‘right’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSDISC’, ‘OSDISC’, 240, 0, 0, ‘’, ‘left’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODMAC’, ‘ODMACULA’, 250, 0, 0, ‘’, ‘right macula’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSMAC’, ‘OSMACULA’, 260, 0, 0, ‘’, ‘left macula’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODVESSELS’, ‘ODVESSELS’, 270, 0, 0, ‘’, ‘right’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSVESSELS’, ‘OSVESSELS’, 280, 0, 0, ‘’, ‘left’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘ODPERIPH’, ‘ODPERIPH’, 290, 0, 0, ‘’, ‘right’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Fields’, ‘OSPERIPH’, ‘OSPERIPH’, 300, 0, 0, ‘’, ‘left’, ‘’, 0, 0, 1, ‘’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_Coding_Terms’, ‘Eye Coding Terms’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_Coding_Terms’, ‘dermato_RUL’, ‘dermatochalasis’, 10, 0, 0, ‘’, ‘RUL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘dermato_RLL’, ‘dermatochalasis’, 20, 0, 0, ‘’, ‘RLL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘dermato_LUL’, ‘dermatochalasis’, 30, 0, 0, ‘’, ‘LUL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘dermato_LLL’, ‘dermatochalasis’, 40, 0, 0, ‘’, ‘LLL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ptosis_RUL’, ‘ptosis’, 50, 0, 0, ‘’, ‘RUL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ptosis_LUL’, ‘ptosis’, 60, 0, 0, ‘’, ‘LUL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘chalazion_RUL’, ‘chalazion’, 70, 0, 0, ‘’, ‘RUL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘chalazion_RLL’, ‘chalazion’, 80, 0, 0, ‘’, ‘RLL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘chalazion_LUL’, ‘chalazion’, 90, 0, 0, ‘’, ‘LUL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘chalazion_LLL’, ‘chalazion’, 100, 0, 0, ‘’, ‘LLL’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicectr_RUL’, ‘cicatricial ectropion’, 110, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.111’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicectr_RLL’, ‘cicatricial ectropion’, 120, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.112’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicectr_LUL’, ‘cicatricial ectropion’, 130, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.114’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicectr_LLL’, ‘cicatricial ectropion’, 140, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.115’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasectr_RUL’, ‘spastic ectropion’, 150, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.141’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasentr_RUL’, ‘spastic entropion’, 160, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.041’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasectr_RLL’, ‘spastic ectropion’, 170, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.142’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasentr_RLL’, ‘spastic entropion’, 180, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.042’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasectr_LUL’, ‘spastic ectropion’, 190, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.144’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasentr_LUL’, ‘spastic entropion’, 200, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.044’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasectr_LLL’, ‘spastic ectropion’, 210, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.145’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘spasentr_LLL’, ‘spastic entropion’, 220, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.045’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicentr_RUL’, ‘cicatricial entropion’, 230, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.111’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicentr_RLL’, ‘cicatricial entropion’, 240, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.112’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicentr_LUL’, ‘cicatricial entropion’, 250, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.114’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘cicentr_LLL’, ‘cicatricial entropion’, 260, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.115’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ect_RUL’, ‘ectropion’, 270, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.101’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ect_RLL’, ‘ectropion’, 280, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.102’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ect_LUL’, ‘ectropion’, 290, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.104’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ect_LLL’, ‘ectropion’, 300, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.105’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ent_RUL’, ‘entropion’, 310, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.001’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ent_RLL’, ‘entropion’, 320, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.002’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ent_LUL’, ‘entropion’, 330, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.004’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘ent_LLL’, ‘entropion’, 340, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.005’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘trich_RUL’, ‘trichiasis’, 350, 0, 0, ‘’, ‘RUL’, ‘ICD10:H02.051’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘trich_RLL’, ‘trichiasis’, 360, 0, 0, ‘’, ‘RLL’, ‘ICD10:H02.052’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘trich_LUL’, ‘trichiasis’, 370, 0, 0, ‘’, ‘LUL’, ‘ICD10:H02.054’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘trich_LLL’, ‘trichiasis’, 380, 0, 0, ‘’, ‘LLL’, ‘ICD10:H02.055’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘stye_RUL’, ‘stye’, 390, 0, 0, ‘’, ‘RUL’, ‘ICD10:H00.011’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘stye_RLL’, ‘stye’, 400, 0, 0, ‘’, ‘RLL’, ‘ICD10:H00.012’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘stye_LUL’, ‘stye’, 410, 0, 0, ‘’, ‘LUL’, ‘ICD10:H00.014’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘stye_LLL’, ‘stye’, 420, 0, 0, ‘’, ‘LLL’, ‘ICD10:H00.015’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘papillae_ODCONJ’, ‘papilla’, 430, 0, 0, ‘’, ‘ODCONJ’, ‘ICD10:H10.401’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘papillae_OSCONJ’, ‘papilla’, 440, 0, 0, ‘’, ‘OSCONJ’, ‘ICD10:H10.402’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘folllicles_ODCONJ’, ‘folllicles’, 450, 0, 0, ‘’, ‘ODCONJ’, ‘ICD10:H10.011’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘folllicles_OSCONJ’, ‘folllicles’, 460, 0, 0, ‘’, ‘OSCONJ’, ‘ICD10:H10.012’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘pterygium_ODCORNEA’, ‘pterygium’, 470, 0, 0, ‘’, ‘ODCORNEA’, ‘ICD10:H11.051’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘pterygium_ODCONJ’, ‘pterygium’, 480, 0, 0, ‘’, ‘ODCONJ’, ‘ICD10:H11.811’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘pterygium_OSCONJ’, ‘pterygium’, 490, 0, 0, ‘’, ‘OSCONJ’, ‘ICD10:H11.812’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘pterygium_OSCORNEA’, ‘pterygium’, 500, 0, 0, ‘’, ‘OSCORNEA’, ‘ICD10:H11.052’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘abrasion_ODCORNEA’, ‘abrasion’, 510, 0, 0, ‘’, ‘ODCORNEA’, ‘ICD10:S05.01XA’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘abrasion_OSCORNEA’, ‘abrasion’, 520, 0, 0, ‘’, ‘OSCORNEA’, ‘ICD10:S05.02XA’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘FB_ODCORNEA’, ‘FB’, 530, 0, 0, ‘’, ‘ODCORNEA’, ‘ICD10:T15.01XA’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘FB_OSCORNEA’, ‘FB’, 540, 0, 0, ‘’, ‘OSCORNEA’, ‘ICD10:T15.02XA’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘dendrite_ODCORNEA’, ‘dendrite’, 550, 0, 0, ‘’, ‘ODCORNEA’, ‘ICD10:B00.52’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘dendrite_OSCORNEA’, ‘dendrite’, 560, 0, 0, ‘’, ‘OSCORNEA’, ‘ICD10:B00.52’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘MDF_ODCORNEA’, ‘MDF’, 570, 0, 0, ‘’, ‘ODCORNEA’, ‘ICD10:H18.59’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘MDF_OSCORNEA’, ‘MDF’, 580, 0, 0, ‘’, ‘OSCORNEA’, ‘ICD10:H18.59’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NS_ODLENS’, ‘NS’, 590, 0, 0, ‘’, ‘ODLENS’, ‘ICD10:H25.11’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NS_OSLENS’, ‘NS’, 600, 0, 0, ‘’, ‘OSLENS’, ‘ICD10:H25.12’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘PSC_ODLENS’, ‘PSC’, 610, 0, 0, ‘’, ‘ODLENS’, ‘ICD10:H25.041’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘PSC_OSLENS’, ‘PSC’, 620, 0, 0, ‘’, ‘OSLENS’, ‘ICD10:H25.042’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘PCIOL_ODLENS’, ‘PCIOL’, 630, 0, 0, ‘’, ‘ODLENS’, ‘ICD10:Z96.1’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘PCIOL_OSLENS’, ‘PCIOL’, 640, 0, 0, ‘’, ‘OSLENS’, ‘ICD10:Z96.1’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘hyphema_ODAC’, ‘hyphema’, 650, 0, 0, ‘’, ‘ODAC’, ‘ICD10:H21.01’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘hyphema_OSAC’, ‘hyphema’, 660, 0, 0, ‘’, ‘OSAC’, ‘ICD10:H21.02’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘horseshoe_ODPERIPHERY’, ‘horseshoe’, 670, 0, 0, ‘’, ‘ODPERIPH’, ‘ICD10:H33.311’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘horseshoe_OSPERIPHERY’, ‘horseshoe’, 680, 0, 0, ‘’, ‘OSPERIPH’, ‘ICD10:H33.312’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘hole_ODPERIPHERY’, ‘hole’, 690, 0, 0, ‘’, ‘ODPERIPH’, ‘ICD10:H33.321’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘hole_OSPERIPHERY’, ‘hole’, 700, 0, 0, ‘’, ‘OSPERIPH’, ‘ICD10:H33.322’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘CSR_ODMACULA’, ‘CSR’, 710, 0, 0, ‘’, ‘ODMACULA’, ‘ICD10:H35.711’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘hole_ODMACULA’, ‘Mac hole’, 720, 0, 0, ‘’, ‘ODMACULA’, ‘ICD10:H35.341’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘CSR_OSMACULA’, ‘CSR’, 730, 0, 0, ‘’, ‘OSMACULA’, ‘ICD10:H35.712’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘hole_OSMACULA’, ‘Mac hole’, 740, 0, 0, ‘’, ‘OSMACULA’, ‘ICD10:H35.342’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘drusen_ODMACULA’, ‘drusen’, 750, 0, 0, ‘’, ‘ODMACULA’, ‘ICD10:H35.361’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘drusen_OSMACULA’, ‘drusen’, 760, 0, 0, ‘’, ‘OSMACULA’, ‘ICD10:H35.362’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘drusen_ODDISC’, ‘drusen’, 770, 0, 0, ‘’, ‘ODDISC’, ‘ICD10:H47.321’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘drusen_OSDISC’, ‘drusen’, 780, 0, 0, ‘’, ‘ODDISC’, ‘ICD10:H47.322’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘BRVO_ODPERIPHERY’, ‘BRVO’, 790, 0, 0, ‘’, ‘ODVESSELS’, ‘ICD10:H34.831’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘CRVO_ODPERIPHERY’, ‘CRVO’, 800, 0, 0, ‘’, ‘ODVESSELS’, ‘ICD10:H34.811’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘lattice_ODPERIPHERY’, ‘lattice’, 810, 0, 0, ‘’, ‘ODPERIPH’, ‘ICD10:H35.412’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘BRVO_OSPERIPHERY’, ‘BRVO’, 820, 0, 0, ‘’, ‘OSVESSELS’, ‘ICD10:H34.832’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘CRVO_OSPERIPHERY’, ‘CRVO’, 830, 0, 0, ‘’, ‘OSVESSELS’, ‘ICD10:H34.812’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘lattice_OSPERIPHERY’, ‘lattice’, 840, 0, 0, ‘’, ‘OSPERIPH’, ‘ICD10:H35.412’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NLDO_RMCT’, ‘NLDO’, 850, 0, 0, ‘’, ‘RMCT’, ‘ICD10:H04.411’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NLDO_LMCT’, ‘NLDO’, 860, 0, 0, ‘’, ‘LMCT’, ‘ICD10:H04.412’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NVD_ODDISC’, ‘NVD:DM’, 870, 0, 0, ‘’, ‘ODDISC’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NVD_OSDISC’, ‘NVD:DM’, 880, 0, 0, ‘’, ‘OSDISC’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘CSME_ODMACULA’, ‘CSME:DM|IOL|RVO’, 890, 0, 0, ‘’, ‘ODMACULA’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘CSME_OSMACULA’, ‘CSME:DM|IOL|RVO’, 900, 0, 0, ‘’, ‘OSMACULA’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NVE_ODVESSELS’, ‘NVE:DM’, 910, 0, 0, ‘’, ‘ODVESSELS’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NVE_OSVESSELS’, ‘NVE:DM’, 920, 0, 0, ‘’, ‘OSVESSELS’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NVE_ODPERIPHERY’, ‘NVE:DM’, 930, 0, 0, ‘’, ‘ODPERIPH’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘NVE_OSPERIPHERY’, ‘NVE:DM’, 940, 0, 0, ‘’, ‘OSPERIPH’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘BDR_ODMACULA’, ‘BDR:DM’, 950, 0, 0, ‘’, ‘ODMACULA’, ‘’, 0, 0, 1, ‘’),(‘Eye_Coding_Terms’, ‘BDR_OSMACULA’, ‘BDR:DM’, 960, 0, 0, ‘’, ‘OSMACULA’, ‘’, 0, 0, 1, ‘’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_QP_ANTSEG_defaults’, ‘Eye QP List ANTSEG for New Providers’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_cl’, ‘c: clear field’, 10, 0, 0, ‘CONJ’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_cl’, ‘c: clear field’, 20, 0, 0, ‘CONJ’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_cl’, ‘c: clear field’, 30, 0, 0, ‘CONJ’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_quiet’, ‘c: quiet’, 40, 0, 0, ‘CONJ’, ‘quiet’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_quiet’, ‘c: quiet’, 50, 0, 0, ‘CONJ’, ‘quiet’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_quiet’, ‘c: quiet’, 60, 0, 0, ‘CONJ’, ‘quiet’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_inj’, ‘c: injection’, 70, 0, 0, ‘CONJ’, ‘injection’, ‘ICD10:H10.31’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_inj’, ‘c: injection’, 80, 0, 0, ‘CONJ’, ‘injection’, ‘ICD10:H10.32’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_inj’, ‘c: injection’, 90, 0, 0, ‘CONJ’, ‘injection’, ‘ICD10:H10.33’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_pap’, ‘c: papillae’, 100, 0, 0, ‘CONJ’, ‘papillae’, ‘ICD10:H10.31’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_pap’, ‘c: papillae’, 110, 0, 0, ‘CONJ’, ‘papillae’, ‘ICD10:H10.32’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_pap’, ‘c: papillae’, 120, 0, 0, ‘CONJ’, ‘papillae’, ‘ICD10:H10.33’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_gpap’, ‘c: giant pap’, 130, 0, 0, ‘CONJ’, ‘giant papillae’, ‘ICD10:H10.411’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_gpap’, ‘c: giant pap’, 140, 0, 0, ‘CONJ’, ‘giant papillae’, ‘ICD10:H10.412’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_gpap’, ‘c: giant pap’, 150, 0, 0, ‘CONJ’, ‘giant papillae’, ‘ICD10:H10.413’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_pinq’, ‘c: pinquecula’, 160, 0, 0, ‘CONJ’, ‘pinquecula’, ‘ICD10:H11.151’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_pinq’, ‘c: pinquecula’, 170, 0, 0, ‘CONJ’, ‘pinquecula’, ‘ICD10:H11.152’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_pinq’, ‘c: pinquecula’, 180, 0, 0, ‘CONJ’, ‘pinquecula’, ‘ICD10:H11.153’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_foll’, ‘c: follicles’, 190, 0, 0, ‘CONJ’, ‘follicles’, ‘ICD10:H10.011’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_foll’, ‘c: follicles’, 200, 0, 0, ‘CONJ’, ‘follicles’, ‘ICD10:H10.012’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_foll’, ‘c: follicles’, 210, 0, 0, ‘CONJ’, ‘follicles’, ‘ICD10:H10.013’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_mucop’, ‘c: mucopurulence’, 220, 0, 0, ‘CONJ’, ‘mucopurulence’, ‘ICD10:H10.013’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_mucop’, ‘c: mucopurulence’, 230, 0, 0, ‘CONJ’, ‘mucopurulence’, ‘ICD10:H10.013’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_mucop’, ‘c: mucopurulence’, 240, 0, 0, ‘CONJ’, ‘mucopurulence’, ‘ICD10:H10.013’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_bleb’, ‘c: mod bleb’, 250, 0, 0, ‘CONJ’, ‘moderate bleb’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_bleb’, ‘c: mod bleb’, 260, 0, 0, ‘CONJ’, ‘moderate bleb’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_bleb’, ‘c: mod bleb’, 270, 0, 0, ‘CONJ’, ‘moderate bleb’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCONJ_sied’, ‘c: siedel negative’, 280, 0, 0, ‘CONJ’, ‘siedel negative’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCONJ_sied’, ‘c: siedel negative’, 290, 0, 0, ‘CONJ’, ‘siedel negative’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCONJ_sied’, ‘c: siedel negative’, 300, 0, 0, ‘CONJ’, ‘siedel negative’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_cl’, ‘k: clear field’, 310, 0, 0, ‘CORNEA’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_cl’, ‘k: clear field’, 320, 0, 0, ‘CORNEA’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_cl’, ‘k: clear field’, 330, 0, 0, ‘CORNEA’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_clear’, ‘k: clear’, 340, 0, 0, ‘CORNEA’, ‘clear’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_clear’, ‘k: clear’, 350, 0, 0, ‘CORNEA’, ‘clear’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_clear’, ‘k: clear’, 360, 0, 0, ‘CORNEA’, ‘clear’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_abr’, ‘k: abrasion’, 370, 0, 0, ‘CORNEA’, ‘abrasion’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_abr’, ‘k: abrasion’, 380, 0, 0, ‘CORNEA’, ‘abrasion’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_abr’, ‘k: abrasion’, 390, 0, 0, ‘CORNEA’, ‘abrasion’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_MDF’, ‘k: MDFP dystrophy’, 400, 0, 0, ‘CORNEA’, ‘MDFP dystrophy’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_MDF’, ‘k: MDFP dystrophy’, 410, 0, 0, ‘CORNEA’, ‘MDFP dystrophy’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_MDF’, ‘k: MDFP dystrophy’, 420, 0, 0, ‘CORNEA’, ‘MDFP dystrophy’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_FB’, ‘k: metallic FB’, 430, 0, 0, ‘CORNEA’, ‘metallic FB’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_FB’, ‘k: metallic FB’, 440, 0, 0, ‘CORNEA’, ‘metallic FB’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_FB’, ‘k: metallic FB’, 450, 0, 0, ‘CORNEA’, ‘metallic FB’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_edema’, ‘k: edema’, 460, 0, 0, ‘CORNEA’, ‘edema’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_edema’, ‘k: edema’, 470, 0, 0, ‘CORNEA’, ‘edema’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_edema’, ‘k: edema’, 480, 0, 0, ‘CORNEA’, ‘edema’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_HSV’, ‘k: dendrite’, 490, 0, 0, ‘CORNEA’, ‘dendrite’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_HSV’, ‘k: dendrite’, 500, 0, 0, ‘CORNEA’, ‘dendrite’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_HSV’, ‘k: dendrite’, 510, 0, 0, ‘CORNEA’, ‘dendrite’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_scar’, ‘k: stromal scar’, 520, 0, 0, ‘CORNEA’, ‘stromal scar’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_scar’, ‘k: stromal scar’, 530, 0, 0, ‘CORNEA’, ‘stromal scar’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_scar’, ‘k: stromal scar’, 540, 0, 0, ‘CORNEA’, ‘stromal scar’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_gut’, ‘k: guttatae’, 550, 0, 0, ‘CORNEA’, ‘guttatae’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_gut’, ‘k: guttatae’, 560, 0, 0, ‘CORNEA’, ‘guttatae’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_gut’, ‘k: guttatae’, 570, 0, 0, ‘CORNEA’, ‘guttatae’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_fkp’, ‘k: fine KPs’, 580, 0, 0, ‘CORNEA’, ‘fine KPs’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_fkp’, ‘k: fine KPs’, 590, 0, 0, ‘CORNEA’, ‘fine KPs’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_fkp’, ‘k: fine KPs’, 600, 0, 0, ‘CORNEA’, ‘fine KPs’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODCORNEA_mkp’, ‘k: mutton-fat KPs’, 610, 0, 0, ‘CORNEA’, ‘mutton-fat keratic precipitates’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSCORNEA_mkp’, ‘k: mutton-fat KPs’, 620, 0, 0, ‘CORNEA’, ‘mutton-fat keratic precipitates’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUCORNEA_mkp’, ‘k: mutton-fat KPs’, 630, 0, 0, ‘CORNEA’, ‘mutton-fat keratic precipitates’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODAC_cl’, ‘ac: clear field’, 640, 0, 0, ‘AC’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSAC_cl’, ‘ac: clear field’, 650, 0, 0, ‘AC’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUAC_cl’, ‘ac: clear field’, 660, 0, 0, ‘AC’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODAC_clear’, ‘ac: clear’, 670, 0, 0, ‘AC’, ‘clear’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSAC_clear’, ‘ac: clear’, 680, 0, 0, ‘AC’, ‘clear’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUAC_clear’, ‘ac: clear’, 690, 0, 0, ‘AC’, ‘clear’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODAC_fc’, ‘ac: F/C’, 700, 0, 0, ‘AC’, ‘F/C’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSAC_fc’, ‘ac: F/C’, 710, 0, 0, ‘AC’, ‘F/C’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUAC_fc’, ‘ac: F/C’, 720, 0, 0, ‘AC’, ‘F/C’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODAC_nar’, ‘ac :narrow’, 730, 0, 0, ‘AC’, ‘narrow’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSAC_nar’, ‘ac :narrow’, 740, 0, 0, ‘AC’, ‘narrow’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUAC_nar’, ‘ac :narrow’, 750, 0, 0, ‘AC’, ‘narrow’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODAC_hyp’, ‘ac: hyphema’, 760, 0, 0, ‘AC’, ‘hyphema’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSAC_hyp’, ‘ac: hyphema’, 770, 0, 0, ‘AC’, ‘hyphema’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUAC_hyp’, ‘ac: hyphema’, 780, 0, 0, ‘AC’, ‘hyphema’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_cl’, ‘lens: clear field’, 790, 0, 0, ‘LENS’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_cl’, ‘lens: clear field’, 800, 0, 0, ‘LENS’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_cl’, ‘lens: clear field’, 810, 0, 0, ‘LENS’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_pxe’, ‘lens: PXE’, 820, 0, 0, ‘LENS’, ‘PXE’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_pxe’, ‘lens: PXE’, 830, 0, 0, ‘LENS’, ‘PXE’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_pxw’, ‘lens: PXE’, 840, 0, 0, ‘LENS’, ‘PXE’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_psc’, ‘lens: PSC’, 850, 0, 0, ‘LENS’, ‘PSC’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_psc’, ‘lens: PSC’, 860, 0, 0, ‘LENS’, ‘PSC’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_psc’, ‘lens: PSC’, 870, 0, 0, ‘LENS’, ‘PSC’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_ns’, ‘lens: NS’, 880, 0, 0, ‘LENS’, ‘NS’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_ns’, ‘lens: NS’, 890, 0, 0, ‘LENS’, ‘NS’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_ns’, ‘lens: NS’, 900, 0, 0, ‘LENS’, ‘NS’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_cort’, ‘lens: cortical’, 910, 0, 0, ‘LENS’, ‘cortical’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_cort’, ‘lens: cortical’, 920, 0, 0, ‘LENS’, ‘cortical’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_cort’, ‘lens: cortical’, 930, 0, 0, ‘LENS’, ‘cortical’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_PC’, ‘lens: PCIOL’, 940, 0, 0, ‘LENS’, ‘PCIOL’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_PC’, ‘lens: PCIOL’, 950, 0, 0, ‘LENS’, ‘PCIOL’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_PC’, ‘lens: PCIOL’, 960, 0, 0, ‘LENS’, ‘PCIOL’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODLENS_yag’, ‘lens: p YAG’, 970, 0, 0, ‘LENS’, ‘PC open’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSLENS_yag’, ‘lens: p YAG’, 980, 0, 0, ‘LENS’, ‘PC open’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OULENS_yag’, ‘lens: p YAG’, 990, 0, 0, ‘LENS’, ‘PC open’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODIRIS_cl’, ‘iris: clear field’, 1000, 0, 0, ‘IRIS’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSIRIS_cl’, ‘iris: clear field’, 1010, 0, 0, ‘IRIS’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUIRIS_cl’, ‘iris: clear field’, 1020, 0, 0, ‘IRIS’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODIRIS_pxe’, ‘iris: PXE’, 1030, 0, 0, ‘IRIS’, ‘PXE’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSIRIS_px’, ‘iris: PXE’, 1040, 0, 0, ‘IRIS’, ‘PXE’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUIRIS_px’, ‘iris: PXE’, 1050, 0, 0, ‘IRIS’, ‘PXE’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODIRIS_pi’, ‘iris: PI’, 1060, 0, 0, ‘IRIS’, ‘patent PI’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSIRIS_pi’, ‘iris: PI’, 1070, 0, 0, ‘IRIS’, ‘patent PI’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUIRIS_pi’, ‘iris: PI’, 1080, 0, 0, ‘IRIS’, ‘patent PI’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODIRIS_nev’, ‘iris: nevus’, 1090, 0, 0, ‘IRIS’, ‘nevus’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSIRIS_nev’, ‘iris: nevus’, 1100, 0, 0, ‘IRIS’, ‘nevus’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUIRIS_nev’, ‘iris: nevus’, 1110, 0, 0, ‘IRIS’, ‘nevus’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_ANTSEG_defaults’, ‘ODIRIS_nv’, ‘iris: NVI’, 1120, 0, 0, ‘IRIS’, ‘NVI’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_ANTSEG_defaults’, ‘OSIRIS_nv’, ‘iris: NVI’, 1130, 0, 0, ‘LENS’, ‘NVI’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_ANTSEG_defaults’, ‘OUIRIS_nv’, ‘iris: NVI’, 1140, 0, 0, ‘IRIS’, ‘NVI’, ‘’, 0, 0, 0, ‘OU’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_QP_EXT_defaults’, ‘Eye QP List EXT for New Providers’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_QP_EXT_defaults’, ‘RBROW’, ‘BROW: clear field’, 10, 0, 0, ‘BROW’, ‘’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW’, ‘BROW: clear field’, 20, 0, 0, ‘BROW’, ‘’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW’, ‘BROW: clear field’, 30, 0, 0, ‘BROW’, ‘’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_ptosis’, ‘BROW: ptosis’, 40, 0, 0, ‘BROW’, ‘ptosis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_ptosis’, ‘BROW: ptosis’, 50, 0, 0, ‘BROW’, ‘ptosis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_ptosis’, ‘BROW: ptosis’, 60, 0, 0, ‘BROW’, ‘ptosis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_rhytids’, ‘BROW: rhytids’, 70, 0, 0, ‘BROW’, ‘rhytids’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_rhytids’, ‘BROW: rhytids’, 80, 0, 0, ‘BROW’, ‘rhytids’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_rhytids’, ‘BROW: rhytids’, 90, 0, 0, ‘BROW’, ‘rhytids’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_scar’, ‘BROW: scar’, 100, 0, 0, ‘BROW’, ‘scar’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_scar’, ‘BROW: scar’, 110, 0, 0, ‘BROW’, ‘scar’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_scar’, ‘BROW: scar’, 120, 0, 0, ‘BROW’, ‘scar’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_sebk’, ‘BROW: seb ker’, 130, 0, 0, ‘BROW’, ‘seb ker’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_sebk’, ‘BROW: seb ker’, 140, 0, 0, ‘BROW’, ‘seb ker’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_sebk’, ‘BROW: seb ker’, 150, 0, 0, ‘BROW’, ‘seb ker’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_AK’, ‘BROW: act ker’, 160, 0, 0, ‘BROW’, ‘actinic keratosis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_AK’, ‘BROW: act ker’, 170, 0, 0, ‘BROW’, ‘actinic keratosis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_AK’, ‘BROW: act ker’, 180, 0, 0, ‘BROW’, ‘actinic keratosis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_bcc’, ‘BROW: BCC’, 190, 0, 0, ‘BROW’, ‘BCC’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_bcc’, ‘BROW: BCC’, 200, 0, 0, ‘BROW’, ‘BCC’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_bcc’, ‘BROW: BCC’, 210, 0, 0, ‘BROW’, ‘BCC’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RBROW_scc’, ‘BROW: SCC’, 220, 0, 0, ‘BROW’, ‘SCC’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LBROW_scc’, ‘BROW: SCC’, 230, 0, 0, ‘BROW’, ‘SCC’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BBROW_scc’, ‘BROW: SCC’, 240, 0, 0, ‘BROW’, ‘SCC’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMRD_mrd0’, ‘MRD: 0’, 250, 0, 0, ‘MRD’, ‘0’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMRD_mrd0’, ‘MRD: 0’, 260, 0, 0, ‘MRD’, ‘0’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMRD_mrd0’, ‘MRD: 0’, 270, 0, 0, ‘MRD’, ‘0’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMRD_mrd1’, ‘MRD: 1’, 280, 0, 0, ‘MRD’, ‘1’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMRD_mrd1’, ‘MRD: 1’, 290, 0, 0, ‘MRD’, ‘1’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMRD_mrd1’, ‘MRD: 1’, 300, 0, 0, ‘MRD’, ‘1’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMRD_mrd2’, ‘MRD: 2’, 310, 0, 0, ‘MRD’, ‘2’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMRD_mrd2’, ‘MRD: 2’, 320, 0, 0, ‘MRD’, ‘2’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMRD_mrd2’, ‘MRD: 2’, 330, 0, 0, ‘MRD’, ‘2’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMRD_mrd3’, ‘MRD: 3’, 340, 0, 0, ‘MRD’, ‘3’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMRD_mrd3’, ‘MRD: 3’, 350, 0, 0, ‘MRD’, ‘3’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMRD_mrd3’, ‘MRD: 3’, 360, 0, 0, ‘MRD’, ‘3’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLF_17’, ‘LF: 17’, 370, 0, 0, ‘LF’, ‘17’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLF_17’, ‘LF: 17’, 380, 0, 0, ‘LF’, ‘17’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLF_17’, ‘LF: 17’, 390, 0, 0, ‘LF’, ‘17’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLF_15’, ‘LF: 15’, 400, 0, 0, ‘LF’, ‘15’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLF_15’, ‘LF: 15’, 410, 0, 0, ‘LF’, ‘15’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLF_15’, ‘LF: 15’, 420, 0, 0, ‘LF’, ‘15’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLF_13’, ‘LF: 13’, 430, 0, 0, ‘LF’, ‘13’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLF_13’, ‘LF: 13’, 440, 0, 0, ‘LF’, ‘13’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLF_13’, ‘LF: 13’, 450, 0, 0, ‘LF’, ‘13’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_clear’, ‘UL: clear field’, 460, 0, 0, ‘UL’, ‘’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_clear’, ‘UL: clear field’, 470, 0, 0, ‘UL’, ‘’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_clear’, ‘UL: clear field’, 480, 0, 0, ‘UL’, ‘’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_norm’, ‘UL: normal’, 490, 0, 0, ‘UL’, ‘normal lids and lashes’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_norm’, ‘UL: normal’, 500, 0, 0, ‘UL’, ‘normal lids and lashes’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_norm’, ‘UL: normal’, 510, 0, 0, ‘UL’, ‘normal lids and lashes’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_der’, ‘UL: dermatochalasis’, 520, 0, 0, ‘UL’, ‘dermatochalasis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_der’, ‘UL: dermatochalasis’, 530, 0, 0, ‘UL’, ‘dermatochalasis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_der’, ‘UL: dermatochalasis’, 540, 0, 0, ‘UL’, ‘dermatochalasis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_der’, ‘LL: dermatochalasis’, 550, 0, 0, ‘LL’, ‘dermatochalasis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_der’, ‘LL: dermatochalasis’, 560, 0, 0, ‘LL’, ‘dermatochalasis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_der’, ‘LL: dermatochalasis’, 570, 0, 0, ‘LL’, ‘dermatochalasis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_pto2’, ‘UL: 2mm ptosis’, 580, 0, 0, ‘UL’, ‘2mm ptosis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_pto2’, ‘UL: 2mm ptosis’, 590, 0, 0, ‘UL’, ‘2mm ptosis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_pto2’, ‘UL: 2mm ptosis’, 600, 0, 0, ‘UL’, ‘2mm ptosis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_pto3’, ‘UL: 3mm ptosis’, 610, 0, 0, ‘UL’, ‘3mm ptosis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_pto3’, ‘UL: 3mm ptosis’, 620, 0, 0, ‘UL’, ‘3mm ptosis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_pto3’, ‘UL: 3mm ptosis’, 630, 0, 0, ‘UL’, ‘3mm ptosis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_lesion’, ‘UL: lesion’, 640, 0, 0, ‘UL’, ‘lesion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_lesion’, ‘UL: lesion’, 650, 0, 0, ‘UL’, ‘lesion’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_lesion’, ‘UL: lesion’, 660, 0, 0, ‘UL’, ‘lesion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_chalazion’, ‘UL: chalazion’, 670, 0, 0, ‘UL’, ‘chalazion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_chalazion’, ‘UL: chalazion’, 680, 0, 0, ‘UL’, ‘chalazion’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_chalazion’, ‘UL: chalazion’, 690, 0, 0, ‘UL’, ‘chalazion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RUL_stye’, ‘UL: stye’, 700, 0, 0, ‘UL’, ‘stye’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LUL_stye’, ‘UL: stye’, 710, 0, 0, ‘UL’, ‘stye’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BUL_stye’, ‘UL: stye’, 720, 0, 0, ‘UL’, ‘stye’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMCT_les’, ‘MCT: lesion’, 730, 0, 0, ‘MCT’, ‘lesion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMCT_les’, ‘MCT: lesion’, 740, 0, 0, ‘MCT’, ‘lesion’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMCT_les’, ‘MCT: lesion’, 750, 0, 0, ‘MCT’, ‘lesion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMCT_NLDa’, ‘MCT: NLDO, acute’, 760, 0, 0, ‘MCT’, ‘NLDO, acute’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMCT_NLDa’, ‘MCT: NLDO, acute’, 770, 0, 0, ‘MCT’, ‘NLDO, acute’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMCT_NLDa’, ‘MCT: NLDO, acute’, 780, 0, 0, ‘MCT’, ‘NLDO, acute’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RMCT_NLDc’, ‘MCT: NLDO, chronic’, 790, 0, 0, ‘MCT’, ‘NLDO, chronic’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LMCT_NLDc’, ‘MCT: NLDO, chronic’, 800, 0, 0, ‘MCT’, ‘NLDO, chronic’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BMCT_NLDc’, ‘MCT: NLDO, chronic’, 810, 0, 0, ‘MCT’, ‘NLDO, chronic’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_clear’, ‘LL: clear field’, 820, 0, 0, ‘LL’, ‘’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_clear’, ‘LL: clear field’, 830, 0, 0, ‘LL’, ‘’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_clear’, ‘LL: clear field’, 840, 0, 0, ‘LL’, ‘’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_norm’, ‘LL: good tone’, 850, 0, 0, ‘LL’, ‘good tone’, ‘’, 0, 0, 1, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_norm’, ‘LL: good tone’, 860, 0, 0, ‘LL’, ‘good tone’, ‘’, 0, 0, 1, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_norm’, ‘LL: good tone’, 870, 0, 0, ‘LL’, ‘good tone’, ‘’, 0, 0, 1, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_ect’, ‘LL: ectropion’, 880, 0, 0, ‘LL’, ‘ectropion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_ect’, ‘LL: ectropion’, 890, 0, 0, ‘LL’, ‘ectropion’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_ect’, ‘LL: ectropion’, 900, 0, 0, ‘LL’, ‘ectropion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_ent’, ‘LL: entropion’, 910, 0, 0, ‘LL’, ‘entropion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_ent’, ‘LL: entropion’, 920, 0, 0, ‘LL’, ‘entropion’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_ent’, ‘LL: entropion’, 930, 0, 0, ‘LL’, ‘entropion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_trich’, ‘LL: trichiasis’, 940, 0, 0, ‘LL’, ‘trichiasis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_trich’, ‘LL: trichiasis’, 950, 0, 0, ‘LL’, ‘trichiasis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_trich’, ‘LL: trichiasis’, 960, 0, 0, ‘LL’, ‘trichiasis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_lesion’, ‘LL: lesion’, 970, 0, 0, ‘LL’, ‘lesion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_lesion’, ‘LL: lesion’, 980, 0, 0, ‘LL’, ‘lesion’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_lesion’, ‘LL: lesion’, 990, 0, 0, ‘LL’, ‘lesion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_fat’, ‘LL: fat prolapse’, 1010, 0, 0, ‘LL’, ‘fat prolapse’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_fat’, ‘LL: fat prolapse’, 1020, 0, 0, ‘LL’, ‘fat prolapse’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_fat’, ‘LL: fat prolapse’, 1030, 0, 0, ‘LL’, ‘fat prolapse’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_pi’, ‘LL: erythema’, 1040, 0, 0, ‘LL’, ‘erythema’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_pi’, ‘LL: erythema’, 1050, 0, 0, ‘LL’, ‘erythema’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_pi’, ‘LL: erythema’, 1060, 0, 0, ‘LL’, ‘erythema’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_nev’, ‘LL: ecchymosis’, 1070, 0, 0, ‘LL’, ‘ecchymosis’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_nev’, ‘LL: ecchymosis’, 1080, 0, 0, ‘LL’, ‘ecchymosis’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_nev’, ‘LL: ecchymosis’, 1090, 0, 0, ‘LL’, ‘ecchymosis’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_chalazion’, ‘LL: chalazion’, 1100, 0, 0, ‘LL’, ‘chalazion’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘BLL_chalazion’, ‘LL: chalazion’, 1110, 0, 0, ‘LL’, ‘chalazion’, ‘’, 0, 0, 0, ‘B’),(‘Eye_QP_EXT_defaults’, ‘RLL_stye’, ‘LL: stye’, 1120, 0, 0, ‘LL’, ‘stye’, ‘’, 0, 0, 0, ‘R’),(‘Eye_QP_EXT_defaults’, ‘LLL_stye’, ‘LL: stye’, 1130, 0, 0, ‘LL’, ‘stye’, ‘’, 0, 0, 0, ‘L’),(‘Eye_QP_EXT_defaults’, ‘BLL_stye’, ‘LL: stye’, 1140, 0, 0, ‘LL’, ‘stye’, ‘’, 0, 0, 0, ‘B’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_QP_RETINA_defaults’, ‘Eye QP List RETINA for New Providers’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_QP_RETINA_defaults’, ‘ODCUP_0’, ‘cup: clear field’, 10, 0, 0, ‘CUP’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_0’, ‘cup: clear field’, 20, 0, 0, ‘CUP’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_0’, ‘cup: clear field’, 30, 0, 0, ‘CUP’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_1’, ‘cup: 0.1’, 40, 0, 0, ‘CUP’, ‘0.1’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_1’, ‘cup: 0.1’, 50, 0, 0, ‘CUP’, ‘0.1’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_1’, ‘cup: 0.1’, 60, 0, 0, ‘CUP’, ‘0.1’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_3’, ‘cup: 0.3’, 70, 0, 0, ‘CUP’, ‘0.3’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_3’, ‘cup: 0.3’, 80, 0, 0, ‘CUP’, ‘0.3’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_5’, ‘cup: 0.5’, 90, 0, 0, ‘CUP’, ‘0.5’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_3’, ‘cup: 0.3’, 100, 0, 0, ‘CUP’, ‘0.3’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_5’, ‘cup: 0.5’, 110, 0, 0, ‘CUP’, ‘0.5’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_5’, ‘cup: 0.5’, 120, 0, 0, ‘CUP’, ‘0.5’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_8’, ‘cup: 0.8’, 130, 0, 0, ‘CUP’, ‘0.8’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_8’, ‘cup: 0.8’, 140, 0, 0, ‘CUP’, ‘0.8’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_8’, ‘cup: 0.8’, 150, 0, 0, ‘CUP’, ‘0.8’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_95’, ‘cup: 0.95’, 160, 0, 0, ‘CUP’, ‘0.95’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_95’, ‘cup: 0.95’, 170, 0, 0, ‘CUP’, ‘0.95’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_95’, ‘cup: 0.95’, 180, 0, 0, ‘CUP’, ‘0.95’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_V’, ‘cup: V (vert)’, 190, 0, 0, ‘CUP’, ‘V’, ‘’, 0, 0, 2, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_V’, ‘cup: V (vert)’, 200, 0, 0, ‘CUP’, ‘V’, ‘’, 0, 0, 2, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_V’, ‘cup: V (vert)’, 210, 0, 0, ‘CUP’, ‘V’, ‘’, 0, 0, 2, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_x’, ‘cup: x (times)’, 220, 0, 0, ‘CUP’, ‘x’, ‘’, 0, 0, 2, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_x’, ‘cup: x (times)’, 230, 0, 0, ‘CUP’, ‘x’, ‘’, 0, 0, 2, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_x’, ‘cup: x (times)’, 240, 0, 0, ‘CUP’, ‘x’, ‘’, 0, 0, 2, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_H’, ‘cup: H (horiz)’, 250, 0, 0, ‘CUP’, ‘H’, ‘’, 0, 0, 2, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_H’, ‘cup: H (horiz)’, 260, 0, 0, ‘CUP’, ‘H’, ‘’, 0, 0, 2, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_H’, ‘cup: H (horiz)’, 270, 0, 0, ‘CUP’, ‘H’, ‘’, 0, 0, 2, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODCUP_notch’, ‘cup: notch’, 280, 0, 0, ‘CUP’, ‘notch’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_notch’, ‘cup: notch’, 290, 0, 0, ‘CUP’, ‘notch’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUCUP_notch’, ‘cup: notch’, 300, 0, 0, ‘CUP’, ‘notch’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_0’, ‘d: clear field’, 310, 0, 0, ‘DISC’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSDISC_0’, ‘d: clear field’, 320, 0, 0, ‘DISC’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_0’, ‘d: clear field’, 330, 0, 0, ‘DISC’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_risk’, ‘d: at risk’, 340, 0, 0, ‘DISC’, ‘disc at risk’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSDISC_risk’, ‘d: at risk’, 350, 0, 0, ‘DISC’, ‘disk at risk’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_risk’, ‘d: at risk’, 360, 0, 0, ‘DISC’, ‘disk at risk’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_pal’, ‘d: pallor’, 370, 0, 0, ‘DISC’, ‘pallor’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSCUP_pal’, ‘d: pallor’, 380, 0, 0, ‘DISC’, ‘pallor’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_pal’, ‘d: pallor’, 390, 0, 0, ‘DISC’, ‘pallor’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_NVD’, ‘d: NVD’, 400, 0, 0, ‘DISC’, ‘NVD’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSDISC_NVD’, ‘d: NVD’, 410, 0, 0, ‘DISC’, ‘NVD’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_NVD’, ‘d: NVD’, 420, 0, 0, ‘DISC’, ‘NVD’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_edema1’, ‘d: gr I edema’, 430, 0, 0, ‘DISC’, ‘Grade I papilledema’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSDISC_edema1’, ‘d: gr I edema’, 440, 0, 0, ‘DISC’, ‘Grade I papilledema’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_edema1’, ‘d: gr I edema’, 450, 0, 0, ‘DISC’, ‘Grade I papilledema’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_edema2’, ‘d: gr III edema’, 460, 0, 0, ‘DISC’, ‘Grade III papilledema’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSDISC_edema2’, ‘d: gr III edema’, 470, 0, 0, ‘DISC’, ‘Grade III papilledema’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_edema2’, ‘d: gr III edema’, 480, 0, 0, ‘DISC’, ‘Grade III papilledema’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODDISC_edemaf’, ‘d: gr V edema’, 490, 0, 0, ‘DISC’, ‘Grade V papilledema’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSDISC_edemaf’, ‘d: gr V edema’, 500, 0, 0, ‘DISC’, ‘Grade V papilledema’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUDISC_edemaf’, ‘d: gr V edema’, 510, 0, 0, ‘DISC’, ‘Grade V papilledema’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODMAC_0’, ‘m: clear field’, 520, 0, 0, ‘MACULA’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSMAC_0’, ‘m: clear field’, 530, 0, 0, ‘MACULA’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUMAC_0’, ‘m: clear field’, 540, 0, 0, ‘MACULA’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODMAC_hd’, ‘m: hard drusen’, 550, 0, 0, ‘MACULA’, ‘hard drusen’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSMAC_hd’, ‘m: hard drusen’, 560, 0, 0, ‘MACULA’, ‘hard drusen’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUMAC_hd’, ‘m: hard drusen’, 570, 0, 0, ‘MACULA’, ‘hard drusen’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODMAC_sd’, ‘m: soft drusen’, 580, 0, 0, ‘MACULA’, ‘soft drusen’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSMAC_sd’, ‘m: soft drusen’, 590, 0, 0, ‘MACULA’, ‘soft drusen’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUMAC_sd’, ‘m: soft drusen’, 600, 0, 0, ‘MACULA’, ‘soft drusen’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODMAC_PED’, ‘m: PED’, 610, 0, 0, ‘MACULA’, ‘PED’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSMAC_PED’, ‘m: PED’, 620, 0, 0, ‘MACULA’, ‘PED’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUMAC_PED’, ‘m: PED’, 630, 0, 0, ‘MACULA’, ‘PED’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODMAC_CSR’, ‘m: CSR’, 640, 0, 0, ‘MACULA’, ‘CSR’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSMAC_CSR’, ‘m: CSR’, 650, 0, 0, ‘MACULA’, ‘CSR’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUMAC_CSR’, ‘m: CSR’, 660, 0, 0, ‘MACULA’, ‘CSR’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_cl’, ‘v: clear field’, 670, 0, 0, ‘VESSELS’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_cl’, ‘v: clear field’, 680, 0, 0, ‘VESSELS’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_cl’, ‘v: clear field’, 690, 0, 0, ‘VESSELS’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_12’, ‘v: 1:2’, 700, 0, 0, ‘VESSELS’, ‘1:2’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_12’, ‘v: 1:2’, 710, 0, 0, ‘VESSELS’, ‘1:2’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_12’, ‘v: 1:2’, 720, 0, 0, ‘VESSELS’, ‘1:2’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_BDR’, ‘v: BDR’, 730, 0, 0, ‘VESSELS’, ‘BDR’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_BDR’, ‘v: BDR’, 740, 0, 0, ‘VESSELS’, ‘BDR’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_BDR’, ‘v: BDR’, 750, 0, 0, ‘VESSELS’, ‘BDR’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_PDR’, ‘v: PDR’, 760, 0, 0, ‘VESSELS’, ‘PDR’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_PDR’, ‘v: PDR’, 770, 0, 0, ‘VESSELS’, ‘PDR’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_PDR’, ‘v: PDR’, 780, 0, 0, ‘VESSELS’, ‘PDR’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_BRVO’, ‘v: BRVO’, 790, 0, 0, ‘VESSELS’, ‘BRVO’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_BRVO’, ‘v: BRVO’, 800, 0, 0, ‘VESSELS’, ‘BRVO’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_BRVO’, ‘v: BRVO’, 810, 0, 0, ‘VESSELS’, ‘BRVO’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_CRVO’, ‘v: CRVO’, 820, 0, 0, ‘VESSELS’, ‘CRVO’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_CRVO’, ‘v: CRVO’, 830, 0, 0, ‘VESSELS’, ‘CRVO’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_CRVO’, ‘v: CRVO’, 840, 0, 0, ‘VESSELS’, ‘CRVO’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_BRAO’, ‘v: BRAO’, 850, 0, 0, ‘VESSELS’, ‘BRAO’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_BRAO’, ‘v: BRAO’, 860, 0, 0, ‘VESSELS’, ‘BRAO’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_BRAO’, ‘v: BRAO’, 870, 0, 0, ‘VESSELS’, ‘BRAO’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODVESSELS_CRAO’, ‘v: CRAO’, 880, 0, 0, ‘VESSELS’, ‘CRAO’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSVESSELS_CRAO’, ‘v: CRAO’, 890, 0, 0, ‘VESSELS’, ‘CRAO’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUVESSELS_CRAO’, ‘v: CRAO’, 900, 0, 0, ‘VESSELS’, ‘CRAO’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_0’, ‘p: clear field’, 910, 0, 0, ‘PERIPH’, ‘’, ‘’, 0, 0, 1, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_0’, ‘p: clear field’, 920, 0, 0, ‘PERIPH’, ‘’, ‘’, 0, 0, 1, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_0’, ‘p: clear field’, 930, 0, 0, ‘PERIPH’, ‘’, ‘’, 0, 0, 1, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_float’, ‘p: floater’, 940, 0, 0, ‘PERIPH’, ‘vitreous floater’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_float’, ‘p: floater’, 950, 0, 0, ‘PERIPH’, ‘vitreous floater’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_float’, ‘p: floater’, 960, 0, 0, ‘PERIPH’, ‘vitreous floater’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_pvd’, ‘p: PVD’, 970, 0, 0, ‘PERIPH’, ‘PVD’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_pvd’, ‘p: PVD’, 980, 0, 0, ‘PERIPH’, ‘PVD’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_pvd’, ‘p: PVD’, 990, 0, 0, ‘PERIPH’, ‘PVD’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_vh’, ‘p: vit hem’, 1000, 0, 0, ‘PERIPH’, ‘vitreous hemorrhage’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_vh’, ‘p: vit hem’, 1010, 0, 0, ‘PERIPH’, ‘vitreous hemorrhage’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_vh’, ‘p: vit hem’, 1020, 0, 0, ‘PERIPH’, ‘vitreous hemorrhage’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_tear’, ‘p: retinal tear’, 1030, 0, 0, ‘PERIPH’, ‘retinal tear’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_tear’, ‘p: retinal tear’, 1040, 0, 0, ‘PERIPH’, ‘retinal tear’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_tear’, ‘p: retinal tear’, 1050, 0, 0, ‘PERIPH’, ‘retinal tear’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_schisis’, ‘p: retinoschisis’, 1060, 0, 0, ‘PERIPH’, ‘retinoschisis’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_schisis’, ‘p: retinoschisis’, 1070, 0, 0, ‘PERIPH’, ‘retinoschisis’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_schisis’, ‘p: retinoschisis’, 1080, 0, 0, ‘PERIPH’, ‘retinoschisis’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_NVE’, ‘p: NVE’, 1090, 0, 0, ‘PERIPH’, ‘NVE’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_NVE’, ‘p: NVE’, 1100, 0, 0, ‘PERIPH’, ‘NVE’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_NVE’, ‘p: NVE’, 1110, 0, 0, ‘PERIPH’, ‘NVE’, ‘’, 0, 0, 0, ‘OU’),(‘Eye_QP_RETINA_defaults’, ‘ODPERIPH_RD’, ‘p: RD’, 1120, 0, 0, ‘PERIPH’, ‘RD’, ‘’, 0, 0, 0, ‘OD’),(‘Eye_QP_RETINA_defaults’, ‘OSPERIPH_RD’, ‘p: RD’, 1130, 0, 0, ‘PERIPH’, ‘RD’, ‘’, 0, 0, 0, ‘OS’),(‘Eye_QP_RETINA_defaults’, ‘OUPERIPH_RD’, ‘p: RD’, 1140, 0, 0, ‘PERIPH’, ‘RD’, ‘’, 0, 0, 0, ‘OU’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_todo_done_defaults’, ‘Eye Orders Defaults’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_todo_done_defaults’, ‘Ascan’, ‘A scan/IOL calc’, 430, 0, 0, ‘’, ‘’, ‘CPT4:76519’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘Bscan’, ‘B scan’, 440, 0, 0, ‘’, ‘’, ‘CPT4:76512’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘dilation’, ‘Dilated Exam’, 90, 0, 0, ‘’, ‘Full dilated exam’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘ExtPhoto’, ‘Ext Photos’, 200, 0, 0, ‘’, ‘’, ‘CPT4:92285’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘FundusPhoto’, ‘Retina Photo’, 210, 0, 0, ‘’, ‘’, ‘CPT4:92250’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘Gonio’, ‘Gonio’, 410, 0, 0, ‘’, ‘’, ‘CPT4:92020’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘IOP’, ‘IOP’, 80, 0, 0, ‘’, ‘Intraocular pressure check’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘irrigate’, ‘Irrigate’, 450, 0, 0, ‘’, ‘’, ‘CPT4:68840’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘ISHI’, ‘Color Plates’, 320, 0, 0, ‘’, ‘’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘lesion’, ‘Surg: office/15 min’, 470, 0, 0, ‘’, ‘’, ‘CPT4:67840’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘OCTDisc’, ‘OCT Disc’, 300, 0, 0, ‘’, ‘’, ‘CPT4:92133’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘OCTRetina’, ‘OCT Retina’, 310, 0, 0, ‘’, ‘’, ‘CPT4:92134’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘Pachy’, ‘Pachymetry’, 420, 0, 0, ‘’, ‘’, ‘CPT4:76514’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘refraction’, ‘Refraction’, 460, 0, 0, ‘’, ‘’, ‘CPT4:92015’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘RTC1month’, ‘RTC 1 month’, 20, 0, 0, ‘’, ‘F/U 1 month’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘RTC1WK’, ‘RTC 1 week’, 10, 0, 0, ‘’, ‘F/U 1 week’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘RTC1yr’, ‘RTC 1 year’, 40, 0, 0, ‘’, ‘Recheck 1 year’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘RTC2yr’, ‘RTC 2 years’, 50, 0, 0, ‘’, ‘Recheck 2 years’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘RTC3wks’, ‘RTC 3 weeks’, 30, 0, 0, ‘’, ‘’, ‘’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘Topo’, ‘Corneal Topo’, 400, 0, 0, ‘’, ‘’, ‘CPT4:92025’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘VFBLEPH’, ‘VF BLEPH’, 130, 0, 0, ‘’, ‘Taped and untaped VF, uppers only’, ‘CPT4:92083’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘VFC10’, ‘Visual Field C-10’, 100, 0, 0, ‘’, ‘Central 10 red target VF’, ‘CPT4:92083’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘VFC24’, ‘VF C-24’, 110, 0, 0, ‘’, ‘Central 24 VF’, ‘CPT4:92083’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘VFC30’, ‘VF C-30’, 120, 0, 0, ‘’, ‘Central 30 VF’, ‘CPT4:92083’, 0, 0, 1, ‘’),(‘Eye_todo_done_defaults’, ‘Yag’, ‘Surg: YAG RT/LT’, 480, 0, 0, ‘’, ‘’, ‘CPT4:66821’, 0, 0, 1, ‘’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_Defaults_for_GENERAL’, ‘Eye Exam Default Values for New Providers’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_Defaults_for_GENERAL’, ‘LBROW’, ‘no brow ptosis’, 60, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘LLF’, ‘17’, 140, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘LLL’, ‘good tone’, 40, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘LMCT’, ‘no masses’, 80, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘LMRD’, ‘+3’, 120, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘LUL’, ‘normal lids and lashes’, 20, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODAC’, ‘deep and quiet’, 190, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODAPD’, ‘0’, 280, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODCONJ’, ‘quiet’, 160, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODCORNEA’, ‘clear’, 170, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODCUP’, ‘0.3’, 450, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODDISC’, ‘pink’, 430, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODIOPTARGET’, ‘21’, 530, 0, 0, ‘’, ‘GLAUCOMA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODIRIS’, ‘round’, 230, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODLENS’, ‘clear’, 210, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODMACULA’, ‘flat’, 470, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODPERIPH’, ‘flat’, 510, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODPUPILREACTIVITY’, ‘+2’, 270, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODPUPILSIZE1’, ‘3’, 250, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODPUPILSIZE2’, ‘2’, 260, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODVESSELS’, ‘2:3’, 490, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODVFCONFRONTATION1’, ‘0’, 330, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODVFCONFRONTATION2’, ‘0’, 340, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODVFCONFRONTATION3’, ‘0’, 350, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODVFCONFRONTATION4’, ‘0’, 360, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘ODVFCONFRONTATION5’, ‘0’, 370, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSAC’, ‘deep and quiet’, 200, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSAPD’, ‘0’, 320, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSCONJ’, ‘quiet’, 150, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSCORNEA’, ‘clear’, 180, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSCUP’, ‘0.3’, 460, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSDISC’, ‘pink’, 440, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSIOPTARGET’, ‘21’, 540, 0, 0, ‘’, ‘GLAUCOMA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSIRIS’, ‘round’, 240, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSLENS’, ‘clear’, 220, 0, 0, ‘’, ‘ANTSEG’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSMACULA’, ‘flat’, 480, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSPERIPH’, ‘flat’, 520, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSPUPILREACTIVITY’, ‘+2’, 310, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSPUPILSIZE1’, ‘3’, 290, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSPUPILSIZE2’, ‘2’, 300, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSVESSELS’, ‘2:3’, 500, 0, 0, ‘’, ‘RETINA’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSVFCONFRONTATION1’, ‘0’, 380, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSVFCONFRONTATION2’, ‘0’, 390, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSVFCONFRONTATION3’, ‘0’, 400, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSVFCONFRONTATION4’, ‘0’, 410, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘OSVFCONFRONTATION5’, ‘0’, 420, 0, 0, ‘’, ‘NEURO’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RADNEXA’, ‘normal lacrimal gland and orbit’, 90, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RBROW’, ‘no brow ptosis’, 50, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RLF’, ‘17’, 130, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RLL’, ‘good tone’, 30, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RMCT’, ‘no masses’, 70, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RMRD’, ‘+3’, 110, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’),(‘Eye_Defaults_for_GENERAL’, ‘RUL’, ‘normal lids and lashes’, 10, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_Lens_Material’, ‘Eye Lens Material’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_Lens_Material’, ‘LM_CG’, ‘Crown Glass’, 10, 0, 0, ‘’, ‘Excellent optics. Low cost. Downsides: heavy, breakable. Abbe Value: 59’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Material’, ‘LM_CR’, ‘CR-39’, 20, 0, 0, ‘’, ‘Excellent optics. Low cost. Downside: thickness. Abbe Value: 58’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Material’, ‘LM_HI_PLASTICS_1’, ‘High-index Plastics (1.6 to 1.67)’, 60, 0, 0, ‘’, ‘Thin and lightweight. Block 100 percent UV. Less costly than 1.70-1.74 high-index lenses. Abbe: 36(1.6) - 32 (1.67)’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Material’, ‘LM_HI_PLASTICS_2’, ‘High-index Plastics (1.7 to 1.74)’, 70, 0, 0, ‘’, ‘The thinnest lenses available. Block 100 percent UV. Lightweight. Abbe: 36(1.7) - 33(1.74)’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Material’, ‘LM_POLY’, ‘Polycarbonate’, 40, 0, 0, ‘’, ‘Superior impact resistance. Blocks 100 percent UV. Lighter than high-index plastic lenses. Abbe: 30’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Material’, ‘LM_TRIBRID’, ‘Tribrid’, 50, 0, 0, ‘’, ‘Thin and lightweight. Significantly more impact-resistant than CR-39 plastic and high-index plastic lenses (except polycarbonate and Trivex). Higher Abbe value than polycarbonate. Downside: Not yet available in a wide variety of lens designs. Abbe: 41’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Material’, ‘LM_TRIVEX’, ‘Trivex’, 30, 0, 0, ‘’, ‘Superior impact resistance. Blocks 100 percent UV. Higher Abbe value than polycarbonate. Lightest lens material available. Abbe Value: 45’, ‘’, 0, 0, 1, ‘’)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’ ,‘Eye_Lens_Treatments’, ‘Eye Lens Treatments’, 1, 0)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES(‘Eye_Lens_Treatments’, ‘LT_ARCOAT’, ‘Anti-reflective coating’, 20, 0, 0, ‘’, ‘’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Treatments’, ‘LT_ASCRATCH’, ‘Anti-scratch coating’, 10, 0, 0, ‘’, ‘’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Treatments’, ‘LT_UVBLOCK’, ‘UV-blocking treatment’, 30, 0, 0, ‘’, ‘’, ‘’, 0, 0, 1, ‘’),(‘Eye_Lens_Treatments’, ‘LT_PHOTOGREY’, ‘Photochromic treatment’, 40, 0, 0, ‘’, ‘’, ‘’, 0, 0, 1, ‘’)
ALTER TABLE users ADD suffix varchar(255) default NULL
INSERT INTO list_options (list_id, option_id, title, seq, notes, activity) VALUES (‘page_validation’, ‘addrbook_edit#theform’, ‘/interface/usergroup/addrbook_edit.php’, 110, ‘{}’, 1)
Skipping section #IfNotTable product_registration
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, toggle_setting_1, toggle_setting_2, activity, subtype) VALUES (‘Eye_Defaults_for_GENERAL’, ‘LADNEXA’, ‘normal lacrimal gland and orbit’, 91, 0, 0, ‘’, ‘EXT’, ‘’, 0, 0, 0, ‘’)
ALTER TABLE log ADD category varchar(255) default NULL
Skipping section #IfNotTable log_validator
INSERT INTO list_options (list_id, option_id, title, seq,is_default) VALUES (‘note_type’, ‘Image Results’, ‘Image Results’, 30, 0)
ALTER TABLE insurance_companies ADD inactive INT(1) NOT NULL DEFAULT ‘0’
INSERT INTO list_options (list_id, option_id, title,activity) VALUES (‘lists’,‘formdir_keys’,‘Form Keys’,1)
INSERT INTO list_options (list_id,option_id,title,seq,notes,activity) VALUES (‘formdir_keys’,‘newpatient’,’“tbl”:“form_encounter”’,10,‘Patient encounter table has non-std name’,1)
INSERT INTO list_options (list_id,option_id,title,seq,notes,activity) VALUES (‘formdir_keys’,‘procedure_order’,’“tbl”:“procedure_order”,“id”:“procedure_order_id”’,20,‘Lab order header table has non-std name and id’,1)
INSERT INTO list_options (list_id,option_id,title,seq,notes,activity) VALUES (‘formdir_keys’,‘physical_exam’,’“id”:“forms_id”,“limit”:""’,30,‘Physical exam form table has non-std id and n records’,1)
ALTER TABLE form_misc_billing_options ADD COLUMN medicaid_referral_code varchar(2) default NULL
ALTER TABLE form_misc_billing_options ADD COLUMN epsdt_flag tinyint(1) default NULL
ALTER TABLE form_misc_billing_options ADD COLUMN provider_qualifier_code varchar(2) default NULL
ALTER TABLE form_misc_billing_options ADD COLUMN provider_id int(11) default NULL
ALTER TABLE form_misc_billing_options ADD COLUMN icn_resubmission_number int(35) default NULL
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘lists’,‘provider_qualifier_code’,‘Provider Qualifier Code’, 1,0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘provider_qualifier_code’,‘dk’,‘DK’,10,0)
INSERT INTO list_options ( list_id, option_id, title, seq, is_default ) VALUES (‘provider_qualifier_code’,‘dn’,‘DN’,20,0)
Skipping section #IfNotTable codes_history
ALTER TABLE form_care_plan ADD COLUMN care_plan_type VARCHAR(30) DEFAULT NULL
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, activity, toggle_setting_1, toggle_setting_2, subtype) VALUES(‘lists’,‘Plan_of_Care_Type’,‘Plan of Care Type’,‘305’,‘1’,‘0’,’’,’’,’’,‘1’,‘0’,‘0’,’’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, activity, toggle_setting_1, toggle_setting_2, subtype) VALUES(‘Plan_of_Care_Type’,‘appointments’,‘Appointments’,‘4’,‘0’,‘0’,’’,‘INT’,’’,‘1’,‘0’,‘0’,’’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, activity, toggle_setting_1, toggle_setting_2, subtype) VALUES(‘Plan_of_Care_Type’,‘instructions’,‘Instructions’,‘5’,‘0’,‘0’,’’,‘INT’,’’,‘1’,‘0’,‘0’,’’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, activity, toggle_setting_1, toggle_setting_2, subtype) VALUES(‘Plan_of_Care_Type’,‘plan_of_care’,‘Plan of Care’,‘1’,‘0’,‘0’,’’,‘INT’,’’,‘1’,‘0’,‘0’,’’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, activity, toggle_setting_1, toggle_setting_2, subtype) VALUES(‘Plan_of_Care_Type’,‘procedure’,‘Procedure’,‘3’,‘0’,‘0’,’’,‘RQO’,’’,‘1’,‘0’,‘0’,’’)
INSERT INTO list_options (list_id, option_id, title, seq, is_default, option_value, mapping, notes, codes, activity, toggle_setting_1, toggle_setting_2, subtype) VALUES(‘Plan_of_Care_Type’,‘test_or_order’,‘Test/Order’,‘2’,‘0’,‘0’,’’,‘RQO’,’’,‘1’,‘0’,‘0’,’’)
Updating global configuration defaults…

ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1

Error: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’

C:\xampp\htdocs\openemr\library\translation.inc.php at 36:sqlStatementNoLog
C:\xampp\htdocs\openemr\library\globals.inc.php at 2732:xl(Māori)
C:\xampp\htdocs\openemr\sql_upgrade.php at 72:require_once(C:\xampp\htdocs\openemr\library\globals.inc.php)

Please help me out

Thanks

[system]

visolveemr wrote on Saturday, February 18, 2017:

Hi Clement,

Please refer the following link to resolve the mentioned issue:
https://sourceforge.net/p/openemr/discussion/202505/thread/d440db8c/

Let us know if you have any concerns.

Visolve

[system]

bradymiller wrote on Saturday, February 18, 2017:

Hi,

To add to Visolve. After you address the issue per Visolve’s link, then run the sql_upgrade script again (it will skip all the stuff it has already done and finish the upgrade shich consists of bringing in the new globals and incrementing the version).

-brady
OpenEMR

[system]

jhunyan wrote on Saturday, February 18, 2017:

Hi,

Thanks for reply.

I changed the collation to utf8_general_ci for lang_definitions and lang_constants but still getting the same error as below.

ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1

Error: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’

I also attached snapshot of the database as well

Please advise

[system]

jhunyan wrote on Sunday, February 19, 2017:

Hi,

I changed all database collation to utf8_general_ci and try to run upgrade to Openemr 5 but still getting the similar error message

ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1

Error: Illegal mix of collations (latin1_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’

Attached in the forum the list of the database

Please advise.

Thanks

[system]

bradymiller wrote on Sunday, February 19, 2017:

Hi,

As I recall, conversion to utf8 is at the sql column level (so just changing each table doesn’t always suffice). Here’s a wiki page that discusses the conversion to utf8 in more detail:
http://www.open-emr.org/wiki/index.php/OpenEMR_UTF-8_Upgrade_Howto
(would go for option 2)

let us know if this helps

-brady
OpenEMR

[system]

jhunyan wrote on Sunday, February 19, 2017:

Dear Brady,

Thank you for your reply. I tried your steps mentioned above but no success but getting error message which I took the snapshot of it.

Please advise.

[system]

bradymiller wrote on Tuesday, February 21, 2017:

yep,

It appears those instructions are specific to linux. May need a windows guru to point out how can convert those to windows command (i am not sure if windows can do piping, though).

To drill downa bit more, what do the structures of your 4 lang_* tables look like in phpmyadmin?
(there is possible shortcut to fix those tables if those are the only ones causing the problem)

-brady
OpenEMR

[system]

jhunyan wrote on Tuesday, February 21, 2017:

Dear Brady,

Thanks for your reply.

Attached is the snapshot of the 4 lang * tables in latin1_general_ci.

I even convert to uft8_general_ci but still could not get through.

Please advise.

Thanks

[system]

cmswest wrote on Tuesday, February 21, 2017:

cygwin, https://cygwin.com, might be able to help if the fix on the lang tables doesn’t do the trick

[system]

bradymiller wrote on Wednesday, February 22, 2017:

Hi,

Actually, cygwin looks like a good option to allow you to convert the database to utf8(via the linux command). Are you able to install and run cygwin?

-brady
OpenEMR

[system]

bradymiller wrote on Wednesday, February 22, 2017:

Also,

Regarding structure, I am more looking at what the tables look like when you click the Structure link for them in your screenshot. The thing about UTF8 conversion is that it is per sql column, not just per table.

Something to try is to update the translation set (ie. this will reinstall the lang sql tables), which is documented here:
http://www.open-emr.org/wiki/index.php/Install_Translations
(Install the Development Translation Release)

-brady
OpenEMR

[system]

jhunyan wrote on Thursday, February 23, 2017:

Dear Brady,

I tried your above method. I chacked on the website you mentioned http://www.open-emr.org/wiki/index.php/Install_Translations. There is no file found for Development Translation Release. When I clicked on it, it seem like it is missing.

I am not familiar with the use of Cygwin. I tired installed it but does not know how to get around it as I am not familiar with the way Linux work. It seems like a learning curve for me as Linux programming works quite differently.

Please advise.

Thanks

[system]

bradymiller wrote on Thursday, February 23, 2017:

Hi Clement,

That is odd. The script to collect this should run again in a couple hours (it’s a daily script). Can also grab it from here for the time being:
http://demo.open-emr.org:2089/openemr/contrib/util/language_translations/currentLanguage_utf8.sql

-brady

[system]

bradymiller wrote on Thursday, February 23, 2017:

Actually, since this is a production install, use this one instead which only brings in the higher quality translations:
http://demo.open-emr.org:2105/openemr/contrib/util/language_translations/currentLanguage_utf8.sql

[system]

jhunyan wrote on Thursday, February 23, 2017:

Dear Brady,

It is finally successful after I imported the script into database.

Thank you very much for your help.

I hope this topic in this forum can be very helpful for someone who experience similar problem like me.