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

How can we check if a particular order is already placed or not to avoid placing a duplicate order?

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

5 Users

0 Reactions

69 Views

RSS

ranoop

(@ranoop)

Posts: 13

Eminent Member

Topic starter

Hi is there any way to find that the order has been created or not created. This validation will help us to avoid placing a duplicate order.

Posted : May 31, 2016 11:57 pm

Sirna

(@sirna)

Posts: 384

Honorable Member

Check the orders section of the patient's chart. Make sure under the organize button you have Complete checked to see all orders in case you run in house labs (services show as complete status).

Posted : June 1, 2016 1:47 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Via MEL, look at looping through the ORDERS_AFTER (delimited) data symbol. You will need to limit the date range to avoid looping through the entire history. You will also want to add filters to exclude cancelled orders and if desired, specify the type of order (service vs test vs referral).

Posted : June 1, 2016 3:00 am

abulsara

(@abulsara)

Posts: 150

Estimable Member

Is there a way to remove an order (unsigned) via MEL? If not, what other method is suggested?

Posted : June 1, 2016 4:20 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Currently, no. The only method is to open the orders module itself and manually remove it via the native workflow. You can use a button to open the module from a form making it easier to execute the manual process.

Posted : June 1, 2016 8:46 pm

ehealthsolution

(@ehealthsolution)

Posts: 4

New Member

{if match(str(ORDERS_ALL("delim")), 1, "^CPT-00000^") > 0 then

userok("This order has already been placed.")

else

MEL_ADD_ORDER("S", "Path","Description","","","", "", "", "", "", "")

endif}

Please let me know if this helps, we are here if you need any other MEL/VFE help.

Posted : June 9, 2016 6:25 am

Lee

(@lee-cooper)

Posts: 348

Reputable Member

Just as an FYI: I would avoid matching on the CPT code for orders since many orders share the same CPT code but use different order descriptions (names). Also be aware that orders all lists all orders ever placed in the patient's chart, regardless of status, making it a poor choice for recurring order scenarios. In addition, because the list returned can be rather huge on long term patient charts, it could have an adverse impact on performance when matching on the unfiltered list.

Posted : June 9, 2016 6:40 am

Share:

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