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

Open Access 01-12-2019 | Research article

Developing a standardised approach to the aggregation of inpatient episodes into person-based spells in all specialties and psychiatric specialties

Authors: Sarah Rees, Ashley Akbari, Huw Collins, Sze Chim Lee, Amanda Marchant, Arfon Rees, Daniel Thayer, Ting Wang, Sophie Wood, Ann John

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

Login to get access

Abstract

Background

Electronic health record (EHR) data are available for research in all UK nations and cross-nation comparative studies are becoming more common. All UK inpatient EHRs are based around episodes, but episode-based analysis may not sufficiently capture the patient journey. There is no UK-wide method for aggregating episodes into standardised person-based spells. This study identifies two data quality issues affecting the creation of person-based spells, and tests four methods to create these spells, for implementation across all UK nations.

Methods

Welsh inpatient EHRs from 2013 to 2017 were analysed. Phase one described two data quality issues; transfers of care and episode sequencing. Phase two compared four methods for creating person spells. Measures were mean length of stay (LOS, expressed in days) and number of episodes per person spell for each method.

Results

3.5% of total admissions were transfers-in and 3.1% of total discharges were transfers-out. 68.7% of total transfers-in and 48.7% of psychiatric transfers-in had an identifiable preceding transfer-out, and 78.2% of total transfers-out and 59.0% of psychiatric transfers-out had an identifiable subsequent transfer-in. 0.2% of total episodes and 4.0% of psychiatric episodes overlapped with at least one other episode of any specialty.
Method one (no evidence of transfer required; overlapping episodes grouped together) resulted in the longest mean LOS (4.0 days for all specialties; 48.5 days for psychiatric specialties) and the fewest single episode person spells (82.4% of all specialties; 69.7% for psychiatric specialties). Method three (evidence of transfer required; overlapping episodes separated) resulted in the shortest mean LOS (3.7 days for all specialties; 45.8 days for psychiatric specialties) and the most single episode person spells; (86.9% for all specialties; 86.3% for psychiatric specialties).

Conclusions

