Concordance between administrative health data and medical records for diabetes status in coronary heart disease patients: a retrospective linked data study

BMC Med Res Methodol. 2013 Oct 1;13:121. doi: 10.1186/1471-2288-13-121.


Background: Administrative data are a valuable source of estimates of diabetes prevalence for groups such as coronary heart disease (CHD) patients. The primary aim of this study was to measure concordance between medical records and linked administrative health data for recording diabetes in CHD patients, and to assess temporal differences in concordance. Secondary aims were to determine the optimal lookback period for identifying diabetes in this patient group, whether concordance differed for Indigenous people, and to identify predictors of false positives and negatives in administrative data.

Methods: A population representative sample of 3943 CHD patients hospitalized in Western Australia in 1998 and 2002-04 were selected, and designated according to the International Classification of Diseases (ICD) version in use at the time (ICD-9 and ICD-10 respectively). Crude prevalence and concordance were compared for the two samples. Concordance measures were estimated from administrative data comparing diabetes status recorded on the selected CHD admission ('index admission') and on any hospitalization in the previous 1, 2, 5, 10 or 15 years, against hospital medical records. Potential modifiers of agreement were determined using chi-square tests and multivariable logistic regression models.

Results: Identification of diabetes on the index CHD admission was underestimated more in the ICD-10 than ICD-9 sample (sensitivity 81.5% versus 91.1%, underestimation 15.1% versus 4.4% respectively). Sensitivity increased to 89.6% in the ICD-10 period using at least 10 years of hospitalization history. Sensitivity was higher and specificity lower in Indigenous patients, and followed a similar pattern of improving concordance with increasing lookback period. Characteristics associated with false negatives for diabetes on the index CHD hospital admission were elective admission, in-hospital death, principal diagnosis, and in the ICD-10 period only, fewer recorded comorbidities.

Conclusions: The accuracy of identifying diabetes status in CHD patients is improved in linked administrative health data by using at least 10 years of hospitalization history. Use of this method would reduce bias when measuring temporal trends in diabetes prevalence in this patient group. Concordance measures are as reliable in Indigenous as non-Indigenous patients.

Publication types

  • Research Support, Non-U.S. Gov't

MeSH terms

  • Aged
  • Comorbidity
  • Coronary Disease / complications
  • Coronary Disease / epidemiology*
  • Cross-Sectional Studies
  • Diabetes Mellitus, Type 1 / complications
  • Diabetes Mellitus, Type 1 / diagnosis
  • Diabetes Mellitus, Type 1 / epidemiology*
  • Diabetes Mellitus, Type 2 / complications
  • Diabetes Mellitus, Type 2 / diagnosis
  • Diabetes Mellitus, Type 2 / epidemiology*
  • Diagnostic Errors
  • Female
  • Hospitalization
  • Humans
  • International Classification of Diseases
  • Male
  • Medical Records*
  • Middle Aged
  • Prevalence
  • Records
  • Retrospective Studies
  • Sensitivity and Specificity
  • Western Australia / epidemiology