Hostname: page-component-89b8bd64d-n8gtw Total loading time: 0 Render date: 2026-05-07T02:26:02.142Z Has data issue: false hasContentIssue false

Are major lower extremity amputations well recorded in primary care electronic health records?: Insights from primary care electronic health records in England

Published online by Cambridge University Press:  28 November 2022

Anna Meffen*
Affiliation:
Department of Health Sciences, University of Leicester, Leicester, UK Department of Cardiovascular Sciences, University of Leicester, British Heart Foundation Cardiovascular Research Centre, Glenfield General Hospital, Leicester, UK
Robert D. Sayers
Affiliation:
Department of Cardiovascular Sciences, University of Leicester, British Heart Foundation Cardiovascular Research Centre, Glenfield General Hospital, Leicester, UK
Clare L. Gillies
Affiliation:
Diabetes Research Centre, University of Leicester, Leicester, UK
Kamlesh Khunti
Affiliation:
Diabetes Research Centre, University of Leicester, Leicester, UK
Laura J. Gray
Affiliation:
Department of Health Sciences, University of Leicester, Leicester, UK
*
Author for correspondence: Anna Meffen, Department of Health Sciences, University of Leicester, Leicester, UK, E-mail: am1173@le.ac.uk
Rights & Permissions [Opens in a new window]

Abstract

Aims:

Major lower extremity amputations (MLEAs) are understood to be well recorded in secondary care in England in the Hospital Episode Statistics (HES) database. It is unclear how well MLEAs are recorded in primary care databases.

Background:

This study compared MLEA event case ascertainment in Clinical Practice Research Datalink (CPRD) to that in HES.

Methods:

MLEA events were ascertained in CPRD and in HES linkage between 1 January 2010 and 31 December 2019. The number of MLEA events and the number of patients with at least one MLEA in each database were recorded and compared. Individual events were matched between the databases using varying date-matching windows. Reasons for differences in case ascertainment were explored.

Findings:

In total 23 262 patients had at least one MLEA record, 8716 (37.5%) had an MLEA record in HES only, 5393 (23.2%) in CPRD only and 9153 (39.4%) in both. Out of a total of 75 221 events, 13 071 (62.4%) were recorded in HES only and 44 151 (81.3%) in CPRD only. 7874 (37.6%) of HES events were recorded in CPRD and 10 125 (18.6%) of CPRD events were recorded in HES when using the maximum date matching window of 28 days plus the time between admission and procedure. The main reasons for differences in case ascertainment included, re-recordings and miscoding in CPRD.

Compared to HES, MLEAs are poorly recorded in CPRD predominantly due to re-recordings of events and miscoding procedures. CPRD data cannot solely be relied upon to ascertain cases of MLEA; however, HES linkage to CPRD may be useful to obtain medical history of diagnoses, medication and diagnostic tests.

Information

Type
Research
Creative Commons
Creative Common License - CCCreative Common License - BY
This is an Open Access article, distributed under the terms of the Creative Commons Attribution licence (http://creativecommons.org/licenses/by/4.0/), which permits unrestricted re-use, distribution and reproduction, provided the original article is properly cited.
Copyright
© The Author(s), 2022. Published by Cambridge University Press
Figure 0

Figure 1: Venn diagram of (A) The number (%) of patients with at least one MLEA in HES, CPRD and patients with at least one MLEA in both HES and CPRD. (B) The number (%) of events recorded in HES, CPRD and the number of events from each database that are recorded in both.Source: Events were merged with the date window HES admit date to 28 days after HES event date. CPRD – Clinical Practice Research Datalink, HES – Hospital Episode Statistics, MLEA – Major lower extremity amputation.*These differ for each database as there were multiple CPRD events that relate to one HES event.

Figure 1

Table 1. Number of MLEA records per patient in HES and CPRD

Figure 2

Table 2. Patient demographic by case-ascertainment source based on the highest physical level of MLEA for each patient

Figure 3

Figure 2: Case-ascertainment source of MLEA by patient demographic based on the highest physical level of MLEA for each patient.Source: Missing/unspecified values: Ethnicity – missing = 1548 (6.7%); Deprivation – missing = 860 (3.4%); Region – missing = 17 (0.07%); Urban/rural – missing = 701 (13.0%). Deprivation quintile: 1 = least deprived; 5 = most deprived. CPRD – Clinical Practice Research Datalink, HES – Hospital Episode Statistics.

Figure 4

Table 3. Results of matching MLEA events in HES to events CPRD for each match window

Figure 5

Figure 3: Percentage of matched events for each date matching window.Source: Denominators for percentages differ and are as described in Table 3.CPRD – Clinical Practice Research Datalink, HES – Hospital Episode Statistics, MLEA – Major lower extremity amputation.Total HES events = 20 945Total CPRD events = 54 276Total HES & CPRD events = 75 265Date match windows are:Exact – Matched CPRD observation date on exact HES event date+ 7 – Matched CPRD observation date between HES admit date and HES event date + 7 days+ 14 – Matched CPRD observation date between HES admit date and HES event date + 14 days+ 21 – Matched CPRD observation date between HES admit date and HES event date + 21 days+ 28 – Matched CPRD observation date between HES admit date and HES event date + 28 days.

Figure 6

Figure 4: Sensitivity analysis – Venn diagram of: (A) The number (%) of patients with at least one MLEA in HES, CPRD and patients with at least one MLEA in both HES and CPRD. (B) The number (%) of events recorded in HES, CPRD and the number of events from each database that are recorded in both. Values in red show the difference (n (%)) from Figure 1.Source: Events were merged with the date window HES admit date to 28 days after HES event date. CPRD – Clinical Practice Research Datalink, HES – Hospital Episode Statistics, MLEA – Major lower extremity amputation.* These differ for each database as there were multiple CPRD events that relate to one HES event.

Supplementary material: File

Meffen et al. supplementary material

Meffen et al. supplementary material
Download Meffen et al. supplementary material(File)
File 14.9 KB