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

Need help updating obs term from part of another obs term in VFE

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

6 Posts

3 Users

0 Reactions

66 Views

RSS

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

The NEURO EXAM obs term can have many options attached to it. I need to create a custom form in VFE that takes very specific sensory and monofilament exam items selected from the PE-CCC form, and updates fields on my custom form.

Here is an example of what I get on the PE-CCC form.

NEURO EXAM: weakness noted, decreased sensation to pinprick and monofilament exam positive x8.

If the NEURO EXAM obs term in the current encounter contains "decreased sensation to pinprick" I need a field on the custom form that will update the obsterm NE L4SENS L to have a value of "diminished".

Also, if NEURO EXAM obs term in the current encounter contains "monofilament exam positive x 8" I need it to update the obs term MONOFILAM LF with a value of "normal".

Any help accomplishing this is very much appreciated. Here is my attempt so far. I'm not an advanced MEL user, so I might be way off here. The custom form currently uses radio buttons for the monofilament and sensory fields, but I can change that if need be.

{!If match(OBSNOW("NEURO EXAM"), "decreased sensation to pinprick")>0
then (OBSNOW("NE L4SENS L"), "absent")
else ""
endif}

Posted : June 30, 2016 12:38 pm

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Your sample looks good, just change

(OBSNOW(“NE L4SENS L”), “absent”)
TO
OBSNOW(“NE L4SENS L”), “absent”)

Use if statements to check for all values you are interested in:

{if match(OBSNOW(“NEURO EXAM”), “decreased sensation to pinprick”)>0 then
OBSNOW(“NE L4SENS L”), “absent”)
endif

if match(OBSNOW(“NEURO EXAM”), “monofilament exam positive x 8”)>0 then
OBSNOW(“MONOFILAM LF”), “normal”)
endif
}

Are you putting this code into a button on your form ? Then add a button, choose RUNPROCESS, and put the code above into the button code.

Posted : June 30, 2016 2:34 pm

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

Thank you so much. I created a button using run process and entered the following code:

If match(OBSNOW("NEURO EXAM"), "decreased sensation to pinprick. ")>0
then OBSNOW("NE L4SENS L"), "absent")
else ""
endif

I received compiler errors until I removed the comma and the right parenthesis in the Then part of the statement. I now have:

If match(OBSNOW("NEURO EXAM"), "decreased sensation to pinprick. ")>0
then OBSNOW("NE L4SENS L") "absent"
else ""
endif

Which doesn't give me any compiler errors, but it is not updating the NE L4SENS L obs term. I ran a MEL trace, and received the following:

07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] >{fn6871_1467639644_200()}
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] execute>call FN6871_1467639644_200()
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] execute>call OBSNOW("NEURO EXAM")
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] results>"decreased sensation to pinprick. "
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] execute>call MATCH("decreased sensation to pinprick. ", "decreased sensation to pinprick. ")
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] results>1
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] execute>1 > 0
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] results>TRUE
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] execute>if TRUE
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] results>TRUE
07/04/2016 09:17:15.794 INFO Process Id #7444 ML Thread [MelTrace] execute>call OBSNOW("NE L4SENS L")
07/04/2016 09:17:15.795 INFO Process Id #7444 ML Thread [MelTrace] results>""
07/04/2016 09:17:15.795 INFO Process Id #7444 ML Thread [MelTrace] results>return "absent"
07/04/2016 09:17:15.795 INFO Process Id #7444 ML Thread [MelTrace] execute>end
07/04/2016 09:17:15.795 INFO Process Id #7444 ML Thread [MelTrace] results>"absent"

It looks to me like its a good code, but it's just not updating the new obs term. Any additional guidance you can give me please?

Posted : July 4, 2016 4:26 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

If you are setting a value in the obs term with this statement:

OBSNOW("NE L4SENS L"), "absent")

It should be

OBSNOW("NE L4SENS L", "absent").

Posted : July 5, 2016 4:05 am

blackmanb

(@blackmanb)

Posts: 268

Reputable Member

Looks like I had a typo

OBSNOW(“NE L4SENS L”), “absent”)

should not have that inner ). Should be

OBSNOW(“NE L4SENS L”, “absent”)

Posted : July 5, 2016 8:00 am

cprice7

(@cprice7)

Posts: 71

Estimable Member

Topic starter

thank you! That fixed it.

Posted : July 13, 2016 1:28 pm

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