Decision support + drug interaction

innocuous wrote on Friday, December 02, 2005:

Hi,
We want to use OpenEMR for our health maintenance organisation which is a group of 200 doctors managing the health of appx 1,000,000 families.

We are very pleased with OpenEMR features and its ability of capture patient data.

However we find it lacking in two areas:
1) Drug drug interaction check
2) Clinical decision support sytem

1) A drug drug interaction check is vital to the concept of managed healthcare. Can OpenEMR be programmed to allow this feature? If yes, can someone guide us?

2) Again, to improve healthcare and to cut down or errors by the doctors, a clinical decision support system which checks tha patient stats, demograhics, medication and conditions, and checks them against the medication being prescribed will be highly useful.
If it finds any conflict, it should flash an alert on the GP’s screen. The rules for checking the same can be coded into a database.

If these two features can be added, we feel OpenEMr will be among the best EHR out there.

Any help in getting these implemented will be highly appreciated.
Thanks

sunsetsystems wrote on Friday, December 02, 2005:

The programming is easy.  The problem is getting the database content, e.g. the interaction data and clinical expertise.  Do you have a source for those, or a method for collecting the data?

– Rod
www.sunsetsystems.com

sankar1234 wrote on Friday, December 02, 2005:

1. The drug interaction is easy.  The Medical letter (a non-profit organization) sells the database for $89.00.  I was communicating with them, but they didn’t respond.  I will send the communication once again.

http://medlet-best.securesites.com/html/software.htm is the URL.

sankar1234 wrote on Friday, December 02, 2005:

On the clinical support,  It requires lot of time.  One way is to change it so it is diagnosis driven or medication driven.  In other words, when the physician selects a diagnosis code, the most frequently used H/P, Ex, PSFH, Rx should popup. In other words,  the system will learn from previous encounters and diagnosis.

-Sankar
www.cvQuest.com

wpennington wrote on Saturday, December 03, 2005:

ProxyMed
http://www.proxymed.com/eprescribe_formularies.asp

Epocrates
http://www2.epocrates.com/products/essentials/

Above are two companies that provide the drug interaction service and that keep the drug information current.  These are examples of companies offering this service, and other companies provide a similar service.  The companies above offer subscription services, and will likely cost $25-100USD annually per medical provider based on 200 providers. 

Decision support for 200 users, and all of the specialties potentially covered by these providers, is a fairly sizable project.  If you are planning OpenEMR with 1M families, you will probably want to engage in multiple tests of OpenEMR, the customization and create a plan for a proof of concept.  A 3-9 month proof of concept using a subset of 10-20 providers and 50-100K families may be a good place to begin.  I would expect that you will probably need a team of 3-6 people during the proof of concept for development, implementation, training, documentation and project management.  Do you have a plan for a proof-of-concept?  Do you have an RFP for this project or are your planning to hire supplemental internal resources?  Who is going to provide third level support for the application and on-going maintenance? 

For projects of this size, the company management and users generally need assurance that the application will be supported for three to six years following deployment, and assurance that once implemented that someone will be responsible for support, maintenance and training on the application.  Management will be subjecting itself to serious financial risk in migrating to a new open source platform, and insuring that the investment today will still be usable, cost effective, and supported in five years is generally a weighty, and justified, management concern.

andres_paglayan wrote on Saturday, December 03, 2005:

I strongly disagree.

-"Management will be subjecting itself to serious financial risk in migrating to a new open source platform,"

This sounds more like the final statement of a Microsoft funded comparison research. It is easy to mention ‘risks’, but there is no risk when you have the whole GPL-ed code written using one of the most popular programming languages. Read _any_ proprietary EULA, that’s risky.

-"And insuring that the investment today will still be usable, cost effective, and supported in five years is generally a weighty, and justified, management concern."

My feeling here is that this is an effect of the “cover my back” culture. It is easier to say, pay $200k for that product and not taking any further responsibility. If there’s a problem, is the vendor’s problem, even if there is no solution, every decision maker remains guilt free. Serious management is about truly independence and best value too.

Any one who will be handling 200 MDs and 1M clients should have couple of ITs in house. If they are fairly good ITs everything should be well documented. And any other good IT should be able to take over by reading the documentation.

