A Centralized Electronic Medical Records and Billing System Pediatric Health Care in Government 1-Iospitals Theme: Innovative Medical Solutions. (Case Study Mbarara Region Flealth Centers)

DECLARA11ON . H

SUPERVISOR~S APPROVAL ~

DEDICATION

ACKNOWLEDGEMENT v

LIST OI~ ACRONYMS

ABSTRACT.

CI IAPTER ONE

1.0 Introduction 4

1.1 Background to the problem

1.2 Problem Statement 6

1.3 Main Objective 6

1.4 Specific Objectives 7

1.SScope /

1.6 Significance /

Cl 1APTER TWO’ 10

Literature Review io

2.0 Introduction 10

2.1 My Approach 10

2.2 A Flexible Conceptual Framework 10

2.3 Electronic Medical Records ii

Medical Records and Billing System ii

2.4 Billing Systems 12

2.4.1 Types of Billing Systems 13

I

2.4.2 Medical Billing Systems .~3

2,4.3 Electronic Billing systems 13

2.5 Inventory Management 13

2.6 Resource centre 14

2.7 Data Security and Confidentiality (Privacy) 14

2.8 Web-based collaboration and telemedicine systems 15

2.8 Conclusion 15

CHAPTER THREE 16

Methodology 16

3.2 Rapid Prototyping 16

3.2.1 Requirements Specification (Analysis) Phase 17

3.2.2 Design Phase 18

3.2.3 Building Prototype 18

3.2.4 Evaluate and refine requirements 18

CHAPTER FOUR’ 19

SYS’l’EM [)ESCRIPTION 19

4,0 Introduction 19

4.1 System User Levels 19

4.1.1 System Administrator 19

4.1,2 Departmental 19

4.1.3 Accounts and Pharmacy 20

4.2 Hardware and Software specifications 20

4.2.1 Hardware specifications 20

4.2.2 Software specifications 20

4.3 System Architecture 21

4.4 Pseudo Codes 21

2

4.4.1 System Log In .21

4.5 System Inputs and Outputs 21

4.5.1 Logical Database Design 22

4.5.2 Physical Database Design 23

4.7 Hierarchical Input and Output

4.8 System Flow 31

4.9 Data flow diagram 32

CI IAPTER FIVE 33

5.0 Introduction 33

5.1 Evaluation 33

5.2 Limitations of the system 3

5,3 Problems Encountered 34

5.4 Future research areas 34

5.5 Recommendations 35

5.7 Experiences learnt 36

5.8 Conclusion 36

REFERENCES 37

APPENDICES 38

Appendix 3 . Interview Guide 39

1 System Log In 41

End4.4.3 DELETE code 42

End If 42

End Sub 42

ChAPTER ONE 1.0 Introduction Electronic systems are groupings of electronic circuits and components which are designed to accomplish one or more complex functions. Examples include telecommunication svstcms. computer systems, power distribution systems, radar systems, electronic music systems, and many others. Suzan Clamp & Justin Keen (2005) I3illing Systems arc systems that are used to track statements of charges for goods supplied or services rendered in business enterprises. Billing systems are used to prepare summary inRwmation of the amount of business done in a specific period (Mulligan 2002). Descriptions of electronic data sources have varied greatly. and numerous terms have been used inconsistently across studies. In most studies, investigators did not provide sufficient information to allow distinctions in terminology. Thus, the EMR listed in each stud~ represented a provider-created electronic record of patient care. Other forms of’ electronic health data that represented subsets of data used for research, such as surveillance databases or data registries, were not considered EMRs as they were not used by health care providers for patient care.