Department of Medical Sciences, Gastroenterology and Hepatology, Uppsala University, Uppsala.
IQVIA Sweden AB, Solna, Stockholm, Sweden.
Ups J Med Sci. 2022 Jan 27;127. doi: 10.48101/ujms.v127.8260. eCollection 2022.
Electronic medical records (EMRs) are adopted for storing patient-related healthcare information. Using data mining techniques, it is possible to make use of and derive benefit from this massive amount of data effectively. We aimed to evaluate validity of data extracted by the Customized eXtraction Program (CXP).
The CXP extracts and structures data in rapid standardised processes. The CXP was programmed to extract TNFα-native active ulcerative colitis (UC) patients from EMRs using defined International Classification of Disease-10 (ICD-10) codes. Extracted data were read in parallel with manual assessment of the EMR to compare with CXP-extracted data.
From the complete EMR set, 2,802 patients with code K51 (UC) were extracted. Then, CXP extracted 332 patients according to inclusion and exclusion criteria. Of these, 97.5% were correctly identified, resulting in a final set of 320 cases eligible for the study. When comparing CXP-extracted data against manually assessed EMRs, the recovery rate was 95.6-101.1% over the years with 96.1% weighted average sensitivity.
Utilisation of the CXP software can be considered as an effective way to extract relevant EMR data without significant errors. Hence, by extracting from EMRs, CXP accurately identifies patients and has the capacity to facilitate research studies and clinical trials by finding patients with the requested code as well as funnel down itemised individuals according to specified inclusion and exclusion criteria. Beyond this, medical procedures and laboratory data can rapidly be retrieved from the EMRs to create tailored databases of extracted material for immediate use in clinical trials.
电子病历（EMR）用于存储与患者相关的医疗保健信息。利用数据挖掘技术，可以有效地利用和从中受益于这些大量的数据。我们旨在评估自定义提取程序（CXP）提取的数据的有效性。
CXP 以快速标准化的流程提取和构建数据。CXP 被编程为使用定义的国际疾病分类第 10 版（ICD-10）代码从 EMR 中提取 TNFα-原生活动性溃疡性结肠炎（UC）患者的数据。提取的数据与 EMR 的手动评估并行读取，以与 CXP 提取的数据进行比较。
从完整的 EMR 集中，提取了 2802 名带有代码 K51（UC）的患者。然后，CXP 根据纳入和排除标准提取了 332 名患者。其中，97.5%的患者被正确识别，最终确定了 320 例符合研究条件的病例。将 CXP 提取的数据与手动评估的 EMR 进行比较，每年的回收率为 95.6-101.1%，加权平均灵敏度为 96.1%。
使用 CXP 软件可以被认为是一种从 EMR 中提取相关数据而不会产生重大错误的有效方法。因此，通过从 EMR 中提取，CXP 可以准确地识别患者，并能够通过找到具有所需代码的患者以及根据指定的纳入和排除标准对项目进行分类，为研究和临床试验提供便利。除此之外，还可以从 EMR 中快速检索医疗程序和实验室数据，以创建定制的提取材料数据库，以便立即用于临床试验。
