Health data quality improvement by comparing administrative medical data and billing data

ObjectiveThe increasing use of medical administrative databases in hospital financing means more attention is being paid to their quality. The object of this study is to compare diagnoses found in the medical database to treatments mentioned in the billing database and to identify hospital stays with discrepancies.MethodThe analysis is performed for the diagnoses of heart failure, hypertension, and pneumonia. Data were extracted from the 2000 National Medical Minimum Basic Data Set (MBDS) database and from the 2000 National bill summary database. The in-hospital stays were split into four analysis groups: patients with the selected disease and a corresponding treatment, patients with the selected disease but without a corresponding treatment, patients with a treatment, without the selected disease, but with another pathology requiring the same treatment, and patients with a treatment, without the selected disease and without any other pathology requiring the same treatment.ResultsThe proportion of in-hospital stays with the disease in the medical database but without a corresponding treatment mentioned in the billing database was 1.1% for heart failure, 12.0% for hypertension, and 5.1% for pneumonia. Under-reporting (patient with a treatment but without any corresponding disease) concerned a high proportion of stays for heart failure and for hypertension (29.6% and 26.8%, respectively).ConclusionsThis database comparison identified hospital stays with discrepancies between the medical database and the billing database. This method allows a better focus on the medical MBDS to be reviewed but must be completed by a thorough analysis of the medical chart. An extension of this methodology to other pathology would be useful to assess the quality of administrative data.