Hello Everyone !!!
HOSPITAL MANAGEMENT SYSTEM (H.M.S.)
Presentation
The Research Work And Written Stuff Done By the :-
2
OBJECTIVES
3
Advantages
4
Disadvantages
NEED FOR PROPOSED SYSTEM
1
GOALS
StakeHolders Discused
7
Doctors / labs
DOCTORS:-
LABS :-
8
Medical Staff
They can enter or edit their details that they provide to the hospital management.
They can edit the medical status of the patients including the basic checkups that are done in timely basis.
They have to maintain the records of drugs used for the patients.
9
Nurse
Enter or Edit personal details
Edit patient medical details
Drug Management
Non-Medical Staff
Can Enter or Edit staff details .
Each staff member will be allotted with different duties
They have to maintain the records of daily work done.
10
Sanitary-Department
Staff Details
Duty Allotment
Daily Work Records
HR
Examples of specific HR Management Functions Include:
11
Receptionist
12
Insurance Agent/ company�
13
Finance Management
14
Inventory Management
15
Pharmacist:�
16
Patients/Visitors
17
Board Of Directors /CEO
18
PR A.K.A Public Relation
19
Organ ,Blood Donation Bank
20
External Organisation
21
Interns
22
Admin
23
Project Timeline
24
25
Grey bar shows actual timing
Modules and Units
Registration Module:
Login Module
Appointment module:
Profile Module:
Pharmacy Management Module:
Salary module:
External Source Management Module:
1)Registration for Guest Users and External Organizations
2)View Doctors and Patients Details
3)Rating and Feedback Unit
4)Show Providing Services Unit
5)Donation Unit
Canteen Module
Loan Module:
Insurance module:
Hospital services Module:
1)login
2)Check doctor availability
3)Allotting the room for emergency patient
4)maintaining record of patient
5)Ward bed availability
6)view personal detail(staff)
7) Ambulance service
8) Ward Cleanliness
9)Stock refill
10) Query/FAQ section
Report Management Module�
1)Maintaining records (Medical staff, database, admin,Receptionist,)
2)To check daily records of patients (medical, database, Receptionist)
3)View medical reports of patients(Doctors)
4)View old records of patients(Interns, External Organization)
5)Sending reports to patients via apps(Patient, Doctors)
6)View Doctor records(External Organization)
7)Add, update and retrieval of reports(Lab expert)
On demand/Request Modules�
1)Check details of extra services provided (Medical staff)
2) Availability of rooms(Medical staff)
3)Booking Medicines from Inventory management (Medical staff)
4)Order Stocks, order confirmation(Caterer, DB, Dealer)
5)Providing Insurance, money(Finance company)
6) Contacting healthcare providers for medication related issues(Pharmacist/Super User)
7)Checks availability of medicines(Pharmacist)
8)Lookout for suitable blood/organ donors(Blood/organ donation)
9)Serving the staff needs(HR)
10)Order/request medicines through app(patients)
HOSPITAL ARRANGEMENT MODULE:�
1) Placing meetings
2) Organizing events
3) Placing medical camps
4) Arranging appointment with other companies
5) Handling resources of hospital
SECURITY MANAGEMENT MODULE:�
1) The Information Security
2) System Vulnerability and Abuse
3) Security Threats (Malicious Software, Hacking etc.) and counter measure.
4) Definition of Cyber Crime and Types.
5) Antivirus
6) Firewalls
7) Anti-Spyware
8) Security Audit
9) Discussion on Overview of IT-ACT 2000.
Feedback Management Module:
Operation Module:
Equipment Management Module:
Bill Module
Research Module:
Waste Management Module
Management Module:
Campaign Module:
1)Participation in Campaign Unit
2)Internship and Trainings Unit
3)Ongoing Campaigns Unit
4)Completed Campaigns with Feedbacks and Ratings Unit
5)Scheduled Campaigns Unit
Modules
Modules for Doctor
Modules for Patients
Modules for Receptionist
Modules for Medical staff
Modules for Non-Medical staff
Modules for HR
1) Performance management
2) Leave management
3)Salary, loan management
4) Recruitment
5)Administration
6) Project tracking
Modules for Blood/Organ donation
1) Physical examination
2)Donor/organ registration
3)Validation
4) Monitoring
Modules for Food service
1. Login
2. Personal info
3.salary
4.view patient diet prescription
5.stock
6.purchase
7.Menu
Modules for Lab Expert
1.Login
2.Personal info
3.Salary
4.View patient details
5.Add medical reports
6.View test prescription
7.Appointment
Modules for Public Relation
Modules for External Organization
1. Login
2. View Patients details
3. Feedback on Progress of health care
4. View Doctors details
5. Remark on Doctor
6. Rating services
7. Providing services
Modules for Finance Manager
1. View Patients Bill details
2. Patients Bill payment
3. Concession in Bill
4. Contact with bank
Modules for BOD
1.Login
2.Modification of records
3.Arranging meetings
4.Payment
5.Opportunities for new talent
Modules for Public Relation
Modules for Disaster Management
1. login
2. drill records
3. hospital insurance records
Databases
Report Management
NAME | DATATYPE | NULL/NOT NULL | KEY |
P_id | VARCHAR(5) | NOT NULL | PRIMARY KEY |
Name | VARCHAR2(30) | NOT NULL |
|
Phone no | INT(10) | NOT NULL |
|
Medicine | VARCHAR (20) | NULL |
|
Staff_id | VARCHAR(10) | NOT NULL |
|
Disease, symptoms | VARCHAR(30) | NOT NULL |
|
Age | VARCHAR(2) | NOT NULL |
|
Important_detail | VARCHAR(50) | NULL | |
JoinOnDate | Datetime | NULL |
|
DischargeDate | Datetime | NULL |
|
On Demand/Request
NAME | DATATYPE | NULL/NOT NULL | KEY |
Demand_id | INT | NOT NULL | PRIMARY KEY |
Demand_to | VARCHAR (20) | NOT NULL |
|
Demand_from | VARCHAR(20) | NOT NULL |
|
Demand _price | INT | NOT NULL |
|
Stock_name | VARCHAR(20) | NOT NULL |
|
Quantity | INT | NOT NULL |
|
Expiry_date | DATE | NOT NULL |
|
Company_name | VARCHAR(20) | NOT NULL |
|
Phone_no | INT(10) | NOT NULL |
|
Location-id | INT(10) | NOT NULL | PRIMARY KEY |
Registration : Patient
Field | Data Type | Null/Not Null | Key |
User ID | VARCHAR2(20) | NOT NULL | Primary Key |
Password | VARCHAR2(20) | NOT NULL | |
Patient Name | VARCHAR2(25) | NOT NULL | |
Contact Address | VARCHAR2(40) | NOT NULL | |
Contact No | VARCHAR2(20) | NOT NULL | |
Aadhar No | VARCHAR2(20) | NOT NULL | Unique |
Field | Data Type | Null/Not Null | Key |
Age | INT(2) | NOT NULL | |
Blood Group | VARCHAR2(5) | NOT NULL | |
Gender | Enum | NOT NULL | |
maritual_status | Enum | Not Null | |
DOB | DATE | NOT NULL | |
Insurance No | VARCHAR2(30) | NOT NULL | Unique |
Employee
Field | Data Type | Null/Not Null | Key |
Employee ID | VARCHAR2(20) | NOT NULL | Primary Key |
Password | VARCHAR2(20) | NOT NULL | |
Name | VARCHAR2(25) | NOT NULL | |
Contact Address | VARCHAR2(40) | NOT NULL | |
Contact No | VARCHAR2(20) | NOT NULL | |
Aadhar No | VARCHAR2(20) | NOT NULL | Unique |
Age | INT(2) | NOT NULL | |
Blood Group | Enum | NOT NULL | |
Gender | Enum | NOT NULL | |
DOB | DATE | NOT NULL | |
Department | VARCHAR2(30) | NOT NULL | |
Specialization | VARCHAR2(30) | NOT NULL | |
External Organization
Field | Data Type | Null/Not Null | Key |
Registration ID | VARCHAR2(20) | NOT NULL | Primary Key |
Password | VARCHAR2(20) | NOT NULL | |
Organization Name | VARCHAR2(25) | NOT NULL | |
Contact Address | VARCHAR2(40) | NOT NULL | |
Contact No | VARCHAR2(20) | NOT NULL | |
Salary:
Pharmacy
External source:
NAME | DATATYPE | NULL/NOT NULL | KEY |
Name | Varchar2(30) | Not Null |
|
Phone Number | Int(10) | Not Null |
|
Adhaar No. | Int(10) | Not Null | Primary Key |
Varchar2(30) | Not Null |
| |
Organisation Name | Varchar2(30) | Null |
|
Donation | Enum | Not Null | |
Login ID | Int(10) | Null | Primary Key |
Donation Unit:
NAME | DATATYPE | NULL/NOT NULL | KEY |
Login ID | Int(10) | Not Null | Primary Key |
Donation Amount | Int(10) | Null |
|
Donation_Item | Varchar2(30) | Null | |
Adhaar No. | Int(10) | Not Null |
|
Varchar2(30) | Not Null |
| |
Organisation Name | Varchar2(30) | Null |
|
Bank Name | Varchar2(30) | Not Null |
|
Account No | Int(15) | Not Null |
|
Campaign:
NAME | DATATYPE | NULL/NOT NULL | KEY |
Name | Varchar2(30) | Not Null |
|
Phone Number | Int(10) | Not Null |
|
Adhaar No. | Int(10) | Not Null |
|
Varchar2(30) | Not Null |
| |
Login ID | Int(10) | Not Null | Primary Key |
Campaign ID | Int(10) | Not Null |
|
Loan Management:
Field | Type | Attribute | Null | Default |
Id | Int(9) |
| No | none |
Loan_amt | Int(9) |
| No | none |
Loan_period | Varchar(50) |
| No |
|
Loan_owner | Varchar(150) |
| No | none |
Pay_back_amt | Int(9) |
| No | 0 |
Loan_date | Date |
| No | none |
Paid_amt | Int(9) |
| No | none |
Approved_status | Varchar(20) |
| No | Pending |
Client_status | Varchar(90) |
| No |
|
Paid_status | Int(5) |
| No | none |
Equipment
Field | Data Type | Null/ Not Null | Key |
Staff_ID | Varchar2(10) | Not null | |
Staff_fname | Varchar2(100) | Not Null | |
Staff_lname | Varchar2(100) | Not null | |
Phone_no | Number | Not Null | |
Ward_no | Varchar2(20) | Not Null | |
Date | Date | Not Null | |
Equipment_id | Varchar(20) | Not Null | Primary key |
Equipment_name | Varchar2(50) | Not Null | |
Quality | Enum | Not Null | |
Durability | Varchar2(50) | Not Null | |
Equipment
Status | Enum | Not null | |
Available_date | Date | Null | |
Best_till | Date | Not null | |
Reason | Varchar2(100) | null | |
Comment | Varchar2(100) | Null | |
Feedback/Rating
NAME | DATATYPE | NULL/NOT NULL | KEY |
Login ID | Int(10) | Not Null | Primary Key |
Feedback | Varchar2(100) | Not Null |
|
Ratings | Int(10) | Not Null |
|
Varchar2(30) | Not Null |
| |
Organisation Name | Varchar2(30) | Null |
|
Role | Enum | Not Null | |
Hospital Arrangement
Field | Datatype | Null/Not Null | Key |
Meeting_no | number | Not null | Primary Key |
Meeting_room | Varchar2(5) | Not null | |
Organizar_name | Varchar2(50) | Not null | |
Organization_name | Varchar2(50) | Not null | |
Members | Varchar2(50) | Not null | |
No_of_Present | Number | Not null | |
External_guests | Varchar2(50) | Not null | |
Security Management:
Field | Datatype | Null/Not Null | Key |
Cam_Id | number | Not null | Primary Key |
Cam_no | number | Not null | |
Security_name | Varchar2(50) | Not null | |
Date&Time | Timestamp | Not null | |
Description | Varchar2(100) | null | |
Confirm_gaurd_name | Varchar2(50) | Not null | |
Operation Management Module
Field | Data Type | Null/ Not Null | key |
Patient_ID | Varchar2(20) | Not Null | |
Patient_Appointment _No | Int | Not Null | |
Patient_FName | Varchar2(50) | Not Null | |
Patient_LName | Varchar2(50) | Not Null |
|
Patient_Email | Varchar2(50) | Null | |
Alternative_Email | Varchar2(50) | Null | |
Surgeon_Name | Varchar2(50) | Not Null | |
Surgeon_Id | Varchar2(20) | Not Null | |
Guardian_Name | Varchar2(20) | Null | |
Center | Varchar(20) | Not Null | |
Patient_Phone_no | Int | Not Null | |
Guardian_Phone | Int | Null | |
Patient_DOB | Date | Not Null | |
Age | Int | Not Null | |
Gender | Enum | Not Null | |
Weight | number | Not Null | |
Height | Number | Not Null | |
Operation Management
Blood Group | Enum | Not Null | |
Operation_Date_Time | Date and Time | Not Null | |
Operation_Duration | Time | Not Null | |
Surgery_name | Varchar2(30) | Null |
|
Symptoms_B_O | Varchar2(100) | Null |
|
Symptoms_W_O | Varchar2(100) | Null |
|
Symptoms_A_O | Varchar2(100) | Null |
|
Surgery_Status | Varchar2(100) | Not Null |
|
Prescription | Va[rcahr2(100) | E |
|
Scan_of_xyz | Blob | Null |
|
Comments | Varchar2(100) | Null |
|
Surgery_Video | bLOB | Null |
|
Guardian_Signature | Blob | Not Null |
|
Surgeon_Signature | Blob | Not Null |
|
Forms
Click Here to view Forms��https://docs.google.com/spreadsheets/d/1Slv0nrdJgOmjSIpdpvXI-3QkJlY0vecjxd8NJwm2fj0/edit?usp=sharing
Report Form
88
Event Table
Board Of directors
90
Event | Activity | Source | Trigger | Response | Destination |
Login | Login as bod | bod/ceo | validate/invalid | Login successfully, �invalid credentials/details | bod/ceo |
update | updating records | employees | record updated | updated successfully | employees |
delete | deleting records | employees | record deleted | deleted successfully | employees |
transaction | checking transaction record,�updating,deleting | trader | updated and deleted� successfully | updated successfully,�deleted successfully | trader, dealer,trust organization,emoloyees |
interns | giving internship | Graduated� students | checking CV | internship granted/denied | graduated �students |
admission | providing admission | students | checking percentage,�rank | admission successfully,� admission denied | students |
fired | firing an employee | employee | giving validate reason | providing resignation letter/�employee fired | employee |
meeting | placing meeting | employees | checking availability | meeting placed/ canceled | employees |
appointment | arranging appointment | other companies,�client,dealers | checking availability | appointment arranged/cancelled | other companies,�client,dealers |
| | | | | |
Medical / Non Medical Staff
91
EVENT | SOURCE | TRIGGER | ACTIVITY | RESPONSE | DESTINATION |
room service | Medical Staff | enter the service required | confirmation of room service | room service completed | Medical staff,database, Admin , Receptionist |
maintain records | Medical Staff | details or query updated | incoming outgoing | update successful | Medical staff,database, Receptionist , Admin |
transportation | Medical/ Non – Medical Staff | provides the Ambulance facilities | picks & drops thepatients | provided Ambulanceservices | Medical/Non – Medical staff,database, Receptionist , Admin |
check-in Patients | Medical Staff | present/absent | Patients checked in/out | Patients check-in/out time | Medical staff,database, Admin , Receptionist |
check daily reports | Medical Staff | check detail Health report of patients | will check for reports on a daily basis | reports checked | Medical staff,Doctor,database, Admin , Receptionist |
Medical / Non Medical Staff
92
EVENT | SOURCE | TRIGGER | ACTIVITY | RESPONSE | DESTINATION |
login | Medical | login through existing acc | will ask for details | login successful | medical,database |
sign-up | Medical | insert new customer | will ask to fill new user registration form | new user will be added | Medical,database |
add patients details | Medical | enter the Patients details | Patients details of room | updated successfully | Medical,database,Reciptionists |
extra services | Medical | details of extra services provided | will check for extra requirements | service found | Medical,database |
Add Foregin patients details | Medical | enter the Foregin Patients details | Foregin Patients details of room | updated successfully | Medical,database,Reciptionists |
93
EVENT | SOURCE | TRIGGER | ACTIVITY | RESPONSE | DESTINATION |
adding food items | Medical | shows Canteen menu | provide food | food provided | Medical,database |
choosing room category | Medical | fill the room requirements | availability | room has been chosen | Medical,database |
room service | Medical | enter the service required | confirmation of room service | room service completed | Medical,database, Reciptionists |
login(Medical) | Medical | validate/verify | username, password details | login successful | Medical,database,HR |
login(Non-Medical) | Non-Medical | validate/verify | username, password details | login successful | Non-Medical,database,HR |
maintain records | Medical | details or query updated | incoming outgoing | update successful | Medical,database,HR |
logout | Medical | validate/verify | username, password | logout successful | Medical,database |
check-in attendees(Medical) | Medical | present/absent | attendees checked in/out | attendee’s check-in/out time | Medical,database,HR |
check-in attendees(Non-Medical) | Non-Medical | present/absent | attendees checked in/out | attendee’s check-in/out time | Non-Medical,database,HR |
Transportation i.e Ambulance Service | Non-Medical | provides the Ambulance facilities | picks & drops the Patients | provided Ambulanceservices | Non-Medical,database,Doctor |
94
EVENT | SOURCE | TRIGGER | ACTIVITY | REPONSE | DESTINATION |
add/update/show details at reception | Medical | select/update room and Patients details | will check for all rooms, Patients and booking details. | check-in/out done successfully | Medical,database,Receptiont |
check daily reports | Medical | check detail of Patients | will check for reports on a daily basis | reports checked | Medical,database,Receptiont |
booking Medicines from Inventory Management | Medical | books the medicines required | Medicines will be collected | collection successful | staff,database,Inventory Management |
Emergency(Critical) | Medical | insert query | call doctor for support | Calls Doctor | staff,database,Doctor |
Doctors/ lab expert
95
Event | Trigger | Source | Activity | Response | Destination |
Login | Validate/verify | Doctor | Username,password details | login confirmation | Doctor |
Add Personal Details | Insert Details | Doctor | add details | Added successfully | Doctor ,HR,Admin |
Edit Personal Details | Update Details | Doctor | Update Details | Update cofirmation | Doctor ,HR,Admin |
View patient details | Retrieval of patient details | Doctor | Displays the details of mentioned patient | Patient details | Doctor |
view medical reports of patient | Retrieval of medical reports of patients | Doctor | Displays the medical reports of mentioned patient | patient medical reports | Doctor |
Add prescription | Add new presccription | Doctor | Adds the new prescription | Added successfully | Doctor,patient,nurse |
Edit prescription | Edit previous prescription | Doctor | updates the prescription | change confirmation | Doctor,patient,nurse |
Set appointment Timings | Sets appointments | Doctor | Apointment timings will be set | Update cofirmation | Doctor,nurse,admin |
View salary | Retrieval of salary details | Doctor | Displays the details of salary | Salary Details | Doctor |
Add Diet Prescription | Add new presccription | Doctor | Adds the new prescription | Added successfully | Doctor,patient,nurse,catering |
Edit Diet prescription | Edit previous prescription | Doctor | updates the prescription | change confirmation | Doctor,patient,nurse,catering |
Add Test Prescriptions | Add new presccription | Doctor | Adds the new prescription | Added successfully | Doctor,patient,nurse,Lab Experts |
Edit Diet prescription | Edit previous prescription | Doctor | updates the prescription | change confirmation | Doctor,patient,nurse,Lab Experts |
96
Event | Trigger | Source | Activity | Response | Destination |
Login | Validate/verify | Lab Expert | Username, password details | login confirmation | Lab Expert |
View salary | Retrieval of salary details | Lab Expert | Displays the details of salary | Salary Details | Lab Expert |
Add Personal Details | Insert Details | Lab Expert | add details | Added successfully | Lab Experts ,HR,Admin |
Edit Personal Details | Update Details | Lab Expert | Update Details | Update cofirmation | Lab Experts ,HR,Admin |
View patient details | Retrieval of patient details | Lab Expert | Displays the details of mentioned patient | Patient details | Lab Expert |
Add medical reports of patient | Add medical reports of patients | Lab Expert | Update the medical reports of mentioned patient | Update confirmation | Lab Expert,Doctor,nurse,patient |
View Test Prescription | Retrieval of Prescription details | Lab Expert | Displays the Test Prescription | Test Prescription | Lab Expert |
Set appointment Timings | Sets appointments | Lab Expert | Apointment timings will be set | Update cofirmation | Lab Expert,patient |
97
Event | Trigger | Source | Activity | Response | Destination |
Login | Validate/verify | Caterer | Username,password details | login confirmation | Caterer |
View salary | Retrieval of salary details | Caterer | Displays the details of salary | Salary Details | Caterer |
Add Personal Details | Insert Details | Caterer | add details | Added successfully | Caterer ,HR,Admin |
Edit Personal Details | Update Details | Caterer | Update Details | Update cofirmation | Caterer ,HR,Admin |
View Patient Diet Prescription | Retrieval of Patient Diet Prescription | Caterer | Displays the Patient Diet Prescription | Patient Diet Presc | Caterer |
Add Stock | Insert Stock | Caterer | Adds stock | Added successfully | Caterer,DB |
Order Requirements | order Stock | Caterer | Order Stock | Order Confirmation | Caterer,DB,Dealer |
Add to Menu | Add menu | Caterer | Adds to Menu | Added successfully | Caterer |
Edit Menu | Update Menu | Caterer | UpdateMenu | Update cofirmation | Caterer |
Finance Managers
Sr No | Event | Trigger | Source | Activity | Response | Destination |
1 | Views Client Bill | Bill Amount view | Finance Manager(LIC,StarHealth) | Viewing Bill Details | Total medical fees | Finance Company |
2 | Provides Insurance/Money | connecting bank/finance company | Finance Manager | Transfering money from bank to hospital | Amount paid successfully | Finance Company,Bank,patient,Hospital Department |
3 | Views Patient Bill | Bill Amount view | Government | Viewing Bill Details | Total medical fees | Government |
4 | Provides Money | Money payment | Government | Paying money to hospital | Amount paid successfully | Government,Patient,Hospital Department |
5 | Views Patient Bill | Bill Amount view | Political Health care Member | Viewing Bill Details | Total medical fees | Political health care manager |
6 | Provides Money | Money payment | Political Health care Member | Paying money to hospital | Amount paid successfully | Political health care manager,Patient,Hospital Department,Bank,Gov |
7 | Views Patient Bill | Bill Amount view | Trustee | Viewing Bill Details | Total medical fees | Trustee |
8 | Provides Money | Money payment | Trustee | Paying money to hospital according to budget | XYZ Amount is paid | Trustee, Patient,Hospital Department(cash counter) |
9 | Provides Money | Money payment | Trustee | Paying Bill fully | Amount paid successfully | Trustee, Patient,Hospital Department(cash counter) |
10 | View Patient Bill | Bill Amount view | Guardian/Family | Viewing Bill Details | Total medical fees | Guardian/Family |
11 | Bill Payment | Money payment | Guardian/Family | Transfering money from bank to hospital | Amount paid successfully | Guardian/Family,Patient,Hospital Department,Bank |
12 | Concession in bill | Concession bill Payment | Government | Request for Concession in bill payment | Concession provided successfully | Government,Patient,Hospital Department |
Interns
Sr No | Event | Trigger | Source | Activity | Response | Destination |
1 | Take Admission | Admission form | Interns | Filling Details in form | Successfully filled details | Interns and Admin |
2 | Interns Pay Full Fees | Fess Payment | Interns | Paying Fees through digitally/ manually | Fees payed successfully | Interns and Admin |
3 | Interns Pay Installment Fees | Installment Fess Payment | Interns | Paying Installment Fees through digitally/ manually | xyz% Fess Payed successfully | Interns and Admin |
4 | Views Old Patient Records | Old data of patients (selective) | Interns | Viewing and analaysing old patients data | Viewing old data for interns | Interns |
5 | View their own progress | View Interns progress detail | Interns | Viewing Their own progress | Interns Progress Detail | Interns |
6 | Pay Fine | Fine Payment | Interns | Paying Fine | Fine Payed Successfully | Interns and Admin |
7 | Receive Reward | Reward for Interns | Interns | Receiving Reward from Hospital | Granted Reward from Hospital | Interns and Admin |
8 | Update Personal details | Personal details updation | Interns | Updating personal details | Details Updated Successfully | Interns, Doctor and Admin |
9 | Admit patients in hospital | Adding patients | Interns | Adding patients in hospital | Patient added successfully | Interns, Doctor,Patient and Admin |
10 | Admit Patients data through camp | Adding Patients through camp | Interns | Adding patients Details through camp | Patient added successfully | Interns, Doctor and Admin |
11 | Updating patients detail(camp) | Update patients detail(camp) | Interns | Updating Patients /details | Patients detail added successfully | Internsa,Doctor and Admin |
12 | Payed Interns update details | Personal details updation | Payed Interns | Updating personal details | Details Updated Successfully | Payed Interns, Doctor and Admin |
13 | Views Old Patient Records | Old data of patients (selective) | Payed Interns | Viewing and analaysing old patients data | Old Patient details for Interns | Payed Interns |
14 | View their own progress | View Payed InternsProgress detail | Payed Interns | Viewing Their own progress | Payed Interns Progress Detail | Payed Interns |
15 | Pay Fine | Fine Payment | Payed Interns | Paying Fine | Fine Payed Successfully | Payed Interns and Admin |
16 | Receive Reward | Reward for payed Interns | Payed Interns | Receiving Reward from Hospital | Granted Reward from Hospital | Payed Interns and Admin |
17 | Recieveing Salary | view salary | Payed Interns | check their salary updates | Salary granted/not granted yet | Payed Interns and Admin |
18 | Interns Admit as patient | bill payment | Interns | Bill payment | concession in bill | Interns and Admin |
19 | Payed Interns Admit as patient | bill payment | Payed Interns | Bill payment | concession in bill | Payed Interns and Admin |
20 | Apply for job | Job Application Form | Interns | Send Request for seeking job | Job request sent | Interns, Admin and chief Doctors |
21 | Adding patients details through camp | Admitting patients through camp | Payed Interns | Adding patients Details through camp | Patients detail added successfully | Payed Interns, Doctor and Admin |
22 | Resigning From Hospital | Block Payed Interns | Payed Interns | Resigning job from the hospital | You are no more working here thankyou for service | Payed Interns and Admin |
External Organization
100
Sr No. | Event | Trigger | Source | Activity | Response | Destination |
1 | Login | Login as guest user | Organiser | To have access of data | New user added | Organiser and Admin |
2 | View Patients Details | View old records of patients | Organiser | To view Patients Records | Patients Record | Organiser |
3 | Give Ratings of Services | Rating on the bases of 5 stars | Organiser | To give rating on bases of hospital services | Thanks for Rating | Everyone (Website, App) |
4 | Remarks on Services | Remarks on hospital service | Organiser | To give remark of hospital’s Services | Remarks added successfully | Everyone |
5 | View Doctor Details | View Doctors records | Organiser | To view Doctor Details | Doctors Record | Everyone |
6 | Remark on Doctor | Remarks on Doctor | Organiser | To give remark on doctor’s performance | Remarks added successfully | Everyone |
Pharmacist
Event | Activity | Source | Trigger | Response | Destination |
Log in | Log in as Pharmacist | Pharmacist /SuperUser | Validate | Login Successful | Pharmacist /SuperUser /Database |
Services And Logistics 24/7 | Manages Pharmacy-related services and logistics 24/7 | Pharmacist | Shows Logistics Info | Your Services | SuperUser, Database |
HealthCare Providers | Contacting all healthcare provider for medication-related issues | SuperUser | Shows HealthCare Issues | HealthCare Issues | SuperUser, Database |
Statistics | Providing adequate statistics on medication consumptions | SuperUser | Shows Stats | Your Statistics | SuperUser, Database |
Medication Budgets | Planning for Medication budgets | SuperUser | Plan New Budget | Plan Budgets | SuperUser, Database |
Events | Activity | Source | Trigger | Response | Destination |
Trainings | Conducting pharmacy-related training for under- and postgraduates | SuperUser | Shows On-Going Trainings | Trainings On-going | SuperUser, Database |
Research Activities | Supervising pharmacy-related research activities | SuperUser | Shows Activities | Activities | SuperUser, Database |
Availability | Checks availability of medicines | Pharmacist | Shows Availability | Availability | SuperUser, Database |
Expiry | checking expires of medicines | Pharmacist | Shows Expiry | Expiry Meds | SuperUser, Database |
Suppliers | Keeping medicine supplier information | Pharmacist | Shows All Suppliers | Suppliers as Follows | SuperUser, Database |
Stocks | Updating Stocks of Medicines | Pharmacist | Shows Stocks | Your Stocks | SuperUser, Database |
Discard | Discarding Expired Medicines For Recycle | Pharmacist | Show Discard Items | Discard List | SuperUser, Database |
Event | Activity | Source | Trigger | Response | Destination |
Log in | Log in as Insurance agent | Insurance agent /SuperUser | Validate | Login Successful | Insurance agent /SuperUser /Database |
Services 24/7 | Manages services for 24/7 | Insurance agent | Shows Logistics Info | Your Services | SuperUser, Database |
HealthCare Insurance Providers | Contacting all healthcare provider for insurance-related issues | SuperUser | Shows Insurance related quey | insurance agenda | SuperUser, Database |
Statistics | Providing on insurance details regarding availability of patient details | SuperUser | Shows Stats | Your Statistics | SuperUser, Database |
Insurance Budgets | Planning for Medication insurance budget | SuperUser | Plan Insurance Budget | Plan Insurance Budgets | SuperUser, Database |
Blood / Organ Donation
104
EVENT | SOURCE | TRIGGER | ACTIVITY | RESPONSE | DESTINATION |
ORGAN DONATION | ORGAN DONOR | TO FILL UP AN INTENT FORM TO DONATE ORGAN | MAKING PROCEDURES FOR ORGAN TRANSPLANTATION TO RECIPIENT | CHECK WHETHER THE ORGAN TRANSPLANT IS SUCCESFULL OR NOT | RECIPIENT/ NOTTO/ROTTO. |
ORGAN DONATION | ORGAN RECIPIENT | LOOKOUT FOR POTENTIAL ORGAN DONORS | TRANSPLANTING AND LOOKING IF ORGAN IS SUITABLE FOR RECIPIENT | MONITORING THE PROGRESS OF RECIPIENT | RECIPIENT |
BLOOD DONATION | BLOOD DONOR | VOLUNTARY BLOOD TRANSFUSION | DONATING BLOOD FOR TRANSFUSION OR STORAGE IN A BLOOD BANK | TO SEE WHETHER BLOOD IS SUITABLE TO ANY PATIENT | BLOODBANK |
BLOOD DONATION | BLOODBANK/RECIPIENT | TO SEARCH FOR SUITABLE BLOOD GROUP | TRANSFER OF BLOOD TO PATIENT IN NEED FROM BLOODBANK OR DONOR | MONITORING THE PATIENT | PATIENT |
HR
105
EVENT | SOURCE | TRIGGER | ACTIVITY | RESPONSE | DESTINATION |
Employee orientation | HR | Introducing new hires to their jobs,responsibilities and workspace. | Provide different orientation for the new employees | New hiring have been recorded. | HR, employee |
Training and performance monitoring | HR | Provide training programs through best practices so as to improve their overall performance. | Assessment of employee training needs Designing, creating and implementing the program
| Training and performance monitoring have been implemented. | HR, Staffs |
Counselling | HR | Interact and provide counselling to the patient and the family members. | Provide counselling and therapy . | Counselling session have been carried out. | HR, counselling team ,patient and family members |
Claims and Handling | HR | Manages the organization,billing, filing, updating and processing of medical claims related to patient diagnoses, treatments and medications. | Maintaining patient records, interacting with health insurance agencies and assuring medical facilities | Claims and files have been maintened. | HR, Insurance agencies ,patients. |
Maintaining budget and profit. | HR | Maintaining use of finanacial resources prudently by meeting patient and community needs. |
| The budgets have been maintained | HR Stockholders ,Owners |
Serving the staff needs |
| Ensures the benefits of employees and monitors their performance evaluation. | To track employee requests for vacation and extended leave | The staff needs are ensured | HR,Staffs |
Department is sufficiently staffed. | HR | Keeps the staff level appropriate according to the needs and patients count | Find immediate replacements and maintain contact with medical staffing agencies or on-call staffers. | The staffs are sufficiently staffed according to the needs | HR,non-medical and medical staffs ,patients. |
106
Decision -Making | HR | Making decisions for the benefits of hospital. | Providing career planning and promotions | The decisions and planning are maintained | HR,other heads |
Feedbacks from Staff-members | HR | Regular feedbacks to be taken to analyse the problems faced by the employees and take appropriate actions | Providing opporunity for employees to give feedbacks and suggestions. | Feedbacks and programs have been taken | HR ,employee |
Risk Management | HR | Enforcing labor and wage laws regarding pay and break periods. | Ensuring that employees understand, and adhere to the organization's policies and procedures | Maintaining an employementeligibility verification form on each employee | HR ,employees |
Ensures Credentials are updated | HR | To keep up with the license renewal times of staff members. | Ensures that certificates are maintained according to education qualification | The credentials are updated | HR, employee |
107
SOURCE | TRIGGER | EVENT | RESPONSE | DESTINATION |
Patient | New patient will have to register | Patient registration | Check registered successfully or not Also check whether already registered customer | Reception(App), Patients |
Patient | After treatment | Patient bill payment | Check Payment status | Reception (App) Patients ; Bank |
Patient | Patient can cancel the appointment | Appointment cancellation | Appointment cancellations | Patient ; Reception ; |
Patient | Patient can reschedule his appointment | Rescheduling Appointment | Need to check availability of that specific doctor | Patient ; Reception |
Patient | App will give them an appointment reminder | Appointment reminders | Through app | Patient ; Reception |
Patients
108
Patient | Patient can enquire about doctors proficiency | Doctor enquiry | Patient gets to know Doctor's proficiency | Patient Doctor |
Patient | Patient will get to know what they cost for | Treatment Details | Will be given the appropriate details | Patient ; Reception Doctors Nurse |
Patient | Patient will receive information about their respective reports | Report sending (eg diabetes) | Can be notified through app | App Patient |
Patient | Patient can give feedback after their treatment | Feedback | Feedback is accepted | Patient Reception |
Patient | Patient can order medicine through app | Ordering Medicines | Lookup for medicine | Patient nurse Staff member |
Patient | Can check the availability of their desired Doctor | Check Doctor’s Schedule | Give that specific doctors working timings | Reception Doctors |
Patient | Patient can apply for insurance after bill | Apply for insurance | Check for proper documents | Reception Insurance agent Patient |
Event | Activity | Source | Trigger | Response | Destination |
Log in | Log in as PR | PR /SuperUser | Validate | Login Successful | PR /SuperUser /Database |
Social influence | Manages social media,media 24/7 | PR | Shows the fame of hospital via media and social media | stats of the popularity,unpopularity of hospital | SuperUser, Database |
Survey | Contacting all patient,staff etc. | SuperUser | Shows HealthCare Issues | responses about hospital management | SuperUser, Database |
Complaints | taking responses from mdical and non medical staff aout the management | SuperUser | Shows complaint | if complaint occur,it will contact HR | SuperUser, Database |
HR | Planning for Medication budgets | SuperUser | shows fixed complaints | it wil fix everything if any complaint occur | SuperUser, Database |
Use Case Diagram
Health Insurance Use Case Diagram
Log In
Insurance provider
Services
Discard
Expired Insurance
client(patient)details
Insurance agent
Log in as SuperUser
Stats
Budgets
patient query
Doctor/lab use case diagram
112
Pharmacist Use Case Diagram
Log In
Stocks
Services & Logistics
Research
Discard
Expired
Suppliers
Pharmacist
Log in as SuperUser
Stats
Trainings
Budgets
HealthCare Providers
Donor Use Case Diagram
114
Medical/Non-Medical Use Case Diagram
115
Patient Use Case Diagram
Log In
registration
bill payment
reminders
doctor
Enquiry
insurance
Patient
appointment
Stats
resheduling
doctors
Finance Use case diagram
Interns Use case Diagram
External Organization Use Case Diagram
119
HR Use Case Diagram
120
Food service
121
Use Case Diagram
Log In
HR
Staff
social media - mobile platform
social imfluence
Survey
PR
Complaints
Doctors
Patient
Media
Board Of Directors
123
State Diagram
Login and Registration
Interns State Diagram
External Organization Donation
Equipment Management Module
Operation Management
Feedback State Diagram
On Demand
On Demand (Pharmacy)
Report Management
Report Management
BOD
Maintenance Management
Appointment
Canteen State Diagram
Loan
Insurance
Waste Management
Hospital Service
Sequence Diagram
144
145
Donor Sequence Diagram
146
Patients Sequence diagram
147
Doctor
Receptionist Sequence Diagram
Medical/Nonmedical
149
Function Point Analysis
Login:
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 2 | 3*2 | 6 |
Outputs | Simple | 2 | 4*2 | 8 |
Average | 1 | 5*1 | 5 | |
Files | - | - | - | - |
Inquiries | - | - | - | - |
Interface | Simple | 1 | 5*1 | 5 |
Total count: 24
Registration
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 22 | 3*22 | 66 |
Outputs | Simple | 24 | 4*24 | 96 |
Files | Average | 2 | 10*2 | 20 |
Inquiries | - | - | - | - |
Interface | Simple | 1 | 5*1 | 5 |
Total Count: 187
Profile Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 25 | 3*25 | 75 |
Average | 5 | 4*5 | 20 | |
Outputs | Simple | 4 | 4*4 | 16 |
Files | Simple | 7 | 7*7 | 49 |
Inquiries | Simple | 5 | 3*5 | 15 |
Average | 3 | 4*3 | 12 | |
Interface | Simple | 4 | 5*4 | 20 |
Total Count: 207
Appointment Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 30 | 3*30 | 90 |
Average | 5 | 5*4 | 20 | |
Outputs | Simple | 3 | 4*3 | 12 |
Files | Simple | 3 | 7*3 | 21 |
Inquiries | Simple | 10 | 3*10 | 30 |
Average | 4 | 4*4 | 16 | |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 199
Report Management:
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 7 | 3*7 | 21 |
Average | 1 | 4*1 | 4 | |
Outputs | Simple | 6 | 4*6 | 24 |
Average | 3 | 5*3 | 15 | |
Files | Simple | 2 | 7*2 | 14 |
Inquiries | Simple | 1 | 3*1 | 3 |
Interface | Simple | 3 | 5*3 | 15 |
Total Count: 92
Hospital Services
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 11 | 3*11 | 33 |
Average | 2 | 4*2 | 8 | |
Outputs | Simple | 2 | 4*2 | 8 |
Files | Simple | 1 | 7*1 | 7 |
Inquiries | Average | 2 | 4*2 | 8 |
Interface | Simple | 1 | 5*1 | 5 |
Total Count: 69
On Demand/Request Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 12 | 3*12 | 36 |
Average | 3 | 4*3 | 12 | |
Outputs | Simple | 3 | 4*3 | 12 |
Average | 1 | 5*1 | 5 | |
Files | Simple | 1 | 7*1 | 7 |
Complex | 1 | 15*1 | 15 | |
Inquiries | Average | 1 | 4*1 | 4 |
Interface | Simple | 3 | 5*3 | 15 |
Average | 2 | 7*2 | 14 |
Total Count: 120
Waste Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 10 | 3*10 | 30 |
Average | 10 | 4*10 | 40 | |
Outputs | Simple | 5 | 4*5 | 20 |
Complex | 5 | 7*5 | 35 | |
Files | Simple | 5 | 7*5 | 35 |
Inquiries | Simple | 6 | 3*6 | 18 |
Complex | 5 | 6*5 | 30 | |
Interface | Average | 3 | 7*3 | 21 |
Total Count: 229
Maintenance Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 30 | 3*30 | 90 |
Average | 20 | 4*20 | 80 | |
Outputs | Simple | 20 | 4*20 | 80 |
Average | 10 | 5*10 | 50 | |
Files | Average | 15 | 10*15 | 150 |
Complex | 5 | 15*5 | 75 | |
Inquiries | Simple | 10 | 3*10 | 30 |
Average | 5 | 4*5 | 20 | |
Interface | Average | 3 | 7*3 | 21 |
Total Count: 596
Campaign Module:
160
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 25 | 25*3 | 75 |
Average | 5 | 4*5 | 20 | |
Outputs | Simple | 5 | 4*5 | 20 |
Files | Complex | 5 | 7*5 | 35 |
Inquiries | Simple | 5 | 3*5 | 15 |
Average | 3 | 4*3 | 12 | |
Interface | Simple | 2 | 5*2 | 10 |
Total count = 187
External Organization
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 30 | 3*30 | 90 |
Average | 5 | 4*5 | 20 | |
Outputs | Simple | 6 | 4*6 | 24 |
Files | Simple | 1 | 7*1 | 7 |
Inquiries | Simple | 10 | 3*10 | 30 |
Average | 4 | 4*4 | 16 | |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 197
Feedback:
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 8 | 3*8 | 24 |
Outputs | Simple | 5 | 4*5 | 20 |
Complex | 1 | 7*1 | 7 | |
Files | - | - | - | - |
Inquiries | Simple | 2 | 3*2 | 6 |
Interface | Simple | 1 | 1*5 | 5 |
Total Count: 62
Operation Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 30 | 3*30 | 90 |
Outputs | Average | 5 | 5*5 | 25 |
Files | Average | 5 | 10*5 | 50 |
Complex | 1 | 15*1 | 15 | |
Inquiries | Simple | 2 | 3*3 | 9 |
Interface | Average | 3 | 7*3 | 21 |
Total Count: 210
Equipment management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 15 | 3*15 | 45 |
Outputs | Simple | 6 | 4*6 | 24 |
Files | Simple | 1 | 7*1 | 7 |
Inquiries | Simple | 3 | 3*3 | 9 |
Average | 3 | 4*3 | 12 | |
Interface | Simple | 2 | 5*2 | 10 |
Complex | 1 | 10*1 | 10 |
Total Count: 117
Canteen Management:
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 17 | 3*17 | 51 |
Outputs | Simple | 2 | 4*2 | 8 |
Average | 3 | 5*3 | 15 | |
Files | Simple | 1 | 7*1 | 7 |
Inquiries | Average | 3 | 4*3 | 12 |
Interface | Simple | 1 | 5*1 | 5 |
Total Count: 98
Loan Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 43 | 3*45 | 135 |
Outputs | Simple | 2 | 4*2 | 8 |
Files | Simple | 5 | 7*5 | 35 |
Inquiries | Simple | 5 | 3*5 | 15 |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 203
Insurance Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 15 | 3*15 | 54 |
Average | 2 | 4*2 | 8 | |
Outputs | Simple | 2 | 4*2 | 8 |
Files | Average | 5 | 10*5 | 50 |
Inquiries | Simple | 5 | 3*5 | 15 |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 145
Pharmacy Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 5 | 5*3 | 15 |
Average | 4 | 4*5 | 20 | |
Outputs | Simple | 5 | 4*5 | 20 |
Average | 5 | 5*5 | 25 | |
Files | Average | 5 | 7*5 | 35 |
Complex | 3 | 10*3 | 30 | |
Inquiries | Simple | 15 | 3*15 | 45 |
Complex | 5 | 6*5 | 30 | |
Interface | Simple | 3 | 5*3 | 15 |
Total Count: 235
Salary Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 15 | 3*15 | 45 |
Average | 5 | 4*5 | 20 | |
Outputs | Simple | 5 | 4*5 | 20 |
Average | 5 | 5*5 | 25 | |
Files | Simple | 3 | 7*3 | 21 |
Inquiries | Simple | 5 | 3*5 | 15 |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 156
Bill Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 10 | 3*10 | 30 |
Outputs | Simple | 5 | 4*5 | 20 |
Average | 1 | 5*1 | 5 | |
Files | Average | 2 | 10*2 | 20 |
Inquiries | Simple | 5 | 3*5 | 15 |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 100
Research Management:
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 10 | 3*10 | 30 |
Average | 5 | 4*5 | 20 | |
Outputs | Simple | 5 | 4*5 | 20 |
Files | Average | 4 | 10*4 | 40 |
Inquiries | Average | 5 | 4*5 | 20 |
Interface | Average | 2 | 7*2 | 14 |
Total Count: 114
Security Management
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 6 | 6*3 | 18 |
Average | 2 | 2*4 | 8 | |
Outputs | Simple | 1 | 4*1 | 4 |
Files | Simple | 1 | 7*1 | 7 |
Complex | 1 | 15*1 | 15 | |
Inquiries | Simple | 3 | 3*3 | 9 |
Interface | Simple | 1 | 5*1 | 5 |
Total Count: 66
Hospital Arrangements
Measurement Parameter | Weighing factor | Count | Calculation | Total |
Inputs | Simple | 19 | 3*19 | 57 |
Average | 4 | 4*4 | 16 | |
Outputs | Simple | 2 | 4*2 | 8 |
Files | Simple | 1 | 7*1 | 7 |
Inquiries | Average | 3 | 4*3 | 12 |
Interface | Simple | 2 | 5*2 | 10 |
Total Count: 110
Function Point Analysis
Complex internal processing = 4
Code to be reusable = 3
High performance = 4
Project adjustment factor = 11
Adjustment calculation:
Adjusted FP = Unadjusted FP X [0.65 + (adjustment factor X 0.01)]
= 3723 X [0.65 + ( 11 X 0.01)]
= 3723 X [0.76]
= 2,829.48 Adjusted function points
174
Function Point Analysis
175
Final Cost
176
Final Cost
177
Final Cost
178
179
Cost of Vending machine => 5 Lakhs
Cost of the Big screen => 1 lakhs per piece i.e. 1 X 30 => 45 Lakhs
Total Cost of the project will be => 3 cr
Kiosk Self Service Machine
Advantages
Vending Machine
ER Diagram
182
Some of our software feature
Some of our software feature
Conclusion
185
THANKS!
For Giving Your Time
186