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.
DomainClinical Administration
Timeline Year2017
Technical Stack
Microsoft AccessVBAClinical WorkflowHealthcare ITInventory TrackingReportingData Privacy