Administrative Claims Database
The Minnesota Hospital Association has a database of nearly 5 million records dating back to 1980 for Twin Cities metropolitan hospitals. From 1980-1992 the system was based on abstracts from the medical record, but in 1993 there was a switch to collect the Uniform Bill, 1992 version (UB-92). In 1995, the database was expanded to invite all Minnesota acute care hospitals to submit both inpatient and outpatient claims data on a voluntary basis. Hospitals benefit by receiving a standard set of reports on a quarterly basis and having access to a vast array of data for use in areas such as strategic planning and marketing, finance, quality assurance and facilities management.
The following examples of standard reports based off of the UB database are free to MHA member hospitals that submit data.
- Charges by diagnostic related group (DRG)
- Patient origin and destination by service
- Ambulatory surgery reports
- Payer mix, charges and ALOS
- Patient disposition report by Top 100 volume DRGs
- Demographic comparison report: age/gender
- Case mix/charge indices for 50 common DRGs
- Case mix/charge indices by service group
- Diagnostic imaging report
- E.R. report
- Observation report
For more information, contact Jaclyn Roland, MHA director of data acquisition, 651-659-1411. To order custom reports, contact Katie Banks, health informatics analyst, 651-659-1406.
Community Health Reports
These reports are based on UB-04/837 administrative data and are the result of a collaborative design effort between local public health, the Minnesota Department of Health and MHA. There are three different reports, each prepared at the county level as well as the regional and state level:
- Discharges and Utilization Rates for Selected Diseases (comparable to the General Mortality PDF report found in MDH’s Minnesota Center for Health Statistics, Minnesota Health Statistics Annual Summary report).
- Five Leading Causes of Hospitalization (Excluding Births) by Age (includes number of discharges, hospital days and charges)
- Hospitalization Rates by Clinical Classifications Software (CCS) Chapter and Age Group.
To download these reports, visit the Community Health Reports website. For more information, contact Katie Banks, health informatics analyst, 651-659-1406.
UB Data Submission Manual
For guidelines on submitting uniform billing data, contact Bonnie Terveer, data operations assistant, 651-603-3520.
Data Release Policy
All hospitals will agree on the format of a set of standard, hard copy reports which all will receive. Any data shared among hospitals in such reports (i.e., where hospitals are identified to one another), must be agreed to by each hospital receiving such reports. Hospitals not wanting to be identified in any or all reports will have their data included in an "other hospitals" aggregate category, and will not receive those reports in which other hospitals are identified.
Special reports which go beyond the standard set are available on a fee-for-service basis to hospitals or the community at large if the data requests meet one of the below conditions:
- the reports do not identify any individual hospitals or physicians;
- the reports contain aggregate categories which are broad enough to make identification of individual hospitals or physicians impossible;
- individual hospitals or physicians consent, in writing, to have themselves specifically identified in any reports.
No entity shall have access to raw data (i.e., MHA will not release individual patient records.)