File was completely bounced this morning

[Jay Goldstein]

The portal would not accept our file at all this morning.  Anyone have any ideas of what type of things I should look at  - maybe it is something obvious

 

--Jay

Maimonides Med Center

[Gregory Briddick]

What was the error that you received? 

[Jay Goldstein]

• You have a column (admission_dt;"arrival_dt";"date_of_birth";"discharge_dt";"discharge_status";"ethnicity";"facility_identifier";"gender";"icd_10_cm_code_1";"icd_10_cm_code_2";"icd_10_cm_code_3";"icd_10_cm_code_4";"icd_10_cm_code_5";"icd_10_cm_code_6";"icd_10_cm_code_7";"icd_10_cm_code_8";"icd_10_cm_code_9";"icd_10_cm_code_10";"icd_10_cm_code_11";"icd_10_cm_code_12";"icd_10_cm_code_13";"icd_10_cm_code_14";"icd_10_cm_code_15";"icd_10_cm_code_16";"icd_10_cm_code_17";"icd_10_cm_code_18";"icd_10_cm_code_19";"icd_10_cm_code_20";"icd_10_cm_code_21";"icd_10_cm_code_22";"icd_10_cm_code_23";"icd_10_cm_code_24";"icd_10_cm_code_25";"icd_10_cm_poa_indicator_1";"icd_10_cm_poa_indicator_2";"icd_10_cm_poa_indicator_3";"icd_10_cm_poa_indicator_4";"icd_10_cm_poa_indicator_5";"icd_10_cm_poa_indicator_6";"icd_10_cm_poa_indicator_7";"icd_10_cm_poa_indicator_8";"icd_10_cm_poa_indicator_9";"icd_10_cm_poa_indicator_10";"icd_10_cm_poa_indicator_11";"icd_10_cm_poa_indicator_12";"icd_10_cm_poa_indicator_13";"icd_10_cm_poa_indicator_14";"icd_10_cm_poa_indicator_15";"icd_10_cm_poa_indicator_16";"icd_10_cm_poa_indicator_17";"icd_10_cm_poa_indicator_18";"icd_10_cm_poa_indicator_19";"icd_10_cm_poa_indicator_20";"icd_10_cm_poa_indicator_21";"icd_10_cm_poa_indicator_22";"icd_10_cm_poa_indicator_23";"icd_10_cm_poa_indicator_24";"icd_10_cm_poa_indicator_25";"insurance_number";"medical_record_number";"other_payer";"patient_control_number";"patient_zip_code_of_residence";"payer";"race";"source_of_admission";"transferred_in";"transferred_out";"transfer_facility_id_receiving";"transfer_facility_id_sending";"transfer_facility_nm_receiving";"transfer_facility_nm_sending";"unique_personal_identifier";"acute_cardiovascular_conditions";"aids_hiv_disease";"altered_mental_status";"asthma";"chronic_liver_disease";"chronic_renal_failure";"chronic_respiratory_failure";"coagulopathy";"congestive_heart_failure";"copd";"dementia";"diabetes";"dialysis_comorbidity";"history_of_covid";"history_of_covid_dt";"history_of_other_cvd";"hypertension";"immunocompromising";"lymphoma_leukemia_multi_myeloma";"mechanical_vent_comorbidity";"medication_anticoagulation";"medication_immune_modifying";"metastatic_cancer";"obesity";"patient_care_considerations";"patient_care_considerations_date";"pregnancy_comorbidity";"pregnancy_status";"smoking_vaping";"tracheostomy_on_arrival";"covid_exposure";"covid_virus";"drug_resistant_pathogen";"flu_positive";"suspected_source_of_infection";"dialysis_treatment";"during_hospital_anticoagulation";"during_hospital_immune_mod_med";"during_hospital_remdesivir";"ecmo";"high_flow_nasal_cannula";"mechanical_vent_treatment";"non_invasive_pos_pressure_vent";"vasopressor_administration";"cv_outcomes_at_discharge";"dialysis_outcome";"mechanical_vent_outcome";"tracheostomy_at_discharge";"cv_outcomes_in_hospital";"icu_during_hospitalization";"pe_dvt";"tracheostomy_in_hospital";"aptt_1";"aptt_2";"aptt_3";"aptt_max";"aptt_dt_1";"aptt_dt_2";"aptt_dt_3";"aptt_dt_max";"bilirubin_arrival";"bilirubin_max";"bilirubin_arrival_dt";"bilirubin_max_dt";"creatinine_arrival";"creatinine_max";"creatinine_arrival_dt";"creatinine_max_dt";"diastolic_1";"diastolic_2";"diastolic_3";"diastolic_min";"diastolic_dt_1";"diastolic_dt_2";"diastolic_dt_3";"diastolic_dt_min";"inr_1";"inr_2";"inr_3";"inr_max";"inr_dt_1";"inr_dt_2";"inr_dt_3";"inr_dt_max";"lactate_level_1";"lactate_level_2";"lactate_level_3";"lactate_level_max";"lactate_level_dt_1";"lactate_level_dt_2";"lactate_level_dt_3";"lactate_level_dt_max";"organ_dysfunc_cardiovascular";"organ_dysfunc_cns";"organ_dysfunc_hematologic";"organ_dysfunc_hepatic";"organ_dysfunc_renal";"organ_dysfunc_respiratory";"platelets_1";"platelets_2";"platelets_3";"platelets_min";"platelets_dt_1";"platelets_dt_2";"platelets_dt_3";"platelets_dt_min";"sirs_heartrate_1";"sirs_heartrate_2";"sirs_heartrate_3";"sirs_heartrate_max";"sirs_heartrate_dt_1";"sirs_heartrate_dt_2";"sirs_heartrate_dt_3";"sirs_heartrate_dt_max";"sirs_leukocyte_arrival";"sirs_leukocyte_min";"sirs_leukocyte_max";"sirs_leukocyte_arrival_dt";"sirs_leukocyte_min_dt";"sirs_leukocyte_max_dt";"sirs_respiratoryrate_1";"sirs_respiratoryrate_2";"sirs_respiratoryrate_3";"sirs_respiratoryrate_max";"sirs_respiratoryrate_dt_1";"sirs_respiratoryrate_dt_2";"sirs_respiratoryrate_dt_3";"sirs_respiratoryrate_dt_max";"sirs_temperature_1";"sirs_temperature_2";"sirs_temperature_3";"sirs_temperature_max";"sirs_temperature_dt_1";"sirs_temperature_dt_2";"sirs_temperature_dt_3";"sirs_temperature_dt_max";"systolic_1";"systolic_2";"systolic_3";"systolic_min";"systolic_dt_1";"systolic_dt_2";"systolic_dt_3";"systolic_dt_min",) which does not exist in the selected data dictionary.
• Question 'admission_dt' doesn't exist.
• Question 'arrival_dt' doesn't exist.
• Question 'date_of_birth' doesn't exist.
• Question 'discharge_dt' doesn't exist.
• Question 'discharge_status' doesn't exist.
• Question 'ethnicity' doesn't exist.
• Question 'facility_identifier' doesn't exist.
• Question 'gender' doesn't exist.
• Question 'icd_10_cm_code_1' doesn't exist.
• Question 'icd_10_cm_code_2' doesn't exist.
• Question 'icd_10_cm_code_3' doesn't exist.
• Question 'icd_10_cm_code_4' doesn't exist.
• Question 'icd_10_cm_code_5' doesn't exist.
• Question 'icd_10_cm_code_6' doesn't exist.
• Question 'icd_10_cm_code_7' doesn't exist.
• Question 'icd_10_cm_code_8' doesn't exist.
• Question 'icd_10_cm_code_9' doesn't exist.
• Question 'icd_10_cm_code_10' doesn't exist.
• Question 'icd_10_cm_code_11' doesn't exist.
• Question 'icd_10_cm_code_12' doesn't exist.
• Question 'icd_10_cm_code_13' doesn't exist.
• Question 'icd_10_cm_code_14' doesn't exist.
• Question 'icd_10_cm_code_15' doesn't exist.
• Question 'icd_10_cm_code_16' doesn't exist.
• Question 'icd_10_cm_code_17' doesn't exist.
• Question 'icd_10_cm_code_18' doesn't exist.
• Question 'icd_10_cm_code_19' doesn't exist.
• Question 'icd_10_cm_code_20' doesn't exist.
• Question 'icd_10_cm_code_21' doesn't exist.
• Question 'icd_10_cm_code_22' doesn't exist.
• Question 'icd_10_cm_code_23' doesn't exist.
• Question 'icd_10_cm_code_24' doesn't exist.
• Question 'icd_10_cm_code_25' doesn't exist.
• Question 'icd_10_cm_poa_indicator_1' doesn't exist.
• Question 'icd_10_cm_poa_indicator_2' doesn't exist.
• Question 'icd_10_cm_poa_indicator_3' doesn't exist.
• Question 'icd_10_cm_poa_indicator_4' doesn't exist.
• Question 'icd_10_cm_poa_indicator_5' doesn't exist.
• Question 'icd_10_cm_poa_indicator_6' doesn't exist.
• Question 'icd_10_cm_poa_indicator_7' doesn't exist.
• Question 'icd_10_cm_poa_indicator_8' doesn't exist.
• Question 'icd_10_cm_poa_indicator_9' doesn't exist.
• Question 'icd_10_cm_poa_indicator_10' doesn't exist.
• Question 'icd_10_cm_poa_indicator_11' doesn't exist.
• Question 'icd_10_cm_poa_indicator_12' doesn't exist.
• Question 'icd_10_cm_poa_indicator_13' doesn't exist.
• Question 'icd_10_cm_poa_indicator_14' doesn't exist.
• Question 'icd_10_cm_poa_indicator_15' doesn't exist.
• Question 'icd_10_cm_poa_indicator_16' doesn't exist.
• Question 'icd_10_cm_poa_indicator_17' doesn't exist.
• Question 'icd_10_cm_poa_indicator_18' doesn't exist.
• Question 'icd_10_cm_poa_indicator_19' doesn't exist.
• Question 'icd_10_cm_poa_indicator_20' doesn't exist.
• Question 'icd_10_cm_poa_indicator_21' doesn't exist.
• Question 'icd_10_cm_poa_indicator_22' doesn't exist.
• Question 'icd_10_cm_poa_indicator_23' doesn't exist.
• Question 'icd_10_cm_poa_indicator_24' doesn't exist.
• Question 'icd_10_cm_poa_indicator_25' doesn't exist.
• Question 'insurance_number' doesn't exist.
• Question 'medical_record_number' doesn't exist.
• Question 'other_payer' doesn't exist.
• Question 'patient_control_number' doesn't exist.
• Question 'patient_zip_code_of_residence' doesn't exist.
• Question 'payer' doesn't exist.
• Question 'race' doesn't exist.
• Question 'source_of_admission' doesn't exist.
• Question 'transferred_in' doesn't exist.
• Question 'transferred_out' doesn't exist.
• Question 'transfer_facility_nm_receiving' doesn't exist.
• Question 'transfer_facility_nm_sending' doesn't exist.
• Question 'unique_personal_identifier' doesn't exist.
• Question 'acute_cardiovascular_conditions' doesn't exist.
• Question 'aids_hiv_disease' doesn't exist.
• Question 'altered_mental_status' doesn't exist.
• Question 'asthma' doesn't exist.
• Question 'chronic_liver_disease' doesn't exist.
• Question 'chronic_renal_failure' doesn't exist.
• Question 'chronic_respiratory_failure' doesn't exist.
• Question 'coagulopathy' doesn't exist.
• Question 'congestive_heart_failure' doesn't exist.
• Question 'copd' doesn't exist.
• Question 'dementia' doesn't exist.
• Question 'diabetes' doesn't exist.
• Question 'dialysis_comorbidity' doesn't exist.
• Question 'history_of_covid' doesn't exist.
• Question 'history_of_covid_dt' doesn't exist.
• Question 'history_of_other_cvd' doesn't exist.
• Question 'hypertension' doesn't exist.
• Question 'immunocompromising' doesn't exist.
• Question 'lymphoma_leukemia_multi_myeloma' doesn't exist.
• Question 'mechanical_vent_comorbidity' doesn't exist.
• Question 'medication_anticoagulation' doesn't exist.
• Question 'medication_immune_modifying' doesn't exist.
• Question 'metastatic_cancer' doesn't exist.
• Question 'obesity' doesn't exist.
• Question 'patient_care_considerations' doesn't exist.
• Question 'patient_care_considerations_date' doesn't exist.
• Question 'pregnancy_comorbidity' doesn't exist.
• Question 'pregnancy_status' doesn't exist.
• Question 'smoking_vaping' doesn't exist.
• Question 'tracheostomy_on_arrival' doesn't exist.
• Question 'covid_exposure' doesn't exist.
• Question 'covid_virus' doesn't exist.
• Question 'drug_resistant_pathogen' doesn't exist.
• Question 'flu_positive' doesn't exist.
• Question 'suspected_source_of_infection' doesn't exist.
• Question 'dialysis_treatment' doesn't exist.
• Question 'during_hospital_anticoagulation' doesn't exist.
• Question 'during_hospital_immune_mod_med' doesn't exist.
• Question 'during_hospital_remdesivir' doesn't exist.
• Question 'ecmo' doesn't exist.
• Question 'high_flow_nasal_cannula' doesn't exist.
• Question 'mechanical_vent_treatment' doesn't exist.
• Question 'non_invasive_pos_pressure_vent' doesn't exist.
• Question 'vasopressor_administration' doesn't exist.
• Question 'cv_outcomes_at_discharge' doesn't exist.
• Question 'dialysis_outcome' doesn't exist.
• Question 'mechanical_vent_outcome' doesn't exist.
• Question 'tracheostomy_at_discharge' doesn't exist.
• Question 'cv_outcomes_in_hospital' doesn't exist.
• Question 'icu_during_hospitalization' doesn't exist.
• Question 'pe_dvt' doesn't exist.
• Question 'tracheostomy_in_hospital' doesn't exist.
• Question 'aptt_1' doesn't exist.
• Question 'aptt_2' doesn't exist.
• Question 'aptt_3' doesn't exist.
• Question 'aptt_max' doesn't exist.
• Question 'aptt_dt_1' doesn't exist.
• Question 'aptt_dt_2' doesn't exist.
• Question 'aptt_dt_3' doesn't exist.
• Question 'aptt_dt_max' doesn't exist.
• Question 'bilirubin_arrival' doesn't exist.
• Question 'bilirubin_max' doesn't exist.
• Question 'bilirubin_arrival_dt' doesn't exist.
• Question 'bilirubin_max_dt' doesn't exist.
• Question 'creatinine_arrival' doesn't exist.
• Question 'creatinine_max' doesn't exist.
• Question 'creatinine_arrival_dt' doesn't exist.
• Question 'creatinine_max_dt' doesn't exist.
• Question 'diastolic_1' doesn't exist.
• Question 'diastolic_2' doesn't exist.
• Question 'diastolic_3' doesn't exist.
• Question 'diastolic_min' doesn't exist.
• Question 'diastolic_dt_1' doesn't exist.
• Question 'diastolic_dt_2' doesn't exist.
• Question 'diastolic_dt_3' doesn't exist.
• Question 'diastolic_dt_min' doesn't exist.
• Question 'inr_1' doesn't exist.
• Question 'inr_2' doesn't exist.
• Question 'inr_3' doesn't exist.
• Question 'inr_max' doesn't exist.
• Question 'inr_dt_1' doesn't exist.
• Question 'inr_dt_2' doesn't exist.
• Question 'inr_dt_3' doesn't exist.
• Question 'inr_dt_max' doesn't exist.
• Question 'lactate_level_1' doesn't exist.
• Question 'lactate_level_2' doesn't exist.
• Question 'lactate_level_3' doesn't exist.
• Question 'lactate_level_max' doesn't exist.
• Question 'lactate_level_dt_1' doesn't exist.
• Question 'lactate_level_dt_2' doesn't exist.
• Question 'lactate_level_dt_3' doesn't exist.
• Question 'lactate_level_dt_max' doesn't exist.
• Question 'organ_dysfunc_cardiovascular' doesn't exist.
• Question 'organ_dysfunc_cns' doesn't exist.
• Question 'organ_dysfunc_hematologic' doesn't exist.
• Question 'organ_dysfunc_hepatic' doesn't exist.
• Question 'organ_dysfunc_renal' doesn't exist.
• Question 'organ_dysfunc_respiratory' doesn't exist.
• Question 'platelets_1' doesn't exist.
• Question 'platelets_2' doesn't exist.
• Question 'platelets_3' doesn't exist.
• Question 'platelets_min' doesn't exist.
• Question 'platelets_dt_1' doesn't exist.
• Question 'platelets_dt_2' doesn't exist.
• Question 'platelets_dt_3' doesn't exist.
• Question 'platelets_dt_min' doesn't exist.
• Question 'sirs_heartrate_1' doesn't exist.
• Question 'sirs_heartrate_2' doesn't exist.
• Question 'sirs_heartrate_3' doesn't exist.
• Question 'sirs_heartrate_max' doesn't exist.
• Question 'sirs_heartrate_dt_1' doesn't exist.
• Question 'sirs_heartrate_dt_2' doesn't exist.
• Question 'sirs_heartrate_dt_3' doesn't exist.
• Question 'sirs_heartrate_dt_max' doesn't exist.
• Question 'sirs_leukocyte_arrival' doesn't exist.
• Question 'sirs_leukocyte_min' doesn't exist.
• Question 'sirs_leukocyte_max' doesn't exist.
• Question 'sirs_leukocyte_arrival_dt' doesn't exist.
• Question 'sirs_leukocyte_min_dt' doesn't exist.
• Question 'sirs_leukocyte_max_dt' doesn't exist.
• Question 'sirs_respiratoryrate_1' doesn't exist.
• Question 'sirs_respiratoryrate_2' doesn't exist.
• Question 'sirs_respiratoryrate_3' doesn't exist.
• Question 'sirs_respiratoryrate_max' doesn't exist.
• Question 'sirs_respiratoryrate_dt_1' doesn't exist.
• Question 'sirs_respiratoryrate_dt_2' doesn't exist.
• Question 'sirs_respiratoryrate_dt_3' doesn't exist.
• Question 'sirs_respiratoryrate_dt_max' doesn't exist.
• Question 'sirs_temperature_1' doesn't exist.
• Question 'sirs_temperature_2' doesn't exist.
• Question 'sirs_temperature_3' doesn't exist.
• Question 'sirs_temperature_max' doesn't exist.
• Question 'sirs_temperature_dt_1' doesn't exist.
• Question 'sirs_temperature_dt_2' doesn't exist.
• Question 'sirs_temperature_dt_3' doesn't exist.
• Question 'sirs_temperature_dt_max' doesn't exist.
• Question 'systolic_1' doesn't exist.
• Question 'systolic_2' doesn't exist.
• Question 'systolic_3' doesn't exist.
• Question 'systolic_min' doesn't exist.
• Question 'systolic_dt_1' doesn't exist.
• Question 'systolic_dt_2' doesn't exist.
• Question 'systolic_dt_3' doesn't exist.
• Question 'systolic_dt_min' doesn't exist.
• Question 'transfer_facility_id_receiving' doesn't exist.
• Question 'transfer_facility_id_sending' doesn't exist.
• Please verify your questions and/or header row structure against version D2-1-1 of the Data Dictionary.
• Case 2884: number of answers provided doesn't match the number of questions
• Please correct the above errors and re-submit.

 

 

