|
|
DETAILS OF
HOSPITAL SOFTWARE
MEDIC AID
(Hospital
Management System)
Contents
I. Introduction
II. Modules available and fully functional
III. General Information
IV. References
A. Introduction
MEDIC AID is a database Application made for the explicit purpose of storing
patients' and related Hospital data. It is a totally GUI based Front End
application made for the MS Windows /NT platform but can also work with some
flavours of UNIX (Sun Solaris) as well as Mac. It utilizes an RDBMS at the
back-end, which has to run simultaneously with the application to store and
retrieve the data.
The concept and ideology:
· Better
Record Keeping
· Automatic
form and report creation
· Avoid
drudgery of repetitive typing
· Eliminate
Writing
· More
Efficiency
· Eliminates
paperwork and the need for getting a range of letterheads and stationery
· Speedy
analysis of data
· The
Multiple user version of this application (over a Client Server Network) is
provided along with a license of Sybase
SQL Studio® database - the RDBMS for which MEDIC AID is optimized for. But,
if required, it can be optimized for connection to the users' own database like
SQL Server® ,
Oracle®, Informix etc. Sybase SQL Studio is compatible with all versions of
Windows and NT as well as Linux.
In MEDIC AID, the data is
stored through easy to use, aesthetic forms with the purpose that the user will
never need to type any information more than once even if for a totally
different reason. The patient's data needs to be fed in only once on his
arrival. He/she is provided with an automatically generated Registration
Number. MEDIC AID will use this number to access and (if not yet made) create
different records like Operation Notes, Admission, Prescription and Bills, etc.
Unlike conventional HMS
systems, this software is made from the clinical and record keeping view point.
This system has been made with close supervision of doctors who have tried to
replace their activities through all their record keeping and writing
activities through the computer. An attempt has been made to provide a system
that emulates a hospital and an individual doctor's paper work through the
computer so that it is
· Simple to use
· Change over (from manual record keeping)
is painless.
· It is faster than
manual record keeping
· More efficient
In a real time test, it was
found that while keeping a permanent record of all the details of the patient,
it could provide a prescription as well as fill in the investigation forms and
reports of any patient faster than manually writing just one medium sized
prescription along with the name age sex etc.
The only software which
keeps complete range of hospital paperwork requirements from clinical details
to the hospitals daily administrative working needs in the digital format.
Entirely made in the 32 bit Windows platform, the GUIs besides being pleassing on the eye are structured to allow all the work
at a particular site from a single main screen.
Context sensitive Online help as well as manual are provided at each node.
Staff training and more
important, inducement of staff to shift to daily usge
is our commitment which has helped us get one of the largest user base for
Medical Software in
Website Development is
part of a separate division and is introduced separately but Email of clinical
records as well as access of details and online referrals, transmission of
reports is very much a part of Medic Aid
which is optimized to work over an intranet
B.Modules available and fully functional
Healthcare
·
Reception
·
Physicians' Out patients
·
Speciality Modules for
·
Ante natal care (Obstetrics)
o ANC Booking
o ANC Visits
o Delivery Notes
o Birth Certificate
o Separate admission for
baby
o Neonatology
·
Paediatrics
o Birthday greetings
o Immunization records
o Growth charts
o Reminder Letters for
Appointments
·
Plastic Surgery
o Mutliple Diagnosis storage
o Multiple procedures
coding and recording
o Image Maintenance
·
Physiotherapy
·
Appointment
·
Ward Patients - Admission, Discharge and transfer
·
Ward case sheet record
·
Routine Medical Check-up report
·
Detailed Check up
·
Operation Theatre Booking
·
Operation notes
·
Operation billing
·
Anaesthesia notes
·
Admissions - Routine and emergency
·
Casualty
·
Pharmacy
·
Surgical Supplies and Inventory
·
Central Drug and Stores
·
Laboratory
·
Radiology
·
Endoscopy
·
Sonar systems
·
Complete tracking of Medical records
·
Retrieval and Linking of Old records with present
·
·
Photographs and image storage retrieval
·
Telemedicine
Peripheral systems
·
Accounting
·
Clinic administration
·
Appointments
·
Receipts - pending and received
·
Payments - due and Paid
·
General ledger
·
Address Book
·
Debit Credit
The last point is common
for all personnel including Doctors, referring doctors, On
call specialists, staff and works as the master list to access names like
treating physician, consultant on call, staff on duty etc.
More modules based on
actual user requirements can be added to the database at a very short notice.
These include :-
Medical Personnel and payroll system, Nursing care details
General Computing Needs
These are not provided in
any specific form by this software but training can be provided to work on
applications like MS Word and Excel. Use of Import Export facility by MEDIC AID
allows intermingling and reuse of available data for the hospital in these
general apps.
Screens are structured such as to link all related data tabs to the
same screen e.g the diagnostic lab will have the tabs
for Ordering investigations, report generation - of all separate types,
billing, Daily register etc along with a general patient search. The user just
selects the patient to be investigated (By scroll or query) and clicks on the
required tab. Multi selection of ordered investigations in groups or individual
(e.g. one can order the complete haemogram (single
selection) or Hb Tlc (2
selected) only is done (patient is automatically billed as per payment
capacity) and as soon as the user clicks that the form is complete, the
patients reports are ready for entry If the user selected Haemogram,
it means reports will created for Hb, TLC, DLC, ESR.
Peripheral Smear etc - as many as once pre decided.
Report generation is
extremely easy and does not require the searching /thinking of competitive
apps. Just click on the print tab while viewing the current form. In the above
example - while entering the haemogram, if the cursor
is in any of records of the above reports, the entire haemogram
report will be printed.
C. General Information
Total number of nodes
suggested and Operating Hardware required:
The number of
workstations depends on the number of nodes (one each). Ideally one server is
additionally required for every 8-10 nodes + one backup for every 4 servers or
less. A 1500 bed hospital would require approx. 50 workstations.
Operating System
(Servers) Windows NT or 2000
For Workstations
Windows 98 or Me.
Printers: Deskjet or Laser one at least for
every place needing a report, + 1 backup for every 8-10
Once the hardware is in
place, the software can be installed. Software is available as auto installable
CD complete with the database (if Sybase SQL Anywhere
is to be used).
Once
installed master lists will have to be created like names of doctors and staff
(Address book), charges for procedures, drugs available in the Pharmacy, store
locations etc. Once these are entered the full functionality like single
keystroke access will be apparent. Different modules for the exact locations
have to be implemented on site.
Most of the modules have
been designed as per specifications given by the client.
The core system will be
up and running within one month but addition of new modules, debugging of the
same, fine tuning and training of regular staff will take around 4 - 6 months.
D. References
List of existing Users (This is only a partial list - it is
growing by the day)
·
President's Estate Clinic,
·
·
Thyroid Clinic, INMAS,
·
RANA Nursing Home,
·
Dr Devinder Gaba
Pediatrician, Janakpuri,
·
Dr P Rustogi Orthopaedic Surgeon,
·
Dr Lalit Kumar General Physician, Vivek Vihar,
·
Dr Aloke Juneja
Pediatrician
·
Dr K Kathuria Obstetrician and
Gynaecologist, Nursing Home owner
·
Dr Rawat, Cardiologist and Nursing
Home Owner,
·
Escorts Medical Institute,
·
Dept of Plastic Surgery, Indraprastha
Apollo Hospitals
·
Dr T Kamra, Dehraduun
·
·
GOURI Nursing Home, Malkaganj,
·
Dr Rana Patir,
·
Dept of Urology AIIMS,
·
Neonatal ICU, AIIMS,
·
·
Sanwari Bai
Surgical Centre, Rajinder Nagar,
·
·
Dr. Vinod Kansal,
Pitampura,
·
Dr. K Sridhar,
·
Dr. G Manokaran,
·
Dept of Haemotology,
·
Dr Rakesh Chopra Oncologist
APPOLLO HOSPITAL,
·
R B
·
SKIN and COSMETIC CARE Clinic, Paschim
Vihar,
·
Dr Gopal
Goel, Janakpuri,
Actual comments of software experts and doctors:
· “One of the best’. (Adjudged by Doctors/users)
· “Requires
far less keystrokes for the same job as compared to others’. (Software and
Hardware seller)
· “Seems
to have been made by some one who knows and understands medical needs”. (Medical Consultant).
· “There
seems to be very extensive hard work gone into it, even I would balk at the
daunting task its creation seems to require”. (Software expert /System analyst)
E. Charges
Charges (of software
alone) can be separated as follows
Basic cost and implementation
cost. The Implementation period of 6 months will include onsite development and
maintenance. Additional AMC can be provided separately
Basic cost: It includes
the cost of the database provided Sybase SQL Anywhere (If the desired vendor
agrees to use that)
· Rs 35000 per server
· Rs 25000 per work station
(If a database license
from another company like ORACLE or SQL Server is already with the user, a
certain amount per
user can be subtracted from these. But time required for implementation time
will be longer and we will need co-ordination with the vendor of that
license.). Taxes shall be as
applicable
Implementation cost.
The implementing staff
shall be working onsite for 4 - 6 months. These costs wil
depend on location - It is reasonable to assume that Travelling Allowance as
well as local accommodation is provided by the clients.
One Project Leader--He shall function as overall incharge of the project.
Three Development Officers. They shall train the local staff to run the
nodes as well as develop new modules, do fine tuning and debugging.
(Optional) Staff to initially man the workstations. They can train the
local staff to free the above to more important tasks. Using staff trained by
us in
Annual Maintenance Contract
First 6 months after the
implementation period cost of one Development Officer posted onsite
After that (optionally As
above OR)
Basic
cost of software + TA / DA for staff. Will include a
visit for a week every 3 months or less on call.