Breadcrumb

Automating National Healthcare Safety Network (NHSN) Standardized Infection Ratio (SIR) Calculation in Scuba Data Warehouse for Enterprise Reporting and Zero Harm Initiatives

Session Date & Time
-
Session Room
EH C
Poster Advanced

Achieving Zero Harm by preventing healthcare-associated infections (HAIs) is a priority for UC Health. The Standardized Infection Ratio (SIR) is the primary measure used by NHSN to risk-adjust HAIs, but access to protected health information (PHI) is restricted, limiting broad data accessibility. Additionally, no dynamic SIR data source existed in the Scuba Data Warehouse for enterprise reporting. To address this, we developed an automated tool, eliminating manual NHSN exports and processing. Using SQL and SAS, the predicted infections are calculated daily based on logistic or negative binomial regression models, then integrated into Scuba for enterprise-wide reporting. This solution saves 40 hours of manual effort monthly, improves access to timely SIR data, and supports key quality dashboards. Our organization is the first to accomplish this in the UC Health system. Next steps include applying this data source to additional dashboards and leveraging it for future AI-driven analytics.

Speaker/Host

Primary/Host Speaker
Yuerong Zhuang

Yuerong Zhuang

Clinical Informatics Specialist at UC San Francisco

Yuerong Zhuang is a Clinical Informatics Specialist on the Enterprise Information & Analytics Health team at UCSF. Prior to joining UCSF, she worked at UCSD starting in 2006 as a Clinical Informatics Specialist and statistician. She has served as a lead analyst for various quality programs, including QIP, PRIME, MSSP ACO, and PQRS, and has years of experience in Infection Control surveillance reporting. Yuerong is certified in Epic Clarity, Cogito, Caboodle, Healthy Planet, Beaker, and Care Everywhere, and is also a Tableau Certified Data Analyst. In her free time, she enjoys hiking and baking.

Let us help you with your search