From: Gregory Briddick <gregthes...@gmail.com>
Sent: Thursday, July 29, 2021 3:00 PM
To: ny-sepsis-ehr-discuss <ny-sepsis-...@cloud.ipro.org>
Cc: Jay Goldstein <JGold...@maimonidesmed.org>
Subject: Re: File was completely bounced this morning

 

Maimonides Information Security Warning This e-mail is from an EXTERNAL source. Ensure you trust this sender before clicking on any links or attachments. If the e-mail appears suspicious, please forward to Informati...@maimonidesmed.org. Remember that MIS will never ask you for your username or password through e-mail.

[Salay, Gene]

Jay, 

 

Check if your column headings are in lower case.   That may cause them to not be recognized.      Also, confirm that every item enclosed with double-quotes.

 

Gene Salay

Manager, ConnectCare Reporting

Information Services

 

Bon Secours Charity Health System

Member of the Westchester Medical Center Health Network

Mount Alverno Center | 20 Grand Street, Suite 308 | Warwick, NY  10990

(O) 845.987.5953 | (C) 201.832.7765 | (F) 845.988.0876

 

Gene_...@bshsi.org | bschs.bonsecours.com

ConnectCare Report Requests

--
You received this message because you are subscribed to the Google Groups "ny-sepsis-ehr-discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ny-sepsis-ehr-di...@cloud.ipro.org.
To view this discussion on the web visit https://groups.google.com/a/cloud.ipro.org/d/msgid/ny-sepsis-ehr-discuss/94fa8ca9f9364be1966ca6ceb7015561%40maimonidesmed.org.

