If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You must register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Medical Database Design

I'm currently designing a medical records application and have some questions as to how to store large amounts of data (physical exam, for example) in a table. The program also needs to handle intra-office communications and communications with patients via a portal so I'm unsure how to structure this in the backend table(s).

I'm using SQL Server 2005 and would like to get this done before utilizing Alpha to build the interface.

Re: Medical Database Design

Originally Posted by washim

I'm currently designing a medical records application and have some questions as to how to store large amounts of data (physical exam, for example) in a table. The program also needs to handle intra-office communications and communications with patients via a portal so I'm unsure how to structure this in the backend table(s).

I'm using SQL Server 2005 and would like to get this done before utilizing Alpha to build the interface.

Thanks.

Try some of the sample apps in Alpha, they are dbf tables but the structure might help you make up your mind...

Re: Medical Database Design

Originally Posted by washim

I'm currently designing a medical records application and have some questions as to how to store large amounts of data (physical exam, for example) in a table. The program also needs to handle intra-office communications and communications with patients via a portal so I'm unsure how to structure this in the backend table(s).

I'm using SQL Server 2005 and would like to get this done before utilizing Alpha to build the interface.

Thanks.

Storing text should not be an issue; Images will be. Some vendors choose to "link" to an image and others put binary data into the table. Some of this is for CCHIT certification and other is just for security.

You will be using several tables that will relate/link. You're probably better off starting on v9 as it affords better tools for connecting/updating sql engines.

You will also need to be familiar with the different column types of your sql backend so as to determine the best type for storing "chunks" of data; you'll also need to store formatting codes for say underlining; bold, etc.

Re: Medical Database Design

Thanks guys.

What I really need is an ERD showing how one would store elements of an encounter. I know the components but exactly how to store them in tables is the question.

My rationale for using SQL Server is that it will allow future development with whatever front end I decide to use if ultimately Alpha Five does not accomplish my goals. From what I've seen, however, I don't think that will be the case.

I already know how I want the interface to function. How this is represented in the back-end is currently my sticking point.

Re: Medical Database Design

First:

What version of Alphga are you using? If you have a specific problem in how to accomplish it, you would do much better to post it in the forum for the product you are using. It will get much more help in general.

Once you know what your user screens should look like, the rest is somewhat easier. It just depends on what you want it to do.

I do not mind if you private me or email me at car_man46@yahoo.com. You will be limiting your available knowledge this way, because none of us have as much knowledge as all combined. There are a bunch of people on here that are better versed on sql than I am and there are also a bunch on here better in other areas.

There are some basics to this RAD that cn be very helpful and if several people join in, the basics will get easier for you even if they disagree.

Re: Medical Database Design

Can someone show a complete dbf tables designed for a small/medium sized hospital.I'l try to build the interface based on the tables.e.g Patient dbf, Inpatient dbf,Outpatient dbf, Diagnosis.db etcThanks!

Re: Medical Database Design

I have since paid a group to develop this software for me given lack of time to devote to the project. I still have the Alpha software that I've never used. If anyone is interested in purchasing at a significantly reduced rate please let me know.

Re: Medical Database Design

Oh no, I'm so sorry, the first time i visited the site was Okey, but now i tried to open but it really informed me that it is an attack site.Maybe the admins can delete my post, I can't edit it. Thank you!