Thanks Nicole! It's awesome that you've provided this information for all of us.
I do have a question on your patient census data if you find the time to answer. Our database does not store historical patient census information, so if I want to look back at a date three months ago and identify how many patients were in the ED, I need to calculate all patients who arrived on or before that date and were discharged after (for the sake of simplicity).
Since the opportunity has presented itself to see how another healthcare system is calculating census I wanted to ask if you are using a similar method, or if you do something different.
Thanks again for the presentation and follow up.
Our live database doesn't store the census history data in the way that we are collecting it. The system has admit and discharge dates, but not summary counts every thirty minutes as presented in the dashboard. We are collecting this information through a query we run. We have the ability to run a query every thirty minutes and with an ETL process store that data into a database that we have security rights to write to. Essentially we are creating our own historical table.
Awesome, thanks Nicole.