HOSPITAL MANAGEMENT SYSTEM

Prepared by-

Page 1

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. Finally, I wish to say thanks to all people of the company for their kind cooperation.

Page 2

Table of Contents Sr. No.

1 2 3 4 5 6 7 8 9 10

Particulars
Introduction

Page No.
Business Objectives System Objectives Scope of the Project

Functional Decomposition Diagram Data Flow Diagram Entity Relationship Diagram Table Design Screen Design List of Reports

Page 3

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 3) OPD 4) Pathology lab

Page 4

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: Patients 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.

Page 5

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 6

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.

Page 7

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. ii. iii. iv.

Record Charges to be taken from the patient. Record details of the concession & concession authority. Consultant charges are automatically picked according to general or emergency charges. The charges for the services are automatically picked according to the category or panel of the patient. The charges are also dependent on time when the service is being given to patient. When patient revisits his information will be automatically picked using his identification number. Patient can be defined under Cash & Credit OPD. All relevant information is transferred to the Investigation departments.

v. vi. vii. viii.

Page 8

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. ii. iii. iv. v. vi. Collection of Payment by Cash/Credit Card/ DD or Cheque. Receipts, refunds, Credit Note Generation. Provisional & Final Bills. Department wise services availed. Automatic scrutiny of the credit limit available to the patient Provision to bill a patient against another account (LIC account/company account/Donors account etc.) Additional payment for Ambulance/attendants at discharge if required.

vii.

Page 9

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 Inpatient Module. All the drugs required by the 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. Total amount of the bill for IPD Patient will automatically get added in his bill. The Medicine can acknowledge the return of items and issue Credit notes. Items cannot be issued after the expiry date.

ii. iii. iv.

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. ii. iii. iv. This module enables complete control on the allocation of beds. The beds are of various types (i.e, ICU, General etc.). A single patient may change the type of bed allotted to him during his period of stay at the hospital. The bed charges are added to the boll automatically.

Page 10

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
The form generation language will be separately documented.

Page 11

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:
Patients 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 12

FDD:

Page 13

Context Level DFD

Page 14

First level DFD

Doctor Administrator Doctor master maintenance Medicine master maintenance Bed Master Maintenance Service Master Maintenance Lab Master Maintenance Maintenance notification Bed Master Maintenance 1 Medicine

Service Test

Page 15

Patient

Test Details Enquire general service 2 Medicine Service Test

Appointment details Medicine Details Change of bed details

Bed

Service Doctor

Patient Patient
Enquire consulting doctor

Pay Consulting fees Test details Medicine details Provide Prescription

OPD

Medicine

Doctor
Consulting Payment

Doctor

Page 16

Bill

Patient Patient
Admission

Receipt
Medical services

4 Medicine

Bed allotment Tests and treatment

IPD
Bed Doctor Test Bill

Doctor

Provide diagnosis/treatment details

Service

Page 17

Patient Patient
Patient Details

Services Services details Doctor Consultation details Bill 5

Billing

Medicine

Receipt

Bill

Page 18

Patient

Payment Details

Patient Bill details 6 Bill Receipt details

A/C receivable

Receipt

Page 19

Patient Discharge details Followup details Doctor 7

Patient

Discharge Card

Discharge

Page 20

Patient Administrator
Queries

Receipt
Reports

Reports

Medicine Bed Doctor Test Bill

Service

Page 21

Admin Access details Sign in details User Security confirmation 9

User

Login

Page 22

Second level DFD

1- Master maintainence 1.1

Bed Master 1.1 Maintainence

Bed

Bed master details

1.2
Medical Master Maintainence

Medicine

Medical master details Service master details Administration

1.3
Service Master Maintainence

Service

Doctor master details 1.4 Lab master details

Doctor Master Maintainence

Doctor

1.5
Lab Master Maintainence

Test

Page 23

2- Services

Service 2.1 Patient Avail a service

General Services

Patient

Service details

Medicine 2.2 Patient Medical prescription

Purchase Medicine

Patient

Issue of medicines

2.3 Patient Change request

Change Bed

Bed Patient

