Patient Log Database

I currently use excel spreadsheets to record what my ultrasound technicians do on a daily basis at various offices. I need a program created that can store, First & Last Name, Date of Birth, Date of Service, Insurance Name, Referring & Reading Doctors Name, Location, and what ultrasound study was done.

At the bottom i need to see the total number of studies done and I need to be able to calculate what we are paid for every study and be able to create various reports.

I may also want to have a web based solution that I can host on go daddy or a server.

These logs are done daily and we categorize them by the Referring Doctors name and month

Something important: We will need to have multiple users access the database and there should be a feature to not allow another user to update the log if someone else is currently working on it.

I want to host the program on a domain by godaddy and have my techs login from any office and would like not to have to download any applications on a computer to make this work.

About Us
We provide mobile ultrasounds services to different offices and need to have a patient log for each office we go to because it allows us to record what our technicians did for the day and we need to provide that info to the referring doctor (which is the doctor’s office we are working at for the day). We currently keep track of everything in excel by months and it becomes a problem because our techs calculate the studies incorrectly, delete the spreadsheet, we have multiple copies because more than one person tries to update the same log.

We use the logs for several things:
1. What studies were done on a patient
2. Calculate how many and what type of studies were done daily, weekly and monthly.
3. Print reports for our referring doctors showing a monthly list of what studies they submitted and an area with the totals of everything.

I need to be able to search for many things: I may need to search for all echo’s done in January, I want the results to list the information and have the option to be able to filter by different fields.
Reporting: I want to know how much I made from each referring doctor based on the calculations we setup for each study we receive. But I need to be able to change those values as medical insurances update them as well as billing, rent etc

Remote Access
• I want to allow the doctors to login and only view their log so they can determine what studies were done on each patient
• I want to allow my sales team to only view a log but not see patient name and other fields I may want to hide.

Some other things we would need
• Need to be able to manage what fields and columns etc. users can view and edit permissions.
• Various users will use the database and only one at a time should be able to update it while others can only ready. A message should alert them file in use by user (name of person)
• Because there are several accounts which have their own patient log am I able to have multiple people working in different logs at once?
• What happens if I need to add a new field? Example. I need to add a location field because some doctors have different locations. Can I add it and it will incorporate into the database you designed or do I need to contact you and that’s an additional cost?

Taidot: ASP, Microsoft Access, MySQL, SQL, Visual Basic

Näytä lisää: my sql create database, go daddy number, need technicians, ultrasound, excel to my sql, excel log database, excel database visual basic, visual basic database excel database, log excel visual basic, 2013 excel visual basic, excel sql create, excel 2013 visual, excel study, database technicians, visual basic excel 2013, patient excel database, create reports excel database, excel 2013 visual basic, sql excel database, service log, Patient record, doctors excel database, create reports sql database, reading database, visual basic excel database

Tietoa työnantajasta:
( 1 arvostelu ) Staten Island, United States

Projektin tunnus: #4276257