{"columns":[{"name":"ingested_at","type":"timestamp[us, tz=America/Chicago]"},{"name":"ingested_file_name","type":"string"},{"name":"message_control_id","type":"string"},{"name":"message_datetime","type":"string"},{"name":"message_code","type":"string"},{"name":"message_variant","type":"string"},{"name":"message_version","type":"string"},{"name":"sending_application","type":"string"},{"name":"sending_facility","type":"string"},{"name":"ft1_ordinal","type":"int64"},{"name":"ft1_transaction_group_index","type":"int64"},{"name":"pid_set_id","type":"string"},{"name":"pid_patient_id_mrn","type":"string"},{"name":"pid_patient_id_assigning_authority","type":"string"},{"name":"pid_patient_id_type","type":"string"},{"name":"pid_last_name","type":"string"},{"name":"pid_first_name","type":"string"},{"name":"pid_middle_name","type":"string"},{"name":"pid_suffix","type":"string"},{"name":"pid_dob","type":"string"},{"name":"pid_sex","type":"string"},{"name":"pv1_set_id","type":"string"},{"name":"pv1_patient_class","type":"string"},{"name":"pv1_point_of_care","type":"string"},{"name":"pv1_room","type":"string"},{"name":"pv1_bed","type":"string"},{"name":"pv1_facility","type":"string"},{"name":"pv1_location_status","type":"string"},{"name":"pv1_location_type","type":"string"},{"name":"pv1_attending_doctor_id","type":"string"},{"name":"pv1_attending_doctor_last_name","type":"string"},{"name":"pv1_attending_doctor_first_name","type":"string"},{"name":"ft1_set_id","type":"string"},{"name":"ft1_transaction_id","type":"string"},{"name":"ft1_transaction_batch_id","type":"string"},{"name":"ft1_transaction_date","type":"string"},{"name":"ft1_transaction_posting_date","type":"string"},{"name":"ft1_transaction_type","type":"string"},{"name":"ft1_transaction_code","type":"string"},{"name":"ft1_transaction_code_text","type":"string"},{"name":"ft1_transaction_description","type":"string"},{"name":"ft1_transaction_amount","type":"string"},{"name":"ft1_transaction_quantity","type":"string"},{"name":"ft1_point_of_care","type":"string"},{"name":"ft1_room","type":"string"},{"name":"ft1_bed","type":"string"},{"name":"ft1_facility","type":"string"},{"name":"ft1_location_status","type":"string"},{"name":"ft1_location_type","type":"string"},{"name":"ft1_diagnosis_code","type":"string"},{"name":"ft1_diagnosis_text","type":"string"},{"name":"ft1_performed_by_id","type":"string"},{"name":"ft1_performed_by_last_name","type":"string"},{"name":"ft1_performed_by_first_name","type":"string"},{"name":"ft1_performed_by_prefix","type":"string"},{"name":"dg1_set_id","type":"string"},{"name":"dg1_diagnosis_code","type":"string"},{"name":"dg1_diagnosis_text","type":"string"},{"name":"dg1_diagnosis_code_system","type":"string"},{"name":"dg1_diagnosis_type","type":"string"},{"name":"obx_set_id","type":"string"},{"name":"obx_value_type","type":"string"},{"name":"obx_observation_identifier","type":"string"},{"name":"obx_observation_identifier_text","type":"string"},{"name":"obx_observation_value","type":"string"},{"name":"obx_observation_result_status","type":"string"},{"name":"obx_observation_datetime","type":"string"}],"n_rows":12,"rows_kept":12,"cut":false,"text_format":"parquet-jsonl-2026-10-02","bounds":{"document_bytes":16777216,"package_text_limit_bytes":33554432,"package_text_slack_bytes":1024,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096,"vector_min":64,"vector_head_fixed":16,"vector_head_variable":64,"kv_value_chars":1048576,"nesting_max":64,"binary_text":true},"cells_cut":0,"cells_bad_utf8":0,"cells_raw":0,"cells_binary":0,"cells_binary_text":0,"cells_vector":0,"n_row_groups":1,"reader":"pyarrow 23.0.1, python 3.13","created_by":"parquet-cpp-arrow version 20.0.0","schema":{"fields":[{"name":"ingested_at","type":"timestamp[us, tz=America/Chicago]","nullable":true,"metadata":null,"children":null},{"name":"ingested_file_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_control_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_datetime","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_variant","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_version","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sending_application","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sending_facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_ordinal","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_group_index","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"pid_set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_patient_id_mrn","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_patient_id_assigning_authority","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_patient_id_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_middle_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_suffix","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_dob","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pid_sex","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_patient_class","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_point_of_care","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_room","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_bed","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_location_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_location_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_attending_doctor_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_attending_doctor_last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"pv1_attending_doctor_first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_batch_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_posting_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_code_text","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_description","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_amount","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_transaction_quantity","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_point_of_care","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_room","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_bed","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_location_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_location_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_diagnosis_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_diagnosis_text","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_performed_by_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_performed_by_last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_performed_by_first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ft1_performed_by_prefix","type":"string","nullable":true,"metadata":null,"children":null},{"name":"dg1_set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"dg1_diagnosis_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"dg1_diagnosis_text","type":"string","nullable":true,"metadata":null,"children":null},{"name":"dg1_diagnosis_code_system","type":"string","nullable":true,"metadata":null,"children":null},{"name":"dg1_diagnosis_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_value_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_observation_identifier","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_observation_identifier_text","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_observation_value","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_observation_result_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"obx_observation_datetime","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional int64 field_id=-1 ingested_at (Timestamp(isAdjustedToUTC=true, timeUnit=microseconds, is_from_converted_type=false, force_set_converted_type=false));\n  optional binary field_id=-1 ingested_file_name (String);\n  optional binary field_id=-1 message_control_id (String);\n  optional binary field_id=-1 message_datetime (String);\n  optional binary field_id=-1 message_code (String);\n  optional binary field_id=-1 message_variant (String);\n  optional binary field_id=-1 message_version (String);\n  optional binary field_id=-1 sending_application (String);\n  optional binary field_id=-1 sending_facility (String);\n  optional int64 field_id=-1 ft1_ordinal;\n  optional int64 field_id=-1 ft1_transaction_group_index;\n  optional binary field_id=-1 pid_set_id (String);\n  optional binary field_id=-1 pid_patient_id_mrn (String);\n  optional binary field_id=-1 pid_patient_id_assigning_authority (String);\n  optional binary field_id=-1 pid_patient_id_type (String);\n  optional binary field_id=-1 pid_last_name (String);\n  optional binary field_id=-1 pid_first_name (String);\n  optional binary field_id=-1 pid_middle_name (String);\n  optional binary field_id=-1 pid_suffix (String);\n  optional binary field_id=-1 pid_dob (String);\n  optional binary field_id=-1 pid_sex (String);\n  optional binary field_id=-1 pv1_set_id (String);\n  optional binary field_id=-1 pv1_patient_class (String);\n  optional binary field_id=-1 pv1_point_of_care (String);\n  optional binary field_id=-1 pv1_room (String);\n  optional binary field_id=-1 pv1_bed (String);\n  optional binary field_id=-1 pv1_facility (String);\n  optional binary field_id=-1 pv1_location_status (String);\n  optional binary field_id=-1 pv1_location_type (String);\n  optional binary field_id=-1 pv1_attending_doctor_id (String);\n  optional binary field_id=-1 pv1_attending_doctor_last_name (String);\n  optional binary field_id=-1 pv1_attending_doctor_first_name (String);\n  optional binary field_id=-1 ft1_set_id (String);\n  optional binary field_id=-1 ft1_transaction_id (String);\n  optional binary field_id=-1 ft1_transaction_batch_id (String);\n  optional binary field_id=-1 ft1_transaction_date (String);\n  optional binary field_id=-1 ft1_transaction_posting_date (String);\n  optional binary field_id=-1 ft1_transaction_type (String);\n  optional binary field_id=-1 ft1_transaction_code (String);\n  optional binary field_id=-1 ft1_transaction_code_text (String);\n  optional binary field_id=-1 ft1_transaction_description (String);\n  optional binary field_id=-1 ft1_transaction_amount (String);\n  optional binary field_id=-1 ft1_transaction_quantity (String);\n  optional binary field_id=-1 ft1_point_of_care (String);\n  optional binary field_id=-1 ft1_room (String);\n  optional binary field_id=-1 ft1_bed (String);\n  optional binary field_id=-1 ft1_facility (String);\n  optional binary field_id=-1 ft1_location_status (String);\n  optional binary field_id=-1 ft1_location_type (String);\n  optional binary field_id=-1 ft1_diagnosis_code (String);\n  optional binary field_id=-1 ft1_diagnosis_text (String);\n  optional binary field_id=-1 ft1_performed_by_id (String);\n  optional binary field_id=-1 ft1_performed_by_last_name (String);\n  optional binary field_id=-1 ft1_performed_by_first_name (String);\n  optional binary field_id=-1 ft1_performed_by_prefix (String);\n  optional binary field_id=-1 dg1_set_id (String);\n  optional binary field_id=-1 dg1_diagnosis_code (String);\n  optional binary field_id=-1 dg1_diagnosis_text (String);\n  optional binary field_id=-1 dg1_diagnosis_code_system (String);\n  optional binary field_id=-1 dg1_diagnosis_type (String);\n  optional binary field_id=-1 obx_set_id (String);\n  optional binary field_id=-1 obx_value_type (String);\n  optional binary field_id=-1 obx_observation_identifier (String);\n  optional binary field_id=-1 obx_observation_identifier_text (String);\n  optional binary field_id=-1 obx_observation_value (String);\n  optional binary field_id=-1 obx_observation_result_status (String);\n  optional binary field_id=-1 obx_observation_datetime (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":5720,"head":""}}],["desisiv:query_meta","{\"persist_path\": null, \"persist_file\": null, \"persist_glob_pattern\": null, \"persist_file_type\": null, \"persist_file_quoting\": null, \"persist_file_delimiter\": null, \"persist_step_type\": null, \"persist_step_sub_type\": null, \"persist_step_name\": null, \"persist_incremental_loading\": null, \"persist_merge_keys\": null}"]]}
["2026-04-20T20:15:04.520547Z","test3.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",5,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","TXN000002","BATCH001","20250115","20250115","CHG","87070","Lab Handling","Lab and specimen handling","45.00","1","UNIT1","ROOM101","BED1","MAINHOSP","A","IP","Z0000","GENERAL EXAM","345678","BILLING","SARAH",null,"1","Z0000","General exam","ICD10","W","1","NM","GLU","Glucose","108","F","20250115113000"]
["2026-04-20T20:15:04.520547Z","test3.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",8,2,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"2","TXN000003","BATCH001","20250115","20250115","CHG","71020","Chest X-ray","Chest radiology study","125.00","1","RAD1","XRAY2","BED1","MAINHOSP","A","OP","R509","COUGH","456789","RADIOLOGIST","EMILY",null,"2","R509","Cough","ICD10","W","2","TX","XRNOTE","Radiology Note","No acute cardiopulmonary abnormality","F","20250115114500"]
["2026-04-20T20:15:04.520547Z","test3.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",11,3,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"3","TXN000004","BATCH001","20250115","20250115","PAY","80050","General Health Panel","Laboratory panel reimbursement","75.00","1","LAB1","CHEM1","BED1","MAINHOSP","A","OP","R7309","ABNORMAL GLUCOSE","567890","LAB","MICHAEL",null,"3","R7309","Abnormal glucose","ICD10","W","3","NM","A1C","Hemoglobin A1c","6.1","F","20250115120000"]
["2026-04-20T20:14:01.805097Z","test2.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",5,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","TXN000002","BATCH001","20250115","20250115","PAY","87070","Lab handling","Lab and specimen handling","45.00","1","UNIT1","ROOM101","BED1","MAINHOSP","A","IP","Z0000","ENCOUNTER","345678","BILLING","SARAH",null,"1","Z0000","General exam","ICD10","W","1","NM","GLU","Glucose","108","F","20250115113000"]
["2026-04-20T20:13:04.248053Z","test.hl7","MSG000001","20250101120000","DFT","P03","2.5.1","Test Application","Test Facility",4,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","","20250115","20250115","CHG","99213^Office Visit","Office Visit",null,"","1","","",null,null,null,null,null,"",null,"",null,null,null,"1","R509","Cough","ICD10","W","1","TX","NOTE","Visit Note","Patient seen for follow-up cough and medication review","F","20250115103000"]
["2026-04-20T20:13:04.248053Z","test.hl7","MSG000002","20250101120000","DFT","P03","2.5.1","Test Application","Test Facility",4,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","","20250115","20250115","CHG","99213^Office Visit","Office Visit",null,"","1","","",null,null,null,null,null,"",null,"",null,null,null,"1","Z0000","General exam","ICD10","W","1","NM","GLU","Glucose","108","F","20250115113000"]
["2026-04-20T20:16:03.254243Z","test_batch.hl7","MSG000001","20250101120000","DFT","P03","2.5.1","Test Application","Test Facility",5,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","TXN000001","BATCH001","20250115","20250115","CHG","99213","Office Visit","Office Visit Established Patient","100.00","1","UNIT1","ROOM101","BED1","MAINHOSP","A","IP","R509","COUGH","123456","ATTENDING","ALICE",null,"1","R509","Cough","ICD10","W","1","TX","NOTE","Visit Note","Patient seen for follow-up cough and medication review","F","20250115103000"]
["2026-04-20T20:16:03.254243Z","test_batch.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",5,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","TXN000002","BATCH001","20250115","20250115","CHG","87070","Lab Handling","Lab and specimen handling","45.00","1","UNIT1","ROOM101","BED1","MAINHOSP","A","IP","Z0000","GENERAL EXAM","345678","BILLING","SARAH",null,"1","Z0000","General exam","ICD10","W","1","NM","GLU","Glucose","108","F","20250115113000"]
["2026-04-20T20:16:03.254243Z","test_batch.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",8,2,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"2","TXN000003","BATCH001","20250115","20250115","CHG","71020","Chest X-ray","Chest radiology study","125.00","1","RAD1","XRAY2","BED1","MAINHOSP","A","OP","R509","COUGH","456789","RADIOLOGIST","EMILY",null,"2","R509","Cough","ICD10","W","2","TX","XRNOTE","Radiology Note","No acute cardiopulmonary abnormality","F","20250115114500"]
["2026-04-20T20:16:03.254243Z","test_batch.hl7","MSG000002","20250101123000","DFT","P03","2.5.1","Test Application","Test Facility",11,3,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"3","TXN000004","BATCH001","20250115","20250115","PAY","80050","General Health Panel","Laboratory panel reimbursement","75.00","1","LAB1","CHEM1","BED1","MAINHOSP","A","OP","R7309","ABNORMAL GLUCOSE","567890","LAB","MICHAEL",null,"3","R7309","Abnormal glucose","ICD10","W","3","NM","A1C","Hemoglobin A1c","6.1","F","20250115120000"]
["2026-04-20T20:14:01.805097Z","test2.hl7","MSG000001","20250101120000","DFT","P03","2.5.1","Test Application","Test Facility",5,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","TXN000001","BATCH001","20250115","20250115","CHG","99213","Office Visit","Office Visit Established Patient","100.00","1","UNIT1","ROOM101","BED1","MAINHOSP","A","IP","R509","COUGH","123456","ATTENDING","ALICE",null,"1","R509","Cough","ICD10","W","1","TX","NOTE","Visit Note","Patient seen for follow-up cough and medication review","F","20250115103000"]
["2026-04-20T20:15:04.520547Z","test3.hl7","MSG000001","20250101120000","DFT","P03","2.5.1","Test Application","Test Facility",5,1,"1","12345","MRN",null,"DOE","JOHN",null,null,"19800101","M","1","I","UNIT","ROOM","BED",null,null,null,"",null,null,"1","TXN000001","BATCH001","20250115","20250115","CHG","99213","Office Visit","Office Visit Established Patient","100.00","1","UNIT1","ROOM101","BED1","MAINHOSP","A","IP","R509","COUGH","123456","ATTENDING","ALICE",null,"1","R509","Cough","ICD10","W","1","TX","NOTE","Visit Note","Patient seen for follow-up cough and medication review","F","20250115103000"]