Sample Preparation of The Hospital Database Schema
In general, the flow of services in a hospital is like this, first a patient comes in to register for the examination of physicians in ambulatory care or emergency services. Patients who had taken care of at the hospital will certainly use the medical record number previously used by the patient, while the patient who first came to the hospital services is going to get a new medical record number. At the time of enrollment to obtain health care, the patient receives a unique registration number.
Furthermore, patients who have registered earlier will be waiting in line queue in outpatient services to be handled by the appropriate physician, or if the patient signed up for emergency services must be immediately examined by a physician in the emergency services and other medical personnel.
In the next stage, doctors in ambulatory care or emergency care earlier may require further examination in clinical laboratory services or radiology services. This is certainly an attempt to confirm the diagnosis of the patient. The results of the examination in clinical laboratory services or radiology services will soon be given to the doctor, and then the doctor will give the patient the drug therapy.
After stage ambulatory care and emergency services to the clinical laboratory and radiology examinations and drug therapy is considered adequate, then there are two possibilities for a patient to move to the next stage. Two possibilities are patient immediately make payment at the cashier or, on the advice of the doctor patient continued to inpatient services.
From the description above it can be seen that the system of hospital services can be broken down into several sub-systems are interconnected. Sub system include patient registration system, the system in the outpatient, emergency service systems, systems in clinical laboratory services, radiology services system, a system in pharmacy services, payment systems at the checkout. Each of these sub-systems and sample preparation of the database schema will be discussed in further discussion.
Furthermore, patients who have registered earlier will be waiting in line queue in outpatient services to be handled by the appropriate physician, or if the patient signed up for emergency services must be immediately examined by a physician in the emergency services and other medical personnel.
In the next stage, doctors in ambulatory care or emergency care earlier may require further examination in clinical laboratory services or radiology services. This is certainly an attempt to confirm the diagnosis of the patient. The results of the examination in clinical laboratory services or radiology services will soon be given to the doctor, and then the doctor will give the patient the drug therapy.
After stage ambulatory care and emergency services to the clinical laboratory and radiology examinations and drug therapy is considered adequate, then there are two possibilities for a patient to move to the next stage. Two possibilities are patient immediately make payment at the cashier or, on the advice of the doctor patient continued to inpatient services.
From the description above it can be seen that the system of hospital services can be broken down into several sub-systems are interconnected. Sub system include patient registration system, the system in the outpatient, emergency service systems, systems in clinical laboratory services, radiology services system, a system in pharmacy services, payment systems at the checkout. Each of these sub-systems and sample preparation of the database schema will be discussed in further discussion.
0 comments:
Post a Comment