Transfers-in appear better recorded than transfers-out. Transfer coding is incomplete, particularly for psychiatric specialties. The proportion of episodes that overlap is small but psychiatric episodes are disproportionately affected.
The most successful method for grouping episodes into person spells aggregated overlapping episodes and required no evidence of transfer from admission source/method or discharge destination codes. The least successful method treated overlapping episodes as distinct and required transfer coding. The impact of all four methods was greater for psychiatric specialties.
Literature
1.
go back to reference McIntosh A, Stewart R, John A, Smith D, Davis K, Sudlow C. Data science for mental health: a UK perspective on a global challenge. Lancet. 2016;3(10):993–8.PubMed McIntosh A, Stewart R, John A, Smith D, Davis K, Sudlow C. Data science for mental health: a UK perspective on a global challenge. Lancet. 2016;3(10):993–8.PubMed
10.
go back to reference Southworth Davis K, Bashford O, Jewell A, Shetty H, Stewart R, Sudlow C, Hotopf M. Using data linkage to electronic patient records to assess the validity of selected mental health diagnoses in English Hospital Episode Statistics (HES). PLoS One. 2018;13(3).CrossRef Southworth Davis K, Bashford O, Jewell A, Shetty H, Stewart R, Sudlow C, Hotopf M. Using data linkage to electronic patient records to assess the validity of selected mental health diagnoses in English Hospital Episode Statistics (HES). PLoS One. 2018;13(3).CrossRef
11.
go back to reference Herbert A, Wijlaars L, Zylbersztejn A, Cromwell D, Hardelid P. Data resource profile: hospital episode statistics admitted patient care (HES APC). Int J Epidemiol. 2017;46(4):1093.CrossRef Herbert A, Wijlaars L, Zylbersztejn A, Cromwell D, Hardelid P. Data resource profile: hospital episode statistics admitted patient care (HES APC). Int J Epidemiol. 2017;46(4):1093.CrossRef
12.
go back to reference Bandyopadhyay A, Tingay K, Borja MC, Griffiths L, Akbari A, Bedford H, Brophy S, Walton S, Dezateux C, Lyons R. Harmonising data from different sources to conduct research using linked survey and routine datasets. International Journal of Population Data Science. 2018;3(4). Bandyopadhyay A, Tingay K, Borja MC, Griffiths L, Akbari A, Bedford H, Brophy S, Walton S, Dezateux C, Lyons R. Harmonising data from different sources to conduct research using linked survey and routine datasets. International Journal of Population Data Science. 2018;3(4).
16.
go back to reference Busby J, Purdy S, Hollingsworth W. Calculating hospital length of stay using the Hospital Episode Statistics; a comparison of methodologies. BMC Health Services Research. 2017; 17 (347). Busby J, Purdy S, Hollingsworth W. Calculating hospital length of stay using the Hospital Episode Statistics; a comparison of methodologies. BMC Health Services Research. 2017; 17 (347).
17.
go back to reference Williams J, Mann R. Hospital episode statistics: time for clinicians to get involved? Clinical Medicine. 2002;2(1):34–7.CrossRef Williams J, Mann R. Hospital episode statistics: time for clinicians to get involved? Clinical Medicine. 2002;2(1):34–7.CrossRef
21.
go back to reference Aiello A, Roddy S. Inpatient coding and the diagnosis-related group. J Vasc Surg. 2017;66(5):1621–3.CrossRef Aiello A, Roddy S. Inpatient coding and the diagnosis-related group. J Vasc Surg. 2017;66(5):1621–3.CrossRef
22.
go back to reference Busse R, Geissler A, Quentin W, Wiley M. Diagnosis-related groups in Europe: moving towards transparency, efficiency and quality in hospitals. Open University Press: Maidenhead; 2011. Busse R, Geissler A, Quentin W, Wiley M. Diagnosis-related groups in Europe: moving towards transparency, efficiency and quality in hospitals. Open University Press: Maidenhead; 2011.
29.
go back to reference Kendrick S, Clarke J. The Scottish record linkage system. Health Bulletin (Edinburgh). 1993;51(2):72–9. Kendrick S, Clarke J. The Scottish record linkage system. Health Bulletin (Edinburgh). 1993;51(2):72–9.
30.
go back to reference J. Clarke, S. Kendrick and M. Sleigh. Specification of 'continuous stay' for SMR01 linked data, NHS National Services Scotland, 1995. J. Clarke, S. Kendrick and M. Sleigh. Specification of 'continuous stay' for SMR01 linked data, NHS National Services Scotland, 1995.
31.
go back to reference Hripcsak G, Duke J, Shah N, Reich C, Huser V, Schuemie M, Suchard M, Park R, Wong IC, Rijnbeek P, van der Lei J, Pratt N, Noren GN, Li YC, Stang P, Madigan D, Ryan P. Observational health data sciences and informatics (OHDSI): opportunities for observational researchers. Stud Health Technol Inform. 2015;216:574–8.PubMedPubMedCentral Hripcsak G, Duke J, Shah N, Reich C, Huser V, Schuemie M, Suchard M, Park R, Wong IC, Rijnbeek P, van der Lei J, Pratt N, Noren GN, Li YC, Stang P, Madigan D, Ryan P. Observational health data sciences and informatics (OHDSI): opportunities for observational researchers. Stud Health Technol Inform. 2015;216:574–8.PubMedPubMedCentral
33.
go back to reference Ceusters W, Blaisure J. A realism-based view on counts in OMOP's Common Data Model. In pHealth 2017: Proceedings of the 14th International conference of wearable micro and nano technologies for personalized health. 2017. Eindhoven, Netherlands. Ceusters W, Blaisure J. A realism-based view on counts in OMOP's Common Data Model. In pHealth 2017: Proceedings of the 14th International conference of wearable micro and nano technologies for personalized health. 2017. Eindhoven, Netherlands.
34.
go back to reference Ford D, Jones K, Verplancke J, Lyons R, John G, Brown G, Brooks C, Thompson S, Bodger O, Couch T, Leake K. The SAIL Databank: building a national architecture for e-health research and evaluation. BMC Health Services Research. 2009; 9 (157). Ford D, Jones K, Verplancke J, Lyons R, John G, Brown G, Brooks C, Thompson S, Bodger O, Couch T, Leake K. The SAIL Databank: building a national architecture for e-health research and evaluation. BMC Health Services Research. 2009; 9 (157).
35.
go back to reference Lyons R, Jones K, John G, Brooks C, Verplancke J, Ford D, Brown G, Leake K. The SAIL databank: linking multiple health and social care datasets. BMC Medical Informatics and Decision-making. 2009; 9 (3). Lyons R, Jones K, John G, Brooks C, Verplancke J, Ford D, Brown G, Leake K. The SAIL databank: linking multiple health and social care datasets. BMC Medical Informatics and Decision-making. 2009; 9 (3).
37.
go back to reference Peng M, Li B, Southern D, Eastwood C, Quan H. Constructing episodes of inpatient care: how to define hospital transfer in hospital administrative health data? Med Care. 2017;55(1):74–8.CrossRef Peng M, Li B, Southern D, Eastwood C, Quan H. Constructing episodes of inpatient care: how to define hospital transfer in hospital administrative health data? Med Care. 2017;55(1):74–8.CrossRef
39.
go back to reference Dr Foster case notes. Counting hospital activity: spells or episodes? BMJ. 2004; 329: 1207. Dr Foster case notes. Counting hospital activity: spells or episodes? BMJ. 2004; 329: 1207.
Metadata
Title
Developing a standardised approach to the aggregation of inpatient episodes into person-based spells in all specialties and psychiatric specialties
Authors
Sarah Rees
Ashley Akbari
Huw Collins
Sze Chim Lee
Amanda Marchant
Arfon Rees
Daniel Thayer
Ting Wang
Sophie Wood
Ann John
Publication date
01-12-2019
Publisher
BioMed Central
Published in
BMC Medical Informatics and Decision Making / Issue 1/2019
Electronic ISSN: 1472-6947
DOI
https://doi.org/10.1186/s12911-019-0953-2

Other articles of this Issue 1/2019

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