Welcome to the NEW CHUG— your ultimate destination for cutting-edge insights and discussions at the intersection of healthcare and technology.

Our platform is dedicated to exploring the dynamic landscape of healthcare technology, empowering professionals, enthusiasts, and innovators alike with the knowledge and resources to navigate the rapidly evolving field.

From telemedicine revolutionizing patient care to the transformative potential of artificial intelligence in diagnostics, we delve into a myriad of topics shaping the future of healthcare delivery. Whether you’re a seasoned healthcare IT professional, an aspiring entrepreneur in the digital health space, or simply curious about the latest innovations, our curated content, expert interviews, and thought-provoking articles provide a comprehensive exploration of healthcare technology’s most pressing issues.

Join us as we navigate the forefront of innovation, driving forward the transformation of healthcare for a healthier, more connected world.

Have questions or suggestions? Please use the contact button below.

Notifications

Clear all

Script for QD to Daily

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

8 Posts

4 Users

0 Reactions

77 Views

RSS

Palko

(@palko)

Posts: 132

Estimable Member

Topic starter

After a recent visit from JCAHO, we are required to change any prescribing method from qd or QD to "daily."
Has anyone run into this and did you have a script to go and find these and update them in the db? A manual process seems laborious.
Thank you!

Posted : March 30, 2016 2:33 am

tcross

(@tcross)

Posts: 165

Estimable Member

That has been a recommendation from JCAHO for a number of years. What I have done here is to create a quick text so that everytime qd or QD is typed or verbalized in dragon it automatically changes it to daily. Then I just change the ones as we prescribe the meds

Posted : March 30, 2016 3:40 am

Palko

(@palko)

Posts: 132

Estimable Member

Topic starter

No we have that in place. I am talking about historical prescriptions.
Thanks so much!

Posted : March 30, 2016 3:48 am

Palko

(@palko)

Posts: 132

Estimable Member

Topic starter

Sorry I don't think I responded properly. This is for historical prescriptions and we do not use Dragon.
Thank you!

Posted : March 30, 2016 3:50 am

tcross

(@tcross)

Posts: 165

Estimable Member

Not sure exactly what you mean. If you are adding a historical Rx to the patient chart you could still use the quick text during entry. Are you trying to go back in and change the ones that are already in the patient chart? That could be a huge task. Why not just have staff who are prepapring the patient for the provider visit correct them as they do their rooming procedure? I am not sure your workflow for rooming your patient for the provider visit so hard to determine an efficient workflow. Sorry I could not be of more help.

Posted : March 30, 2016 5:10 am

Palko

(@palko)

Posts: 132

Estimable Member

Topic starter

It is a huge task and we have to resolve them because Joint Commission came in and did an audit and told us to do it.
We are working with GE to come to a solution.
Thank you!

Posted : March 30, 2016 5:14 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

This is a bigger problem than QD. Think BID, QOD, QID, q4h. In addition po, prn, pr, sl, etc. I have a program to print all patient medication information using translations. This requires a function in UsrLib.txt. Contact me if you re interested.

Posted : March 30, 2016 5:53 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

You are going to end up updating the INSTRUCTIONS field of the MEDICATE table. In the Oracle world, it is going to be something like:

update ml.medicate set instructions = replace(instructions,' QD ','daily') where instructions like '% QD %'

This would replace a capitalized QD that was preceded and followed by a space with the word daily in the INSTRUCTIONS field of the MEDICATE table. You need to run this query against a test database or change the query to just specify one test patient if you don't have a test database. I have not tested this. It may need some tweaking. You would need to modify this query for each abbreviation you want to change and remember that Oracle is case sensitive.

Good luck

Posted : April 25, 2016 1:09 pm

Share:

24 Forums
9,940 Topics
39.9 K Posts
2 Online
6,470 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Powered by wpForo Powered by wpForo version 2.4.0