Sunny Chen1, William A Banks2,3, Meera Sheffrin4, William Bryson5, Marissa Black1,3, Stephen M Thielke1,5. 1. Geriatric Research, Education, and Clinical Center and Research and Development, Puget Sound VA Medical Center, Seattle, WA. 2. Research and Development, Puget Sound VA Medical Center, Seattle, WA. 3. Division of Gerontology and Geriatric Medicine, Department of Medicine and Department of Psychiatry and Behavioral Sciences, University of Washington School of Medicine, WA. 4. Geriatric Medicine, Division of General Medical Disciplines, Stanford University School of Medicine, Stanford, CA. 5. Department of Psychiatry and Behavioral Sciences, University of Washington School of Medicine, WA.
Abstract
Background: Spurious weights compromise the validity of summary measures, such as averages and trends. Even rare errors in weight records can undermine the utility of electronic medical record (EMR) data. Objective: We sought to estimate the prevalence of spurious weight values in a large EMR, to ascertain the likely causes, and to develop and test straightforward algorithms for identifying spurious weight data. Design: Using EMR data from 10,000 randomly selected patients aged ≥65 y in the VA system, we examined the percentage of weight change across various time intervals, from 1 to 3000 d. We examined descriptive results and developed 3 algorithms to categorize degree of weight change over time. On the basis of distributions, we identified cases that were most likely spurious. We manually reviewed these and categorized the type of error. Results: The data followed the expected distributions. The algorithms reliably identified spurious weight. Approximately 0.8% of all weights in the record appeared to be spurious and ∼1 in 5 patient charts included ≥1 spurious weight value. The most common type of error involved the misentry of a single digit (e.g., 148 for 178). Conclusions: Spurious weights are common in EMRs. Straightforward algorithms can identify and remove them, and thus enhance the reliability of EMR data.
Background: Spurious weights compromise the validity of summary measures, such as averages and trends. Even rare errors in weight records can undermine the utility of electronic medical record (EMR) data. Objective: We sought to estimate the prevalence of spurious weight values in a large EMR, to ascertain the likely causes, and to develop and test straightforward algorithms for identifying spurious weight data. Design: Using EMR data from 10,000 randomly selected patients aged ≥65 y in the VA system, we examined the percentage of weight change across various time intervals, from 1 to 3000 d. We examined descriptive results and developed 3 algorithms to categorize degree of weight change over time. On the basis of distributions, we identified cases that were most likely spurious. We manually reviewed these and categorized the type of error. Results: The data followed the expected distributions. The algorithms reliably identified spurious weight. Approximately 0.8% of all weights in the record appeared to be spurious and ∼1 in 5 patient charts included ≥1 spurious weight value. The most common type of error involved the misentry of a single digit (e.g., 148 for 178). Conclusions: Spurious weights are common in EMRs. Straightforward algorithms can identify and remove them, and thus enhance the reliability of EMR data.
Authors: Lauren A Stalbow; Michael H Preuss; Roelof A J Smit; Nathalie Chami; Lise Bjørkhaug; Ingvild Aukrust; Anna L Gloyn; Ruth J F Loos Journal: Diabetologia Date: 2022-10-11 Impact factor: 10.460
Authors: Julia Mueller; Rebecca Richards; Rebecca A Jones; Fiona Whittle; Jennifer Woolston; Marie Stubbings; Stephen J Sharp; Simon J Griffin; Jennifer Bostock; Carly A Hughes; Andrew J Hill; Amy L Ahern Journal: Obes Facts Date: 2022-04-13 Impact factor: 4.807
Authors: Charlotte S C Woolley; Ian G Handel; B Mark Bronsvoort; Jeffrey J Schoenebeck; Dylan N Clements Journal: PLoS One Date: 2020-01-24 Impact factor: 3.240