Skip to main content
Top
Published in: BMC Health Services Research 1/2019

Open Access 01-12-2019 | Care | Research article

Linking observational data from general practice, hospital admissions and diabetes clinic databases: can it be used to predict hospital admission?

Authors: Sarah Dennis, Jane Taggart, Hairong Yu, Bin Jalaludin, Mark F. Harris, Siaw-Teng Liaw

Published in: BMC Health Services Research | Issue 1/2019

Login to get access

Abstract

Background

Linking process of care data from general practice (GP) and hospital data may provide more information about the risk of hospital admission and re-admission for people with type-2 diabetes mellitus (T2DM). This study aimed to extract and link data from a hospital, a diabetes clinic (DC). A second aim was to determine whether the data could be used to predict hospital admission for people with T2DM.

Methods

Data were extracted using the GRHANITE™ extraction and linkage tool. The data from nine GPs and the DC included data from the two years prior to the hospital admission. The date of the first hospital admission for patients with one or more admissions was the index admission. For those patients without an admission, the census date 31/03/2014 was used in all outputs requiring results prior to an admission. Readmission was any admission following the index admission.
The data were summarised to provide a comparison between two groups of patients: 1) Patients with a diagnosis of T2DM who had been treated at a GP and had a hospital admission and 2) Patients with a diagnosis of T2DM who had been treated at a GP and did not have a hospital admission.

Results

Data were extracted for 161,575 patients from the three data sources, 644 patients with T2DM had data linked between the GPs and the hospital. Of these, 170 also had data linked with the DC. Combining the data from the different data sources improved the overall data quality for some attributes particularly those attributes that were recorded consistently in the hospital admission data. The results from the modelling to predict hospital admission were plausible given the issues with data completeness.

Conclusion

