Abstract :

The manual collection of midnight totals in hospitals has long been used to calculate key performance indicators such as bed occupancy rates. Despite technological advancements, many hospitals still rely on labour-intensive manual methods prone to inaccuracies at multiple stages. This study introduces and evaluates the Smart Hospital Metrics Calculator, a tool developed to automate the calculation of midnight totals and same-day discharges using patient admission and discharge dates from the electronic Indoor Morbidity and Mortality Return (eIMMR). Both manual and software-based methods exhibited inaccuracies, but errors in software-based calculations were primarily due to issues with entering dates, which can be mitigated by improving workflows and refining the eIMMR system. In contrast, improving manual methods requires addressing challenges across multiple levels. Data from three hospitals were analysed, and while the results do not yet demonstrate these outcomes, it is postulated that with enhanced date entry processes, software-based methods, such as the Smart Hospital Metrics Calculator, could achieve near-zero inaccuracies. These findings suggest that transitioning to this automated approach has the potential to streamline data collection, enable real-time monitoring, and improve hospital data management—without requiring additional workload or significant investment. If successfully implemented, this change could represent a seamless transformation, realizing benefits without disrupting current operations.

---

Keywords :

Bed occupancy rate, Daily census, Healthcare informatics, Hospital data management, Hospital performance indicators, Sri Lanka., Total inpatient days

---

References :

1. Ilham MA. ANALYSIS OF THE RELATIONSHIP BETWEEN THE BEHAVIOR OF IMPLEMENTING NURSES TO FILLING OUT THE DAILY CENSUS OF INPATIENTS AT THE HOSPITAL WULAN WINDY GENERAL HOSPITAL. J Ekon. 2022 Dec 30;11(03):2144–50.
2. Utami D, Cahyaningrum N, Idris SAB. Literature Study Analysis of Daily Inpatient Census Implementation for Reporting of Hospital Inpatient Service Indicators. Proc Int Conf Nurs Health Sci. 2022 May 28;3(1):207–14.
3. Sandanayake, AP, Wickramasinghea SC. Improving the management of midnight data to enhance evidence-based decision making. SLJBMI. 2020 Oct 31;Vol 11(No 1):1–7.
4. Silver P, Sweberg T. 3: PATIENT CENSUS AT MIDNIGHT DOES NOT ACCURATELY REFLECT PEAK BED UTILIZATION IN A PEDIATRIC ICU. Crit Care Med. 2013 Dec;41:A1.
5. DeLia D. Annual Bed Statistics Give a Misleading Picture of Hospital Surge Capacity. Ann Emerg Med. 2006 Oct;48(4):384-388.e2.
6. Simon M. Midnight census revisited: Reliability of patient day measurements in US hospital units. Int J Nurs Stud. 2011