Data Sets

Quarterly Discharge Data Sets

Pursuant to Chapter 153, Wisconsin Statutes, all Wisconsin hospital and surgery centers are required to submit inpatient and outpatient data to WHAIC each quarter. WHAIC provides the quarterly discharge data sets in two data formats: Relational and Fixed-Width. The main differences between the formats are the number of diagnoses and procedures provided on a single record and the revenue line detail. The Fixed-Width format provides a maximum of ten diagnoses and six procedures for a single record, whereas the relational format provides all of the diagnoses and procedures on a single record.  Another difference is that the Present on Admission (POA) Indicators are only available in the relational format.

The relational format includes the revenue-enhanced data, which includes revenue codes, CPT/HCPCS, units of service and the revenue line charges.

Which data types are available in the two data formats?

Fixed-Width

Relational

  • Inpatient
  • Outpatient Surgery
  • Emergency Department Visits
  • Inpatient
  • Outpatient Surgery
  • Emergency Department Visits
  • Observation
  • Other Hospital Outpatient (OHO)

One enhancement available, in the fixed-width format, is the Physician-Enhanced data.

Available with the relational data are Physician-Enhanced and Border-State County Enhanced data.

 

Annual Hospital Survey Data Sets

All Wisconsin hospitals are also required to submit the hospital surveys each year. WHAIC has the Annual and Fiscal Survey data sets available.

The Annual Survey of Hospitals Data Set contains staffing and utilization data about Wisconsin hospitals.

The Hospital Fiscal Survey Data Set contains fiscal data about Wisconsin hospitals. Some of the elements include overall revenue and expenses classified by gross patient revenue; deductions from public and commercial sources, unrestricted assets and liabilities, charity care and bad debt, and gross and net revenue projections.

 

Certified Health Cost Fee Database for WI Worker's Compensation Program

This database may be used to determine the reasonableness of a health service provider’s fee for services under the WI Worker’s Compensation Act.