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.
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
• 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?