text: TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_admission_source;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_admission_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_anesthesia_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_antimicrobial;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_asa_class;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_cancel_reason;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_caresetting;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_collection_src_site;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_collection_status;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_compliance_status;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_date;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_diagnosis;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_diagnosis_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_diagnostic_grouping;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_dischg_disp;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_discontinue_reason;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_event_class;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_event_code;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_event_reltn;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_event_source;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_formulary_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_frequency;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_hospital;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_interp_result;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_isolate;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_lab_procedure;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_lab_result_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_manufacturer;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_med_order_status;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_med_product;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_med_reason;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_medication;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_mic_order_status;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_micro_result_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_normalcy;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_normalcy_method;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_order_stop_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_order_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_patient;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_patient_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_payer;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_physician;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_present_on_admit;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_procedure;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_procedure_modifier;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_reporting_priority;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_result_indicator;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_result_type_proc;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_route_admin;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_surgical_case_level;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_surgical_procedure;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_surgical_specialty;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_test_type;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_unit;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_d_wound_class;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_clinical_event;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_diagnosis;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_enc_history;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_encounter;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_implant_log;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_lab_procedure;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_med_history;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_medication;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_micro_susceptibility;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_microbiology;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_procedure;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_surgical_case;
  TRUNCATE TABLE native.Cdm_testing_cerner.hf_f_surgical_procedure;
  -- 2: Hospital has caresetting_id  47
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('1', 'South', '6', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  INSERT INTO native.Cdm_testing_cerner.hf_d_caresetting (caresetting_id, caresetting_desc) VALUES ('47', 'Hepatology - Outpatient');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('3', '2', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('4', '1', '-1', '47', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '1999-09-09 10:23:00', '1999-09-09 10:23:00', '1', '1');
  -- 3: Hospital has caresetting_id  86
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('5', 'South', '6', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  INSERT INTO native.Cdm_testing_cerner.hf_d_caresetting (caresetting_id, caresetting_desc) VALUES ('86', 'Nursing Home (LTC)');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('7', '6', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('8', '5', '-1', '86', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '1999-09-09 10:23:00', '1999-09-09 10:23:00', '1', '1');
  -- 4: Hospital has caresetting_id  140
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('9', 'South', '6', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  INSERT INTO native.Cdm_testing_cerner.hf_d_caresetting (caresetting_id, caresetting_desc) VALUES ('140', 'Step-Down Unit');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('11', '10', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('12', '9', '-1', '140', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '1999-09-09 10:23:00', '1999-09-09 10:23:00', '1', '1');
  -- 5: Hospital has caresetting_id  14
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('13', 'South', '6', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  INSERT INTO native.Cdm_testing_cerner.hf_d_caresetting (caresetting_id, caresetting_desc) VALUES ('14', 'Cardiology - Pediatrics');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('15', '14', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('16', '13', '-1', '14', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '1999-09-09 10:23:00', '1999-09-09 10:23:00', '1', '1');
  -- 6: Patient has diagnosis in hf_f_diagnosis
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('18', '17', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_diagnosis (diagnosis_id, diagnosis_type, diagnosis_code, diagnosis_description) VALUES ('148', 'ICD9', '038.42', 'Septicemia Due to Escherichia Coli [E. Coli]');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('19', '84', '-1', '16', '18', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-02-29 10:23:00', '2000-02-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_diagnosis (encounter_id, diagnosis_id, diagnosis_priority, diagnosis_type_id, present_on_admit_id, third_party_ind) VALUES ('19', '148', '1', '83', '6', '0');
  -- 7: Patient has diagnosis in hf_f_diagnosis
  INSERT INTO native.Cdm_testing_cerner.hf_d_diagnosis (diagnosis_id, diagnosis_type, diagnosis_code, diagnosis_description) VALUES ('103761', 'ICD10-CM', 'M87.112', 'Osteonecrosis due to drugs, left shoulder');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('21', '20', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('22', '84', '-1', '16', '21', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-30 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_diagnosis (encounter_id, diagnosis_id, diagnosis_priority, diagnosis_type_id, present_on_admit_id, third_party_ind) VALUES ('22', '103761', '1', '83', '6', '0');
  -- 8: Patient has code in hf_f_clinical_event that maps to domain = Condition midnight
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('24', '23', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('25', '84', '-1', '16', '24', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_clinical_event (encounter_id, lab_procedure_id, event_code_id, event_class_id, event_end_dt_tm, event_end_dt_id, event_reltn_id, event_start_dt_tm, event_start_dt_id, event_expiration_dt_id, event_normalcy_id, event_normalcy_method_id, performed_dt_id, performed_prsnl_id, result_normalcy_flg, result_time_unit_id, result_units_id, result_value_dt_id, result_feasible_ind, result_inaccurate_ind, event_source_id, verified_dt_id, verified_prsnl_id) VALUES ('25', '23', '308', '15', '2000-08-29 00:00:00', '7285', '4', '2000-08-29 00:00:00', '4019', '4019', '-1', '-1', '4019', '-9', '0', '250', '250', '4019', '0', '0', '-1', '4019', '-9');
  -- 9: Patient has code in hf_f_clinical_event that maps to domain = Condition
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('27', '26', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('28', '84', '-1', '16', '27', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 09:23:00', '2000-08-29 11:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_clinical_event (encounter_id, lab_procedure_id, event_code_id, event_class_id, event_end_dt_tm, event_end_dt_id, event_reltn_id, event_start_dt_tm, event_start_dt_id, event_expiration_dt_id, event_normalcy_id, event_normalcy_method_id, performed_dt_id, performed_prsnl_id, result_normalcy_flg, result_time_unit_id, result_units_id, result_value_dt_id, result_feasible_ind, result_inaccurate_ind, event_source_id, verified_dt_id, verified_prsnl_id) VALUES ('28', '23', '308', '15', '2000-08-29 10:23:00', '7285', '4', '2000-08-29 10:23:00', '4019', '4019', '-1', '-1', '4019', '-9', '0', '250', '250', '4019', '0', '0', '-1', '4019', '-9');
  -- 10: Patient has code in hf_f_clinical_event that maps to domain = Condition, lab_procedure_id is blank
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('30', '29', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('31', '84', '-1', '16', '30', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 09:23:00', '2000-08-29 11:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_clinical_event (encounter_id, event_code_id, event_class_id, event_end_dt_tm, event_end_dt_id, event_reltn_id, event_start_dt_tm, event_start_dt_id, event_expiration_dt_id, event_normalcy_id, event_normalcy_method_id, performed_dt_id, performed_prsnl_id, result_normalcy_flg, result_time_unit_id, result_units_id, result_value_dt_id, result_feasible_ind, result_inaccurate_ind, event_source_id, verified_dt_id, verified_prsnl_id) VALUES ('31', '308', '15', '2000-08-29 10:23:00', '7285', '4', '2000-08-29 10:23:00', '4019', '4019', '-1', '-1', '4019', '-9', '0', '250', '250', '4019', '0', '0', '-1', '4019', '-9');
  -- 11: Patient has HCPCS code in hf_f_procedure that maps to domain = Condition midnight
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('33', '32', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('34', '84', '-1', '16', '33', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_procedure (encounter_id, procedure_id, procedure_dt_id, procedure_dt_tm, procedure_priority, third_party_ind) VALUES ('34', '18890', '4019', '2000-08-29 00:00:00', '1', '0');
  -- 12: Patient has HCPCS code in hf_f_procedure that maps to domain = Condition time outside encounter
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('36', '35', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_procedure (procedure_id, procedure_type, procedure_code, procedure_description) VALUES ('18890', 'HCPCS', 'G8019', 'DIABETIC PATIENT WITH MOST RECENT LOW-DENSITY LIPOPROTEIN (WITHIN THE LAST 12 MONTHS) DOCUMENTED AS GREATER THAN OR EQUAL TO 100 MG/DL');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('37', '84', '-1', '16', '36', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_procedure (encounter_id, procedure_id, procedure_dt_id, procedure_dt_tm, procedure_priority, third_party_ind) VALUES ('37', '18890', '4019', '2000-08-29 15:28:30', '1', '0');
  -- 13: Patient has HCPCS code in hf_f_procedure that maps to domain = Condition time inside encounter
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('39', '38', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('40', '84', '-1', '16', '39', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:20:00', '2000-08-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_procedure (encounter_id, procedure_id, procedure_dt_id, procedure_dt_tm, procedure_priority, third_party_ind) VALUES ('40', '18890', '4019', '2000-08-29 10:21:00', '1', '0');
  -- 14: Patient has drug in hf_f_medication
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('42', '41', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_medication (medication_id, ndc_code, brand_name, generic_name, product_strength_description, route_description, dose_form_description) VALUES ('118619', '52604520002', 'Levoxyl', 'levothyroxine', '0.2 mg', 'oral', 'tablet');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('43', '84', '-1', '16', '42', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2011-03-29 10:23:00', '2011-03-29 12:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_medication (encounter_id, medication_id, med_dispensed_caresetting_id, med_request_caresetting_id, discontinue_reason_id, route_administration_id, formulary_type_id, frequency_id, order_stop_type_id, order_type_id, med_order_status_id, med_started_dt_id, med_entered_dt_id, med_stopped_dt_id, med_discontinued_dt_id, total_dispensed_doses, dose_quantity, initial_dose_quantity, dose_units_id, charge_quantity, credit_quantity, infusion_rate, infusion_time, infusion_time_units_id, order_strength, order_strength_units_id, order_volume, order_volume_units_id, med_started_dt_tm, med_stopped_dt_tm, med_started_tm_valid_flg, med_entered_tm_valid_flg, med_stopped_tm_valid_flg, med_discontinued_tm_valid_flg) VALUES ('43', '118619', '174', '174', '1', '56', '1', '110', '2', '4', '4', '7187', '7187', '4019', '4019', '0.0', '1.0', '0.0', '39', '0.0', '0.0', '0.0', '250', '250', '174', '174', '1.0', '162', '2011-03-29 11:09:00', '2011-03-29 11:09:00', '1', '1', '1', '1');
  -- 15: Patient has drug code in hf_f_procedure
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('45', '44', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_procedure (procedure_id, procedure_type, procedure_code, procedure_description) VALUES ('20522', 'HCPCS', 'J7640', 'FORMOTEROL, INHALATION SOLUTION, COMPOUNDED PRODUCT, ADMINISTERED THROUGH DME, UNIT DOSE FORM, 12 MICROGRAMS');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('46', '84', '-1', '16', '45', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2012-05-07 08:23:00', '2012-05-07 20:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_procedure (encounter_id, procedure_id, procedure_dt_id, procedure_dt_tm, procedure_priority, third_party_ind) VALUES ('46', '20522', '4019', '2012-05-07 10:58:00', '1', '0');
  -- 16: Hospital has census_division code 1
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('47', 'South', '1', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 17: Hospital has census_division code 2
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('48', 'South', '2', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 18: Hospital has census_division code 3
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('49', 'South', '3', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 19: Hospital has census_division code 4
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('50', 'South', '4', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 20: Hospital has census_division code 5
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('51', 'South', '5', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 21: Hospital has census_division code 6
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('52', 'South', '6', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 22: Hospital has census_division code 7
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('53', 'South', '7', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 23: Hospital has census_division code 8
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('54', 'South', '8', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 24: Hospital has census_division code 9
  INSERT INTO native.Cdm_testing_cerner.hf_d_hospital (hospital_id, census_region, census_division, bed_size_range, teaching_facility_ind, cath_lab_full_ind, cath_lab_diagnostic_ind, urban_rural_status, acute_status, alt_health_system_id) VALUES ('55', 'South', '9', '<5', '0', '0', '0', 'Urban', 'Acute', '79');
  -- 25: Patient has measurement in lab procedure table
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('57', '56', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_lab_procedure (lab_procedure_id, lab_procedure_mnemonic, lab_procedure_name, lab_procedure_group, lab_super_group, loinc_code) VALUES ('1149', 'Lipid Panel', 'Lipid Panel', 'Lipids Test', 'General Test', '57698-3');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('58', '84', '-1', '16', '57', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2012-05-07 10:23:00', '2012-05-07 10:50:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_lab_procedure (encounter_id, detail_lab_procedure_id, order_lab_procedure_id, lab_order_caresetting_id, reporting_priority_id, lab_result_type_id, result_indicator_id, lab_ordered_dt_id, lab_drawn_dt_id, lab_received_dt_id, lab_completed_dt_id, lab_cancelled_dt_id, lab_verified_dt_id, date_result_id, result_units_id, lab_drawn_dt_tm, lab_ordered_tm_vld_flg, lab_drawn_tm_vld_flg, lab_received_tm_vld_flg, lab_completed_tm_vld_flg, lab_cancelled_tm_vld_flg, lab_verified_tm_vld_flg, lab_performed_tm_vld_flg, lab_performed_caresetting_id, collection_source_id) VALUES ('58', '39', '1149', '16', '1', '7', '8', '4019', '4019', '4019', '4019', '4019', '4019', '4019.000000', '250.0', '2012-05-07 10:40:00', '1', '1', '1', '1', '0', '1', '1', '174', '522');
  -- 26: Patient has two encounters 0 days apart, one observation_period created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('60', '59', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('61', '84', '-1', '16', '60', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('62', '84', '-1', '16', '60', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-20 10:23:00', '2010-01-22 10:23:00', '1', '1');
  -- 27: Patient has two encounters 3 days apart, two observation_periods created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('64', '63', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('65', '84', '-1', '16', '64', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('66', '84', '-1', '16', '64', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-23 10:23:00', '2010-01-25 10:23:00', '1', '1');
  -- 28: Patient has one encounter across the end of a year, one observation_period created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('68', '67', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('69', '84', '-1', '16', '68', '90', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2015-12-14 19:58:00', '2016-01-07 18:30:00', '1', '1');
  -- 29: Patient has 3 encounters 3 across 3 months, 3 observation_periods created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('71', '70', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('72', '84', '-1', '16', '71', '90', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-05-05 20:41:00', '2010-05-16 09:05:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('73', '84', '-1', '16', '71', '90', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-07-02 15:57:00', '2010-07-16 11:40:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('74', '84', '-1', '16', '71', '90', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-06-03 15:14:00', '2010-07-01 10:15:00', '1', '1');
  -- 30: Patient has one encounter 0 days apart, one observation_period created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('76', '75', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('77', '84', '-1', '16', '76', '90', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-02-02 06:26:00', '2000-02-02 06:26:00', '1', '1');
  -- 31: Patient has one encounter 1 day apart, one observation_period created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('79', '78', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('80', '84', '-1', '16', '79', '90', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2002-03-22 13:16:00', '2002-03-22 13:16:00', '1', '1');
  -- 32: Patient has two encounters 3 months apart, two observation_periods created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('82', '81', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('83', '84', '-1', '16', '82', '86', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2006-09-08 18:10:00', '2006-09-10 11:00:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('84', '84', '-1', '16', '82', '86', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2006-06-02 19:10:00', '2006-06-06 19:00:00', '1', '1');
  -- 33: Patient has observation code in hf_f_clinical_event
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('86', '85', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('87', '84', '-1', '16', '86', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-29 11:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_clinical_event (encounter_id, lab_procedure_id, event_code_id, event_class_id, event_end_dt_tm, event_end_dt_id, event_reltn_id, event_start_dt_tm, event_start_dt_id, event_expiration_dt_id, event_normalcy_id, event_normalcy_method_id, performed_dt_id, performed_prsnl_id, result_normalcy_flg, result_time_unit_id, result_units_id, result_value_dt_id, result_feasible_ind, result_inaccurate_ind, event_source_id, verified_dt_id, verified_prsnl_id) VALUES ('87', '23', '274', '15', '2000-08-29 10:59:00', '7285', '4', '2000-08-29 10:50:00', '4019', '4019', '-1', '-1', '4019', '-9', '0', '250', '250', '4019', '0', '0', '-1', '4019', '-9');
  -- 34: Patient has code in hf_f_clinical_event that maps to domain = Observation
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('89', '88', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('90', '84', '-1', '16', '89', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 09:23:00', '2000-08-29 11:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_clinical_event (encounter_id, lab_procedure_id, event_code_id, event_class_id, event_end_dt_tm, event_end_dt_id, event_reltn_id, event_start_dt_tm, event_start_dt_id, event_expiration_dt_id, event_normalcy_id, event_normalcy_method_id, performed_dt_id, performed_prsnl_id, result_normalcy_flg, result_time_unit_id, result_units_id, result_value_dt_id, result_feasible_ind, result_inaccurate_ind, event_source_id, verified_dt_id, verified_prsnl_id) VALUES ('90', '23', '159', '15', '2000-08-29 10:23:00', '7285', '4', '2000-08-29 10:23:00', '4019', '4019', '-1', '-1', '4019', '-9', '0', '250', '250', '4019', '0', '0', '-1', '4019', '-9');
  -- 35: Patient has observation code in hf_f_diagnosis
  INSERT INTO native.Cdm_testing_cerner.hf_d_diagnosis (diagnosis_id, diagnosis_type, diagnosis_code, diagnosis_description) VALUES ('15110', 'ICD10-CM', 'V41.2', 'Problems with Hearing');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('92', '91', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('93', '84', '-1', '16', '92', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_diagnosis (encounter_id, diagnosis_id, diagnosis_priority, diagnosis_type_id, present_on_admit_id, third_party_ind) VALUES ('93', '15110', '1', '83', '6', '0');
  -- 36: Patient has gender = Male
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('95', '94', 'Caucasian', 'Male', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('96', '84', '-1', '16', '95', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 37: Patient has gender = Female
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('98', '97', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('99', '84', '-1', '16', '98', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 38: Patient has an unknown gender on their most recent record
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('101', '100', 'Caucasian', 'Male', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('102', '100', 'Caucasian', 'Unknown', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('103', '84', '-1', '16', '101', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('104', '84', '-1', '16', '102', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-22 10:23:00', '2010-01-22 10:23:00', '1', '1');
  -- 39: Patient has race value Caucasian
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('106', '105', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('107', '84', '-1', '16', '106', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 40: Patient has race value African American
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('109', '108', 'African American', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('110', '84', '-1', '16', '109', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 41: Patient has race value Hispanic
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('112', '111', 'Hispanic', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('113', '84', '-1', '16', '112', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 42: Patient has race value Asian
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('115', '114', 'Asian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('116', '84', '-1', '16', '115', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 43: Patient has race value Native American
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('118', '117', 'Native American', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('119', '84', '-1', '16', '118', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 44: Patient has race value Biracial
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('121', '120', 'Biracial', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('122', '84', '-1', '16', '121', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 45: Patient has race value Pacific Islander
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('124', '123', 'Pacific Islander', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('125', '84', '-1', '16', '124', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 46: Patient has race value Asian/Pacific Islander
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('127', '126', 'Asian/Pacific Islander', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('128', '84', '-1', '16', '127', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 47: Patient has race value Mid Eastern Indian
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('130', '129', 'Mid Eastern Indian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('131', '84', '-1', '16', '130', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 48: Patient has race value Other
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('133', '132', 'Other', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('134', '84', '-1', '16', '133', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 49: Patient has ethnicity value Caucasian
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('136', '135', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('137', '84', '-1', '16', '136', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 50: Patient has ethnicity value African American
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('139', '138', 'African American', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('140', '84', '-1', '16', '139', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 51: Patient has ethnicity value Hispanic
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('142', '141', 'Hispanic', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('143', '84', '-1', '16', '142', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 52: Patient has ethnicity value Asian
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('145', '144', 'Asian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('146', '84', '-1', '16', '145', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 53: Patient has ethnicity value Native American
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('148', '147', 'Native American', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('149', '84', '-1', '16', '148', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 54: Patient has ethnicity value Biracial
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('151', '150', 'Biracial', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('152', '84', '-1', '16', '151', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 55: Patient has ethnicity value Pacific Islander
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('154', '153', 'Pacific Islander', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('155', '84', '-1', '16', '154', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 56: Patient has ethnicity value Asian/Pacific Islander
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('157', '156', 'Asian/Pacific Islander', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('158', '84', '-1', '16', '157', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 57: Patient has ethnicity value Mid Eastern Indian
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('160', '159', 'Mid Eastern Indian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('161', '84', '-1', '16', '160', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 58: Patient has ethnicity value Other
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('163', '162', 'Other', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('164', '84', '-1', '16', '163', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  -- 59: Patient has ICD10PCS code in hf_f_procedure and procedure priority = 1
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('166', '165', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_procedure (procedure_id, procedure_type, procedure_code, procedure_description) VALUES ('108701', 'ICD10-PCS', '04QW3ZZ', 'Repair Left Foot Artery, Percutaneous Approach');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('167', '84', '-1', '16', '166', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2012-05-07 10:23:00', '2012-05-07 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_procedure (encounter_id, procedure_id, procedure_dt_id, procedure_dt_tm, procedure_priority, third_party_ind) VALUES ('167', '108701', '4019', '2012-05-07 10:58:00', '1', '0');
  -- 60: Patient has CPT4 code in hf_f_procedure and procedure priority = 3
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('169', '168', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_procedure (procedure_id, procedure_type, procedure_code, procedure_description) VALUES ('9160', 'CPT4', '37200', 'Transcatheter biopsy');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('170', '84', '-1', '16', '169', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2012-05-12 10:23:00', '2012-05-12 20:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_procedure (encounter_id, procedure_id, procedure_dt_id, procedure_dt_tm, procedure_priority, third_party_ind) VALUES ('170', '9160', '4019', '2012-05-12 10:30:00', '3', '0');
  -- 61: Patient has procedure code in hf_f_clinical_event
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('172', '171', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('173', '84', '-1', '16', '172', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:00:00', '2000-08-29 10:50:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_clinical_event (encounter_id, lab_procedure_id, event_code_id, event_class_id, event_end_dt_tm, event_end_dt_id, event_reltn_id, event_start_dt_tm, event_start_dt_id, event_expiration_dt_id, event_normalcy_id, event_normalcy_method_id, performed_dt_id, performed_prsnl_id, result_normalcy_flg, result_time_unit_id, result_units_id, result_value_dt_id, result_feasible_ind, result_inaccurate_ind, event_source_id, verified_dt_id, verified_prsnl_id) VALUES ('173', '23', '742', '15', '2010-02-19 14:44:00.000000', '7285', '4', '2000-08-29 10:23:00', '4019', '4019', '-1', '-1', '4019', '-9', '0', '250', '250', '4019', '0', '0', '-1', '4019', '-9');
  -- 62: Patient has procedure code in hf_f_diagnosis
  INSERT INTO native.Cdm_testing_cerner.hf_d_diagnosis (diagnosis_id, diagnosis_type, diagnosis_code, diagnosis_description) VALUES ('15110', 'ICD9-CM', 'V73.4', 'Yellow Fever Screening');
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('175', '174', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('176', '84', '-1', '16', '175', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2000-08-29 10:23:00', '2000-08-29 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_diagnosis (encounter_id, diagnosis_id, diagnosis_priority, diagnosis_type_id, present_on_admit_id, third_party_ind) VALUES ('176', '15110', '1', '83', '6', '0');
  -- 63: Provider has medical specialty Internal Medicine
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('177', 'Internal Medicine');
  -- 64: Provider has medical specialty Not a Medical Speciality
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('178', 'Not a Medical Speciality');
  -- 65: Provider has medical specialty Family/General Practice
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('179', 'Family/General Practice');
  -- 66: Provider has medical specialty Other
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('180', 'Other');
  -- 67: Provider has medical specialty Undefined / Unknown
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('181', 'Undefined / Unknown');
  -- 68: Provider has medical specialty Pediatrics
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('182', 'Pediatrics');
  -- 69: Provider has medical specialty Emergency/Trauma
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('183', 'Emergency/Trauma');
  -- 70: Provider has medical specialty Radiology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('184', 'Radiology');
  -- 71: Provider has medical specialty Obstetrics and Gynecology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('185', 'Obstetrics and Gynecology');
  -- 72: Provider has medical specialty Anesthesiology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('186', 'Anesthesiology');
  -- 73: Provider has medical specialty Surgery, General
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('187', 'Surgery, General');
  -- 74: Provider has medical specialty DCPTEAM
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('188', 'DCPTEAM');
  -- 75: Provider has medical specialty Orthopedics
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('189', 'Orthopedics');
  -- 76: Provider has medical specialty Cardiology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('190', 'Cardiology');
  -- 77: Provider has medical specialty Radiologist
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('191', 'Radiologist');
  -- 78: Provider has medical specialty Psychiatry
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('192', 'Psychiatry');
  -- 79: Provider has medical specialty Gastroenterology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('193', 'Gastroenterology');
  -- 80: Provider has medical specialty Ophthalmology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('194', 'Ophthalmology');
  -- 81: Provider has medical specialty Neurology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('195', 'Neurology');
  -- 82: Provider has medical specialty Dentistry
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('196', 'Dentistry');
  -- 83: Provider has medical specialty Urology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('197', 'Urology');
  -- 84: Provider has medical specialty Family Practice
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('198', 'Family Practice');
  -- 85: Provider has medical specialty Gynecology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('199', 'Gynecology');
  -- 86: Provider has medical specialty Otolaryngology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('200', 'Otolaryngology');
  -- 87: Provider has medical specialty Obstetrics
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('201', 'Obstetrics');
  -- 88: Provider has medical specialty Hematology/Oncology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('202', 'Hematology/Oncology');
  -- 89: Provider has medical specialty Pulmonology
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('203', 'Pulmonology');
  -- 90: Provider has medical specialty Student
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('204', 'Student');
  -- 91: Provider has medical specialty Podiatry
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('205', 'Podiatry');
  -- 92: Provider has medical specialty Surgeon
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('206', 'Surgeon');
  -- 93: Provider has medical specialty Orthopedics, Reconstructive
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('207', 'Orthopedics, Reconstructive');
  -- 94: Provider has medical specialty Surgery, Plastic
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('208', 'Surgery, Plastic');
  -- 95: Provider has medical specialty Hospitalist
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('209', 'Hospitalist');
  -- 96: Provider has medical specialty Health Care Provider
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('210', 'Health Care Provider');
  -- 97: Provider has medical specialty Surgery, Neuro
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('211', 'Surgery, Neuro');
  -- 98: Provider has medical Physical Medicine and Rehabilitation
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('212', 'Physical Medicine and Rehabilitation');
  -- 99: Patient has two IP encounters 0 days apart, one visit created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('214', '213', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('215', '84', '-1', '16', '214', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('216', '84', '-1', '16', '214', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-20 10:23:00', '2010-01-22 10:23:00', '1', '1');
  -- 100: Patient has two IP encounters >0 days apart, two visits created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('218', '217', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('219', '84', '-1', '16', '218', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('220', '84', '-1', '16', '218', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-25 10:23:00', '2010-01-27 10:23:00', '1', '1');
  -- 101: Patient has two IP encounters 0 days apart, one visit created with the earlier physician id
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('222', '221', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('225', 'NULL');
  INSERT INTO native.Cdm_testing_cerner.hf_d_physician (physician_id, medical_specialty) VALUES ('226', 'NULL');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('223', '84', '225', '16', '222', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-16 10:23:00', '2010-01-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('224', '84', '226', '16', '222', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-01-20 10:23:00', '2010-01-22 10:23:00', '1', '1');
  -- 102: Patient has one IP encounter with an OP visit in the middle, one IP visit created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('228', '227', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('229', '84', '-1', '16', '228', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-02-16 10:23:00', '2010-02-20 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('230', '84', '-1', '16', '228', '98', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-02-18 10:23:00', '2010-02-18 10:23:00', '1', '1');
  -- 103: Patient has one IP encounter with an ER visit at the beginning, one IP visit and one ER visit created
  INSERT INTO native.Cdm_testing_cerner.hf_d_patient (patient_id, patient_sk, race, gender, marital_status) VALUES ('232', '231', 'Caucasian', 'Female', 'Single');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('233', '84', '-1', '16', '232', '87', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-03-02 10:23:00', '2010-03-05 10:23:00', '1', '1');
  INSERT INTO native.Cdm_testing_cerner.hf_f_encounter (encounter_id, hospital_id, admitting_physician_id, discharge_caresetting_id, patient_id, patient_type_id, admitted_dt_id, discharged_dt_id, discharge_disposition_id, diagnostic_grouping_id, admission_source_id, admission_type_id, payer_id, total_charges, billing_ind, weight, weight_unit_id, admitted_dt_tm, discharged_dt_tm, admitted_tm_valid_ind, discharged_tm_valid_ind) VALUES ('234', '84', '-1', '16', '232', '84', '4019', '4019', '1', '1', '1', '6', '22', '0.000000', '1', '250', '250', '2010-03-02 10:23:00', '2010-03-02 10:23:00', '1', '1');