A novel tool for patient data management in the ICU-Ensuring timely and accurate vital data exchange among ICU team members

Abstract

Objective: The coronavirus pandemic has highlighted the need to simplify data collection for critically-ill patients, particularly for physicians relocated to the ICU setting. Herein we present a simple, reproducible, and highly-customizable manual-entry tool to track ICU patients using new HIPAA-compliant Google Big Query technology for parsing large datasets. This innovative flow chart is useful and could be modified to serve the particular needs of different sub-specialists, particularly those that either rely heavily on hand-written notes or experience poor electronic medical record (EMR) penetration.

Methods: The tool was developed using a combination of three Google Enterprise features: Google Forms for data input, Google Sheets for data output, and Google Big Query for data parsing. Code was written in SQL. Sheets functions were used to transpose and filter parsed data. White and black box tests were performed to examine functionality.

Results: Our tool was successfully able to collect and output fictional patient data across all 57 data points specified by the intensivists and surgeons of Cardiovascular Department of Mt. Sinai Morningside Hospital.

Conclusion: The functional tests performed demonstrate use of the tool. Though originally conceived to simplify patient data collection for newly relocated physicians to the ICU, our tool also overcomes financial and technological barriers previously described in low-income countries that could dramatically improve patient care and provide data to power future studies in these regions. With the original code provided, implementers may adapt our tool to best meet the requirements of their clinical setting and protocols during this very challenging time.

Keywords: Electronic medical record; Intensive care.