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"
Comments
0 comments
Please sign in to leave a comment.