Design And Implementation Of A Mortuary Billing System

Introduction

1.1 Background of the Study

A morgue or mortuary (in a hospital or elsewhere) is used for the storage of human corpses awaiting identification or removal for autopsy or disposal by burial, cremation or other method. In modern times corpses have customarily been refrigerated to delay decomposition. Mortuary early 14c., from Anglo-French mortuarie “gift to a parish priest from a deceased parishioner,” from Medieval Latin mortuarium, noun use of neuter of Late Latin adjective mortuarius “pertaining to the dead,” from Latin mortuus, pp. of mori “to die” (see mortal (adj.)). Meaning “place where bodies are kept temporarily” first recorded 1865, a euphemism for earlier English term “deadhouse.”Morgue from the French morgue, which means ‘to look at solemnly, to defy’. First used to describe the inner wicket of a prison, where new prisoners were kept so that jailers and turnkeys could recognize them in the future, it took on its modern meaning in fifteenth-century Paris, being used to describe part of the Châtelet used for the storage and identification of unknown corpses (Assmann, 2005).

The dead arrive at all hours of the day, zipped into body bags and delivered to a white-tiled room called mortuary.The routine is the same no matter the name on the tag. The time is noted. The body is weighed. An autopsy is scheduled.A life is over, but the work here is just beginning.And so are the costs to taxpayers.Money isn’t the biggest concern at the morgue, not for the staff and certainly not for the families whose relatives are brought here but its proper documentation is important. But every new arrival carries costs that most people never see, from N1000 body bags and N150,000 DNA tests to the N200,000 payment of the pathologist who performs the autopsy.(Gillespie, 2002)

At the morgue, death is both a personal tragedy and a public burden. Mortuary attendants spend more than N4 million a year to keep it running, and the price keeps going up.Most of those costs aren’t negotiable because the state requires special coroners to investigate fatal accidents, homicides and any other death that police or doctors consider “unnatural.” Last year, more than 1,000 such cases came through the morgue’s doors, a 15 percent increase from just five years ago.It depends. If someone is hit by a car, a long investigation probably isn’t needed to determine the cause of death. But if drugs are involved, or murder charges are possible, the investigation and the expense can grow dramatically.

One of the challenges for the billing department is properly documenting payments made by the relatives of the dead body. Due to the long processes the body goes throughfrom when it came to when it left, proper documentation is necessary. Drug and alcohol tests run more than N150, 000, including labor costs, and the analysis of tissue samples is about N18,000. The fatal shooting case is significantly more expensive because it required DNA testing, which totals about N200,000, and eventually will include ballistics and firearms tests, which involve days of work. Manual documentation of all the payments gives rise to errors which would have been prevented if the process is automated by the computer.

1.2 Statement of the Problem

One of the challenges for the mortuary attendants is proper documentation of payments. Due to the long processes the body goes through from when it came to when it left, proper documentation of payments become tedious. The following specific problems were identified in the existing system at the case study:

Inability to keep the proper record of number human body in mortuary

Error in computation of available space in the mortuary

Inability to accurately calculate bill for mortuary service

Errors in computation of mortuary bills.

Difficulties in obtaining mortuary bills report.

This work tends to curb the above problems by designing a computerized billing system for the mortuary. With the developed system, documenting, analysis, searching and computation of bills becomes easy. Doctors and managers can make better managerial decisions due to accurate data.

1.3 Aim and Objectives of the Study

The aim of this study is to design and implement a billing system for mortuaries for the proper management of payments. To achieve the stated aim, the following specific objectives were laid out:

To design a system that can be utilized to accurately bill for mortuary services.

To design a database system that can be used to store mortuary billing records.

To design a system that can be used to obtain mortuary bill reports.

1.4 Significance of the Study

The billing system will be of great benefit to mortuaries and it will improve the managerial cum administrative strength of the hospital and move the business forward to meet the demand of times and globalization in this era of technology. It provides easy record of goods and proper identification of payments. This piece of work will add to the already existing literature review and act as a reference work for future researchers.

1.5 Scope and Limitation of the Study

This project work covers body registration, payment management and receipt generation. It tends to correct anomalies in morgue business. It provides quick way of operation by capturing the manual process and automating them. Receipts are printed after payment and can be reprinted at will at any number of times. This project uses web technologies to accept and store the necessary information. The users must connect to the system using any internet enabled device. One major limitation of this system is that it doesn’t support all the features of mortuary management system like warehouse management and body status monitoring which are very important features in mortuaries.

1.6 Project Methodology

There are approaches are also referred as Software Development Process Models. These processes model follows particular life cycle in order to ensure success in process of software development. One such approach which is used in this project is waterfall model. It was the first process model to be introduced and followed widely in software engineering to ensure success of the project. In the waterfall approach, the whole process of software development is divided into separate process phases. The phases in the waterfall model are: Requirement specification phase, Software design, Implementation and maintenance. All these phases are cascaded to each other so that second phase is started as and when defined set of goals are achieved for first phase.

1.7 Project Organization

This research work is organized into five chapters.

Chapter one is concerned with the introduction of the research study and it presents the preliminaries, theoretical background, statement of the problem, aim and objectives of the study, significance of the study, scope of the study, organization of the research and definition of terms.

Chapter two focuses on the literature review, the contributions of other scholars on the subject matter is discussed.

Chapter three is concerned with the system analysis and design. It presents the research methodology used in the development of the system; it analyzes the present system to identify the problems and provides information on the advantages and disadvantages of the proposed system. The system design is also presented in this chapter.

Chapter four presents the system implementation and documentation, the choice of programming language, testing, and choice of programming language and system requirements for implementation.

Chapter five focuses on the summary, evaluation of the study, conclusion and recommendations are provided in this chapter based on the study carried out

1.8 Definition of Terms

Mortuary:

A place where dead bodies are stored prior to burial or cremation.

Embalm:

To treat a corpse

Funeral:

A ceremony to honor and remember a deceased person

Bill:

Amount charged for a service

Autopsy:

An activity performed to find out the cause of death.