Computerized Billing System
DESCRIPTION OF THE EXISTING SYSTEM
The existing system of the patient record was found to be completely manual at the Dra. Nelma Tan ObGyne and Medical Clinic. The secretary will write patient information into a medical form. The Clinician (Dra. Nelama Tan) takes the medical history of the pregnant, writes diagnosis and treatment on the form. The Clinician sometimes can refer the patient to the laboratory for medical test before diagnosis depending on the situation of the patient (pregnant). All the patient form are collected and kept in the filling cabinet for follow up check and future use.
DESCRIPTION OF PROPOSED SYSTEM The current manual system used at Dra Nelma Tan ObGyne Clinic generates paperwork that is difficult to deal with, in terms of storage, retrieval, maintenance. The proposed Patient Information System is designed in Visual 6.0 and MS Access. It will improve the keeping of medical records of the patient, can handle data efficiently, more accurate in filling and retrieving of records. Since the necessary data is available in one place and the computer is able to manipulate it like sorting, stratifying, then the reports are easy to make unlike using the manual system. The Proposed system directly maps on database and its focuses in adding, searching, modifying, printing and saving of the medical history/ diagnosis of the pregnant patient.
FLOWCHART OF EXISTING SYSTEM Secretary
Secretary
0 Check-Up
0 Check-Up
Patient
Patient
1
Manually Search
Record
1
Manually Search
Record
Filling Cabinet
3
Forward
3
Forward
2
Write new patient record
2
Write new patient record If not found If Found
6
Re-file medical form
6
Re-file medical form
5
Visit end
5
Visit end
4
Educate patient write remarks on clinic form and
The existing system of the patient record was found to be completely manual at the Dra. Nelma Tan ObGyne and Medical Clinic. The secretary will write patient information into a medical form. The Clinician (Dra. Nelama Tan) takes the medical history of the pregnant, writes diagnosis and treatment on the form. The Clinician sometimes can refer the patient to the laboratory for medical test before diagnosis depending on the situation of the patient (pregnant). All the patient form are collected and kept in the filling cabinet for follow up check and future use.
DESCRIPTION OF PROPOSED SYSTEM The current manual system used at Dra Nelma Tan ObGyne Clinic generates paperwork that is difficult to deal with, in terms of storage, retrieval, maintenance. The proposed Patient Information System is designed in Visual 6.0 and MS Access. It will improve the keeping of medical records of the patient, can handle data efficiently, more accurate in filling and retrieving of records. Since the necessary data is available in one place and the computer is able to manipulate it like sorting, stratifying, then the reports are easy to make unlike using the manual system. The Proposed system directly maps on database and its focuses in adding, searching, modifying, printing and saving of the medical history/ diagnosis of the pregnant patient.
FLOWCHART OF EXISTING SYSTEM Secretary
Secretary
0 Check-Up
0 Check-Up
Patient
Patient
1
Manually Search
Record
1
Manually Search
Record
Filling Cabinet
3
Forward
3
Forward
2
Write new patient record
2
Write new patient record If not found If Found
6
Re-file medical form
6
Re-file medical form
5
Visit end
5
Visit end
4
Educate patient write remarks on clinic form and