CLINIC MANAGEMENT SYSTEM: OUTPATIENT MANAGEMENT SYSTEM .
CLINIC MANAGEMENT SYSTEM:OUTPATIENT MANAGEMENT SYSTEMNURZETY AQTAR AHMAD AZUANA thesis submitted in partial fulfilmentof the requirements for the awardof the degree of Bachelor of Computer Technology(Software Engineering)Faculty of Computer System & Software EngineeringUniversity College of Engineering & Technology MalaysiaMARCH 2005
VABSTRACTAs people become more educated, hence people become more aware of thequality of their life especially something that is related toward their health Thepoor service in health care would give an effect towards the development of ourcountry To receive a treatment from government hospitals, patients sometimesneed to wait for hours .While for administration's task they need. to keep track a.huge number of filing where all details on patients were being kept, sometimes itleads to data. redundancy and .an additional workload .That is why Outpatient.Management System is being proposed .Outpatient Management System is developusing a web-based, concept. This system is develop using Java.ServerPages (JSP)and is design using Macromedia Dreamweaver MX .Because OutpatientManagement System is a management type of system .thus,.the development of thissystem is according to the Protocol Management System where this protocol ismore like aguideline-in order to develop amanagemenuypeofsystem OutpatientManagement System helps Outpatient Department, which are attend by more than500 hundreds patients each. day perform a better service.in term, of registrationprocess, patient's details and reduce time waiting for patients With the existence ofthis system,. the registration. process would. avoid - data.redundancy, records keepingon patient details can be find faster and time waiting for patient before received atreatment from doctor could be. lessen,, this is because all manual task that happen inOutpatient Department is being convert to computerized type of system.
viABSTRAKDalam arus pembangunan yang semakin pesat, masyarakat menjadi semakinberilmu dan terpelajar,tahap kehidupan juga meningkat .Masyarakat kini semakinmementingkan taraf mutu kesihatan mereka Kemudahan kesihatan darl pihakkerajaan yang kurang berkualiti menyebabkan proses pembangunan yang sepatutnyapesat menjadi penlahan .Untuk menerima rawatan dari hospital kerajaan, pesakitkebiasaannya terpaksa menunggu dalam jangka masa yang panjang Selain itumasalah juga timbul di pihak pengurusan, dimana pihak pengurusan terpaksaberhadapan dengan timbunan fail pesakit yang kesernuanya menyimpan data-datapenting, kewujudan fail-fail dalam kuantiti yang amat besar mi memakan ruang dandalam masa yang sarna membawa kepada simpanan data yang berganda .Selain itu,pihak pengurusanjuga terpaksa berhadapan dengan pertambahan beban kerja keranauntuk mencari fail pesakit dari timbunan fail adalah satu kerja yang seharusnya dapatdipermudahkan .Kerana wujud permasalahan yang sebegini Sistem Pesakit Luar telahdibangunican.Sjstem Pesakit Luar mi adalah sistem yang berkonsepkan pembangunanaplikasj web .Sistem mi dibangunkan menggunakan 'Java Server Pages (JSP)' danantaramukanya dibangunkan menggunakan 'Macromedia Dreamweaver Na' .Sistemmi dibina berdasarkan Protokol Pengurusan Sistem, dimana protokol mi lebih kepadagaris panduan untulç membangunkan system yang berbentuk pengurusan. SistemPengurusan Pesakit Luar yang diguna pakai di Jabatan Pesakit Luar yangkebiasaaimya menerima lebih dari 500 pesakit sehari telah membawa banyakkebaikan .Beban kerja pihak hospital dapat dikurangkan dan pesakit tidak perlumenuggu dalam jangka masa yang panjang untuk memperoleh rawatan. Prosesp enyimpanan data-data juga tidak lagi memerlukan ruang yang besar dan mi dapat
ViiTABLE OF LEDGEMENTivABSTRACTvABSTRAKTABLE OF CONTENTviiLIST OF TABLESxLIST OF FIGURExiLIST OF APPENDICESxii,LIST OF roblem Statement21.2.1Overview of Current System21.2.1.1 Registration2List of Problem31.2.21.3Objectives41.4Scope of the Project4
viiiLJLITERATIJRE .RE'/llW2.1.Introduction.6.2.2Current Clinic Management System6(Similar To OPD).2.2.12.3Overview of Clinic Management System6Importance of Clinic ManagementSystem in OPD72.4Definition of Out Patient Department2.5Clinic Management System for OPD82.5.182.6OMS Registration ProcessAvailable Clinic Management System (CMS)9On Market2.6.1clinic Management System (CMS-BCA)9byBCA.Inc2.6.2Clinic Management System byAIZ Company32.7Benefits of Outpatient Management System2.8Comparison between Available Systems1011and Outpatient Management System122.9Overview of web based application132.10Advantages of web-based142.11Protocol Management System15METHODOLOGY3.1Introduction163.2Project Planning183.2.1 Interview183.2.2 Observation1.83.2.3 Meeting19System Design and Implementation193.3
Ix3.3.1Context Diagram ofOutpatient Management System3.3.2Diagram OofOutpatient Management System33.327System Requirement283.4.1Hardware Requirement293.4.2Software Requirement293.4.2.130Java Server Pages30RESULT AND DISCUSSION4.1Introduction314.2Output Testing Analysis314.2.1Output for Patient Registration314.2.2Output for Medical Leave Letter334.2.3Output for Manage Patient's Details344.3Advantages of Outpatient Management System364.4Disadvantages of Outpatient Management System364.5Assumptions and Future Work374.6Constraints374.6.138Conducting Interview4.6.2 Observation5253.3.4 Data dictionary3.4.2.2 Database Oracle 91423Flowchart ofOutpatient Management System3.421CONCLUSION3839REFERENCES41APPENDICES A-D42
xLIST OF TABLESTABLE NOTITLEPAGE2.1Comparison between Available System133.1Table for Registration273.2Table for Doctor273.3Table for Admin283.4Table for Medical Leave Letter283.5Hardware Requirement293.6Software Requirement29
MLIST OF FIGURETITLEFIGURE NOPAGE1.1Workflow of Outpatient Management System33.1Overview of RAD Process174.1Registration Form324.2List of Registered Patients334.3Medical Leave Letter for doctors to 1111 in334.4Medical Leave Letter Generated by OMS344.5Update Patient's Details354.6Output for Search Availability of Patients35
xl"LIST OF APPENDICESAPPENDIXABCDTITLEExample of interface of the CMSOutpatient Management SystemGantt ChartRegistration FormMedical Leave LetterPAGE334156
xiiLIST OF ABBREVIATIONBCABusiness Computer ApplicationCMSClinic Management SystemHTAAHospital Tengku Ampuan AfzanM.DJoint Application DevelopmentJSPJava Server PagesOPDOut Patient DepartmentOMSOutpatient Management SystemRADRapid Application DevelopmentWWWWorld Wide Web
CHAPTER 1INTRODUCTION1.1IntroductionIn the era of technology, where everything needs to be done efficiently andeffectively the existences of Clinic Management System (CMS) become necessary.The used of CMS can enhance the services and also the work flow of all activity thathappens in hospitals where it helps in reducing the workload of medical staff, thenumber of man power needed and it also make hospitals management become moremanageable and easier to control. This Outpatient Management System is happens tobe develop in one of government hospitals in Kuantan Pahang, Hospital TengkuAmpuan Afzan (HTAA).The usage of Outpatient Management System in Outpatient Department (OPD)brings a lot of advantages to patient and also to people who works under thisdepartment Outpatient Management System makes the registration process inhospitals become computerized and this feature helps a lot in keeping details of allpatients and whoever has once received a treatment in Outpatient DepartmentAll in all, the development of Outpatient Management System with allnecessary features would bring many advantages to all people in this country.
21.2Problem StatementNowadays, the current CMS that are available had not been widely used .Thisis because the process of task that occurred in hospitals is quiet complex compared toother organization. The other reason. it that, most of existing system does not full fillthe requirements of doctor and other medical staff in our country.1.2.1 Overview Of Current SystemCurrent system that is being used widely in all government hospitals inMalaysia is a manual system .Where all information is being collect using form and alldata is being kept in the archive, where this conventional ways lead to the need ofspace and time wasting.1.2.1.1 RegistrationIn hospitals, the processes of works to be done are vary. In current system thatis being used in Hospital Tengku Ampuan Aifzan (HTAA) where the case study hasbeen done, all tasks are done manually .Before a patient can received a treatment fromdoctors, first of all, they need to register .Person who is in charge in registrationprocess must make sure either the person had ever received a service from thehospitals or not .lf the person had been received treatments from the hospitals, thenattendance are responsible to find back their file where a details of that particularperson had been kept.In registration process, usually the person in charge is someone who worksunder ad ministrator department This responsible person will hand out a form to befilled by patients who wish to receive a treatment in Outpatient Department .Patients
3need to give details about themselves In some cases, patient come to hospitals withserious injured and because of this, patient sometimes are not able to fill in the formthemselves so someone need to fill in the form for them, before they are allow toreceive a treatment from Outpatient Department .Because of this scenario, sometimesthe details that had been given are not correct So whenever patient are available to doit themselves they need to-register again, and this lead to a data redundancy, timewasting and also and additional workload for hospital staff especially the registrar.They need to find out the previous details about the patients which are incorrect in thearchive .Where, in archive, it contains thousand of files on patient's details.Figure 1.1 Workflow of Out Patient Department
ri1.2.2 List of ProblemsCompare the current system to the available CMS and the one that is to bedeveloped here are list of problems that people who works in hospitals are facing:(i)The manual registration process leads to data redundancy and alsogives an additional workload to the person who is in charge .Because ifthe patients have received treatment from Outpatient Departmentbefore, then they need to find back the details on that particular patientin the archive.(ii)From the research, by interviewing the medical staff, and also peoplewho work under this organization they feel that the current CMS thatare available in the market nowadays do not fill fill their requirement.This is because most of the current CMS system are develop by peoplefrom others country, so the system sometimes does not suits orcompatible to he used in our country. The main reason is that, themanagement of many hospitals in our country is different from otherscountly.1.3 ObjectivesThe integrated CMS are planned to be develop to fulfill some of the problemthat occurred in both manual system and also current CMS system which are notintegrated Below are the lists of the objectives:(i) To transform the manual system into computerized OutpatientManagement System.
5(ii) To develop a prototype on outpatient department system using webbased application.1.4Scope of the projectThe scope of this project will be focused on the outpatient department inhospitals. The scopes of the research are:(i)This case study of this project is Hospital Tengki Ampuan AfzanHTAA in Kuantan, Pahang.(ii)The development of this system is using the Java Server Pages (JSP) aslanguage tools.(iii)The process of develop this system is done in a windows environment.(iv)To design this system, Macromedia Dreamweaver MX is software thatis going to be used, other than that, Oracle 9i as a database and JakartaTomcat as a platform.This system will have three (3) types of features which are:(i)Patient Registration Module - This module are responsible for all theregistration process that happen in Outpatient Department.Registrar/nurse is the person involved under this module.(ii)Generate Medical Leave Module - This module is able to produce amedical leave on demand but under the permission of doctors.(iii)Manage Patient's Details - System must continuously update thedatabase for any new information or changes on patient's details.
CHAPTER 2LITERATURE REVIEW2.1IntroductionThe current manual system that is being used widely in many government hospitalsin Malaysia makes the services received by patients are not so efficient and effective Timewasting, loads of paperwork, filing, and a huge numbers of man power needed are few tobe listed This list can be lessen if a computerized system is being implemented in thisorganization This is to make sure the service and treatment that all government's hospitalsoffer become more standard and have a good quality.2.2 Current Clinic Managements System (similar to OPD)The used of clinic management system (CMS) is not new in our country.Nowadays, a lot of private clinic have practice this sort of system .The used of clinicmanagement system can make sure the flow of the service that they offer are efficient andeffective towards patients.2.2.1 Overview of Clinic Management SystemCurrent clinics management systems that are available nowadays have been widelyPractice in most of private clinic in Malaysia .This system is not so efficient because most
7of them are a stand alone type of system .This system is capable mostly in registrationprocess and billing, because most of these available systems are stand alone systems, so alldata are not being updated on demand .People who work in the administration need to keyin new data everyday .These types of work process are not so efficient, because still theworkloads are there, where the admin need to enter important data before the clinicsoperations are being closed for that day.Usually in clinic man
Management System is a management type of system .thus,.the development of this system is according to the Protocol Management System where this protocol is more like aguideline-in order to develop amanagemenuypeofsystem Outpatient Management System helps Outpatient Department, which are attend by more than .
Clinic County Clinic Name Clinic Address Clinic City Clinic Zip Participant County Participant Gender Enrollment Status Fax Received Date BLACK HAWK CHRIST, MEREDITH - IAM 1015 S HACKETT RD WATERLOO 50701 BLACK HAWK Female Unreachable 4/21/2014
4,994 Alamosa VA Clinic 24,091 Aurora VA Clinic 1,430 Burlington VA Clinic 17,685 Denver VA Clinic: 63,884 Golden VA Clinic: 2,311 IDES 15,372 Jewell VA Clinic 4,343 La Junta VA Clinic 1,580 Lamar VA Clinic 172,745 PFC Floyd K. Lindstrom VA Clinic 66,385 PFC James Dunn VA Clinic 583,038 Rocky Mountain Regional VA Medical Center 874 Salida VA .
Mayo Clinic - Baldwin Building, Primary Care Internal Medicine x Mayo Clinic - Kasson x Mayo Clinic - Northeast x Mayo Clinic - Northwest x x Mayo Clinic Health System - Adams x Mayo Clinic Health System - Alden x Mayo Clinic Health System - Le Sueur x MNBTE and MNQIPS Rewarded Clinics
User Persona: Clinic Managers Setup a Clinic Add a Clinic to Account Add Vaccine Inventory to Account Adding Vaccine Supply to a Clinic Setup clinic Schedule Schedule Clinic Hours of Operation Add Vaccine Administrators to a
houston tx 77055 06 gulf coast clinic/group practice clinic/group practice 14 1,285.68 abilene bone & joint clinic llp-abilene bone and joint clinic llp 1633 cottonwood st abilene tx 79601 02 northwest texas clinic/group practice clinic/group practice 3 101.09 abilene diagnostic clinic pllc
Audiology Clinic III On-Campus 120 2 Fall CSAD 640C Audiology Clinic IV On-Campus 60 2 Spring CSAD 650C Audiology Clinic V Off-Campus 120 2 Summer CSAD 660C Audiology Clinic VI Off-Campus 120 3 Fall CSAD 670C Audiology Clinic VII Off-Campus 120 3 Spring CSAD 680C Audiology Clinic VIII Off-Campus 120 4 Summer, Fall, Spring
Audiology Clinic II . On-Campus 60 1 Summer CSAD 630C Audiology Clinic III : On-Campus 120 2 Fall CSAD 640C Audiology Clinic IV . On-Campus 60 2 Spring CSAD 650C Audiology Clinic V : Off-Campus 120 2 Summer CSAD 660C Audiology Clinic VI . Off-Campus 120 3 Fall CSAD 670C Audiology Clinic
2nd Grade Reading Curriculum Guide . Greeley-Evans School District 6 Page 2 of 14 2016 - nd2017 2 Grade Reading Curriculum Guide Quick Reference Pacing Guide 2016-2017 Grade 2-5 Unit Instructional Days Additional TRE Days Dates Start Smart 5 0 Aug. 22 – Aug. 26 1 30 2 Aug. 29 – Oct. 13 2 30 3 Oct. 17 – Dec. 6 3 30 3 Dec. 7 – Feb. 7 4 30 3 Feb. 8– April 3 5 30 3 April 4 – May 19 .