Availability status

Page 24

2.5 Patient Test details Test Patient

Doctor Appointment

Test report details

3-OPD

3.1 Patient Appointment Details Test report details Doctor Provide Prescription
Consulting Doctor

Doctor Patient

Doctor Doctor Prescription Details Bill details 3.2 Bill

Patient

Bill Payment

Patient

Page 25

4-IPD

Services Fetched Details 4.1 Patient Patient Details Bed allotment details Doctor Admittance details Bed

Allotment of room

Patient

Services

4.2 Patient Treatment details Doctor Provide Treatment Prescription Doctor

Diagnosis Treatment

Patient Medicine

Bill

Receipt

Page 26

5- Billing Patient 5.1 1.1 Compute Doctor Charges Doctor consultation details 5.2 .2
Compute Services Charges

Bed Doctor

Patient Medicine Service

Services details

Bed alloted details Patients

5.3 3
Compute bed charges

Patient Bed

Medicine details 5.4

Compute Medicine charges

Patient Medicine Test

Final bill generation

5.5

Patient Test Medicine

Taxes and issue bill

Page 27

ERD:

Page 28

TABLE AND DATA DICTIONARY

TABLE DESIGN:

Service:

Attribute Ser_id

Type Number

Width 6

Key Primary Key

Constraint Not Null, Unique

Description Gives the Unique service Id No Gives the service Name Describe the service Gives the cost per unit for each service

Ser_name

Varchar2

10

Not Null

Ser_desc

Varchar2

15

Not Null

Cost_per_unit

Number

Not Null

Page 29

Doctor:
Attribute Doc_id Type Number Width 6 Key Primary key Doc_name Varchar2 20 Constraint Not Null, Unique Not Null Description Unique for every doctor The doctors name Doctors Contact Details Doctors Address Doctors Field Of Specialization Consultation Fees Type of department

Doc_contact

Number

14

Not Null

Doc_address

Varchar2

50

Not Null

Doc_Specialization

Varchar2

20

Not Null

Doc_ Cons_Fees Doc_dpt

Number

Not Null

Vacrchar2 15

Not Null

Page 30

Medicine:

Attribute Med_id

Type Varchar2

Width 6

Key Primary key

Constraint Not Null, Unique Not Null

Description Gives the Medicine Id Medicine Details Name of the Medical Manufacturer Type of medicine Cost per unit of medicine

Med_desc

Varchar2

10

Manf_Name

Varchar2

10

Not Null

Med_type

Varchar2

10

Not Null

Med_cost_per_unit

Number

Not Null

Bed:
Attribute Bed_id Type Varchar2 Width 6 Key Primary key Bed_type Varchar2 10 Constraint Not Null, Unique Not Null Description Gives the Bed Id Gives the type of bed Gives the bed

Bed_Cost_per_day

Number

Not Null

Page 31

cost per day

Registration:

Attribute Reg_id

Type Varchar2

Width 6

Key Primary key

Constraint Not Null, Unique

Description Is Unique For Every Registration Registration Incharge Reason for admittance

Reg_By

Varchar2

20

Reg_reason

Varchar2

30

Patient_Id

Varchar2

Foreign Key

Not Null

A reference to the patient id

Page 32

Patient:
Attribute Patient_id Type Varchar2 Width Key 6 Primary key Patient_name Varchar2 20 Constraint Not Null, Unique Not Null Description Is Unique For Every patient Name of the patient Date of birth of the person Sex of the patient Patient contact number Not Null Address of the patient Patient of opd or ipd Company candidate or normal

Patient_dob

Date

Not Null

Patient_sex

Varchar2

10

Not Null

Patient_contact_no Number

14

Patient_Address

Varchar2

50

Patient_type

Varchar2

10

Patient_category

Varchar2

20

Page 33

Bill:

Attribute Bill_No

Type Varchar2

Width 6

Key Primary key

Constraint Not Null, Unique

Description Generated Automatically and is unique Generated When bill is printed Generated with the bill A reference to registration

Bill_date

Date

Not Null

Bill_amt

Number

10

Not Null

Reg_Id

