Optimising Hospital Appointment Flow with an Online Scheduling System : Architecture, Workflow, Integration, and Usability Evaluation

다국어 초록 (Multilingual Abstract)

Zimbabwe’s major government hospitals primarily rely on manual appointment-booking systems, leading to long queues, overcrowded waiting areas, and limited access to scheduling information. Such inefficiencies impede efficiency, equity and timeliness of care. Patients will be awaiting to enrol or to see a doctor, and they may be complicating their conditions and putting extra financial pressures on them like loss of income and recurring traveling. This is a crisis in the urban centres; Harare, Bulawayo where the population is greater than the infrastructures and manpower to handle it, which leads to a bottleneck and slows down treatment and diagnosis.
The rural and peri-urban patients seem to have extra hindrances, such as traveling at high costs and taking long durations, which frequently lead to missing appointments or lack of space in the hospital outpatient services. Such systemic challenges undermine confidence in the services of the state, do not encourage the timely use of care, and create unsustainable demands on already scarce resources. To deal with them, patient-oriented digital applications are needed to simplify access and enhance resource management.
This thesis presents and discusses an Online Hospital Appointment Booking System (OABS) that is constructed on the MERN stack (MongoDB, Express.js, React.js, Node.js). The system allows patients to book an appointment remotely through the web and mobile platforms (with SMS support), gives them real-time access to the schedule of hospital clinicians, sends automated alerts, and enables Ithem to amend or cancel an appointment safely. This is followed by a short period interval (symptom-first) triage (with or without vitals) to offer clinical safety and throughput, according to the set rules to determine priority and slotting allocation without overbooking, based on NEWS or MEWS score. Hospital administrators and clinicians get the tools which enable people to manage bookings, monitoring patient flows and analyzing operations. The system also manages all patient data off-chain to promote accountability by providing tamper evident audit logs (hash chained, in which the root of the day is anchored to write when stored or permissioned ledger) as well. Performance and usability will be evaluated using a mixed-method. The quantitative measures will comprise a change in waiting time, no-show rates, and booking accuracy. Usability, satisfaction, and opportunities to improve will be obtained through qualitative feedbacks that will involve patients, clinicians, and administrative personnel. Phased approach that involves assessment of need, development of the system, pilot testing, monitoring and impact analysis will be useful in ensuring the strict evaluation of technical functionality and user experience.
The anticipated results are better accessibility, decrease in congestion, better utilisation of the clinical workforce, and increased patient satisfaction. In addition to direct impacts, the OABS provides a scalable framework on how digital health can be applied in low-resource environments, which enhances the infrastructure of Zimbabwean public hospitals and gives a model on how other nations can update their care offerings using patient-centred e-health solutions. The project also contributes to more universal health coverage, digital inclusion, and system resilience. In order to make the evaluation rigorous and yet realistic, we rely on pre-existing models and measures: queueing theory for waiting time and utilization, a simple access-time decomposition for booking convenience, standard rates for no-shows and throughput, and human-centred instruments including the System Usability Scale (SUS), Cronbach’s alpha for reliability, and technology-acceptance constructs (TAM/UTAUT) for adoption.

목차 (Table of Contents)

