Mansour Richard, Master Samip
All authors: Louisiana State University Health Sciences Center, Shreveport, LA.
JCO Clin Cancer Inform. 2017 Nov;1:1-6. doi: 10.1200/CCI.17.00038.
Quality measurement and improvement is a focus of ASCO. In the era of electronic health records (EHRs), computerized order entry, and medication administration records, quality monitoring can be an automated process. The EHR data are usually stored within tables in a relational database management system. ASCO Quality Oncology Practice Initiative measure NHL78a (hepatitis B virus antigen test and hepatitis B core antibody test within 3 months before initiation of obinutuzumab, ofatumumab, or rituximab for patients with non-Hodgkin lymphoma) presents an opportunity for automation of a quality measure using existing data in the EHR.
We used a locally developed Structured Query Language (SQL) language procedure in the Microsoft SQL Query Manager to access the EPIC CLARITY database. Access to the relational database management system of the EHR permits rapid case identification (the denominator set) of the unique ID of all of the patients who have received one of the target medications (ie, obinutuzumab, ofatumumab, or rituximab). Then, we went through a six-step process to find the number of patients who passed or failed the quality measure.
When the final SQL procedure executes, it takes < 5 seconds to see the result set for a 12-month period. The procedure can be changed to incorporate a desired date range. Once the SQL procedure is created, there is essentially no labor and low costs to run the procedure at specific time intervals.
Our method of quality measurement using EHRs is cost effective, fast, and precise, and can be reproduced at other centers.
质量测量与改进是美国临床肿瘤学会(ASCO)的一个重点。在电子健康记录(EHR)、计算机化医嘱录入和用药管理记录的时代,质量监测可以是一个自动化过程。EHR数据通常存储在关系数据库管理系统的表中。ASCO质量肿瘤学实践倡议措施NHL78a(对于非霍奇金淋巴瘤患者,在开始使用奥滨尤妥珠单抗、奥法木单抗或利妥昔单抗前3个月内进行乙肝病毒抗原检测和乙肝核心抗体检测)为利用EHR中的现有数据实现质量测量自动化提供了契机。
我们在Microsoft SQL查询管理器中使用本地开发的结构化查询语言(SQL)程序来访问EPIC CLARITY数据库。访问EHR的关系数据库管理系统可快速识别所有接受过一种目标药物(即奥滨尤妥珠单抗、奥法木单抗或利妥昔单抗)的患者的唯一ID(分母集)。然后,我们经过六个步骤来确定通过或未通过质量测量的患者数量。
当最终的SQL程序执行时,查看12个月期间的结果集耗时不到5秒。该程序可以更改以纳入所需的日期范围。一旦创建了SQL程序,在特定时间间隔运行该程序基本上无需人工且成本很低。
我们使用EHR进行质量测量的方法具有成本效益、快速且精确,并且可以在其他中心重现。