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

Changing Location of Care on Completed Order

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

5 Posts

2 Users

0 Reactions

65 Views

RSS

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

Topic starter

Hello,
Is there a way to Changing Location of Care on a Completed Order? A provider has selected the wrong location of care while placing his E&M codes and the order status is Completed. I tried clicking on Change but since its completed it wont let me make any changes. Thanks in advance for any help!

Posted : March 27, 2018 1:02 am

rfisher

(@rfisher)

Posts: 126

Estimable Member

You can update the LOCOFSERVICE on the ORDERS table with a SQL statement but it won't change the facility that will pull over to the billing module when you retrieve charges. That will require you to manually change after retrieval or you could update the FacilityId on the MIKPatientVisit table before retrieval but that may be too much work.

Posted : March 27, 2018 1:53 am

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

Topic starter

Thanks! Do you know the SQL statement i can run to update it at least on the chart side?

Posted : March 27, 2018 1:57 am

rfisher

(@rfisher)

Posts: 126

Estimable Member

Run these 2 statements, the 1st one should get you the order you are looking for. Change the PatientId and ORDERNUM of course. Just verify this is the order you want and grab the ORDERID

The 2nd statement will give you a list of Locations of Care

select * from ORDERS o join PatientProfile p on p.PId = o.PID where p.PatientId = '123456' and o.ORDERNUM = '123456-7'

select * from LOCREG

The update statement will require the ORDERID from the 1st select statement and the LOCID from the 2nd.

UPDATE ORDERS SET LOCOFSERVICE = '1234567812345678' WHERE ORDERID = '1234567812345678'

Posted : March 27, 2018 2:18 am

sharansunkara

(@sharansunkara)

Posts: 83

Estimable Member

Topic starter

Thank you so much!!!!!

Posted : March 27, 2018 2:39 am

Share:

24 Forums
9,940 Topics
39.9 K Posts
1 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