This project has established the methodology (tools and processes) to extract, link, aggregate and analyse data from general practices, hospital admission data and DC data. This study methodology involved the establishment of a comparator/control group from the same sites to compare and contrast the predictors of admission, addressing a limitation of most published risk stratification and admission prediction studies. Data completeness needs to be improved for this to be useful to predict hospital admissions.
Literature
2.
go back to reference Khalid JM, Raluy-Callado M, Curtis BH, Boye KS, Maguire A, Reaney M. Rates and risk of hospitalisation among patients with type 2 diabetes: retrospective cohort study using the UK general practice research database linked to English hospital episode statistics. Int J Clin Pract. 2014;68(1):40–8.PubMedCrossRef Khalid JM, Raluy-Callado M, Curtis BH, Boye KS, Maguire A, Reaney M. Rates and risk of hospitalisation among patients with type 2 diabetes: retrospective cohort study using the UK general practice research database linked to English hospital episode statistics. Int J Clin Pract. 2014;68(1):40–8.PubMedCrossRef
3.
go back to reference Katterl R, Anikeeva O, Butler C, Brown L, Smith B, Bywood P. Potentially avoidable hospitalisations in Australia: causes for hospitalisations and primary health care interventions. Primary Health Care Research & Information Service: Adelaide; 2012. Katterl R, Anikeeva O, Butler C, Brown L, Smith B, Bywood P. Potentially avoidable hospitalisations in Australia: causes for hospitalisations and primary health care interventions. Primary Health Care Research & Information Service: Adelaide; 2012.
4.
go back to reference Bottle A, Millett C, Xie Y, Saxena S, Wachter RM, Majeed A. Quality of primary care and hospital admissions for diabetes mellitus in England. The Journal of ambulatory care management. 2008;31(3):226–38.PubMedCrossRef Bottle A, Millett C, Xie Y, Saxena S, Wachter RM, Majeed A. Quality of primary care and hospital admissions for diabetes mellitus in England. The Journal of ambulatory care management. 2008;31(3):226–38.PubMedCrossRef
5.
go back to reference Comino EJ, Tran DT, Taggart JR, Liaw S-T, Ruscoe W, Snow JM, et al. A preliminary study of the relationship between general practice care and hospitalisation using a diabetes register. CARDIAB Australian Health Review. 2013;37(2):210–7.PubMedCrossRef Comino EJ, Tran DT, Taggart JR, Liaw S-T, Ruscoe W, Snow JM, et al. A preliminary study of the relationship between general practice care and hospitalisation using a diabetes register. CARDIAB Australian Health Review. 2013;37(2):210–7.PubMedCrossRef
6.
go back to reference Nichols GA, Joshua-Gotlib S, Parasuraman S. Glycemic control and risk of cardiovascular disease hospitalization and all-cause mortality. J Am Coll Cardiol. 2013;62(2):121–7.PubMedCrossRef Nichols GA, Joshua-Gotlib S, Parasuraman S. Glycemic control and risk of cardiovascular disease hospitalization and all-cause mortality. J Am Coll Cardiol. 2013;62(2):121–7.PubMedCrossRef
7.
go back to reference Emery J, Boyle D. Data linkage. Aust Fam Physician. 2017;46:615–9.PubMed Emery J, Boyle D. Data linkage. Aust Fam Physician. 2017;46:615–9.PubMed
8.
go back to reference National Health & Hospital Reform Commission. A Healthier Future For All Australians – Final Report of the National Health and Hospitals Reform Commission. Commonwealth of Australia, Department of Health and Ageing; 2009. National Health & Hospital Reform Commission. A Healthier Future For All Australians – Final Report of the National Health and Hospitals Reform Commission. Commonwealth of Australia, Department of Health and Ageing; 2009.
9.
go back to reference Liaw S-T, Chen H-Y, Maneze D, Taggart J, Dennis S, Vagholkar S, et al. Health reform: is routinely collected electronic information fit for purpose? Emergency Medicine Australasia. 2012;24(1):57–63.PubMedCrossRef Liaw S-T, Chen H-Y, Maneze D, Taggart J, Dennis S, Vagholkar S, et al. Health reform: is routinely collected electronic information fit for purpose? Emergency Medicine Australasia. 2012;24(1):57–63.PubMedCrossRef
10.
go back to reference Siaw-Teng Liaw, Jane Taggart, Sarah Dennis, Anthony Yeo. Data quality and fitness for purpose of routinely collected data – a general practice case study from an electronic Practice-Based Research Network (ePBRN).". AMIA Annual Symposium Proc. 2011:785–94. Siaw-Teng Liaw, Jane Taggart, Sarah Dennis, Anthony Yeo. Data quality and fitness for purpose of routinely collected data – a general practice case study from an electronic Practice-Based Research Network (ePBRN).". AMIA Annual Symposium Proc. 2011:785–94.
11.
go back to reference Wang R. A product perspective on total data quality management. Communications of the ACM. 1998;41(2 (Feb)):58–65.CrossRef Wang R. A product perspective on total data quality management. Communications of the ACM. 1998;41(2 (Feb)):58–65.CrossRef
12.
go back to reference Redman T. Measuring data accuracy. In: Rea W, editor. Information Quality. Armonk: ME Sharpe Inc; 2005. p. 21. Redman T. Measuring data accuracy. In: Rea W, editor. Information Quality. Armonk: ME Sharpe Inc; 2005. p. 21.
13.
go back to reference Wand Y, Wang R. Anchoring data quality dimensions in ontological foundations. Communications of the ACM. 1996;39(11 (Nov)):86–9.CrossRef Wand Y, Wang R. Anchoring data quality dimensions in ontological foundations. Communications of the ACM. 1996;39(11 (Nov)):86–9.CrossRef
14.
go back to reference Canadian Institute for Health Information. The CIHI Data Quality Framework. Ottawa: CIHI; 2009. Canadian Institute for Health Information. The CIHI Data Quality Framework. Ottawa: CIHI; 2009.
15.
go back to reference Liaw S, Taggart J, Dennis S, Yeo A. Data quality and fitness for purpose of routinely collected data – a case study from an electronic practice-based research network (ePBRN). American medical informatics association annual symposium 2011. Washington DC: Springer Verlag; 2011. Liaw S, Taggart J, Dennis S, Yeo A. Data quality and fitness for purpose of routinely collected data – a case study from an electronic practice-based research network (ePBRN). American medical informatics association annual symposium 2011. Washington DC: Springer Verlag; 2011.
16.
go back to reference Liaw S, Rahimi A, Ray P, Taggart J, Dennis S, de Lusignan S, et al. Towards an ontology for data quality in integrated chronic disease: a realist review of the literature. Int J Med Inform. 2013;82(1):10–24.PubMedCrossRef Liaw S, Rahimi A, Ray P, Taggart J, Dennis S, de Lusignan S, et al. Towards an ontology for data quality in integrated chronic disease: a realist review of the literature. Int J Med Inform. 2013;82(1):10–24.PubMedCrossRef
17.
go back to reference Kahn MG, Callahan TJ, Barnard J, Bauck AE, Brown J, Davidson BN, et al. A Harmonized Data Quality Assessment Terminology and Framework for the Secondary Use of Electronic Health Record Data. EGEMS (Wash DC). 2016;4(1):1244-.CrossRef Kahn MG, Callahan TJ, Barnard J, Bauck AE, Brown J, Davidson BN, et al. A Harmonized Data Quality Assessment Terminology and Framework for the Secondary Use of Electronic Health Record Data. EGEMS (Wash DC). 2016;4(1):1244-.CrossRef
18.
go back to reference Liaw S-T, Taggart J, Yu H, de Lusignan S, Kuziemsky C, Hayen A. Integrating electronic health record information to support integrated care: practical application of ontologies to improve the accuracy of diabetes disease registers. J Biomed Inform. 2014;52:364–72.PubMedCrossRef Liaw S-T, Taggart J, Yu H, de Lusignan S, Kuziemsky C, Hayen A. Integrating electronic health record information to support integrated care: practical application of ontologies to improve the accuracy of diabetes disease registers. J Biomed Inform. 2014;52:364–72.PubMedCrossRef
19.
go back to reference Boyle D, Liaw ST, Crowden A. GRHANITE™: generic software demonstrating advanced security, ethical consent and confidentiality processes for clinical data sharing, audit and research. The Australasian Bioethics Association/Australian and New Zealand Institute of Health Law and Ethics; 2007. Boyle D, Liaw ST, Crowden A. GRHANITE™: generic software demonstrating advanced security, ethical consent and confidentiality processes for clinical data sharing, audit and research. The Australasian Bioethics Association/Australian and New Zealand Institute of Health Law and Ethics; 2007.
20.
go back to reference The Royal Australian College of General Practitioners. General practice management of type 2 diabetes: 2016–18. East Melbourne, Vic: RACGP; 2016. The Royal Australian College of General Practitioners. General practice management of type 2 diabetes: 2016–18. East Melbourne, Vic: RACGP; 2016.
21.
go back to reference Boyle D, Rafael N. BioGrid Australia and GRHANITE™: privacy-protecting subject matching. Stud Health Technol Inform. 2011;168:24–34.PubMed Boyle D, Rafael N. BioGrid Australia and GRHANITE™: privacy-protecting subject matching. Stud Health Technol Inform. 2011;168:24–34.PubMed
22.
go back to reference Rahimi A, Liaw S-T, Taggart J, Ray P, Yu H. Validating an ontology-based algorithm to identify patients with type 2 diabetes mellitus in electronic health records. Int J Med Inform. 2014;83(10):768–78.PubMedCrossRef Rahimi A, Liaw S-T, Taggart J, Ray P, Yu H. Validating an ontology-based algorithm to identify patients with type 2 diabetes mellitus in electronic health records. Int J Med Inform. 2014;83(10):768–78.PubMedCrossRef
23.
go back to reference Kim H, Ross JS, Melkus GD, Zhao Z, Boockvar K. Scheduled and unscheduled hospital readmissions among diabetes patients. Am J Manag Care. 2010;16(10):760–7.PubMedPubMedCentral Kim H, Ross JS, Melkus GD, Zhao Z, Boockvar K. Scheduled and unscheduled hospital readmissions among diabetes patients. Am J Manag Care. 2010;16(10):760–7.PubMedPubMedCentral
24.
go back to reference Comino EJ, Harris MF, Islam MF, Tran DT, Jalaludin B, Jorm L, et al. Impact of diabetes on hospital admission and length of stay among a general population aged 45 year or more: a record linkage study. BMC Health Serv Res. 2015;15(1):1–13.CrossRef Comino EJ, Harris MF, Islam MF, Tran DT, Jalaludin B, Jorm L, et al. Impact of diabetes on hospital admission and length of stay among a general population aged 45 year or more: a record linkage study. BMC Health Serv Res. 2015;15(1):1–13.CrossRef
25.
go back to reference Jackson G, Walker B. O, Smith J, Papa D, Field A. Hospital admissions for people with diagnosed diabetes: Challenges for diabetes prevention and management programmes. New Zealand Medical Journal. 1288;122(1288). Jackson G, Walker B. O, Smith J, Papa D, Field A. Hospital admissions for people with diagnosed diabetes: Challenges for diabetes prevention and management programmes. New Zealand Medical Journal. 1288;122(1288).
26.
go back to reference Bo S, Ciccone G, Grassi G, Gancia R, Rosato R, Merletti F, et al. Patients with type 2 diabetes had higher rates of hospitalization than the general population. J Clin Epidemiol. 2004;57(11):1196–201.PubMedCrossRef Bo S, Ciccone G, Grassi G, Gancia R, Rosato R, Merletti F, et al. Patients with type 2 diabetes had higher rates of hospitalization than the general population. J Clin Epidemiol. 2004;57(11):1196–201.PubMedCrossRef
27.
go back to reference Burke V, Zhao Y, Lee AH, Hunter E, Spargo RM, Gracey M, et al. Predictors of type 2 diabetes and diabetes-related hospitalisation in an Australian Aboriginal cohort. Diabetes Res Clin Pract. 2007;78(3):360–8.PubMedCrossRef Burke V, Zhao Y, Lee AH, Hunter E, Spargo RM, Gracey M, et al. Predictors of type 2 diabetes and diabetes-related hospitalisation in an Australian Aboriginal cohort. Diabetes Res Clin Pract. 2007;78(3):360–8.PubMedCrossRef
28.
go back to reference Lind M, Olsson M, Rosengren A, Svensson AM, Bounias I, Gudbjornsdottir S. The relationship between glycaemic control and heart failure in 83,021 patients with type 2 diabetes. Diabetologia. 2012;55(11):2946–53.PubMedCrossRef Lind M, Olsson M, Rosengren A, Svensson AM, Bounias I, Gudbjornsdottir S. The relationship between glycaemic control and heart failure in 83,021 patients with type 2 diabetes. Diabetologia. 2012;55(11):2946–53.PubMedCrossRef
29.
go back to reference Brameld KJ, Ward A, Gavin AL, Holman CD. Health outcomes in people with type 2 diabetes. A record linkage study. Aust Fam Physician. 2002;31(8):775–8.PubMed Brameld KJ, Ward A, Gavin AL, Holman CD. Health outcomes in people with type 2 diabetes. A record linkage study. Aust Fam Physician. 2002;31(8):775–8.PubMed
30.
go back to reference Taggart J, Liaw S-T, Yu H. Structured data quality reports to improve EHR data quality. Int J Med Inform. 2015;84(12):1094–8.PubMedCrossRef Taggart J, Liaw S-T, Yu H. Structured data quality reports to improve EHR data quality. Int J Med Inform. 2015;84(12):1094–8.PubMedCrossRef
31.
go back to reference Royal Australian College of General Practitioners. Standards for general practices (4th edition). East Melbourne, Australia: The Royal Australian College of General Practitioners; 2015. Royal Australian College of General Practitioners. Standards for general practices (4th edition). East Melbourne, Australia: The Royal Australian College of General Practitioners; 2015.
32.
go back to reference van der Bij S, Khan N, ten Veen P, de Bakker DH, Verheij RA. Improving the quality of EHR recording in primary care: a data quality feedback tool. J Am Med Inform Assoc. 2017;24(1):81–7.PubMedCrossRef van der Bij S, Khan N, ten Veen P, de Bakker DH, Verheij RA. Improving the quality of EHR recording in primary care: a data quality feedback tool. J Am Med Inform Assoc. 2017;24(1):81–7.PubMedCrossRef
33.
go back to reference Verheij RA, Curcin V, Delaney BC, McGilchrist MM. Possible sources of Bias in primary care electronic health record data use and reuse. J Med Internet Res. 2018;20(5):e185.PubMedPubMedCentralCrossRef Verheij RA, Curcin V, Delaney BC, McGilchrist MM. Possible sources of Bias in primary care electronic health record data use and reuse. J Med Internet Res. 2018;20(5):e185.PubMedPubMedCentralCrossRef
34.
go back to reference Henderson J, Britt H, Miller G. Extent and utilisation of computerisation in Australian general practice. Med J Aust. 2006;185(2):84–7.PubMed Henderson J, Britt H, Miller G. Extent and utilisation of computerisation in Australian general practice. Med J Aust. 2006;185(2):84–7.PubMed
35.
go back to reference Liaw S-T, Kearns R, Taggart J, Frank O, Lane R, Tam M, et al. The informatics capability maturity of integrated primary care Centres in Australia. Int J Med Inform. 2017;105:89–97.PubMedCrossRef Liaw S-T, Kearns R, Taggart J, Frank O, Lane R, Tam M, et al. The informatics capability maturity of integrated primary care Centres in Australia. Int J Med Inform. 2017;105:89–97.PubMedCrossRef
36.
go back to reference Calvert M, Shankar A, McManus RJ, Lester H, Freemantle N. Effect of the quality and outcomes framework on diabetes care in the United Kingdom: retrospective cohort study. BMJ. 2009;338(may26_2):b1870-.PubMedPubMedCentralCrossRef Calvert M, Shankar A, McManus RJ, Lester H, Freemantle N. Effect of the quality and outcomes framework on diabetes care in the United Kingdom: retrospective cohort study. BMJ. 2009;338(may26_2):b1870-.PubMedPubMedCentralCrossRef
37.
go back to reference Bij S. van der V, R. Inzet variabiliseringsgelden 2013 leidt tot belangrijke verbetering EPD. SYNTHESIS. 2013;12(4):16–7. Bij S. van der V, R. Inzet variabiliseringsgelden 2013 leidt tot belangrijke verbetering EPD. SYNTHESIS. 2013;12(4):16–7.
38.
go back to reference Knight AW, Caesar C, Ford D, Coughlin A, Frick C. Improving primary care in Australia through the Australian primary care Collaboratives program: a quality improvement report. BMJ Quality & Safety. 2012. Knight AW, Caesar C, Ford D, Coughlin A, Frick C. Improving primary care in Australia through the Australian primary care Collaboratives program: a quality improvement report. BMJ Quality & Safety. 2012.
39.
go back to reference Knight A, Dhillon M, Lembke T, Mitchell C. The eCollaborative: using a quality improvement collaborative to implement the national eHealth record system in Australian primary care practices. International Journal for Quality in Health Care Advance Access. 2014:1–7. Knight A, Dhillon M, Lembke T, Mitchell C. The eCollaborative: using a quality improvement collaborative to implement the national eHealth record system in Australian primary care practices. International Journal for Quality in Health Care Advance Access. 2014:1–7.
40.
go back to reference McDonald J, Lane R, Kearns R, Ward B, Powell Davies G, Fuller J, et al. Emerging models of integrated primary health care centres: how they optimise access and integration and the influence of characteristics and organisational factors. Centre for Primary Health Care and Equity UNSW and Australian Primary Health Care Research Institute: Sydeny; 2015. McDonald J, Lane R, Kearns R, Ward B, Powell Davies G, Fuller J, et al. Emerging models of integrated primary health care centres: how they optimise access and integration and the influence of characteristics and organisational factors. Centre for Primary Health Care and Equity UNSW and Australian Primary Health Care Research Institute: Sydeny; 2015.
41.
go back to reference Gruber TR. Toward principles for the design of ontologies used for knowledge sharing. Int J Human Comput Stud. 1995;43(5–6).CrossRef Gruber TR. Toward principles for the design of ontologies used for knowledge sharing. Int J Human Comput Stud. 1995;43(5–6).CrossRef
42.
go back to reference Civili C, Console M, De Giacomo G, Lembo D, Lenzerini M, Lepore L, et al. MASTRO STUDIO: managing ontology-based data access applications. Proceedings of the VLDB Endowment. 2013;6(12):1314–7.CrossRef Civili C, Console M, De Giacomo G, Lembo D, Lenzerini M, Lepore L, et al. MASTRO STUDIO: managing ontology-based data access applications. Proceedings of the VLDB Endowment. 2013;6(12):1314–7.CrossRef
43.
go back to reference Esswein S, Goasguen S, Post C, Hallstrom J, White D, Eidson G, editors. Towards ontology-based data quality inference in large-scale sensor networks 2012. Esswein S, Goasguen S, Post C, Hallstrom J, White D, Eidson G, editors. Towards ontology-based data quality inference in large-scale sensor networks 2012.
44.
go back to reference Geisler S, Weber S, Quix C, editors. Ontology-based data quality framework for data stream applications 2011. Geisler S, Weber S, Quix C, editors. Ontology-based data quality framework for data stream applications 2011.
45.
go back to reference Jonnagaddala J, Liaw S, Ray P. Impact of data quality assessment on development of clinical predictive models. Studies in health technology and informatics. 2015;216:1069.PubMed Jonnagaddala J, Liaw S, Ray P. Impact of data quality assessment on development of clinical predictive models. Studies in health technology and informatics. 2015;216:1069.PubMed
46.
go back to reference Johnson SG, Speedie S, Simon G, Kumar V, Westra BL. Application of an ontology for characterizing data quality for a secondary use of EHR data. Applied Clinical Informatics. 2016;7(1):69–88.PubMedPubMedCentralCrossRef Johnson SG, Speedie S, Simon G, Kumar V, Westra BL. Application of an ontology for characterizing data quality for a secondary use of EHR data. Applied Clinical Informatics. 2016;7(1):69–88.PubMedPubMedCentralCrossRef
Metadata
Title
Linking observational data from general practice, hospital admissions and diabetes clinic databases: can it be used to predict hospital admission?
Authors
Sarah Dennis
Jane Taggart
Hairong Yu
Bin Jalaludin
Mark F. Harris
Siaw-Teng Liaw
Publication date
01-12-2019
Publisher
BioMed Central
Keyword
Care
Published in
BMC Health Services Research / Issue 1/2019
Electronic ISSN: 1472-6963
DOI
https://doi.org/10.1186/s12913-019-4337-1

Other articles of this Issue 1/2019

BMC Health Services Research 1/2019 Go to the issue