WARNING: The sender of this email could not be validated and may not match the person in the “From” field.
CAUTION: This email originated from outside of the Bon Secours Mercy Health organization.  DO NOT CLICK on any links or attachments unless you recognize the sender and you know that the content is safe.

CONFIDENTIALITY NOTICE: This message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. CONFIDENTIALITY NOTICE: This message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

[Salay, Gene]

I mean to say – headings need to be in lower case.   Upper case will case them to not be recognized.

 

Gene Salay

Manager, ConnectCare Reporting

Information Services

 

Bon Secours Charity Health System

Member of the Westchester Medical Center Health Network

Mount Alverno Center | 20 Grand Street, Suite 308 | Warwick, NY  10990

(O) 845.987.5953 | (C) 201.832.7765 | (F) 845.988.0876

 

Gene_...@bshsi.org | bschs.bonsecours.com

ConnectCare Report Requests

 

To view this discussion on the web visit https://groups.google.com/a/cloud.ipro.org/d/msgid/ny-sepsis-ehr-discuss/DM8PR08MB7286A18524DBEAC21BCCA19CFDEB9%40DM8PR08MB7286.namprd08.prod.outlook.com.

[Gregory Briddick, Jr.]

Jay,

    Your first column is not in the correct format, so the portal is not seeing any of the columns.  See the error how it has starts with

(admission_dt;"arrival_dt";"date_of_birth";"discharge_dt";......

The first column name isn't within quotation marks, and the portal doesn't recognize it.

[Gregory Briddick, Jr.]

That's why the subsequent list of all the questions which say that the file is missing all of the column names.....