Patients and their prescriptions database

G

Guest

What we have is the following

A person comes in with a list of medications they need to take. It can be from one, up to around 13 to 15, depending on the person.

The same person can have one doctor, or multiple doctors, but usually one doctor.

We fill out an application for each medicine (prescription or script). Regardless if they have multiple medicines from the same company

We gather the paperwork, send it to the Dr for signature, receive the paperwork back from the Dr. and send it to the pharmaceutical company.

The problem come in here. After the initial order, the person comes back in when their medication runs out. Either in 30, 60, or 90 days. Then we do a re-order for the person.

How do I keep a history of what we have done for the person?

And for each medicine

I would like to grow the database in the future to include the pharmaceutical companies and their respective medicines.

I would also like to have the system tell me when a persons medication is about to run out, so that we can reorder it and the person does not have to go without medicine, which they have to do now.

We also have to track the following

The date the person originally came in and joine
The date we originally received a prescriptio
The date we processed the prescription and did the paper wor
The date we sent the paper work to the Dr for signatur
The date we received the paper work from the Dr with his signatur
The date we send the paper work to the pharmaceutical compan
The date the medicine comes i
The date we contact the person that their medicine is in and available to be picked up.

Any help and or guidance would be very greatly appreciated, and help us to help many other people that would not normally get the medicines they need to live.

Thanks in advance,

Kirk Rotrame
P.A.L.S. - Prescription Assistance League Servic
Patient Advocat
 
P

Pavel Romashkin

Do you already have anything in place, or are you going to make a new
database for it? My reason for asking is, if you already have something,
you will want to keep (at least the data from) what you have. If you are
doing a "clean install", you can design it properly form the ground up.
Depending on this, db structure would differ.
Good luck,
Pavel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top