I2b2-etl: Python application for importing electronic health data into the informatics for integrating biology and the bedside platform.

MOTIVATION: The i2b2 platform is used at major academic health institutions and research consortia for querying for electronic health data. However, a major obstacle for wider utilization of the platform is the complexity of data loading that entails a steep curve of learning the platform's complex data schemas. To address this problem, we have developed the i2b2-etl package that simplifies the data loading process, which will facilitate wider deployment and utilization of the platform. RESULTS: We have implemented i2b2-etl as a Python application that imports ontology and patient data using simplified input file schemas and provides inbuilt record number de-identification and data validation. We describe a real-world deployment of i2b2-etl for a population-management initiative at MassGeneral Brigham. AVAILABILITY AND IMPLEMENTATION: i2b2-etl is a free, open-source application implemented in Python available under the Mozilla 2 license. The application can be downloaded as compiled docker images. A live demo is available at https://i2b2clinical.org/demo-i2b2etl/ (username: demo, password: Etl@2021). SUPPLEMENTARY INFORMATION: Supplementary data are available at Bioinformatics online.

Population health management of low-density lipoprotein cholesterol via a remote, algorithmic, navigator-executed program.

BACKGROUND: Implementation of guideline-directed cholesterol management remains low despite definitive evidence establishing such measures reduce cardiovascular (CV) events, especially in high atherosclerotic CV disease (ASCVD) risk patients. Modern electronic resources now exist that may help improve health care delivery. While electronic medical records (EMR) allow for population health screening, the potential for coupling EMR screening to remotely delivered algorithmic population-based management has been less studied as a way of overcoming barriers to optimal cholesterol management. METHODS: In an academically affiliated healthcare system, using EMR screening, we sought to identify 1,000 high ASCVD risk patients not meeting guideline-directed low-density lipoprotein-cholesterol (LDL-C) goals within specific system-affiliated primary care practices. Contacted patients received cholesterol education and were offered a remote, guideline-directed, algorithmic cholesterol management program executed by trained but non-licensed "navigators" under professional supervision. Navigators used telephone, proprietary software and internet resources to facilitate algorithm-driven, guideline-based medication initiation/titration, and laboratory testing until patients achieved LDL-C goals or exited the program. As a clinical effectiveness program for cholesterol guideline implementation, comparison was made to those contacted patients who declined program-based medication management, and received education only, along with their usual care. RESULTS: 1021 patients falling into guideline-defined high ASCVD risk groups warranting statin therapy (ASCVD, type 2 diabetes, LDL ≥ 190 mg/dL, calculated 10-year ASCVD risk ≥7.5%) and not achieving guideline-defined target LDL-C levels and/or therapy were identified and contacted. Among the 698 such patients who opted for program medication management, significant LDL-C reductions occurred in the total cohort (mean -65.4 mg/dL, 45% decrease), and each high ASCVD risk subgroup: ASCVD (-57.2 mg/dL, -48.0%); diabetes mellitus (-53.1 mg/dL, -40.0%); severe hypercholesterolemia (-76.3 mg/dL, -45.7%); elevated ASCVD 10-year risk (-62.8 mg/dL, -41.1%) (P<0.001 for all), without any significant complications. Among 20% of participants with reported statin intolerance, average LDL-C decreased from baseline 143 mg/dL to 85 mg/dL using mainly statins and ezetimibe, with limited PCSK9 inhibitor use. In comparison, eligible high ASCVD risk patients who were contacted but opted for education only, a 17% LDL-C decrease occurred over a similar timeframe, with 80% remaining with an LDL-C over 100 mg/dL. CONCLUSIONS: A remote, algorithm-driven, navigator-executed cholesterol management program successfully identified high ASCVD risk undertreated patients using EMR screening and was associated with significantly improved guideline-directed LDL-C control, supporting this approach as a novel strategy for improving health care access and delivery.

Use of automatic SQL generation interface to enhance transparency and validity of health-data analysis.

Analysis of health data typically requires development of queries using structured query language (SQL) by a data-analyst. As the SQL queries are manually created, they are prone to errors. In addition, accurate implementation of the queries depends on effective communication with clinical experts, that further makes the analysis error prone. As a potential resolution, we explore an alternative approach wherein a graphical interface that automatically generates the SQL queries is used to perform the analysis. The latter allows clinical experts to directly perform complex queries on the data, despite their unfamiliarity with SQL syntax. The interface provides an intuitive understanding of the query logic which makes the analysis transparent and comprehensible to the clinical study-staff, thereby enhancing the transparency and validity of the analysis. This study demonstrates the feasibility of using a user-friendly interface that automatically generate SQL for analysis of health data. It outlines challenges that will be useful for designing user-friendly tools to improve transparency and reproducibility of data analysis.

Workflow Automation for a Virtual Hypertension Management Program.

OBJECTIVES: Hypertension is a modifiable risk factor for numerous comorbidities and treating hypertension can greatly improve health outcomes. We sought to increase the efficiency of a virtual hypertension management program through workflow automation processes. METHODS: We developed a customer relationship management (CRM) solution at our institution for the purpose of improving processes and workflow for a virtual hypertension management program and describe here the development, implementation, and initial experience of this CRM system. RESULTS: Notable system features include task automation, patient data capture, multi-channel communication, integration with our electronic health record (EHR), and device integration (for blood pressure cuffs). In the five stages of our program (intake and eligibility screening, enrollment, device configuration/setup, medication titration, and maintenance), we describe some of the key process improvements and workflow automations that are enabled using our CRM platform, like automatic reminders to capture blood pressure data and present these data to our clinical team when ready for clinical decision making. We also describe key limitations of CRM, like balancing out-of-the-box functionality with development flexibility. Among our first group of referred patients, 76% (39/51) preferred email as their communication method, 26/51 (51%) were able to enroll electronically, and 63% of those enrolled (32/51) were able to transmit blood pressure data without phone support. CONCLUSION: A CRM platform could improve clinical processes through multiple pathways, including workflow automation, multi-channel communication, and device integration. Future work will examine the operational improvements of this health information technology solution as well as assess clinical outcomes.