2020 Data Collection Materials
Cross-Campus Dialysis Resource Tracking Dashboard
We developed a data-driven approach to analyze and guide our response to the COVID-19 surge using web-based spreadsheets to track continuous renal replacement therapy (CRRT) and hemodialysis (HD) censuses and dialysis supplies. Each site enters the details of their own CRRT and HD programs, which then automatically populated the Enterprise-wide RRT Dashboards. The CRRT dashboard also includes the current count of cartridges and bags of therapy fluid available at each site and at the central warehouse. The projected number of days of supply remaining for each site and for the entire enterprise based on the size of the CRRT census was automatically calculated and color-coded. The dashboard allowed for identification of hospitals that were disproportionally affected, and aided in enterprise-level decisions to shift resources between hospitals or from central storage. Similarly, the HD dashboard allowed for quick, visual reporting of the status of working machines, census sizes, nurses, and HD technicians at each site. Both tools were critical in decision-making that occurred nightly on the cross-campus conference calls, and allowed for the equitable sharing of resources across a large, complex healthcare system.
Subjects
Files
-
Cross-Campus CRRT and HD Tracking for AC - 2020.08.05.xlsx application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 448 KB Download File
More About This Work
- Academic Units
- Nephrology
- Series
- Columbia University Division of Nephrology Tracking Tools
- Published Here
- August 10, 2020