Skip to main content
Top
Published in: BMC Medical Informatics and Decision Making 1/2014

Open Access 01-12-2014 | Research article

Optimal strategy for linkage of datasets containing a statistical linkage key and datasets with full personal identifiers

Authors: Lee K Taylor, Katie Irvine, Renee Iannotti, Taylor Harchak, Kim Lim

Published in: BMC Medical Informatics and Decision Making | Issue 1/2014

Login to get access

Abstract

Background

Linkage of aged care and hospitalisation data provides valuable information on patterns of health service utilisation among aged care service recipients. Many aged care datasets in Australia contain a Statistical Linkage Key (SLK-581) instead of full personal identifiers. We linked hospital and death records using a full probabilistic strategy, the SLK-581, and three combined strategies; and compared results for each strategy.

Methods

Linkage of Admitted Patient Data for 2000–01 to 2008–09 and Registry of Births, Deaths and Marriages death registration data for 2008–09 for New South Wales, Australia, was carried out using probabilistic methods and compared to links created using four strategies incorporating a SLK-581. The Basic SLK-581 strategy used the SLK-581 alone. The Most Recent SLK-581, Most Frequent SLK-581, and Any Match SLK-581 strategies leveraged probabilistic links between hospital records drawn from the Centre for Health Record Linkage Master Linkage Key. Rates of hospitalisations among people who died were calculated for each strategy and a range of health conditions.

Results

Compared to full probabilistic linkage, the basic SLK-581 strategy produced substantial rates of missed links that increased over the study period and produced underestimates of hospitalisation rates that varied by health condition. The Most Recent SLK-581, Most Frequent SLK-581, and Any Match SLK-581 strategies resulted in substantially lower rates of underestimation than the Basic SLK-581. The Any Match SLK-581 strategy gave results closest to full probabilistic linkage.

Conclusions

Hospitalisation rates prior to death are substantially underestimated by linkage using a SLK-581 alone. Linkage rates can be increased by combining deterministic methods with probabilistically created links across hospital records.
Appendix
Available only for authorised users
Literature
1.
go back to reference Karmel R: Transitions between aged care services: AIHW Cat. no. CSI 2. 2005, AIHW: Canberra Karmel R: Transitions between aged care services: AIHW Cat. no. CSI 2. 2005, AIHW: Canberra
2.
go back to reference Australian Institute of Health and Welfare: Data linkage series no. 11: Cat. no. CSI 11. Comparing an SLK-based and a name-based data linkage strategy: an investigation into the PIAC linkage. 2011, Canberra: AIHW Australian Institute of Health and Welfare: Data linkage series no. 11: Cat. no. CSI 11. Comparing an SLK-based and a name-based data linkage strategy: an investigation into the PIAC linkage. 2011, Canberra: AIHW
3.
go back to reference Australian Government Department of Health and Ageing: Home and community care program minimum data set 2009–10 annual bulletin. 2011, Canberra: Australian Government Department of Health and Ageing Australian Government Department of Health and Ageing: Home and community care program minimum data set 2009–10 annual bulletin. 2011, Canberra: Australian Government Department of Health and Ageing
5.
go back to reference Karmel R: Data linkage protocols using a statistical linkage key: AIHW Cat. no. CS1. 2005, AIHW: Canberra Karmel R: Data linkage protocols using a statistical linkage key: AIHW Cat. no. CS1. 2005, AIHW: Canberra
6.
go back to reference Ryan T, Holmes B, Gibson D: A national minimum data set for home and community care. 1999, AIHW: Canberra Ryan T, Holmes B, Gibson D: A national minimum data set for home and community care. 1999, AIHW: Canberra
8.
go back to reference Karmel R, Gibson D: Event-based record linkage in health and aged care services data: a methodological innovation. BMC Health Serv Res. 2007, 7: 154-10.1186/1472-6963-7-154.CrossRefPubMedPubMedCentral Karmel R, Gibson D: Event-based record linkage in health and aged care services data: a methodological innovation. BMC Health Serv Res. 2007, 7: 154-10.1186/1472-6963-7-154.CrossRefPubMedPubMedCentral
9.
go back to reference Karmel R, Rosman D: Linkage of health and aged care service events: comparing linkage and event selection methods. BMC Health Serv Res. 2008, 8: 149-10.1186/1472-6963-8-149.CrossRefPubMedPubMedCentral Karmel R, Rosman D: Linkage of health and aged care service events: comparing linkage and event selection methods. BMC Health Serv Res. 2008, 8: 149-10.1186/1472-6963-8-149.CrossRefPubMedPubMedCentral
10.
go back to reference Karmel R, Anderson P, Gibson D, Peut A, Duckett S, Wells Y: Empirical aspects of record linkage across multiple data sets using statistical linkage keys: the experience of the PIAC cohort study. BMC Health Serv Res. 2010, 10: 41-10.1186/1472-6963-10-41.CrossRefPubMedPubMedCentral Karmel R, Anderson P, Gibson D, Peut A, Duckett S, Wells Y: Empirical aspects of record linkage across multiple data sets using statistical linkage keys: the experience of the PIAC cohort study. BMC Health Serv Res. 2010, 10: 41-10.1186/1472-6963-10-41.CrossRefPubMedPubMedCentral
11.
go back to reference Australian Bureau of Statistics: Catalogue No. 3101.0. Australian demographic statistics, December 2011. 2012, Canberra: ABS Australian Bureau of Statistics: Catalogue No. 3101.0. Australian demographic statistics, December 2011. 2012, Canberra: ABS
12.
go back to reference National Centre for Classification in Health: The international statistical classification of diseases and related health problems, tenth revision, Australian modification (ICD-10-AM). 2010, Sydney: NCCH National Centre for Classification in Health: The international statistical classification of diseases and related health problems, tenth revision, Australian modification (ICD-10-AM). 2010, Sydney: NCCH
15.
go back to reference Kelman CW, Bass AJ, Holman CDJ: Research use of linked health data – a best practice protocol. Aust N Z J Public Health. 2002, 26: 251-255. 10.1111/j.1467-842X.2002.tb00682.x.CrossRefPubMed Kelman CW, Bass AJ, Holman CDJ: Research use of linked health data – a best practice protocol. Aust N Z J Public Health. 2002, 26: 251-255. 10.1111/j.1467-842X.2002.tb00682.x.CrossRefPubMed
17.
go back to reference Page A, Ambrose S, Glover J, Hetzel D: Atlas of avoidable hospitalisations in Australia: ambulatory care-sensitive conditions. 2007, Adelaide: Public Health Information Development Unit, University of Adelaide and Australian Institute of Health and Welfare Page A, Ambrose S, Glover J, Hetzel D: Atlas of avoidable hospitalisations in Australia: ambulatory care-sensitive conditions. 2007, Adelaide: Public Health Information Development Unit, University of Adelaide and Australian Institute of Health and Welfare
18.
go back to reference SAS Institute Inc: SAS Software, Version 9.2. 2009, Cary, NC SAS Institute Inc: SAS Software, Version 9.2. 2009, Cary, NC
Metadata
Title
Optimal strategy for linkage of datasets containing a statistical linkage key and datasets with full personal identifiers
Authors
Lee K Taylor
Katie Irvine
Renee Iannotti
Taylor Harchak
Kim Lim
Publication date
01-12-2014
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2014
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/1472-6947-14-85

Other articles of this Issue 1/2014

BMC Medical Informatics and Decision Making 1/2014 Go to the issue