LAN-Based Electronic Medical Record System

LAN-based Electronic Medical Record System

Purpose and Description

To develop a LAN-based Electronic Medical Record System that will benefit the patients of Medical Lab Clinic. The system includes billing, laboratory results and history of doctor’s prescriptions.

The objectives of the Electronic Medical Record System would be:

• To have a LAN-Based Record System that will monitor the patient’s record and doctor’s appointments.
• To easily retrieve patient’s record

Scope of the Study

The study is focused on developing the patient’s record. Patient Integrated system is a LAN-Based System that will focus on keeping all the patient records.

The system will consist but not limited to the following modules:

• Patients Record Keeping
• Billings
• Laboratory Results
• Consultation Fee
• Medicine Inventory
• Doctor’s Prescriptions
• Doctor’s in Charge

The proposed system also includes a terminal for the patient to view the following information:

• Patient Medical History
• Reservations of Appointments
• Reservation of Laboratory Request
• Doctor’s Prescription
• Patient Billings

Database Schema

tblPatient (id, recordNo, lname, fname, mname, gender, age, address, contact, username, password)

tblQue (id, patientid, mdate)

tblDoctor (id, doctorrecono, doctorName, address, contact, fieldOfSpecialization, username, password)

tblCases (id, caseName, description)

tblMedicine (id, medicineName, purpose, initialQty, dateDelivered)

tblConsultation (id, patientid, diagnostic, treatment, bp, weight, attendingDoctorid, dateRecorded)

tblGivenMedicine(id, consultationid, medicineid, qty, amount, mstatus(sold or not))

tblLaboratoryRecord (id, patientid, labName, resultStatus, dateReleased)

tblBilling (id, patientid, billTo, billAmount, dateRecorded, tblgivenmedicine.consultationid)

tblClerk (id, clerkrecno, fullname, address, contact, username, password)

Features

1. The user will encode the following records:
   1. Patient info
   2. Doctor info
   3. Cases/Diseases
   4. Medicine
2. The user will then add the patient to que list
3. The user will record the consultation info
4. The user will record the Laboratory result
5. The user will issue a billing statement
6. The patient can view his/her medical records

Menu Structure

Administrator

• Manage Clerk
• Manage Doctors
• Manage Medicine

Clerk/Users

• Manage Patient
• Manage Cases
• Manage Medicine
• Record Consultation
• Record Laboratory Result
• Manage Billing
• View Queue
• Change Password

Doctors

• View Queue
• View Consultation Archive
• Change Password
• view patient view lab result

Nurse

• Manage patient
• Manage cases
• Manage medicine
• Manage billing
• Change password
• View Queue

Accounting

• Manage patient
• Manage billing
• Manage medicine

Medical Technician

• View patient
• Manage lab request/result change pass

Development Tools:

The proposed project can be develop using the following programming languages:

• Visual Basic 6/.Net and MySQL
• C# and SQL Server or MySQL
• Java and MySQL
• PHP, MySQL and Bootstrap