About this Dataset

Pharmacy Medical Billing Services (SV4) Detail Information

The Texas Department of Insurance, Division of Workers’ Compensation (DWC) maintains a database of pharmacy medical billing services (SV4). It contains charges, payments, and prescriptions billed on a DWC Form-066, Statement of Pharmacy Services by pharmacies with dates of service for the last five years. For datasets going back to 2010, see pharmacy medical billing services (SV4) detail information – historical. The detail section 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 pharmacy medical billing services (SV4) detail data dictionary. See pharmacy medical billing services (SV4) header information for the corresponding header records related 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-25T21:54:34.388229
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_pharmacy_medical_billing_services_sv4_d_bb2ce039.table_1

73.87 MB
1,918,229 rows
41 columns

CREATE TABLE table_1 (
  "bill_selection_date" TIMESTAMP,
  "bill_id" BIGINT,
  "bill_detail_id" BIGINT,
  "line_number" BIGINT,
  "ndc_billed_code" VARCHAR,
  "prescription_line_number" VARCHAR,
  "dispensed_as_written_code" BIGINT,
  "drug_name" VARCHAR,
  "basis_of_cost_determination_code" DOUBLE,
  "service_line_from_date" TIMESTAMP,
  "service_line_to_date" TIMESTAMP,
  "prescription_line_date" TIMESTAMP,
  "drugs_supplies_quantity_dispensed" BIGINT,
  "drugs_supplies_number_of_days" BIGINT,
  "drugs_supplies_dispensing_fee" DOUBLE,
  "drugs_supplies_billed_amount" DOUBLE,
  "total_amount_paid_per_line" DOUBLE,
  "ndc_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
);