The team is excited about the latest release from the Teaching EMR (tEMR) team. The essential items in this release where our transition from Oracle to PostgreSQL, Drug Alerts, and support for Single Sign-on. These are significant milestones in our product evolution. This Fall, several new programs (University of Connecticut School of Medicine and University of Southern Indiana) will be going live. We also have completed some work for a research project for a National Science Foundation (NSF)-funded grant using the Teaching EMR in this latest release.
Support for Single Sign-On with the CAS2 protocol
Who really wants to remember another password? The average person has to remember 19-27 discrete logins which require passwords according to several polls I found online. So much so, that the anger we feel when prompted for another login and password has a name–password rage. I’m not going to lie. I’ve been there myself a few times when I can’t remember my login and/or password. I would guess because of my heavy use of technology related services that I have well over 50 logins, or twice the normal.
Giving students, program faculty, and administrators one less login and password to remember to access the Teaching EMR sounds like a great feature to anyone. We now support single sign-on for schools that will be going live with the tEMR this Fall.
Drug Alerts Research funded by National Science Foundation
The Teaching EMR is an applied innovation that was born out of a research grant. We are a renowned research organization that has been part of IU Medical School since the late 1960’s. Much of the research on the efficacy of EMRs came out of our research done by Dr. Clem McDonald. So, when we are approached by researchers who wish to use the Teaching EMR we are more than pleased to find a way to work with them.
The work around the drug alerts inside the application for an NSF-funded study lead by Dr. Davide Bolchini and Dr. Jon Duke was completed in this current release. This study looked at the impact that six different drug interaction alert formats had on subsequent user actions. Those alerts leveraged our Rule Authoring and Validation Environment (RAVE) capabilities that are an added feature of our tEMR application that makes our system unique for programs.
RAVE is available as a stand-alone application or can be integrated with other applications to help non-programmers create complex rules within the EMR quickly and easily. You can create clinical automation based on patient activity. It allows users to build simple or complex if/then rules that can execute on events within the EHR or in real-time. You can mix-and-match a variety of “conditions” and “actions” and go from rule creation to product deployment in minutes. We would be happy to show you how we use RAVE in the tEMR.
Oracle to PostgreSQL
Our production platform that the Teaching EMR is a branch of uses Oracle databases. Great company, great products. I have nothing but wonderful things to say about Oracle. We have been very pleased with Oracle, so it was not a quick or easy decision to make a switch from Oracle to PostgreSQL. We evaluated moving to the Oracle cloud for our technology stack for our SaaS application. Either way, we would have development cycles to invest in to make the switch.
Ultimately, the decision came down to licensing and the associated costs for programs in our decision to move to the open source PostgreSQL.
Our mission is for more students to have access to an EMR learning platform earlier within their Medical and Health Professions Education. If we can reduce the barriers to more programs be able to use our application in more classrooms sooner, we will improve education and healthcare even faster. So that is what we did.
Sorry Oracle, but we are investing this time around in students, faculty, and programs.
Please stay dialed in to for more great release information and updates from the Teaching EMR team at our blog. Subscribe to stay connected.