Ontology highlight
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.
SUBMITTER: Newman N
PROVIDER: S-EPMC7528843 | biostudies-literature | 2020 Dec
REPOSITORIES: biostudies-literature
Newman Noah N Gilman Sam S Burdumy Matt M Yimen Mekeleya M Lattouf Omar O
International journal of medical informatics 20201001
<h4>Objective</h4>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, particular ...[more]