Advanced Clinical Workflow for Connecting Clinic
Sagar Ravindra Patil, Mahadev Sudhakar Garad, Nikhil Goraksh Pawar, Supriya DadabhauTambe
Abstract -This system is designed to improve clinical workflow, and perform advanced appointment scheduling. This application shows how clinics and patient are connected online through web based application. In today’s life no one has time to visit clinic a nd wait for appointment. This application will help for getting online appointment. Patient can get appointment through SMS or Internet.
Receptionist will manage all the appointment. Doctor can make his schedule according to patient’s appointment. Patient can se e online how many people are waiting for appointment. Doctor will upload all the patient medical history on website. This information is visible to only that patient and to the visiting Doctors. Thus privacy is maintained. As patient and clinic are connected online if patient goes from one clinic to another clinic, visited clinics doctor can see medical history of that patient and personal information of patient. It is waiting room solution. All this services provided to users at free of cost.
Index Terms— — Alert Notification, Appointment scheduling, Database management, Online Appointment, Report Generation, Secure private information, Unique ID.
1 INTRODUCTION
—————————— ——————————
2 EXISTING SYSTEM
s importance of web based application is increasing day by day, it is important to manage all the healthcare data online. Now everyone has internet connection and it is easy to use web application. This application will reduce the work of patient as well as doctor. Doctor does not need to take patient’s weight, patient’s blood group, because all this information is entered at the time of registration of patient on website. Doctor will automatically see patient’s infor- mation. There is no more hardware required for patient and
doctor.
Efficient appointment schedules reduced patient wait-
ing time while keeping doctor idle time as low as possible
without adding extra resources. Efficient and effective man-
agement of healthcare is imperative due to the efficient ap-
pointment scheduling.
There are following thing are required for Doctor:- A) Computer or Laptop
B) Internet Connection
There are following things are required for Patient:- A) Computer
B) Mobile
C) Internet Connectio
Sagar Patil is currently pursuing bachelor degree program in Information
Technology in University of Pune, India. E-mail: srpatil91@gmail.com
Mahadev Garad is currently pursuing bachelor degree program in Infor- mation Technology in University of Pune, India. E-mail: garadms@gmail.com
Nikhil Pawar is currently pursuing bachelor degree program in Infor- mation Technology in University of Pune, India. E-mail: nickypawar1990@gmail.com
Supriya Tambe is currently pursuing bachelor degree program in Infor- mation Technology in University of Pune, India. E-mail: tambesu- priyad@gmail.com
The earliest work studying the appointment scheduling issue was made by Bo Hang (2011) [1].
System was used to schedule an appointment and to de- termine the need for registration, the system is registering the customer's name, gender, ID number, telephone number and simple personal medical background information, etc., and accordance with the patient's registration department, visiting time period agreed upon their visits, visits of experts. After successful registration, the time of registration status set to "have an appointment taken". If the customer had previously used the reservation registration system, enter the customer's ID number. After the basic situation of the client as well as its previous record of registration and other information is dis- played immediately, the patient miss an appointment can be registered directly; if the client ever had a history of default the system will automatically alarm, that the client is blacklist- ed.
In Existing system, Doctor and Patient both have to pay some money for using that system. But many users prefer us- ing the system to which they don’t have to pay money. So we are developing system which provides services to users free of cost. Hence our system will be more preferred than any other system.
3 SYSTEM SCOPE
The scope of the project can be summarized as follows:
A) To prevent getting lost of appointment and patients information.
B) To prepare suitable weekly schedule for the doctors. C) The software benefits the patient by cutting his/her
waiting hours and the queue to Registerfor an ap-
pointment.
D) The doctors can change the appointment timings in emergencies.
E) To present a good user interface for creating, deleting, editing, and updating the appointment schedule.
F) Overcome the problems of inadequate workload over doctors.
G) It facilitates the receptionist by showing all patients details and appointment timings, rescheduling at a click.
ments ensure a very friendly User Interface. On the server side there is Mysql server 5.5 acting as the database server and Apache tomcat 7.0 acting as a Web server.
6 SYSTEM ARCHITECTURE
Doctor
H) It reduces the time
I) Fast process
J) Report generation
Patient
Receptionist
Internet
Unite Clinic
Home Page of
Proposed
Admin
4 UNIQUE ID
Every patient and Clinic will get unique ID at the time of registration. Each doctor in clinic will have unique ID on the basis of his/her clinic. This ID is useful in entire process. This ID will be used in searching patient, searching clinic. It is also useful to maintain privacy of patient and doctor’s information.
Registered patient data will be verified by the clinic when patient meets to clinic first time, after that there is no need to verify the data by all the clinics. Clinical data and patient data will be verified by special authority so that there will not be any fraud data. After all this verification Final Unique ID is generated.-less method. In order to setup the database, the client must register in person at the organization. The client’s mobile phone/SIM card identification factors, e.g. IMEI/IMSI, are retrieved and stored in the database, in addition to the username and PIN. The J2ME OTP generating software is in- stalled on the mobile phone. The software is configured to connect to the server’s GSM modem in case the SMS option is used. A unique symmetric key is also generated and installed on both the mobile phone and server. Both parties are ready to generate the OTP at that point.
5 SYSTEM IMPLEMENTATION
The application requires following software-
A) Java Runtime Environment and Java Development kit version 1.7
B) Apache Tomcat Version 7.0
C) Mysql Database 5.5 as backend
Proposed system is based on MVC (Model View Control- ler) architecture which describes our system, in that Mysql server database is acting as model, HTML GUI is view and JSP is acting as controller which controls communication between view and model. Users are connected to the Web Server through an Internet connection and communication with the database server through JDBC is established and data are ac- cessed directly from the database Server. System’s GUI ele-
Medical Rep-
Figure 1: System architecture of proposed model.
6.1 System Architecture
The above figure explains working of proposed system. Doctor, Patient, Receptionist and Medical Representative are client side users. All these users are connected to proposed system through internet. System is managed by Admin at server side. Proposed system’s users are described below.
6.1.1 Patient
Patient can search doctor by doctor’s degree or specifica- tion, doctor’s name or clinic’s name. If particular doctor have an emergency, then appointments are taken after that, and then rescheduling of appointments is done by the receptionist. This message is display on website, receptionist will report this message. Patient can utilize his/her time rather than go- ing at early in the morning to take appointment and wait till the number came.
Secret information of patient is not visible to other patient; privacy of the patient is maintained. Time of the hospital and day when hospital is close is displayed. Emergency contact number of doctor will be displayed.
6.1.2 Doctor
Doctor can see the personal information and allergic in- formation of patient, and depending upon the allergy, doctor can give him prescription. Doctor can also view the patient history. There is no need of paper to keep record of patient. All patient data is stored in the proposed system. It is easy for doctor to keep record of all patients, and also to retrieve the patient information.
6.1.3 Receptionist
Receptionist will help to manage appointment schedul-
ing. Receptionist will inform whether doctor is available or not. Receptionist will send alert notification from his/her clin- ic to the patient. e.g. Tomorrow clinic will be closed.
6.1.4 Medical Representative
Main revenue of proposed system is from Medical Repre- sentative. Medical Representative will advertise his medicine on website, and it is visible only for doctors. Medical Repre- sentative can insert record of new medicine and remove rec- ords of banned medicine.
After login patient will search for the doctor depending upon doctor’s name, specialization or location, if the required doctor is selected, then patient needs to select the date for appoint- ment. If any time slot is available then confirmation message is send along with time. After receiving confirmation message, if time is not convenient for patient then the patient is given dif- ferent time slots to select from and whichever is convenient is selected by the patient. After the procedure is completed the patient logs out.
Search Doctor
Search Doctor
By Name
Search Doctor By
Specialization
Search Doctor
By Location
Nikhil MBBS Kondhwa
Search
Figure 4: Search Doctor Form.
Appointment
Figure 2: Use Case Diagram for Medical Representative
6.1.5 Admin
Admin will manage all database of proposed system. Admin will update system time to time. And all these updates are available to user without any additional cost.
Figure 3: Use Case Diagram for Admin
7 APPOINTMENT MODEL
All new patients firstly need to do registration. If they have already registered then they can directly do the login.
Select Doctor:
Name Specialization Location Nikhil Pawar MBBS Kondhawa Nikhil Pote MBBS Kondhawa
Take Appointment
Figure 5: Appointment Form.
Figure 6: Use Case Diagram for Appointment Model
8 REPORT GENERATION
At the end of day all the clinics can generate report show- ing number of patient visited to the clinic. System can also able to generate report for number of patient suffering from particular disease for that clinic. All the clinics in city are con- nected so that we can get report for number of people suffer- ing from particular disease from particular city. This report will be useful for government for making survey for diseases.
Figure 7: Use Case Diagram for Report Generation
9 HISTORY MAINTENANCE
Patient record cover the following elements: Personal da- ta, medical history list, medical examinations and tests, links to medical databases, etc.
This data is shown only to particular patient and doctor
who are performing treatment on that patient. This assures privacy of patient data and also data security.
This helps doctor to apply good medical treatment on pa-
tient, as all information of patient, such as previously taken treatment and allergic information are available with doctor.
Figure 8: Use Case for Managing Case Paper
10 ALERT NOTIFICATION
Notifications are of three types: K) Mobile SMS
L) Email
M) Website
Patient will get appointment confirmation SMS on his mobile regarding time of visiting to the doctor. Patient will also receive health care tips regarding common diseases e.g. swine flu and dengue. Alert notification also takes care of us- er’s privacy as we are sending notifications according to their request and settings.
11 ALERT NOTIFICATION
11.1 Prescription via SMS
Prescription will sent directly on patient’s mobile via SMS. This will save written work of doctor as well as paper. Digital signature will verify prescription.
11.2 Android Application
As most of the mobile uses Android operating system, android application of unite clinic will be available.
11.3 Medical Stores
Pharmacist will view prescription given by doctor to pa- tient. Pharmacist will enter patients ID and then he will able to view the prescription for patient.
11.4 Suggestion for doctor
We are making survey of treatments given by doctors, from which we are creating reports. That reports will be avail- able to other Doctors for reference.
12 FUTURE SCOPE
12.1 Prescription via SMS
Prescription will sent directly on patient’s mobile via SMS. This will save written work of doctor as well as paper. Digital signature will verify prescription.
12.2 Android Application
As most of the mobile uses Android operating system, an- droid application of unite clinic will be available.
12.3 Medical Stores
Pharmacist will view prescription given by doctor to pa- tient. Pharmacist will enter patients ID and then he will able to view the prescription for patient.
12.4 Suggestion for doctor
We are making survey of treatments given by doctors, from which we are creating reports. That reports will be avail- able to other Doctors for reference.
13 CONCLUSION
The Proposed system is used to connect all clinics in a city. System is available to doctor, patient and receptionist at free of cost. System assigns unique ID to each doctor and pa- tient. System manages all records. Also ensures security, in- tegrity, privacy and availability of information. Appointment Management scheduling software allows patients to manage scheduling appointments.
ACKNOWLEDGMENT
First and foremost we would like to thank our project guide Mr. Anand Magar and doctors from Pune, Dr. Bade, Dr. Shaha and Dr. Borkar for their valuable guidance and advice. They have inspired us greatly to work on this project. Their willingness to motivate us contributed tremendously to our project.
We wish to thank our project supervisor Mr. Anand Magar,
for his valuable guidance, support, constant supervision and for providing all the necessary information regarding the pro- ject.
We would like to express our special gratitude and thanks to our HOD Prof. Abhay Adapanawar, Mr. and Mrs. Bangare whose kind co-operation and encouragement helped us in the project.
Our thanks and appreciation also goes to our colleagues
who have helped us out to the best of their abilities.
REFERENCES
[1] Bo Hang, “Web based long-distance appointment regis- tered system,” CCTAE, 2010 International Conference, vol. 3, Page(s): 232 – 235.
[2] Lu, K.M.; Hamid, S.H.A., “Conceptual Design of Web- Based Appointment Management System using Object WebML,” ISITAE '07, Page(s): 354 – 359.
[3] Marinos, S.; Nikolopoulos, P.; Pavlopoulos, S., “A WEB-
based patient record and appointment management sys-
tem,” BMES/EMBS Conference, 1999, Vol. 2.
[4] Wijewickrama, A. “Simulation analysis of appointment
scheduling in an outpatient department of internal medi-
cine,” Simulation Conference, Dec. 2005.
[5] Hung, K.; Yuan-Ting Zhang “Implementation of a WAP-
based telemedicine system for patient monitoring,” In- formation Technology in Biomedicine, Vol.7, Issue: 2,
2003, Page(s): 101 – 107.
[6] Marinos, S, “A WEB-based patient record and appoint- ment management system Assessment of user satisfaction with an Internet-based integrated patient education sys- tem for diabetes management,” Engineering in Medicine and Biology, 1999, vol.2.