Back to Systems Directory
MI Room OPD Management Application
MI Room outpatient workflow and pharmacy inventory system
Overview & Scope
Developed the MI Room OPD Management Application (MIROPD), a custom Electronic Medical Record (EMR) system built for unit-level MI Room outpatient settings, replacing slow and error-prone paper registers.
Operational Outpatient Workflow
In high-throughput MI Room clinics, maintaining continuity of care, improving prescription readability, and tracking medicine inventories are constant administrative challenges. MIROPD integrates these administrative workflows into an offline-first Microsoft Access and VBA application:
- Vitals and Clinical Logging: Operators can register visits, record basic observations such as temperature, blood pressure, and oxygen saturation, and track follow-up visits.
- Prescription Printing and Replication: Standardized prescriptions print on compact paper formats. For recurring follow-ups, authorized operators can copy prior prescription structures and update them for the current visit.
- Pharmacy Stock and Drug Indent Controls: The system tracks medicine stock levels against local thresholds, flags approaching expiries, and warns operators before expired stock is selected.
- Administrative reporting: Generates monthly operational summaries and follow-up lists while relying on local access controls and backup routines.
Core Deliverables
- Outpatient Registration with a one-time demographic record and search utility to prevent duplicate entries.
- Prescription Replication allowing medical operators to copy and adjust previous prescriptions for chronic visits.
- Structured Vitals Logging to record basic observations such as temperature, blood pressure, and oxygen saturation.
- Drug Stock & Expiry Controls tracking stock limits (MMF) and blocks prescribing expired medications.
- Auto-Generated Drug Indents calculating suggested quantities from consumption trends and current stock.
- Standardized Prescription Printing formatted for clean delivery on half-sized A4 or legal page configurations.