{"columns":[{"name":"sending_app","type":"string"},{"name":"message_type","type":"string"},{"name":"header","type":"struct<control_id: string, message_datetime: string, message_type: string, processing_id: string, receiving_app: string, receiving_facility: string, sending_app: string, sending_facility: string, version: string>"},{"name":"patient","type":"struct<pid: struct<alt_patient_id: string, dob: string, name: struct<family: string, given: string, middle: string, prefix: string, suffix: string>, patient_ids: list<element: struct<assigning_authority: string, check_digit: string, id: string, id_type: string>>, set_id: string, sex: string>>"},{"name":"visit","type":"struct<pv1: struct<assigned_location: struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>, attending_doctor: struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>, patient_class: string, set_id: string, visit_number: string>>"},{"name":"charge","type":"struct<assigned_patient_location: struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>, diagnosis_code_raw: string, performing_provider: struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>, posting_datetime: string, quantity: string, set_id: string, transaction_amount: string, transaction_batch_id: string, transaction_code: struct<code: string, system: string, text: string>, transaction_datetime: string, transaction_description: string, transaction_id: string, transaction_type: string>"},{"name":"charge_index","type":"int64"},{"name":"segment_index","type":"struct<FT1: list<element: string>, MSH: list<element: string>, PID: list<element: string>, PV1: list<element: string>>"},{"name":"created_at","type":"string"},{"name":"ingested_at","type":"string"},{"name":"ingested_file_name","type":"string"}],"n_rows":1,"rows_kept":1,"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":"sending_app","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"header","type":"struct<control_id: string, message_datetime: string, message_type: string, processing_id: string, receiving_app: string, receiving_facility: string, sending_app: string, sending_facility: string, version: string>","nullable":true,"metadata":null,"children":[{"name":"control_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_datetime","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"processing_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"receiving_app","type":"string","nullable":true,"metadata":null,"children":null},{"name":"receiving_facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sending_app","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sending_facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"version","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"patient","type":"struct<pid: struct<alt_patient_id: string, dob: string, name: struct<family: string, given: string, middle: string, prefix: string, suffix: string>, patient_ids: list<element: struct<assigning_authority: string, check_digit: string, id: string, id_type: string>>, set_id: string, sex: string>>","nullable":true,"metadata":null,"children":[{"name":"pid","type":"struct<alt_patient_id: string, dob: string, name: struct<family: string, given: string, middle: string, prefix: string, suffix: string>, patient_ids: list<element: struct<assigning_authority: string, check_digit: string, id: string, id_type: string>>, set_id: string, sex: string>","nullable":true,"metadata":null,"children":[{"name":"alt_patient_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"dob","type":"string","nullable":true,"metadata":null,"children":null},{"name":"name","type":"struct<family: string, given: string, middle: string, prefix: string, suffix: string>","nullable":true,"metadata":null,"children":[{"name":"family","type":"string","nullable":true,"metadata":null,"children":null},{"name":"given","type":"string","nullable":true,"metadata":null,"children":null},{"name":"middle","type":"string","nullable":true,"metadata":null,"children":null},{"name":"prefix","type":"string","nullable":true,"metadata":null,"children":null},{"name":"suffix","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"patient_ids","type":"list<element: struct<assigning_authority: string, check_digit: string, id: string, id_type: string>>","nullable":true,"metadata":null,"children":[{"name":"element","type":"struct<assigning_authority: string, check_digit: string, id: string, id_type: string>","nullable":true,"metadata":null,"children":[{"name":"assigning_authority","type":"string","nullable":true,"metadata":null,"children":null},{"name":"check_digit","type":"string","nullable":true,"metadata":null,"children":null},{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"id_type","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"sex","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"visit","type":"struct<pv1: struct<assigned_location: struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>, attending_doctor: struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>, patient_class: string, set_id: string, visit_number: string>>","nullable":true,"metadata":null,"children":[{"name":"pv1","type":"struct<assigned_location: struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>, attending_doctor: struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>, patient_class: string, set_id: string, visit_number: string>","nullable":true,"metadata":null,"children":[{"name":"assigned_location","type":"struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>","nullable":true,"metadata":null,"children":[{"name":"bed","type":"string","nullable":true,"metadata":null,"children":null},{"name":"facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"location_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"person_location_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"point_of_care","type":"string","nullable":true,"metadata":null,"children":null},{"name":"room","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"attending_doctor","type":"struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>","nullable":true,"metadata":null,"children":[{"name":"family","type":"string","nullable":true,"metadata":null,"children":null},{"name":"given","type":"string","nullable":true,"metadata":null,"children":null},{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"middle","type":"string","nullable":true,"metadata":null,"children":null},{"name":"prefix","type":"string","nullable":true,"metadata":null,"children":null},{"name":"suffix","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"patient_class","type":"string","nullable":true,"metadata":null,"children":null},{"name":"set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"visit_number","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"charge","type":"struct<assigned_patient_location: struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>, diagnosis_code_raw: string, performing_provider: struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>, posting_datetime: string, quantity: string, set_id: string, transaction_amount: string, transaction_batch_id: string, transaction_code: struct<code: string, system: string, text: string>, transaction_datetime: string, transaction_description: string, transaction_id: string, transaction_type: string>","nullable":true,"metadata":null,"children":[{"name":"assigned_patient_location","type":"struct<bed: string, facility: string, location_status: string, person_location_type: string, point_of_care: string, room: string>","nullable":true,"metadata":null,"children":[{"name":"bed","type":"string","nullable":true,"metadata":null,"children":null},{"name":"facility","type":"string","nullable":true,"metadata":null,"children":null},{"name":"location_status","type":"string","nullable":true,"metadata":null,"children":null},{"name":"person_location_type","type":"string","nullable":true,"metadata":null,"children":null},{"name":"point_of_care","type":"string","nullable":true,"metadata":null,"children":null},{"name":"room","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"diagnosis_code_raw","type":"string","nullable":true,"metadata":null,"children":null},{"name":"performing_provider","type":"struct<family: string, given: string, id: string, middle: string, prefix: string, suffix: string>","nullable":true,"metadata":null,"children":[{"name":"family","type":"string","nullable":true,"metadata":null,"children":null},{"name":"given","type":"string","nullable":true,"metadata":null,"children":null},{"name":"id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"middle","type":"string","nullable":true,"metadata":null,"children":null},{"name":"prefix","type":"string","nullable":true,"metadata":null,"children":null},{"name":"suffix","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"posting_datetime","type":"string","nullable":true,"metadata":null,"children":null},{"name":"quantity","type":"string","nullable":true,"metadata":null,"children":null},{"name":"set_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_amount","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_batch_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_code","type":"struct<code: string, system: string, text: string>","nullable":true,"metadata":null,"children":[{"name":"code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"system","type":"string","nullable":true,"metadata":null,"children":null},{"name":"text","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"transaction_datetime","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_description","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_type","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"charge_index","type":"int64","nullable":true,"metadata":null,"children":null},{"name":"segment_index","type":"struct<FT1: list<element: string>, MSH: list<element: string>, PID: list<element: string>, PV1: list<element: string>>","nullable":true,"metadata":null,"children":[{"name":"FT1","type":"list<element: string>","nullable":true,"metadata":null,"children":[{"name":"element","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"MSH","type":"list<element: string>","nullable":true,"metadata":null,"children":[{"name":"element","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"PID","type":"list<element: string>","nullable":true,"metadata":null,"children":[{"name":"element","type":"string","nullable":true,"metadata":null,"children":null}]},{"name":"PV1","type":"list<element: string>","nullable":true,"metadata":null,"children":[{"name":"element","type":"string","nullable":true,"metadata":null,"children":null}]}]},{"name":"created_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ingested_at","type":"string","nullable":true,"metadata":null,"children":null},{"name":"ingested_file_name","type":"string","nullable":true,"metadata":null,"children":null}],"parquet":"required group field_id=-1 schema {\n  optional binary field_id=-1 sending_app (String);\n  optional binary field_id=-1 message_type (String);\n  optional group field_id=-1 header {\n    optional binary field_id=-1 control_id (String);\n    optional binary field_id=-1 message_datetime (String);\n    optional binary field_id=-1 message_type (String);\n    optional binary field_id=-1 processing_id (String);\n    optional binary field_id=-1 receiving_app (String);\n    optional binary field_id=-1 receiving_facility (String);\n    optional binary field_id=-1 sending_app (String);\n    optional binary field_id=-1 sending_facility (String);\n    optional binary field_id=-1 version (String);\n  }\n  optional group field_id=-1 patient {\n    optional group field_id=-1 pid {\n      optional binary field_id=-1 alt_patient_id (String);\n      optional binary field_id=-1 dob (String);\n      optional group field_id=-1 name {\n        optional binary field_id=-1 family (String);\n        optional binary field_id=-1 given (String);\n        optional binary field_id=-1 middle (String);\n        optional binary field_id=-1 prefix (String);\n        optional binary field_id=-1 suffix (String);\n      }\n      optional group field_id=-1 patient_ids (List) {\n        repeated group field_id=-1 list {\n          optional group field_id=-1 element {\n            optional binary field_id=-1 assigning_authority (String);\n            optional binary field_id=-1 check_digit (String);\n            optional binary field_id=-1 id (String);\n            optional binary field_id=-1 id_type (String);\n          }\n        }\n      }\n      optional binary field_id=-1 set_id (String);\n      optional binary field_id=-1 sex (String);\n    }\n  }\n  optional group field_id=-1 visit {\n    optional group field_id=-1 pv1 {\n      optional group field_id=-1 assigned_location {\n        optional binary field_id=-1 bed (String);\n        optional binary field_id=-1 facility (String);\n        optional binary field_id=-1 location_status (String);\n        optional binary field_id=-1 person_location_type (String);\n        optional binary field_id=-1 point_of_care (String);\n        optional binary field_id=-1 room (String);\n      }\n      optional group field_id=-1 attending_doctor {\n        optional binary field_id=-1 family (String);\n        optional binary field_id=-1 given (String);\n        optional binary field_id=-1 id (String);\n        optional binary field_id=-1 middle (String);\n        optional binary field_id=-1 prefix (String);\n        optional binary field_id=-1 suffix (String);\n      }\n      optional binary field_id=-1 patient_class (String);\n      optional binary field_id=-1 set_id (String);\n      optional binary field_id=-1 visit_number (String);\n    }\n  }\n  optional group field_id=-1 charge {\n    optional group field_id=-1 assigned_patient_location {\n      optional binary field_id=-1 bed (String);\n      optional binary field_id=-1 facility (String);\n      optional binary field_id=-1 location_status (String);\n      optional binary field_id=-1 person_location_type (String);\n      optional binary field_id=-1 point_of_care (String);\n      optional binary field_id=-1 room (String);\n    }\n    optional binary field_id=-1 diagnosis_code_raw (String);\n    optional group field_id=-1 performing_provider {\n      optional binary field_id=-1 family (String);\n      optional binary field_id=-1 given (String);\n      optional binary field_id=-1 id (String);\n      optional binary field_id=-1 middle (String);\n      optional binary field_id=-1 prefix (String);\n      optional binary field_id=-1 suffix (String);\n    }\n    optional binary field_id=-1 posting_datetime (String);\n    optional binary field_id=-1 quantity (String);\n    optional binary field_id=-1 set_id (String);\n    optional binary field_id=-1 transaction_amount (String);\n    optional binary field_id=-1 transaction_batch_id (String);\n    optional group field_id=-1 transaction_code {\n      optional binary field_id=-1 code (String);\n      optional binary field_id=-1 system (String);\n      optional binary field_id=-1 text (String);\n    }\n    optional binary field_id=-1 transaction_datetime (String);\n    optional binary field_id=-1 transaction_description (String);\n    optional binary field_id=-1 transaction_id (String);\n    optional binary field_id=-1 transaction_type (String);\n  }\n  optional int64 field_id=-1 charge_index;\n  optional group field_id=-1 segment_index {\n    optional group field_id=-1 FT1 (List) {\n      repeated group field_id=-1 list {\n        optional binary field_id=-1 element (String);\n      }\n    }\n    optional group field_id=-1 MSH (List) {\n      repeated group field_id=-1 list {\n        optional binary field_id=-1 element (String);\n      }\n    }\n    optional group field_id=-1 PID (List) {\n      repeated group field_id=-1 list {\n        optional binary field_id=-1 element (String);\n      }\n    }\n    optional group field_id=-1 PV1 (List) {\n      repeated group field_id=-1 list {\n        optional binary field_id=-1 element (String);\n      }\n    }\n  }\n  optional binary field_id=-1 created_at (String);\n  optional binary field_id=-1 ingested_at (String);\n  optional binary field_id=-1 ingested_file_name (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":6424,"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}"]]}
["Test Application","DFT",{"control_id":"MSG000001","message_datetime":"20250101120000","message_type":"DFT^P03","processing_id":"P","receiving_app":"RECEIVING_APP","receiving_facility":"RECEIVING_FAC","sending_app":"Test Application","sending_facility":"Test Facility","version":"2.5.1"},{"pid":{"alt_patient_id":"","dob":"19800101","name":{"family":"DOE","given":"JOHN","middle":"","prefix":"","suffix":""},"patient_ids":[{"assigning_authority":"MRN","check_digit":"","id":"12345","id_type":""}],"set_id":"1","sex":"M"}},{"pv1":{"assigned_location":{"bed":"BED","facility":"","location_status":"","person_location_type":"","point_of_care":"UNIT","room":"ROOM"},"attending_doctor":{"family":"","given":"","id":"","middle":"","prefix":"","suffix":""},"patient_class":"I","set_id":"1","visit_number":""}},{"assigned_patient_location":{"bed":"","facility":"","location_status":"","person_location_type":"","point_of_care":"","room":""},"diagnosis_code_raw":"","performing_provider":{"family":"","given":"","id":"","middle":"","prefix":"","suffix":""},"posting_datetime":"20250115","quantity":"1","set_id":"1","transaction_amount":"100.00","transaction_batch_id":"20250115","transaction_code":{"code":"99213","system":"","text":"Office Visit"},"transaction_datetime":"20250115","transaction_description":"Office Visit","transaction_id":"","transaction_type":"CHG"},0,{"FT1":["FT1|1||20250115|20250115|CHG|99213^Office Visit|Office Visit||100.00|1|||||||||||||||||||||||"],"MSH":["MSH|^~\\&|Test Application|Test Facility|RECEIVING_APP|RECEIVING_FAC|20250101120000||DFT^P03|MSG000001|P|2.5.1|"],"PID":["PID|1||12345^^^MRN||DOE^JOHN||19800101|M|||123 MAIN ST^^CITY^STATE^12345||555-1234|"],"PV1":["PV1|1|I|UNIT^ROOM^BED|||||||||||V|||||||||||||||||||||20250101100000|"]},"2026-04-06T16:11:53.800524+00:00","2026-04-06T16:11:53.800535+00:00","test.hl7"]