Scalability by clustering a Linux based environment is easy this days (as in out of the box cluster installation). In the other hand, how many of you are running critical data in 5 year old hard drives in your companies? You can’t expect most hardware investments to last more than 5 years.

While data is the most important part, software is a little unpredictable, write anyything new modular enough so in the future it can be reused or ported to any new emerging language that could be the new de-facto development platform.

With decision support, I always ask my self: what are physicians for? There is still not enough proof that they do good more than bad. But an intelligent system that learns from the own database is tempting to have, as in evidence based.

I agree with most posts about drug interactions. Either way is fine.

sunsetsystems wrote on Saturday, December 03, 2005:

I think Walt was just saying "plan carefully", and probably did not mean to imply that an open source solution is any riskier than otherwise.

Perhaps what he doesn’t know are: (a) currently the clinics are not automated at all, and so this is not really a “migration”, and (b) it looks like the management wants to be very much hand-on and will not be turning over responsibility for success to a third party (however it seems they understandably want some advice and guidance from current OpenEMR developers).

It appears the management team is comfortable with open source and with OpenEMR already, and is prepared to devote adequate IT resources towards taking full advantage of the natural benefits of this kind of solution and ensuring its longevity. 

This is exactly the kind of user acceptance and commitment to open source that we want to encourage and nurture.

Regarding scalability, I have been proposing use of a separate OpenEMR database for each clinic, combined with development of some additional tools for centralized management and reporting.  I think this kind of approach will scale very well and will take advantage of the current strengths of OpenEMR.

– Rod
www.sunsetsystems.com

sankar1234 wrote on Monday, December 05, 2005:

I second what Walt mentions. For tasks such as these, they have to approach this problem in a very professional and pragmatic fashion.

I would definitely consider performing experiments on OpenEMR and have resources to do enhancements to OPenEMR. 

The things I would certainly look are : performace, scalability, distributed, replication, network, firewall issues.

For example, though EMR can handle many users on a sufficient memory and processor system, their local network architecture may hinder the performance considerably.  A good system IT guy has to do good experiments before settling down with final installations.

Also, though Linux may be good for performance, but Windows servers will be system of choice because of lots of third party softwares are built for Windows.

Moreover, the local IT resources are more available in windows enviroment than Linux environment, and the costs of acquiring such resources are less. This should be the last consideration.

innocuous wrote on Monday, December 05, 2005:

Sankar, the main problem is that OpenEMR does not go well with a windows install! I have tried hard to install it on Windows. Though I have got success, on some machines it runs out of the box, on others it gives errors even with same OS version! On MS server systems it always gives errors, and you never know when a new error might pop up if you upgrade or add another module.

sunsetsystems wrote on Monday, December 05, 2005:

For an organization already sold on the concept of an open source EMR, and one which is known to be happiest under Linux, I think trying to deploy it on a different, closed-source proprietary platform would be a very strange decision indeed.

By the way I’m getting the feeling that nobody noticed my suggestion above regarding a separate database for each clinic.  This solves most of the scaling issues.

– Rod
www.sunsetsystems.com

andres_paglayan wrote on Monday, December 05, 2005:

"…Also, though Linux may be good for performance, but Windows servers will be system of choice because of lots of third party softwares are built for Windows. … "

When talking serverwise, I can’t think of anything missed out there for Linux.

Do you have an specific application that would be needed to run under a OpenEMR Linux server and which is not available under GPL?

drbowen wrote on Monday, December 05, 2005:

I think the problem innocuous mentioned in prior posts is that these doctors are carrying laptops that run MS Windows already.  Physicians are very resistant to change.

What you are proposing above is to convince 200 physicians to discard their current Windows OS in favor of what they will view as an untried and poorly supported OS.  (It will be difficult to convince them that we are going to support them from inside the United States.)

They using laptops as the server for each physician.  So far there is some variation from one machine to the next on whether the installed MS Windows version will even run OpenEMR. 

OpenEMR seems to be fine on Windows XP and Windows 2003 server.  The install on Windows 2000 can be dramatically more difficult.

The best solution may be to purchase individual licenses for VMWare.  Install the VMWare on the laptops and then run OpenEMR on a Linux server inside of the VMWare environment.  This has the penalty of cutting the effective RAM in half for both the "client" Windows browser and the VMWare\Linux Server.

