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

Status of appointment by visitid

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

3 Posts

2 Users

0 Reactions

67 Views

RSS

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Topic starter

Is there any way to find out the status of an appointment based on the visit ID within MEL.

We require office notes to have a visitID associated with them. We have a popup message that will warn the user if they have linked the office visit with the appointment. We have users that are starting their office notes before the patients arrive (they aren't supposed to) and linking them to the proper visit ID, only to have the appointment cancelled and rescheduled same day. Now the note is linked to a cancelled appointment. I was hoping to find a way to determine the status of an appointment based on the visitid but I do not see any MEL functions that include the visitid.

Posted : July 14, 2017 7:00 am

gibsonmi

(@gibsonmi)

Posts: 827

Prominent Member

This should do it, I have never used status, but I use this to get a few other details from the appointment like physician and appttype.

{find("_PatientAppointments","Status","AppointmentsID",find("Document","AppointmentsID"))}

Posted : July 17, 2017 12:17 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

Topic starter

There were a few issues with the names in your code (maybe because it was made for CPS instead of CEMR?) but I was able to use what you gave me along with the mldef files to come up with some working code. The below code checks to see that there is a visit ID and if there is one, it makes sure that the visitid is not a cancelled appointment or a no show appt.

{! if DOCUMENT.VISITID = "" then USEROK("* Visit ID Missing * Click the Close button on the first form, click the Properties button, enter the Visit ID, click the OK button.") else if (find("_PatientAppointment","ApptStatus","VisitID",DOCUMENT.VISITID) = 2) then USEROK("* Wrong Visit ID Linked to Note *" + HRET + HRET + "This Document is linked to a *CANCELLED* appointment." + HRET + HRET + " Click the Close button on the first form, click the Properties button, change the Visit ID, click the OK button.") else if (find("_PatientAppointment","ApptStatus","VisitID",DOCUMENT.VISITID) = 1) then USEROK("* Wrong Visit ID Linked to Note *" + HRET + HRET + "This Document is linked to a *NO SHOW* appointment." + HRET + HRET + " Click the Close button on the first form, click the Properties button, change the Visit ID, click the OK button.")

endif endif endif }

Posted : July 17, 2017 3:15 am

Share:

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