Posted: Sat Jul 21, 2007 4:27 am Post subject: Possible to construct Patient Data Base?
I'm a chiropractor and the wife has decided to computerize the office. I've looked at the programs for scheduling, managing patients, etc and they are rediculous in their price and I have no need to do anything with insurance with is usually the big feature.
I was wondering if it was possible to construct a database that could do the following:
Hold patient details: Name, address, phone, etc.
Hold patient notes: multiple entrys by date & write details.
Generate letters using info in patient details database
Generate list of birthdays coming up next month
Contains pictures: patient face, xrays, mri scan, etc.
More of course but before I go wading through all the help file, learning how to do all this, I want to ask you knowledgeable people if this is possible. If so I'll start reading and learning how, if not I won't waste my and your time.
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Sat Jul 21, 2007 5:52 am Post subject:
I know for certain you can do the first three things you asked about.
I am reasonably certain you can generate the list of upcoming birthdays.
I think it is possible to include images, but I don't know what field type you need, or what the limitations are.
You should know that most of our forum regulars don't use Base much. More often than not, we have to refer questions to the OpenOffice.org Base forum.
I am working on learning more about Base, and have started a tutorial series in our Wiki, but I'm not very far in the process. The NeoBase page in the wiki also has links to other tutorials, reference guides, and articles on using Base available on the net.
I can tell you that you will want one table for patient info (names, addresses, birthdays, etc.) and one table for patient notes. You might want a third for images, test results, etc., although those could also be entered as dated patient notes. If you want to handle billing through the database, that will involve one or more other tables as well, I would think.
Joined: Nov 21, 2005 Posts: 1285 Location: Witless Protection Program
Posted: Sat Jul 21, 2007 7:45 pm Post subject:
drbones666,
Creating a complex and business critical database is something that takes some time.
While it an interesting task, can you take that much time from your practice?
I'm not trying to be rude, just warning you based upon my past experience.
Joined: Dec 08, 2005 Posts: 291 Location: Berlin, Germany
Posted: Sun Jul 22, 2007 11:29 am Post subject:
drbones666,
I'm doing database development (in web environments) professionally, and just my feeling is, that NeoOffice (or OpenOffice.org) Base to use for your task wouldn't be my choice:
1. Like LemonAid said, it takes some time
2. I think some knowledge of the inner workings of Relational Databases and SQL (Structured Query Language) would be necessary (especially when using Base)
3. The project seems to be experimental to me, as Base seems to have still many bugs and limited features
If I would have to produce a system like the one you'd like to have, and there would be no affordable solution available, I would suggest to use (the commercial, and not very cheap, sorry) FileMaker Pro, as I would have the feeling, that I can produce nice interfaces to work with every day. Additionally, I know of some non-professionals, who managed to do such projects with FileMaker by themselves (it has a rather easy graphical interface, good documentation and low entry levels).
If you'd like to further explore the Base option, I would first ask on
http://www.oooforum.org/
about experiences with similar projects.
And, finally, if you do use Base, I would be very interested in your experiences.
Joined: Jun 20, 2006 Posts: 2051 Location: Midwest, USA
Posted: Sun Jul 22, 2007 12:02 pm Post subject:
Patient addresses, and mail merge letters is a relatively simple process that you could probably tackle relatively easily.
Dated notes and images will require more work, and in all honesty the documentation is scattered and has lots of holes. (See my rant on this very topic if you want more details.)
Don't get me wrong, I'm thrilled that Neo now has a database component, and I have successfully used it for simple projects. But it is not a terribly user friendly component, especially given the current state of the documentation. (I understand that the OOo authors group is working on a guide to Base, but it's not finished yet.)
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum You cannot attach files in this forum You cannot download files in this forum