Installing Linux on a variety of laptop hardware may not be a cake walk. Knoppix based versions would likely be the best at hardware detection.  One could not know for sure until all of the laptop brand names and configurations were known or one had the time to do all of the installations.

drbowen wrote on Monday, December 05, 2005:

I could spend some time trying to determine the minimum Windows OS configuration to install OpenEMR and have it run correctly.

I do have some recently reconfigured Windows 2000 Professional desktops in the office that I could try. 

sunsetsystems wrote on Monday, December 05, 2005:

My understanding is that innocuous is more recently considering an ASP model, with the servers all at a central location.  So the problems of installing on Windows laptops would go away.

However if not, there is now a free VMware Player which would do the job nicely.  It’s no longer necessary to purchase VMware for something like this.  256MB of physical memory is probably not enough, so yes, many of the laptops might need hardware upgrades.

– Rod
www.sunsetsystems.com

sankar1234 wrote on Monday, December 05, 2005:

I didn’t post my message to say Windows is the option to select, not Linux.  I am also fan of Linux and I have worked in SGI and Disney with Unix platforms. My LSU 6 years are all in Unix world.  I adore Unix world. 

At Andreas question: Most Physician know only windows world.  It is easy to sell a windows EMR for me, than Linux EMR though Linux is better.

To Innocuous answer:  For a project of this magnitude,  you could have hired programmers to fix this because you or your customers wanted Windows platforms. Otherwise you wouldn’t have taken windows platform. Also, You have to understand that OPenEMR developer’s test platform is Linux. So everything will work great under Linux, not windows.  Because they didn’t test it under windows.  I spent almost 1 month to compile it in my windows platform.  When I was done, next version popped up. Nothing worked again.  I have to spend 1 more month again.  So, the best option if I may suggest is: For a project of this size, you have to have to hire Php, mysql, html developers (on contract) on your site to fix these problems.  Otherwise, the project may be very risky because your are betting your future without inhouse development efforts.

I have not followed their thread, so I am little on the dark side.  I can’t comment their future direction or plans.   

ajperezcrespo wrote on Monday, December 05, 2005:

Here are a couple of links that might help with VMWare stuff.
http://www.vmware.com/download/player/
Pre-built Browser Appliance Virtual Machine
Featuring: Mozilla Firefox 1.0.7 and Ubuntu Linux 5.04
http://download3.vmware.com/software/vmplayer/Browser-Appliance-1.0.0b2.zip
Download the Player and then use Pre-built VM.  Ubuntu is already installed and ready to run just do OpenEMR install.
http://johnbokma.com/mexit/2005/11/07/vmware-player-ubuntu-installation.html

innocuous wrote on Tuesday, December 06, 2005:

Earlier we were considering installing OpenEMR on individual laptops, each acting as client and server and later we add a synchronization module to upload data to central server
Thats where the issues of windows would come in.
Now what we think will be more practical is to have a central server hosting OpenEMR running linux. The GPs’ can run whatever OS they prefer as they will only be clients connecting to the server
Same as your hotmail and other web accounts.

Yes, we do require that one clinic patients can be only viewed and accessed by the doctor in that clinic. No sharing of patients is allowed.

I guess the main area we will have to concentrate on is 1) hardware and backup 2)patient db 3)client access 4)additional modules ie formulary & decision support.

Btw I got OpenEMR working on a windows XP PRo install but on an XP Home install it again gave errors. I had to spend almost 2 weeks sorting the errors out, but again there is no reliability that things will always work whenever a new module or upgrade is added.

nbr11 wrote on Tuesday, December 06, 2005:

You can also consider creating a http://www.colinux.org approach. To run a linux in a windows process. Works great for me. Need no special licenses,except GPL

drbowen wrote on Tuesday, December 06, 2005:

1) Drug drug interaction check
2) Clinical decision support system

These absolutely critical for any modern EMR / EHR.

Sam Bowen, MD

sunsetsystems wrote on Tuesday, December 06, 2005:

Sam, do you (or does anyone) have some thoughts as to what the user interfaces for these features should look like?  Consider also the tools needed to accumulate content for a decision support database.  If we flesh out these "wish list" items some more, perhaps someone would be willing to sponsor them.

– Rod
www.sunsetsystems.com