{"columns":[{"name":"ingested_at","type":"timestamp[us, tz=America/Chicago]"},{"name":"ingested_file_name","type":"string"},{"name":"message_code","type":"string"},{"name":"message_variant","type":"string"},{"name":"implementation_reference","type":"string"},{"name":"transaction_set_control_number","type":"string"},{"name":"st_transaction_set_identifier_code","type":"string"},{"name":"st_transaction_set_control_number","type":"string"},{"name":"st_implementation_convention_reference","type":"string"},{"name":"bht_hierarchical_structure_code","type":"string"},{"name":"bht_transaction_set_purpose_code","type":"string"},{"name":"bht_reference_identification","type":"string"},{"name":"bht_date","type":"string"},{"name":"bht_time","type":"string"},{"name":"bht_transaction_type_code","type":"string"},{"name":"submitter_name","type":"string"},{"name":"submitter_id","type":"string"},{"name":"receiver_name","type":"string"},{"name":"receiver_id","type":"string"},{"name":"billing_provider_hl_id","type":"string"},{"name":"billing_provider_hl_level_code","type":"string"},{"name":"billing_provider_name","type":"string"},{"name":"billing_provider_npi","type":"string"},{"name":"subscriber_hl_id","type":"string"},{"name":"subscriber_parent_hl_id","type":"string"},{"name":"payer_responsibility_sequence_number_code","type":"string"},{"name":"subscriber_relationship_code","type":"string"},{"name":"claim_filing_indicator_code","type":"string"},{"name":"subscriber_last_name","type":"string"},{"name":"subscriber_first_name","type":"string"},{"name":"subscriber_id","type":"string"},{"name":"payer_name","type":"string"},{"name":"payer_id","type":"string"},{"name":"claim_patient_control_number","type":"string"},{"name":"claim_total_charge_amount","type":"string"},{"name":"claim_facility_type_code","type":"string"},{"name":"claim_facility_code_qualifier","type":"string"},{"name":"claim_frequency_type_code","type":"string"},{"name":"provider_signature_indicator","type":"string"},{"name":"assignment_or_plan_participation_code","type":"string"},{"name":"benefits_assignment_certification_indicator","type":"string"},{"name":"release_of_information_code","type":"string"},{"name":"service_line_number","type":"string"},{"name":"svc_product_service_id_qualifier","type":"string"},{"name":"svc_procedure_code","type":"string"},{"name":"svc_modifier_1","type":"string"},{"name":"svc_modifier_2","type":"string"},{"name":"svc_modifier_3","type":"string"},{"name":"svc_modifier_4","type":"string"},{"name":"svc_line_item_charge_amount","type":"string"},{"name":"svc_unit_of_measure","type":"string"},{"name":"svc_unit_count","type":"string"},{"name":"svc_diagnosis_code_pointer","type":"string"},{"name":"svc_service_date","type":"string"}],"n_rows":9,"rows_kept":9,"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_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"message_variant","type":"string","nullable":true,"metadata":null,"children":null},{"name":"implementation_reference","type":"string","nullable":true,"metadata":null,"children":null},{"name":"transaction_set_control_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"st_transaction_set_identifier_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"st_transaction_set_control_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"st_implementation_convention_reference","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_hierarchical_structure_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_transaction_set_purpose_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_reference_identification","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_date","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_time","type":"string","nullable":true,"metadata":null,"children":null},{"name":"bht_transaction_type_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"submitter_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"submitter_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"receiver_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"receiver_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_hl_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_hl_level_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"billing_provider_npi","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_hl_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_parent_hl_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payer_responsibility_sequence_number_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_relationship_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_filing_indicator_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_last_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_first_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"subscriber_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payer_name","type":"string","nullable":true,"metadata":null,"children":null},{"name":"payer_id","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_patient_control_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_total_charge_amount","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_facility_type_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_facility_code_qualifier","type":"string","nullable":true,"metadata":null,"children":null},{"name":"claim_frequency_type_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"provider_signature_indicator","type":"string","nullable":true,"metadata":null,"children":null},{"name":"assignment_or_plan_participation_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"benefits_assignment_certification_indicator","type":"string","nullable":true,"metadata":null,"children":null},{"name":"release_of_information_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"service_line_number","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_product_service_id_qualifier","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_procedure_code","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_modifier_1","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_modifier_2","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_modifier_3","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_modifier_4","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_line_item_charge_amount","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_unit_of_measure","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_unit_count","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_diagnosis_code_pointer","type":"string","nullable":true,"metadata":null,"children":null},{"name":"svc_service_date","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_code (String);\n  optional binary field_id=-1 message_variant (String);\n  optional binary field_id=-1 implementation_reference (String);\n  optional binary field_id=-1 transaction_set_control_number (String);\n  optional binary field_id=-1 st_transaction_set_identifier_code (String);\n  optional binary field_id=-1 st_transaction_set_control_number (String);\n  optional binary field_id=-1 st_implementation_convention_reference (String);\n  optional binary field_id=-1 bht_hierarchical_structure_code (String);\n  optional binary field_id=-1 bht_transaction_set_purpose_code (String);\n  optional binary field_id=-1 bht_reference_identification (String);\n  optional binary field_id=-1 bht_date (String);\n  optional binary field_id=-1 bht_time (String);\n  optional binary field_id=-1 bht_transaction_type_code (String);\n  optional binary field_id=-1 submitter_name (String);\n  optional binary field_id=-1 submitter_id (String);\n  optional binary field_id=-1 receiver_name (String);\n  optional binary field_id=-1 receiver_id (String);\n  optional binary field_id=-1 billing_provider_hl_id (String);\n  optional binary field_id=-1 billing_provider_hl_level_code (String);\n  optional binary field_id=-1 billing_provider_name (String);\n  optional binary field_id=-1 billing_provider_npi (String);\n  optional binary field_id=-1 subscriber_hl_id (String);\n  optional binary field_id=-1 subscriber_parent_hl_id (String);\n  optional binary field_id=-1 payer_responsibility_sequence_number_code (String);\n  optional binary field_id=-1 subscriber_relationship_code (String);\n  optional binary field_id=-1 claim_filing_indicator_code (String);\n  optional binary field_id=-1 subscriber_last_name (String);\n  optional binary field_id=-1 subscriber_first_name (String);\n  optional binary field_id=-1 subscriber_id (String);\n  optional binary field_id=-1 payer_name (String);\n  optional binary field_id=-1 payer_id (String);\n  optional binary field_id=-1 claim_patient_control_number (String);\n  optional binary field_id=-1 claim_total_charge_amount (String);\n  optional binary field_id=-1 claim_facility_type_code (String);\n  optional binary field_id=-1 claim_facility_code_qualifier (String);\n  optional binary field_id=-1 claim_frequency_type_code (String);\n  optional binary field_id=-1 provider_signature_indicator (String);\n  optional binary field_id=-1 assignment_or_plan_participation_code (String);\n  optional binary field_id=-1 benefits_assignment_certification_indicator (String);\n  optional binary field_id=-1 release_of_information_code (String);\n  optional binary field_id=-1 service_line_number (String);\n  optional binary field_id=-1 svc_product_service_id_qualifier (String);\n  optional binary field_id=-1 svc_procedure_code (String);\n  optional binary field_id=-1 svc_modifier_1 (String);\n  optional binary field_id=-1 svc_modifier_2 (String);\n  optional binary field_id=-1 svc_modifier_3 (String);\n  optional binary field_id=-1 svc_modifier_4 (String);\n  optional binary field_id=-1 svc_line_item_charge_amount (String);\n  optional binary field_id=-1 svc_unit_of_measure (String);\n  optional binary field_id=-1 svc_unit_count (String);\n  optional binary field_id=-1 svc_diagnosis_code_pointer (String);\n  optional binary field_id=-1 svc_service_date (String);\n}\n"},"kv_metadata":[["ARROW:schema",{"$cut":{"chars":5024,"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-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","2","1","P","18","CI","DOE","JANE","MEM000001","ACME HEALTH PLAN","842610001","PCLAIM001","250","11","B","1","Y","A","Y","Y","1","HC","99213",null,null,null,null,"125","UN","1","1","20260405"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","2","1","P","18","CI","DOE","JANE","MEM000001","ACME HEALTH PLAN","842610001","PCLAIM001","250","11","B","1","Y","A","Y","Y","2","HC","87070",null,null,null,null,"125","UN","1","1","20260405"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","2","1","P","18","CI","DOE","JANE","MEM000001","ACME HEALTH PLAN","842610001","PCLAIM002","340","11","B","1","Y","A","Y","Y","1","HC","99214",null,null,null,null,"190","UN","1","1","20260406"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","2","1","P","18","CI","DOE","JANE","MEM000001","ACME HEALTH PLAN","842610001","PCLAIM002","340","11","B","1","Y","A","Y","Y","2","HC","80053",null,null,null,null,"150","UN","1","2","20260406"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","3","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","PCLAIM003","415","11","B","1","Y","A","Y","Y","1","HC","99223",null,null,null,null,"215","UN","1","1","20260407"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","3","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","PCLAIM003","415","11","B","1","Y","A","Y","Y","2","HC","71020",null,null,null,null,"200","UN","1","1","20260407"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","3","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","PCLAIM004","510","11","B","1","Y","A","Y","Y","1","HC","99215",null,null,null,null,"260","UN","1","1","20260408"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","3","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","PCLAIM004","510","11","B","1","Y","A","Y","Y","2","HC","93000",null,null,null,null,"125","UN","1","2","20260408"]
["2026-04-15T22:32:01.209293Z","837-professional-sample-mutliple-claims.x12","837","PROFESSIONAL","005010X222A1","0101","837","0101","005010X222A1","0019","00","PROF0001","20260406","1200","CH","NEXUS BILLING SERVICES","SUBMITTER01","ACME HEALTH PLAN","RECEIVER01","1","20","NEXUS FAMILY PRACTICE","1234567893","3","1","P","18","CI","SMITH","JOHN","MEM000002","ACME HEALTH PLAN","842610001","PCLAIM004","510","11","B","1","Y","A","Y","Y","3","HC","36415",null,null,null,null,"125","UN","1","2","20260408"]