Table 4

Study characteristics and test measures of studies for physician claims data and hospital discharge data

CountryStudy yearsAuthor(reference)ReferenceType of administrative dataDiabetes case definitionICD codes usedStudy, NSensitivity % (95% CI)Specificity % (95% CI)PPV % (95% CI)NPV % (95% CI)κ
Canada1992–1999Hux et al21Medical chartPhysician claims and hospital discharge dataOne physician service claims or one hospitalisation with diagnosis of diabetesICD-9 250.x33179192*6199*
Two physician service claims or one hospitalisation with diagnosis of diabetesICD-9 250.x8697*8098*
Canada2000–2002Chen et al25Medical chartPhysician claims and hospital discharge data3 years observation perioddataICD 9 250.xx, ICD 10 E10.x-14.x336295.6 (92.5 to 97.7)92.8 (91.9 to 93.7)54 (49.6 to 58.5)99.6 (99.4 to 99.8)0.65 (0.61 to 0.69)
2 years observation period dataICD 9 250.xx, ICD 10 E10.x-14.x86.4 (82.4 to 90.5)97.1 (96.5 to 97.7)72.4 (67.5 to 77.3)98.8 (98.4 to 99.2)0.77 (0.73 to 0.81)
Physician claims3 years observation period dataICD 9 250.xx, ICD 10 E10.x-14.x91.2 (87.9 to 94.6)97.6 (97.1 to 98.1)72.1 (67.5 to 76.9)99.2 (98.9 to 99.5)0.82 (0.78 to 0.85)
2 years observation period dataICD 9 250.xx, ICD 10 E10.x-14.x76.6 (71.5 to 81.6)99.3 (99.0 to 99.6)90.9 (87.2 to 94.6)98 (97.5 to 98.4)0.82 (78.0 to 85.5)
USA1999Rector et al17Telephone surveysHospital discharge data and physician claimsOne 1999 claim with dxICD 9 250.xx, 357.2x, 362.0x, 366.4136339093 
One 1999 face-to-face encounter claim with dxICD 9 250.xx, 357.2x, 362.0x, 366.418296
One 1999 face-to-face encounter claim with primary dxICD 9 250.xx, 357.2x, 362.0x, 366.417298
Two 1999 claims with dxICD 9 250.xx, 357.2x, 362.0x, 366.418596
Two 1999 face-to-face encounter claims with primary dxICD 9 250.xx, 357.2x, 362.0x, 366.417098
Two 1999 face-to-face encounter claims with primary dxICD 9 250.xx, 357.2x, 362.0x, 366.415799
1999–2000One 1999 or 2000 claim with dxICD 9 250.xx, 357.2x, 362.0x, 366.41)9588
One 1999 or 2000 face-to-face encounter claim with dxICD 9 250.xx, 357.2x, 362.0x, 366.419492
One 1999 or 2000 face-to-face encounter claim with primary dxICD 9 250.xx, 357.2x, 362.0x, 366.418796
Two 1999 or 2000 claims with dxICD 9 250.xx, 357.2x, 362.0x, 366.419393
Two 1999 or 2000 face-to-face encounter claims with dxICD 9 250.xx, 357.2x, 362.0x, 366.419195
Two 1999 or 2000 face-to-face encounter claims with primary dxICD 9 250.xx, 357.2x, 362.0x, 366.417798
Canada1980–1984Young et al27Self-reported surveyHospital admission and physician claims(Hospital admissions of provincial residents claims for which are submitted to the MHSC) AND (Hospital admissions of provincial residents claims for which are submitted to the MHSC AND Claims by the physician to the MHSC or payment)ICD 9-CM100082.796.3   
(Hospital admissions of provincial residents claims for which are submitted to the MHSC AND Claims by the physician to the MHSC or payment) AND (Claims by the physician to the MHSC or payment)ICD 9-CM82.198.5
(Hospital admissions of provincial residents claims for which are submitted to the MHSC) AND (Hospital admissions of provincial residents claims for which are submitted to the MHSC AND Claims by the physician to the MHSC or payment) AND (Claims by the physician to the MHSC or payment)ICD 9-CM83.995.8
  • Superior performance characteristics within studies have been highlighted in bold.

  • *Sensitivity, specificity, PPV and NPV are all hand-calculated:

  • sensitivity identifies the proportion of patients who truly do have the disease/condition;

  • specificity identifies the proportion of patients who truly do not have the disease/condition;

  • PPV is the probability that participants with a positive screening test truly have the disease/condition;

  • NPV is the probability that participants with a negative screening test truly do not have the disease/condition;

  • κ is an inter-rater agreement statistic to evaluate the agreement between two classifications on ordinal or nominal scales.

  • ICD 10-AM, International Classification of Diseases, Tenth Revision, Australian Modification; ICD, International Classification of Diseases; ICD-9-CM, International Classification of Diseases, Ninth Revision, Clinical Modification; MHSC, Manitoba Health Services Commission; NPV, negative predictive value; PPV, positive predictive value.