Creation and Validation of Linkage Between Orthopedic Registry and Administrative Data Using Indirect Identifiers

Jialin Mao*, Caryn Diane Etkin, David G. Lewallen, Art Sedrakyan

*Corresponding author for this work

Research output: Contribution to journalArticle

Abstract

Background: Registries and administrative databases have unique and complementary strengths in device epidemiologic studies. We sought to develop, validate, and assess a sequential algorithm using indirect identifiers to link registry and administrative data. Methods: Hip and knee arthroplasty procedures performed at 6 New York State hospitals enrolled in American Joint Replacement Registry in 2014 were included. After conducting a direct linkage using patient identifiers including name and social security numbers, we validated the methodology of indirect linkage using facility ID, patients’ year and month of birth, sex, and zip code, and procedure date and site (hip/knee). We further evaluated the influence of absent indirect identifier(s) and compromised data quality on linkage success. Results: Using our sequential algorithm, 3739 of the 4063 directly linked records (92.03%) were matched with indirect identifiers, with an accuracy of >99.9%. Main reasons for nonmatching included discrepancies in procedure codes and dates. When one of the indirect identifiers was not available, the linkage algorithm still achieved over 90% sensitivity and 99.8% accuracy. Analyses showed that the algorithm was robust when quality of data was moderately compromised. Conclusion: This study demonstrated high sensitivity and accuracy of an algorithm to create linkages between a registry and an administrative database using indirect identifiers. The methodology will enable long-term surveillance and outcome assessment of a wide variety of devices and procedures. Variations in the coding of procedures, availability of indirect identifiers, and their quality have limited impact on this algorithm.

Original languageEnglish (US)
Pages (from-to)1076-1081.e0
JournalJournal of Arthroplasty
Volume34
Issue number6
DOIs
StatePublished - Jun 1 2019

Fingerprint

Orthopedics
Registries
Hip
Replacement Arthroplasties
Databases
Equipment and Supplies
Knee Replacement Arthroplasties
State Hospitals
Social Security
Names
Epidemiologic Studies
Knee
Outcome Assessment (Health Care)
Parturition
Data Accuracy

Keywords

  • data linkage
  • device evaluation
  • joint arthroplasty
  • orthopedic device registry
  • validation

ASJC Scopus subject areas

  • Orthopedics and Sports Medicine

Cite this

@article{2fd706b9412347a09acdcb072a22722c,
title = "Creation and Validation of Linkage Between Orthopedic Registry and Administrative Data Using Indirect Identifiers",
abstract = "Background: Registries and administrative databases have unique and complementary strengths in device epidemiologic studies. We sought to develop, validate, and assess a sequential algorithm using indirect identifiers to link registry and administrative data. Methods: Hip and knee arthroplasty procedures performed at 6 New York State hospitals enrolled in American Joint Replacement Registry in 2014 were included. After conducting a direct linkage using patient identifiers including name and social security numbers, we validated the methodology of indirect linkage using facility ID, patients’ year and month of birth, sex, and zip code, and procedure date and site (hip/knee). We further evaluated the influence of absent indirect identifier(s) and compromised data quality on linkage success. Results: Using our sequential algorithm, 3739 of the 4063 directly linked records (92.03{\%}) were matched with indirect identifiers, with an accuracy of >99.9{\%}. Main reasons for nonmatching included discrepancies in procedure codes and dates. When one of the indirect identifiers was not available, the linkage algorithm still achieved over 90{\%} sensitivity and 99.8{\%} accuracy. Analyses showed that the algorithm was robust when quality of data was moderately compromised. Conclusion: This study demonstrated high sensitivity and accuracy of an algorithm to create linkages between a registry and an administrative database using indirect identifiers. The methodology will enable long-term surveillance and outcome assessment of a wide variety of devices and procedures. Variations in the coding of procedures, availability of indirect identifiers, and their quality have limited impact on this algorithm.",
keywords = "data linkage, device evaluation, joint arthroplasty, orthopedic device registry, validation",
author = "Jialin Mao and Etkin, {Caryn Diane} and Lewallen, {David G.} and Art Sedrakyan",
year = "2019",
month = "6",
day = "1",
doi = "10.1016/j.arth.2019.01.063",
language = "English (US)",
volume = "34",
pages = "1076--1081.e0",
journal = "Journal of Arthroplasty",
issn = "0883-5403",
publisher = "Churchill Livingstone",
number = "6",

}

