Hospital Inpatient & Daily Census Information System (SHRI)
Healthcare Management System & Medical Analytics — An enterprise-grade hospital management system automating inpatient tracking, daily ward censuses (SHRI), and automated calculation of hospital efficiency metrics (BOR, ALOS, TOI, BTO, NDR, GDR).
SYSTEM PROBLEM STATEMENT & PERSONAL SCOPE
Operational Challenge & System Purpose
An enterprise-grade hospital management system automating inpatient tracking, daily ward censuses (SHRI), and automated calculation of hospital efficiency metrics (BOR, ALOS, TOI, BTO, NDR, GDR).
Key Contributions & Implementation
- > Engineered automated calculation engine for BOR, ALOS, TOI, BTO, NDR, and GDR medical formulas.
- > Designed 4-tier access control matrix (ADMIN, KEPALA, PERAWAT, PETUGAS).
- > Configured batch processing data export/import via Laravel Excel and DomPDF.
ARCHITECTURE & SYSTEM DATA FLOW
+-----------------------+ HTTPS / JSON +-----------------------+
| CLIENT / USER UI | ==========================> | REST API LAYER |
| (Astro / React / FE) | <========================== | (Laravel 10) |
+-----------------------+ +-----------------------+
||
|| SQL / ORM
\/
+-----------------------+
| DATABASE PERSISTENCE |
| (MySQL / PostgreSQL) |
+-----------------------+
Key Architectural Decision Records (ADRs):
Automated healthcare indicator analytics mathematical engine
4-tier RBAC matrix and ICD code medical taxonomy mapping
ENGINEERING CHALLENGES & SOLUTIONS
Automating complex healthcare indicator metrics (BOR, ALOS, TOI, BTO, NDR, GDR) for daily ward censuses.
Engineered medical indicator calculation formulas with 4-tier RBAC access control.