• 1. INTRODUCTION 1
• 1. Background of the Study 1
• 2. Problem Statement 3
• 3. Objectives and Goals 4
• 3.1. Objectives 4
• 3.2. Goals 4
• 4. Significance of the Study 4
• 4.1 Policy Fit and Governance 5
• 4.2 Feasibility and Replicability 5
• 4.3 Equity and Inclusion 6
• 4.4 Evidence and Guidance for Policymakers 6
• 4.5 Broader System Significance 7
• 5. Expected Impact 7
• 6. Research Questions 8
• 2. LITERATURE REVIEW 10
• 1. Challenges of Manual Appointment Systems 10
• 2. Benefits of Online Appointment Booking Systems 12
• 2.1. Better Patient Accessibility and Convenience 13
• 2.2. Hospital Efficiency 13
• 2.3. Justice, Non-Discrimination, and Non-Paternalism 14
• 2.4. Improved Accountability and Governance 14
• 2.5. Insight and Health System Planning Data-Driven 15
• 2.6. Trust and Engagement in patients 15
• 3. Global Case Studies 16
• 3.1. China 16
• 3.2. United Kingdom 16
• 3.3. Nigeria 17
• 3.4. Saudi Arabia 17
• 3.5. Turkey 18
• 3.6. Synthesis for Zimbabwe 18
• 4. Equity and Inclusive Design in OABS 19
• 5. Governance and Data Security in OABS 21
• 5.1. Legal and Policy Frameworks 21
• 5.2. Technical Safeguards 22
• 5.3. Responsibility by Meaning Accountability 22
• 5.4. Ethical Concerns and Trust in the Patient 23
• 5.5. Organisational Governance 23
• 5.6. International Comparisons 24
• 6. Implementation Challenges in LMICs 25
• 6.1. Barriers of a technical and Infrastructural nature 25
• 6.2. Organisational Preparedness and Ability 26
• 6.3. Financial Sustainability 26
• 6.4. Socio Economic/Literacy Barriers 26
• 6.5. Policy and Governance Problems 27
• 6.6. Cultural and Behavioural Resistance 27
• 6.7. Security and Privacy Issues 28
• 7. Future Technologies and Scalability 29
• 7.1. Sustainability Through Futureproofing 29
• 7.2. Artificial Intelligence and Machine Learning 29
• 7.3. Distributed Ledger technology and Blockchain 30
• 7.4. Health Information Exchange and Interoperability 31
• 7.5. Cloud and Edge Computing 31
• 7.6. Multi-Channel to Expand and mHealth Integration 32
• 7.7. Cybersecurity Futures 32
• 7.8. Engine of Data analytics and public health planning 33
• 7.9. Scalability Pathways 33
• 7.10. Sustainability and System Integration 34
• 8. Implications for Zimbabwe 35
• 8.1. Online Background: Applicability of Global Lessons 35
• 8.2. Implications for Patients 35
• 8.3. Implications on Healthcare Workers and Administrators. 35
• 8.4. Health System efficiency implications 36
• 8.5. The implication on Governance and Accountability 36
• 8.6. Implications to Equity and Inclusion 37
• 8.7. Consequences to Sustainability and Scalability 37
• 9. Analytical Models & Metrics Used in This Study 38
• 10. Research Gap 40
• 3. RESEARCH DESIGN AND METHODOLOGY 42
• 1. Research Design 43
• 2. Sampling and Recruitment 46
• 3. Study Context: Zimbabwe’s Urban Referral Hospitals 48
• 4. Instruments and Measures 49
• 5. Procedures and Data Collection 52
• 6. Data Management and Privacy 53
• 7. Data Analysis 53
• 8. Analytical Models & Calculations 55
• 9. Comparative Projection and Feasibility (MERN) 57
• 10. Research Rigor and Trustworthiness 60
• 11. Ethical Considerations 61
• 12. Limitations 62
• 13. Dissemination 62
• 4. RESULTS 65
• 1. Objective 1 Outcomes: Baseline Manual Appointment System (Access, Flow, and Equity) 65
• 1.1. Sample Overview 65
• 1.2. Quantitative Findings: Access, Flow, and Effort 66
• 1.3. Qualitative Themes: Explaining the Numbers and Capturing User Requirements 67
• 1.4. Integrated Findings and Design Implications 70
• 1.5. Patient Access Patterns & Channel Equity: Findings 70
• 2. Objective 2 Outcomes: Proposed Online Appointment Booking System 73
• 2.1. Use-case diagram of the proposed OABS 73
• 2.2. Appointment Lifecycle State Machine 75
• 2.3. Software Architecture (Logical View) 75
• 2.4. Hardware Architecture On-Prem, Hospital Appointment System 89
• 3. Objective 3 Results: Validation and Evaluation Framework 96
• 3.1. Evaluation Framework 96
• 3.2. Data Sources and Collection 97
• 3.3. Survey Results and User Feedback 98
• 3.4. Analysis and Interpretation 100
• 3.5. Governance, Ethics, and Reliability 100
• 5. DISCUSSION 102
• 1. Patient Access and Waiting Times 102
• 2. Attendance and No-Show Behaviour 103
• 3. Staff Workflow and Desk Load 103
• 4. User Experience and Acceptance 104
• 5. Equity and Channel Access 104
• 6. Reliability and Performance 104
• 7. Data Quality and Governance 105
• 8. Validation Checks 105
• 9. Synthesis and Answers to the Research Questions 106
• 10. Recommendations 106
• 11. Conclusion 109
• 12. Limitations 111
• 13. Future Directions 112
• 13.1. Channels & Experience 112
• 13.2. AI-Assisted Operations 112
• 13.3. Interoperability & Analytics 113
• 13.4. Security & Trust 113
• 13.5. Resilience & Performance 113
• 13.6. Evaluation Design 114
• 6. References 115
• Appendix 1 123
• Appendix 2 146
• Appendix 3 150