Varchar2

Not Null

User
Attribute User_Id Type Varchar2 Width 6 Key Primary key User_Name Access Varchar2 Varchar2 10 Constraint Not Null, Unique Not Null Not Null Description Unique user id

User name Access to system

Page 34

Receipt:
Attribute Rec_No Type Number Width Key 6 Primary key Rec_date Date Constraint Not Null, Unique Not Null Description Is Unique for every patient Date of receipt generation Amount for which the receipt is generated A reference to registration Mode Of Payment

Rec_amt

Number

10

Not Null

Reg_Id

Varchar 2

Foreign key

Not Null

Payment_Mode

Varchar2

10

Not null

Page 35

Dicharge_Card:
Attribute Discharge_card_id Type Varchar2 Width 6 Key Primary key Patient_Id Varchar2 6 Foreign key Constraint Not Null, Unique Description Gives the Uniques service Id No Gives the patient Id Gives the follow up Gives the doctor details Gives the next appointment date A reference to the registration

Not Null

Follow_up

Varchar2

100

Not Null

Doc_details

Varchar2

50

Not Null

Next_ appointment_date

Date

Not Null

Reg_id

Varchar2

Foreign key

Not Null

Page 36

Test:
Attribute Test_id Type Varchar 2 Width 4 Key Primary key Constraint Not Null, Unique Description Gives the unique test id Name of the test Description of the test Type of test Rate of test

Test_name

Varchar 2

20

Not Null

Test_desc

Varchar 2

30

Not Null

Test_type Rate

Varchar 2 Number

20 (6,2)

Not Null

Page 37

Input Form
Medicine_Master_Form:

Page 38

Doctor_Master_Form:

Page 39

Service_Master_Form:

Page 40

Bed_Master_Form:

Page 41

Registration_Master_form

Page 42

Bill_Form:

Page 43

Medicine_Purchase_Form:

Page 44

Discharge_Card_Form:

Page 45

Receipt_Form:

Page 46

Doctor_View_Form:

Page 47

REPORTS
Month Wise Revenue Report:
Name of the Report Purpose User : Month wise revenue generated : To analyze monthly revenue generated from different department : Lower Level Management

Tables referred : doctor, patient, bill

Page 48

Quarterly Revenue Report:

Name of the Report Purpose User

: Quarterly revenue generated : To analyze quarterly revenue generated from different department : Middle Level Management

Tables referred : doctor, patient, bill

Page 49

Yearly Revenue Report:

Name of the Report Purpose User

: Yearly Revenue Collected From different Department : To analyze Yearly revenue generated from different department : Top Management

Tables referred : doctor, patient, bill

Page 50

Number of Patients Referred Report:

Name of the Report Purpose User : Yearly Number of Patients Referred : To analyze number of patients referred by a doctor : Management

Tables referred : doctor, patient, test, medicine

Page 51

Yearly Category wise Patients Report:

Name of the Report Purpose User : Yearly category wise patient Report : To analyze different category of patients : Management

Tables referred : patient, service, medicine, bill

Page 52

Yearly Company wise Patients underwent Treatment Report:

Name of the Report Purpose Users

: Company wise number of Patient undergone treatment in hospital : To analyze revenue generated from a company : Management

Tables referred : patient, service, medicine and bill

Page 53

Bed wise allocation Report:

Name of the Report Purpose Users : bed wise allocation report : To provide bed to the patient unambiguously : Lower level Management

Tables referred : patient, bed, medicine and discharge card

Page 54

Bed wise availability Report:

Name of the Report Purpose Users : bed wise availability status report : To provide bed status to the patient : Lower level Management

Tables referred : bed, service, patient

Page 55

Hospital Bill Report:

Name of the Report Purpose Users : Hospital Bill : To provide Bill to the patient at the time of discharge : Lower level Management

Tables referred : patient, bill, doctor, discharge card, service

Page 56

OPD/IPD Registration Report:

Name of the Report Purpose Users : OPD/IPD registration report : To provide details of patient at OPD/IPD : Lower level Management

Tables referred : patient, service, doctors

Page 57