About this Dataset

Institutional Medical Billing Services (SV2) Header Information

The Texas Department of Insurance, Division of Workers' Compensation (DWC) maintains a database of institutional medical billing services (SV2). It contains charges, payments, and treatments billed on a CMS-1450 form (UB-92, UB-04) by hospitals and medical facilities that treat injured employees, excluding ambulatory surgical centers, with dates of service for the last five years. For datasets going back to 2010, see institutional medical billing services (SV2) header information – historical. The header identifies insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill header information groups individual line items reported in the detail section. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our institutional medical billing services (SV2) header data dictionary. See institutional medical billing services (SV2) detail information for the corresponding detail records related to this dataset. Go to our page on DWC medical state reporting public use data file (PUDF) to learn more about using this information.
Organization: City of Austin
Last updated: 2023-08-25T22:37:26.609277
Tags: billing, cms-1450, cms-1500, dwc-066, facility, hospital, insurance, medical, pharmacy, professional, ub-04, ub-92, workers-compensation

Tables

Table 1

@usgov.city_of_austin_institutional_medical_billing_services__4c5e688b.table_1

106.56 MB
765,018 rows
123 columns

CREATE TABLE table_1 (
  "bill_selection_date" TIMESTAMP,
  "bill_id" BIGINT,
  "billing_provider_unique_bill_identification_number" VARCHAR,
  "unique_bill_id_number" VARCHAR,
  "bill_type" VARCHAR,
  "reporting_period_start_date" TIMESTAMP,
  "reporting_period_end_date" TIMESTAMP,
  "insurer_fein" VARCHAR,
  "insurer_postal_code" VARCHAR,
  "claim_administrator_fein" VARCHAR,
  "claim_administrator_name" VARCHAR,
  "claim_administrator_postal_code" VARCHAR,
  "transaction_set_purpose_code" BIGINT,
  "employer_fein" VARCHAR,
  "employer_physical_city" VARCHAR,
  "employer_physical_state_code" VARCHAR,
  "employer_physical_postal_code" VARCHAR,
  "employer_physical_country_code" VARCHAR,
  "employee_mailing_city" VARCHAR,
  "employee_mailing_state_code" VARCHAR,
  "employee_mailing_postal_code" VARCHAR,
  "employee_mailing_country_code" VARCHAR,
  "employee_date_of_birth" VARCHAR,
  "employee_gender_code" VARCHAR,
  "employee_marital_status_code" VARCHAR,
  "claim_administrator_claim_number" VARCHAR,
  "employee_date_of_injury" VARCHAR,
  "total_charge_per_bill" DOUBLE,
  "billing_type_code" VARCHAR,
  "place_of_service_bill_code" VARCHAR,
  "billing_format_code" VARCHAR,
  "provider_signature_on_file_indicator" VARCHAR,
  "release_of_information_code" VARCHAR,
  "provider_agreement_code" VARCHAR,
  "facility_code" BIGINT,
  "bill_frequency_type_code" BIGINT,
  "admission_date" TIMESTAMP,
  "admission_hour" VARCHAR,
  "discharge_date" TIMESTAMP,
  "discharge_hour" VARCHAR,
  "admission_type_code" BIGINT,
  "diagnosis_related_group_code" DOUBLE,
  "bill_submission_reason_code" BIGINT,
  "date_insurer_received_bill" TIMESTAMP,
  "service_bill_from_date" TIMESTAMP,
  "service_bill_to_date" TIMESTAMP,
  "date_of_bill" TIMESTAMP,
  "date_insurer_paid_bill" TIMESTAMP,
  "contract_type_code" DOUBLE,
  "total_amount_paid_per_bill" DOUBLE,
  "patient_account_number" VARCHAR,
  "transaction_tracking_number" VARCHAR,
  "first_icd_9cm_or_icd_10cm_diagnosis_code" VARCHAR,
  "second_icd_9cm_or_icd_10cm_diagnosis_code" VARCHAR,
  "third_icd_9cm_or_icd_10cm_diagnosis_code" VARCHAR,
  "fourth_icd_9cm_or_icd_10cm_diagnosis_code" VARCHAR,
  "fifth_icd_9cm_or_icd_10cm_diagnosis_code" VARCHAR,
  "principal_diagnosis_code" VARCHAR,
  "admitting_diagnosis_code" VARCHAR,
  "icd_9cm_or_icd_10cm_principal_procedure_code" VARCHAR,
  "principal_procedure_date" TIMESTAMP,
  "first_icd_9cm_or_icd_10cm_procedure_code" VARCHAR,
  "second_icd_9cm_or_icd_10cm_procedure_code" VARCHAR,
  "third_icd_9cm_or_icd_10cm_procedure_code" VARCHAR,
  "fourth_icd_9cm_or_icd_10cm_procedure_code" VARCHAR,
  "first_procedure_date" TIMESTAMP,
  "second_procedure_date" TIMESTAMP,
  "third_procedure_date" TIMESTAMP,
  "fourth_procedure_date" TIMESTAMP,
  "facility_name" VARCHAR,
  "facility_fein" VARCHAR,
  "facility_primary_address" VARCHAR,
  "facility_secondary_address" VARCHAR,
  "facility_city" VARCHAR,
  "facility_state_code" VARCHAR,
  "facility_postal_code" VARCHAR,
  "facility_country_code" VARCHAR,
  "facility_state_license_number" VARCHAR,
  "facility_medicare_number" VARCHAR,
  "facility_national_provider_id" DOUBLE,
  "managed_care_organization_identification" VARCHAR,
  "billing_provider_last_name_or_group" VARCHAR,
  "billing_provider_first_name" VARCHAR,
  "billing_provider_middle_name_initial" VARCHAR,
  "billing_provider_suffix" VARCHAR,
  "billing_provider_fein" VARCHAR,
  "billing_provider_gate_keeper_indicator" VARCHAR,
  "billing_provider_primary_specialty_code" VARCHAR,
  "billing_provider_primary_address" VARCHAR,
  "billing_provider_secondary_address" VARCHAR,
  "billing_provider_city" VARCHAR,
  "billing_provider_state_code" VARCHAR,
  "billing_provider_postal_code" VARCHAR,
  "billing_provider_country_code" VARCHAR,
  "billing_provider_state_license_number" VARCHAR,
  "billing_provider_medicare_number" VARCHAR,
  "treatment_authorization_number" VARCHAR,
  "billing_provider_national_provider_id" DOUBLE,
  "rendering_bill_provider_last_name_or_group" VARCHAR,
  "rendering_bill_provider_first_name" VARCHAR
);