File Creation Guide (CSV)

Follow

Facilities must submit flat, delimited text files for validation. Header rows are required for submission. If you choose to use Excel to enter your data, please see https://ipro.zendesk.com/hc/en-us/sections/200523960-File-Creation

Please note:

  • Data elements are to be delimited with semi-colon ; 
  • All elements are to be enclosed with double quotes " " including numeric fields and blanks
  • Composite data elements are delimited with a colon : 
  • One case per line 

Example

"unique_personal_identifier";"patient_control_number";"date_of_birth";"gender";"race";"ethnicity";"payer";"insurance_number";"medical_record_number";"facility_identifier";"admission_datetime";"source_of_admission";"discharge_datetime";"discharge_status";"protocol_initiated";"protocol_initiated_place";"protocol_type";"excluded_from_protocol";"excluded_reason";"excluded_datetime";"excluded_explain";"earliest_datetime";"triage_datetime";"protocol_datetime";"vascular_or_interosseous_access_datetime";"left_ed_datetime";"destination_after_ed";"lactate_reported";"lactate_reported_datetime";"lactate_level";"lactate_level_unit";"lactate_reordered";"lactate_reordered_datetime";"blood_cultures_obtained";"blood_cultures_obtained_datetime";"blood_cultures_result";"blood_cultures_pathogen";"antibiotics_given";"antibiotics_start_datetime";"adult_fluids";"pediatric_fluids";"fluids_completed_datetime";"fluid_assessment";"hypotension";"vasopressors_given";"vasopressors_given_datetime";"cvp_measured";"cvp_measured_datetime";"scvo2_measured";"scvo2_measured_datetime";"platelet_count";"bandemia";"lower_respiratory_infection";"altered_mental_status";"septic_shock_diagnosis";"infection_etiology";"site_of_infection";"mechanical_ventilation";"mechanical_ventilation_datetime";"icu";"icu_admission_datetime";"icu_discharge_datetime";"chronic_respiratory_failure";"aids_hiv_disease";"metastatic_cancer";"lymphoma_leukemia_multiple_myeloma";"immune_modifying_medications";"congestive_heart_failure";"chronic_renal_failure";"chronic_liver_disease";"diabetes";"organ_transplant"
"TESTXX1234";"99999";"19700101";"M";"46";"5";"C";"1111";"2222";"0777";"2014-01-01 08:00";"4";"2014-01-02 13:00";"01";"1";"1";"1";"0";"";"";"";"2014-01-02 08:00";"2014-01-02 08:15";"2014-04-10 08:15";"2014-01-02 08:30";"2014-01-02 12:00";"2";"1";"2014-04-02 09:15";"8.0";"1";"0";"";"1";"2014-01-02 09:00";"1";"4";"1";"2014-01-02 09:00";"1";"9";"2014-04-02 11:00";"3:4";"0";"1";"2014-01-02 11:00";"0";"";"1";"2014-01-02 11:00";"1";"0";"0";"1";"1";"1";"4";"0";"";"1";"2014-01-02 12:00";"2014-01-02 13:00";"1";"0";"0";"0";"0";"1";"1";"1";"1";"1"

Have more questions? Submit a request

Comments

Powered by Zendesk