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

Update medications without a start date

General Discussion

Last Post by jfitzmd 8 years ago

3 Posts

3 Users

0 Reactions

67 Views

RSS

vhayes

(@vhayes)

Posts: 44

Trusted Member

Topic starter

Someone was nice enough to help me with a script to update problems without an onset date in EMR that worked great. I am now looking to update our meds that were entered without a start date. Your assistance is greatly appreciated.

Virginia

Posted : July 26, 2016 8:45 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

What is the logic that it would use to set the date? Should it be based on the date it was entered?

This is how I would do it in oracle if I wanted to update the startdate to the date that the medication was added to the chart (the date the row in the DB was created):

update medicate set startdate = ml.convert_id_to_date(medicate.mid) where startdate is null; commit;

It looks like you are on CPS according to your profile. I do not have a CPS database but my best guess would be a command like this (note, I am not sure if the convert_id_to_date function exists in cps but I will assume it does)

begin tran; update medicate set startdate = convert_id_to_date(medicate.mid) where startdate is null; commit;

These would update every start date that was null. I am not sure if you would want to do that to replaced medications. If you only wanted to do it for active rows you would and "and change = 2" to the end of the queries.

Posted : July 26, 2016 9:05 am

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Just a word of caution, be very careful when you are updating tables directly from SQL queries. GE is not sympathetic when there is a problem.

Posted : July 26, 2016 11:43 am

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