A practical method of linking data from Medicare claims and a comprehensive electronic medical records system

Michael Weiner, Timothy E. Stump, Christopher Callahan, John N. Lewis, Clement J. McDonald

Research output: Contribution to journalArticle

20 Citations (Scopus)

Abstract

Background: Linking administrative and clinical databases provides opportunities for richer studies to improve healthcare, but linkage may require sophisticated algorithms. Linking US Medicare data with large databases used for everyday clinical practice is seldom described in detail in medical literature. Objectives: Test a deterministic method of linking data from a local electronic medical records system to Medicare data, and report specific details of the algorithm used as well as lessons learned from the linkage process. Subjects: Medicare beneficiaries with medical encounters in selected Indiana counties in the 5-year period ending in 1999. Results: For 6388 beneficiaries with Medicare data indicating inpatient encounters in the system, 98% had links to the clinical database. Of 7231 patients hospitalized and registered in the local clinical system, 86% contained a link to Medicare data, and 69% contained a link even without using Social security number (SSN) as an identifier. Medicare data that conflicted with local hospital records by indicating no local hospitalization occurred in 1.8%. More than 2000 claims contained hospital identifiers that did not exist in the hospital codebook. Conclusions: Details of a practical, deterministic method of linking Medicare claims to a large electronic records system have been applied and described. Most records were linked without SSN. A variety of inconsistencies were found and these, along with missing or incomplete data, can influence linking. Integrity of specific variables must be assessed carefully.

Original languageEnglish
Pages (from-to)57-69
Number of pages13
JournalInternational Journal of Medical Informatics
Volume71
Issue number1
DOIs
StatePublished - Aug 1 2003

Fingerprint

Electronic Health Records
Medicare
Social Security
Databases
Hospital Records
Inpatients
Hospitalization
Delivery of Health Care

Keywords

  • Health services
  • Information systems
  • Medicare
  • Records, computerized medical

ASJC Scopus subject areas

  • Medicine(all)

Cite this

A practical method of linking data from Medicare claims and a comprehensive electronic medical records system. / Weiner, Michael; Stump, Timothy E.; Callahan, Christopher; Lewis, John N.; McDonald, Clement J.

In: International Journal of Medical Informatics, Vol. 71, No. 1, 01.08.2003, p. 57-69.

Research output: Contribution to journalArticle

@article{f2d1f9dc810b446b9cb718fc6bbaf3cc,
title = "A practical method of linking data from Medicare claims and a comprehensive electronic medical records system",
abstract = "Background: Linking administrative and clinical databases provides opportunities for richer studies to improve healthcare, but linkage may require sophisticated algorithms. Linking US Medicare data with large databases used for everyday clinical practice is seldom described in detail in medical literature. Objectives: Test a deterministic method of linking data from a local electronic medical records system to Medicare data, and report specific details of the algorithm used as well as lessons learned from the linkage process. Subjects: Medicare beneficiaries with medical encounters in selected Indiana counties in the 5-year period ending in 1999. Results: For 6388 beneficiaries with Medicare data indicating inpatient encounters in the system, 98{\%} had links to the clinical database. Of 7231 patients hospitalized and registered in the local clinical system, 86{\%} contained a link to Medicare data, and 69{\%} contained a link even without using Social security number (SSN) as an identifier. Medicare data that conflicted with local hospital records by indicating no local hospitalization occurred in 1.8{\%}. More than 2000 claims contained hospital identifiers that did not exist in the hospital codebook. Conclusions: Details of a practical, deterministic method of linking Medicare claims to a large electronic records system have been applied and described. Most records were linked without SSN. A variety of inconsistencies were found and these, along with missing or incomplete data, can influence linking. Integrity of specific variables must be assessed carefully.",
keywords = "Health services, Information systems, Medicare, Records, computerized medical",
author = "Michael Weiner and Stump, {Timothy E.} and Christopher Callahan and Lewis, {John N.} and McDonald, {Clement J.}",
year = "2003",
month = "8",
day = "1",
doi = "10.1016/S1386-5056(03)00089-3",
language = "English",
volume = "71",
pages = "57--69",
journal = "International Journal of Medical Informatics",
issn = "1386-5056",
publisher = "Elsevier Ireland Ltd",
number = "1",

}

TY - JOUR

T1 - A practical method of linking data from Medicare claims and a comprehensive electronic medical records system

AU - Weiner, Michael

AU - Stump, Timothy E.

AU - Callahan, Christopher

AU - Lewis, John N.

AU - McDonald, Clement J.

PY - 2003/8/1

Y1 - 2003/8/1

N2 - Background: Linking administrative and clinical databases provides opportunities for richer studies to improve healthcare, but linkage may require sophisticated algorithms. Linking US Medicare data with large databases used for everyday clinical practice is seldom described in detail in medical literature. Objectives: Test a deterministic method of linking data from a local electronic medical records system to Medicare data, and report specific details of the algorithm used as well as lessons learned from the linkage process. Subjects: Medicare beneficiaries with medical encounters in selected Indiana counties in the 5-year period ending in 1999. Results: For 6388 beneficiaries with Medicare data indicating inpatient encounters in the system, 98% had links to the clinical database. Of 7231 patients hospitalized and registered in the local clinical system, 86% contained a link to Medicare data, and 69% contained a link even without using Social security number (SSN) as an identifier. Medicare data that conflicted with local hospital records by indicating no local hospitalization occurred in 1.8%. More than 2000 claims contained hospital identifiers that did not exist in the hospital codebook. Conclusions: Details of a practical, deterministic method of linking Medicare claims to a large electronic records system have been applied and described. Most records were linked without SSN. A variety of inconsistencies were found and these, along with missing or incomplete data, can influence linking. Integrity of specific variables must be assessed carefully.

AB - Background: Linking administrative and clinical databases provides opportunities for richer studies to improve healthcare, but linkage may require sophisticated algorithms. Linking US Medicare data with large databases used for everyday clinical practice is seldom described in detail in medical literature. Objectives: Test a deterministic method of linking data from a local electronic medical records system to Medicare data, and report specific details of the algorithm used as well as lessons learned from the linkage process. Subjects: Medicare beneficiaries with medical encounters in selected Indiana counties in the 5-year period ending in 1999. Results: For 6388 beneficiaries with Medicare data indicating inpatient encounters in the system, 98% had links to the clinical database. Of 7231 patients hospitalized and registered in the local clinical system, 86% contained a link to Medicare data, and 69% contained a link even without using Social security number (SSN) as an identifier. Medicare data that conflicted with local hospital records by indicating no local hospitalization occurred in 1.8%. More than 2000 claims contained hospital identifiers that did not exist in the hospital codebook. Conclusions: Details of a practical, deterministic method of linking Medicare claims to a large electronic records system have been applied and described. Most records were linked without SSN. A variety of inconsistencies were found and these, along with missing or incomplete data, can influence linking. Integrity of specific variables must be assessed carefully.

KW - Health services

KW - Information systems

KW - Medicare

KW - Records, computerized medical

UR - http://www.scopus.com/inward/record.url?scp=0042090167&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=0042090167&partnerID=8YFLogxK

U2 - 10.1016/S1386-5056(03)00089-3

DO - 10.1016/S1386-5056(03)00089-3

M3 - Article

C2 - 12909159

AN - SCOPUS:0042090167

VL - 71

SP - 57

EP - 69

JO - International Journal of Medical Informatics

JF - International Journal of Medical Informatics

SN - 1386-5056

IS - 1

ER -