Page 1
HOSPITAL MANAGEMENT
SYSTEM
ACKNOWLEDGEMENT
It is our pleasure to acknowledge the help I have received from different individuals,
institutions and ‘ABC hospital’ during the project based training period.
Our first sincere appreciation and gratitude goes to Professor A. Ghaisas for his
guidance, constructive comments, valuable suggestions and inspirations. During
entire project, we have received endless help from him.
Page 3
Table of Contents
Sr. No.
Particulars
Page No.
1 Introduction
2 Business Objectives
3 System Objectives
4 Scope of the Project
5 Functional Decomposition Diagram
6 Data Flow Diagram
7 Entity Relationship Diagram
8 Table Design
9 Screen Design
Introduction
Brief description of business:
The hospital which we have studied for the assignment is ABC Hospital Ltd.
The hospital has following departments :
Inward patient department , Outward patient department ,Pathology lab , X-ray , CT
csan,Operation Theatre , Yoga center , Account dept , admin dept ,etc.
Details about hospital:
No of doctors in the hospital 25
Total bed capacity 60
Types of ward : general, deluxe, super deluxe, semi –deluxe, ICCU, ICU
No of nurse : 35
No of ward boys : 15
To narrow down the scope, four modules were selected for the assignment. The modules
are as follows:
1) Patient registration
2) IPD
Page 5
1) Patient registration:
As soon as a patient enters the hospital for first time he/she should get registered
(irrespective of ipd or opd) .Information such as personal details, family details, etc is
recorded and a registration id is issued. Every time a patient is treated at the hospital
he/she will be referred by this number.
2) IPD:
Patient’s admission details such as reason for admission, ward details, operation
details (if any), etc. are recorded whenever he/she is admitted.
A discharge card is issued to the patient at the time of discharge stating the treatment
summary. Also, a bill is prepared against the various services availed by the patient.
3) OPD:
Consulting details of the patient are recorded and a bill is prepared (including the
services such as pathology lab availed by the patient)
4) Pathology lab:
Pathology lab is used for both ipd and opd. Depending on the test prescribed, tests are
performed and results are recorded. Also, the charges are included in the bill given to the
patient.
Business objectives:
• The objective of the hospital management system is consistent growth of the Hospital, through continual improvement in the processes.
• To provide quick, reliable, quality and error free service by making use of high end technology to ease the management of the patients.
• To help administration in efficient management of the organization very smoothly by achieving high competency.
System Objectives:
• Transition of manual to Automated system • User Friendly
• Time saving and more efficient • Reduce work load
• Record maintenance • Security
• Proper login name and password so that only valid user can assess the system. • Generate Information which helps in decision making for management purpose.
• Manage activities of the hospital such as bed and Doctor Assignment, operations scheduling, personnel management and administrative issues.
Page 7
Functional Requirements
Patient Registration
Every patient who visits the hospital has to get registered prior to getting any consultation, treatment or investigations done. Registration of patients involves accepting certain general and demographic
information about the patient. The patient is allocated a unique Registration number and a Patient Identification number. The Patient ID will remain same for his all subsequent visits to the hospital whereas he will be allocated a new registration number on every visit. The consultation charges (if applicable) can also be collected for the OPD patients during registration and a receipt will be generated.
The following information is required for the registration of OPD Patient:
Patient Details like Name, Age, Sex, Address, Contact number, Nationality, etc. Referring Source and Sponsorship / Penal Details
Department & Consultant to be visited.
For Inpatient the additional information requirements are:
Room / bed requirement. Consultant In charge Treatment required
Authorisation from Sponsor/Penal if required
After registration an OPD Card is printed for the OPD patients, which list all his registration information. This card is used for the prescription writing by the consultant. An Admission form is printed with all the registration details for Indoor patients, which serves as the cover page of the patient file.
Receipt
For billing of any OPD service like Pathology Tests, or any imaging investigation, the patient moves to OPD billing counter. Here the services are charged as per the rates already defined for various
categories/ penal/ time etc to the patient with his Patient ID. The Payment is collected for the service provided and a receipt is generated. The receipt is generated at the service desk.
All services will be automatically entered into the respective modules wherever required like lab & Imaging reporting.
The Salient features of this module are:
i. Record Charges to be taken from the patient.
ii. Record details of the concession & concession authority.
iii. Consultant charges are automatically picked according to general or emergency charges. iv. The charges for the services are automatically picked according to the category or panel of the
patient.
v. The charges are also dependent on time when the service is being given to patient.
vi. When patient revisits his information will be automatically picked using his identification number. vii. Patient can be defined under Cash & Credit OPD.
Page 9
Billing:
Indoor billing module has a supervisory role. The entries for billing are automatically transferred to the patient bill by the respective departments, which provide the service. The services are charged as per the category/panel/package applicable.
Here the bill is compiled and the payment collected from time to time. Provisional and Final bills are generated which provides complete information about the Services availed, its Charges, Advance collected, appropriate Receipts, Refunds, Credit notes, Concession allowed, etc.
Salient Features:
i. Collection of Payment by Cash/Credit Card/ DD or Cheque. ii. Receipts, refunds, Credit Note Generation.
iii. Provisional & Final Bills.
iv. Department wise services availed.
v. Automatic scrutiny of the credit limit available to the patient
vi. Provision to bill a patient against another account (LIC account/company account/Donors account etc.)
Medicine
The Medicine Module deal with the Retail Sale of medicines to OPD patients and Issue of medicines to the In-patients in the hospital. Its function includes, online drug prescription, inventory management and billing of drugs, consumables and sutures. This module is closely linked to the Billing Module and In-patient Module. All the drugs required by the In-patient can be indented from the various sub stores.
Salient Features:
i. This module enables complete control on pharmacy including Purchase & Issue of medicine to IPD or OPD Patient.
ii. Total amount of the bill for IPD Patient will automatically get added in his bill. iii. The Medicine can acknowledge the return of items and issue Credit notes. iv. Items cannot be issued after the expiry date.
Bed
This module deals with the allocation of bed to the in house patients. It has an interface with the billing module. The charges levied to any bed are automatically added to the final bill.
Salient Features:
i. This module enables complete control on the allocation of beds.
ii. The beds are of various types (i.e, ICU, General etc.).
iii. A single patient may change the type of bed allotted to him during his period of stay at the hospital. iv. The bed charges are added to the boll automatically.
Page 11
Other functionalities:
Security:
Each member is required to enter an individual password when accessing the site. Administrators have the option of increasing the level of password security their members must use. The data on your site is secured through multiple layers of protection. One of those security layers involves member passwords. For maximum security of your site, each member must protect their password.
Performance requirements:
The performance of our product is at its best if stored locally, as the response time will be much faster. If the product accessed via Internet, the performance is limited by the connection speed. The only foreseen limitation is that of web-server response.
Safety:
Humans are error-prone, but the negative effects of common errors should be limited. E.g., users should realize that a given command will delete data, and be asked to confirm their intent or have the option to undo.
User Documentation
Scope of application software:
Login:
• Allows the doctors, attendants, and management to login to the system using their respective login ids.
• Doctors will be able to manage their information (like input their availability for the week or day), view patient case history, treatment details, test reports etc.
• Attendants will be able to help the patients to view their case history, treatment details, appointment with the doctors, bill details, wards, medical services provided, test results etc. • Management will be able to view some overall records pertaining to them and then see reports.
Patient registration:
As soon as a patient enters the hospital for first time he/she should get registered (irrespective of ipd or opd) .Information such as personal details, family details, etc is recorded and a registration id is issued. Every time a patient is treated at the hospital he/she will be referred by this number.
IPD:
Patient’s admission details such as reason for admission, ward details, operation details (if any), etc. are recorded whenever he/she is admitted.
A discharge card is issued to the patient at the time of discharge stating the treatment summary. Also, a bill is prepared against the various services availed by the patient.
OPD:
Consulting details of the patient are recorded and a bill is prepared (including the services such as pathology lab availed by the patient)
Pathology lab:
Pathology lab is used for both ipd and opd. Depending on the test prescribed, tests are performed and results are recorded. Also, the charges are included in the bill given to the patient.
Page 13
Page 15
First level DFD
Doctor master maintenance
Master Maintenance Administrator Doctor Medicine Bed Service Bed Master Maintenance
1
Test Medicine master maintenance
Service Master Maintenance Lab Master Maintenance Maintenance notification
Service Patient Medicine Bed Service Appointment details 2 Doctor Enquire general service
Medicine Details
Change of bed details Test
Test Details
OPD
PatientDoctor
Medicine Doctor Enquire consulting doctorPay Consulting fees
Consulting Payment Medicine details 3 Test details Provide Prescription Patient
Page 17 Bill
IPD
PatientDoctor
Medicine Doctor AdmissionTests and treatment
4 Bed allotment Provide diagnosis/treatment details Bill Patient Service Receipt Medical services Bed Test
Billing
Patient Medicine Receipt Patient Details Services details Bill 5 Doctor Consultation detailsBill Patient
Page 19
A/C receivable Patient Bill Receipt Payment Details Bill details Receipt details 6 Patient
Discharge Card Patient Discharge Discharge details 7 Patient Doctor Followup details
Page 21
Reports
Administrator Medicine Doctor Queries 8 Bill Service Patient Reports Bed Test ReceiptLogin
Admin Access details 9 User User Sign in details Security confirmationPage 23
Second level DFD
1- Master maintainence 1.1 Administration BedBed Master Maintainence 1.1
Doctor Master Maintainence 1.4
Lab Master Maintainence 1.5
Service Master Maintainence 1.3
Medical Master Maintainence 1.2 Medicine Service Doctor Test Bed master details
Medical master details
Service master details
Doctor master details
2- Services
General Services
Patient Avail a service
2.1 Service Patient Service details
Purchase Medicine
Patient Medical prescription
2.2 Medicine Patient Issue of medicines
Change Bed
Patient Change request Bed
Availability status
2.3
Page 25
3-OPD
Doctor Appointment
Patient Test details Test
Test report details Patient
2.5
Patient Appointment Details Doctor
Test report details
Patient
Consulting Doctor 3.1
Doctor Provide Prescription
Patient Doctor Prescription Details Bill Bill details Patient
Bill Payment 3.2 Doctor
4-IPD
Patient Patient Details Bed
Bed allotment details
Patient
Doctor Admittance details
Allotment of room 4.1 Services Services Fetched Details Patient Doctor Treatment details Patient Doctor Provide Treatment Prescription
Diagnosis Treatment 4.2 Medicine Bill Receipt
Page 27 5- Billing 1.1 Patients Bed
Compute Medicine charges 5.4
Taxes and issue bill 5.5
Compute bed charges 5.3 3
Compute Services Charges 5.2 .2 Medicine Service Doctor Patient Doctor consultation details Services details
Bed alloted details
Medicine details
Final bill generation
Compute Doctor Charges 5.1 Test Patient Bed Patient Medicine Patient Test Patient Medicine
Page 29
TABLE AND DATA DICTIONARY
TABLE DESIGN
:
Service
:
Attribute
Type
Width Key
Constraint
Description
Ser_id
Number
6
Primary
Key
Not Null,
Unique
Gives the
Unique service
Id No
Ser_name
Varchar2
10
Not Null
Gives the
service Name
Ser_desc
Varchar2
15
Not Null
Describe the
service
Cost_per_unit
Number
5
Not Null
Gives the cost
per unit for
each service
Doctor
:
Attribute
Type
Width Key
Constraint
Description
Doc_id
Number
6
Primary
key
Not Null,
Unique
Unique for
every doctor
Doc_name
Varchar2 20
Not Null
The doctor’s
name
Doc_contact
Number
14
Not Null
Doctor’s
Contact
Details
Doc_address
Varchar2 50
Not Null
Doctor’s
Address
Doc_Specialization
Varchar2 20
Not Null
Doctor’s Field
Of
Specialization
Doc_
Cons_Fees
Number
6
Not Null
Consultation
Fees
Doc_dpt
Vacrchar2 15
Not Null
Type of
department
Page 31
Medicine:
Attribute
Type
Width Key
Constraint
Description
Med_id
Varchar2 6
Primary
key
Not Null,
Unique
Gives the
Medicine Id
Med_desc
Varchar2 10
Not Null
Medicine
Details
Manf_Name
Varchar2 10
Not Null
Name of the
Medical
Manufacturer
Med_type
Varchar2 10
Not Null
Type of
medicine
Med_cost_per_unit Number
5
Not Null
Cost per unit
of medicine
Bed:
Attribute
Type
Width Key
Constraint
Description
Bed_id
Varchar2
6
Primary
key
Not Null,
Unique
Gives the
Bed Id
Bed_type
Varchar2
10
Not Null
Gives the
type of bed
Bed_Cost_per_day
Number
6
Not Null
Gives the bed
cost per day
Registration:
Attribute
Type
Width Key
Constraint
Description
Reg_id
Varchar2
6
Primary
key
Not Null,
Unique
Is Unique For
Every
Registration
Reg_By
Varchar2
20
Registration
Incharge
Reg_reason
Varchar2
30
Reason for
admittance
Patient_Id
Varchar2
6
Foreign
Key
Not Null
A reference to
the patient id
Page 33
Patient:
Attribute
Type
Width Key
Constraint
Description
Patient_id
Varchar2
6
Primary
key
Not Null,
Unique
Is Unique For
Every patient
Patient_name
Varchar2
20
Not Null
Name of the
patient
Patient_dob
Date
Not Null
Date of birth
of the person
Patient_sex
Varchar2
10
Not Null
Sex of the
patient
Patient_contact_no Number
14
Patient
contact
number
Patient_Address
Varchar2
50
Not Null
Address of
the patient
Patient_type
Varchar2
10
Patient of
opd or ipd
Patient_category
Varchar2
20
Company
candidate or
normal
Bill:
Attribute
Type
Width Key
Constraint
Description
Bill_No
Varchar2
6
Primary
key
Not Null,
Unique
Generated
Automatically
and is unique
Bill_date
Date
Not Null
Generated
When bill is
printed
Bill_amt
Number
10
Not Null
Generated
with the bill
Reg_Id
Varchar2
6
Not Null
A reference to
registration
User
Attribute
Type
Width Key
Constraint
Description
User_Id
Varchar2
6
Primary
key
Not Null,
Unique
Unique user id
User_Name
Varchar2
Not Null
User name
Access
Varchar2
10
Not Null
Access to
Page 35
Receipt:
Attribute
Type
Width Key
Constraint
Description
Rec_No
Number
6
Primary
key
Not Null,
Unique
Is Unique for
every patient
Rec_date
Date
Not Null
Date of receipt
generation
Rec_amt
Number
10
Not Null
Amount for
which the
receipt is
generated
Reg_Id
Varchar 2
6
Foreign
key
Not Null
A reference to
registration
Payment_Mode Varchar2
10
Not null
Mode Of
Dicharge_Card:
Attribute
Type
Width Key
Constraint
Description
Discharge_card_id
Varchar2
6
Primary
key
Not Null,
Unique
Gives the
Uniques
service Id No
Patient_Id
Varchar2
6
Foreign
key
Not Null
Gives the
patient Id
Follow_up
Varchar2
100
Not Null
Gives the
follow up
Doc_details
Varchar2
50
Not Null
Gives the
doctor details
Next_
appointment_date
Date
Not Null
Gives the
next
appointment
date
Reg_id
Varchar2
6
Foreign
key
Not Null
A reference
to the
registration
Page 37
Test:
Attribute
Type
Width Key
Constraint
Description
Test_id
Varchar 2
4
Primary key
Not Null,
Unique
Gives the
unique test
id
Test_name
Varchar 2
20
Not Null
Name of the
test
Test_desc
Varchar 2
30
Not Null
Description
of the test
Test_type
Varchar 2
20
Not Null
Type of test
Rate
Number
(6,2)
Rate of test
Input Form
Page 39
Doctor_Master_Form:
Page 41
Bed_Master_Form:
Page 43
Bill_Form:
Page 45
Discharge_Card_Form:
Page 47
Doctor_View_Form:
REPORTS
Month Wise Revenue Report:
Name of the Report : Month wise revenue generated
Purpose : To analyze monthly revenue generated from different department User : Lower Level Management
Page 49
Quarterly Revenue Report:
Name of the Report : Quarterly revenue generated
Purpose : To analyze quarterly revenue generated from different department User : Middle Level Management
Yearly Revenue Report:
Name of the Report : Yearly Revenue Collected From different Department
Purpose : To analyze Yearly revenue generated from different department User : Top Management
Page 51
Number of Patients Referred Report:
Name of the Report : Yearly Number of Patients Referred
Purpose : To analyze number of patients referred by a doctor User : Management
Yearly Category wise Patients Report:
Name of the Report : Yearly category wise patient Report Purpose : To analyze different category of patients User : Management
Page 53
Yearly Company wise Patients underwent Treatment Report:
Name of the Report : Company wise number of Patient undergone treatment in hospital Purpose : To analyze revenue generated from a company
Users : Management
Bed wise allocation Report:
Name of the Report : bed wise allocation report
Purpose : To provide bed to the patient unambiguously Users : Lower level Management
Page 55
Bed wise availability Report:
Name of the Report : bed wise availability status report Purpose : To provide bed status to the patient Users : Lower level Management
Hospital Bill Report:
Name of the Report : Hospital Bill
Purpose : To provide Bill to the patient at the time of discharge Users : Lower level Management
Page 57
OPD/IPD Registration Report:
Name of the Report : OPD/IPD registration report
Purpose : To provide details of patient at OPD/IPD Users : Lower level Management
