Notifications
Clear all
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
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
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
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
Topic starter
Thank you so much!!!!!
Posted : March 27, 2018 2:39 am
