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

Moving Service Orders

CPS, C-EMR, PM

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

82 Views

RSS

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

Does anyone know if it's possible to move a whole category of orders from "Service" to "Test and Procedures" without having to reenter all of the information. Thank!

Posted : September 22, 2017 3:58 am

acantu

(@acantu)

Posts: 722

Prominent Member

Yes, but needs to be done through the database using a script

Posted : September 22, 2017 4:06 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

Thanks! Any idea on what that might look like?

Posted : September 22, 2017 4:11 am

acantu

(@acantu)

Posts: 722

Prominent Member

Well it all depends on if you already have the codes setup in the right places.
Use this script to see what you will affect first:

SELECT * FROM ORDERS WHERE ORDERTYPE = 'S' --Order Type is a Service AND CODE = 'CODEHERE' -- Input your orginial code here AND CHANGE IN (2,6) -- Use this to only apply to open and active orders AND ORDERDATE BETWEEN '1/1/2016' AND '12/31/2016' -- Use this if you want to do a date range only

Once you see that this is what you want to change, then do an update like this, again, this will all depend on what you want to change it to

UPDATE ORDERS SET ORDERTYPE = 'T', --Changes Type to Test CODE = 'NEWCODEHERE' --Input New Code to Change to here if different, if not, then do not use this part and remove the comma after the 'T' WHERE ORDERTYPE = 'S' --Order Type is a Service AND CODE = 'CODEHERE' -- Input your orginial code here AND CHANGE IN (2,6) -- Use this to only apply to open and active orders AND ORDERDATE BETWEEN '1/1/2016' AND '12/31/2016' -- Use this if you want to do a date range only

Posted : September 22, 2017 4:25 am

akoen

(@akoen)

Posts: 144

Estimable Member

There is also a Clinical Kit builder that would allow you to export your service orders to an excel spreadsheet, modify, and re-import as Tests or referrals. I have attached the builder below.

Clinical Kit Builder

Posted : September 22, 2017 4:36 am

mvolkert

(@mvolkert)

Posts: 143

Reputable Member

Topic starter

That did exactly what I needed. Thank you Amanda!

Posted : September 22, 2017 6:17 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