Introduction to the Algorithm
The dashboard presents critical data on Covid-19 patients. Patients who have been tested for Covid along with their test results and vitals are retrieved from the Cerner V500 database at 10-minute intervals. This data is presented in the form of charts and tables.
Application Roadmap
We present a breakdown of the counts of positive, negative and persons under investigation by facility. In addition, MEWS data for patients with a MEWS score greater than 4 and ICU patients at risk for CRRT are displayed as tables. Ventilator monitoring charts are shown for each patient in the ICU. Time series charts in the application provide patient counts over time for the past 6 months. The current application is read-only, providing information to users in real time.
The RADS2 team is redesigning the system to enable rapid dashboard development for conditions other than Covid-19. This dashboard will be enhanced to build a secure and robust application that will provide annotation capabilities to power users. Authorized users will be able to:
- View the charts and tables relating to the condition
- Annotate individual charts and patients data
- Save the annotations and set up alerts when certain conditions/events transpire
This will make the application more useful, alerting the power users to changes in the conditions that they are interested in monitoring. We aim to develop this infrastructure such that we can deploy this system with data coming in from Cerner or Epic in the future.
Design and Implementation
Data from the Cerner database is retrieved using stored procedures that run every 10 minutes and stored in a local database. Views that compute various values are then used to create tables and charts on the dashboard.
