About this Dataset

Professional Medical Billing Services (SV1) Detail Information - Historical

The Texas Department of Insurance, Division of Workers' Compensation (DWC) maintains a database of professional medical billing services (SV1). It contains charges, payments, and treatments billed on a CMS-1500 form by doctors and other health care professionals who treat injured employees, including ambulatory surgical centers, with dates of service more than five years old going back to 2010. For datasets from the past five years, see professional medical billing services (SV1) detail information. The detail contains information to identify insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill details are individual line items that are grouped in the header section of a single bill. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our professional medical billing services (SV1) detail data dictionary. See professional medical billing services (SV1) header information – historical for the corresponding header 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:14:26.222003
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_professional_medical_billing_services_s_2d2b69ef.table_1

368.4 MB
13813843 rows
53 columns


CREATE TABLE table_1 (
  "bill_selection_date" TIMESTAMP,
  "bill_id" BIGINT,
  "bill_detail_id" BIGINT,
  "line_number" BIGINT,
  "hcpcs_line_procedure_billed_code" VARCHAR,
  "first_hcpcs_modifier_billed_code" VARCHAR,
  "second_hcpcs_modifier_billed_code" VARCHAR,
  "third_hcpcs_modifier_billed_code" VARCHAR,
  "fourth_hcpcs_modifier_billed_code" VARCHAR,
  "procedure_description" VARCHAR,
  "total_charge_per_line" DOUBLE,
  "days_units_code" VARCHAR,
  "days_units_billed" DOUBLE,
  "place_of_service_line_code" DOUBLE,
  "first_diagnosis_pointer" DOUBLE,
  "second_diagnosis_pointer" DOUBLE,
  "third_diagnosis_pointer" DOUBLE,
  "fourth_diagnosis_pointer" DOUBLE,
  "crna_supervision_indicator" VARCHAR,
  "provider_agreement_line_code" VARCHAR,
  "service_line_from_date" TIMESTAMP,
  "service_line_to_date" TIMESTAMP,
  "contract_line_type_code" VARCHAR,
  "treatment_line_authorization_number" VARCHAR,
  "total_amount_paid_per_line" DOUBLE,
  "hcpcs_line_procedure_paid_code" VARCHAR,
  "first_hcpcs_modifier_paid_code" VARCHAR,
  "second_hcpcs_modifier_paid_code" VARCHAR,
  "third_hcpcs_modifier_paid_code" VARCHAR,
  "fourth_hcpcs_modifier_paid_code" VARCHAR,
  "days_units_paid" DOUBLE,
  "rendering_line_provider_national_provider_id" DOUBLE,
  "number_of_service_adjustments" BIGINT,
  "service_adjustment_group_code_1" VARCHAR,
  "service_adjustment_reason_code_1" VARCHAR,
  "service_adjustment_amount_1" DOUBLE,
  "service_adjustment_units_1" DOUBLE,
  "service_adjustment_group_code_2" VARCHAR,
  "service_adjustment_reason_code_2" VARCHAR,
  "service_adjustment_amount_2" DOUBLE,
  "service_adjustment_units_2" DOUBLE,
  "service_adjustment_group_code_3" VARCHAR,
  "service_adjustment_reason_code_3" VARCHAR,
  "service_adjustment_amount_3" DOUBLE,
  "service_adjustment_units_3" DOUBLE,
  "service_adjustment_group_code_4" VARCHAR,
  "service_adjustment_reason_code_4" VARCHAR,
  "service_adjustment_amount_4" DOUBLE,
  "service_adjustment_units_4" DOUBLE,
  "service_adjustment_group_code_5" VARCHAR,
  "service_adjustment_reason_code_5" VARCHAR,
  "service_adjustment_amount_5" DOUBLE,
  "service_adjustment_units_5" DOUBLE
);