Creation and Validation of Linkage Between Orthopedic Registry and Administrative Data Using Indirect Identifiers. / Mao, Jialin; Etkin, Caryn Diane; Lewallen, David G.; Sedrakyan, Art.

In: Journal of Arthroplasty, Vol. 34, No. 6, 01.06.2019, p. 1076-1081.e0.

Research output: Contribution to journalArticle

TY - JOUR

T1 - Creation and Validation of Linkage Between Orthopedic Registry and Administrative Data Using Indirect Identifiers

AU - Mao, Jialin

AU - Etkin, Caryn Diane

AU - Lewallen, David G.

AU - Sedrakyan, Art

PY - 2019/6/1

Y1 - 2019/6/1

N2 - Background: Registries and administrative databases have unique and complementary strengths in device epidemiologic studies. We sought to develop, validate, and assess a sequential algorithm using indirect identifiers to link registry and administrative data. Methods: Hip and knee arthroplasty procedures performed at 6 New York State hospitals enrolled in American Joint Replacement Registry in 2014 were included. After conducting a direct linkage using patient identifiers including name and social security numbers, we validated the methodology of indirect linkage using facility ID, patients’ year and month of birth, sex, and zip code, and procedure date and site (hip/knee). We further evaluated the influence of absent indirect identifier(s) and compromised data quality on linkage success. Results: Using our sequential algorithm, 3739 of the 4063 directly linked records (92.03%) were matched with indirect identifiers, with an accuracy of >99.9%. Main reasons for nonmatching included discrepancies in procedure codes and dates. When one of the indirect identifiers was not available, the linkage algorithm still achieved over 90% sensitivity and 99.8% accuracy. Analyses showed that the algorithm was robust when quality of data was moderately compromised. Conclusion: This study demonstrated high sensitivity and accuracy of an algorithm to create linkages between a registry and an administrative database using indirect identifiers. The methodology will enable long-term surveillance and outcome assessment of a wide variety of devices and procedures. Variations in the coding of procedures, availability of indirect identifiers, and their quality have limited impact on this algorithm.

AB - Background: Registries and administrative databases have unique and complementary strengths in device epidemiologic studies. We sought to develop, validate, and assess a sequential algorithm using indirect identifiers to link registry and administrative data. Methods: Hip and knee arthroplasty procedures performed at 6 New York State hospitals enrolled in American Joint Replacement Registry in 2014 were included. After conducting a direct linkage using patient identifiers including name and social security numbers, we validated the methodology of indirect linkage using facility ID, patients’ year and month of birth, sex, and zip code, and procedure date and site (hip/knee). We further evaluated the influence of absent indirect identifier(s) and compromised data quality on linkage success. Results: Using our sequential algorithm, 3739 of the 4063 directly linked records (92.03%) were matched with indirect identifiers, with an accuracy of >99.9%. Main reasons for nonmatching included discrepancies in procedure codes and dates. When one of the indirect identifiers was not available, the linkage algorithm still achieved over 90% sensitivity and 99.8% accuracy. Analyses showed that the algorithm was robust when quality of data was moderately compromised. Conclusion: This study demonstrated high sensitivity and accuracy of an algorithm to create linkages between a registry and an administrative database using indirect identifiers. The methodology will enable long-term surveillance and outcome assessment of a wide variety of devices and procedures. Variations in the coding of procedures, availability of indirect identifiers, and their quality have limited impact on this algorithm.

KW - data linkage

KW - device evaluation

KW - joint arthroplasty

KW - orthopedic device registry

KW - validation

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

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

U2 - 10.1016/j.arth.2019.01.063

DO - 10.1016/j.arth.2019.01.063

M3 - Article

C2 - 30803801

AN - SCOPUS:85061839475

VL - 34

SP - 1076-1081.e0

JO - Journal of Arthroplasty

JF - Journal of Arthroplasty

SN - 0883-5403

IS - 6

ER -