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

Hopefully an easy if-then dates question

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

7 Posts

3 Users

0 Reactions

72 Views

RSS

babbott

(@babbott)

Posts: 8

Active Member

Topic starter

Hello,

I am just delving into the world of MEL and am trying to digest the "Creating Clinical Content" pdf.

I am trying to put together an if-then statement that will compare: if the last OBSDATE for colonfit test is > 1 year ago, then order the FIT test. I can get the MEL statements for the orders and I think I have the basics down, but comparing the dates is a challenge for me.

Here is what I have so far:

if
DURATIONDAYS(LASTOBSDATE('FECIMMTEST'),._TODAYSDATE) > 365
then
MEL_ADD_ORDER('T','Labs','Fecal Immunochemical Test (FIT)','','ICD-Z12.11','Colorectal screening')''
else
"Patient is not due for colonoscopy until " + HEMOCULTDUE +"."
endif

Posted : July 3, 2019 4:26 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

The one problem I see is that you must convert your dates to a string before you can use the DURATIONDAYS() function. This is a common oversight when learning MEL.

The line:

DURATIONDAYS(LASTOBSDATE(‘FECIMMTEST’),._TODAYSDATE) > 365

should be:

DURATIONDAYS(LASTOBSDATE(‘FECIMMTEST’),str(._TODAYSDATE)) > 365

Hope that helps.

Posted : July 3, 2019 4:40 am

babbott

(@babbott)

Posts: 8

Active Member

Topic starter

That works for the if/then logic and order, but I can't get it to display HEMOCULT due date. any ideas?

Posted : July 3, 2019 4:59 am

mjharunk

(@mjharunk)

Posts: 191

Reputable Member

You have to use LASTOBSVALUE("HEMOCULTDUE")

Posted : July 3, 2019 5:03 am

virtualHITman

(@virtualhitman)

Posts: 319

Reputable Member

If HEMOCULTDUE is an OBS term that contains the due date, try:

“Patient is not due for colonoscopy until ” + OBSANY("HEMOCULTDUE") +”.”

That should return the most recent value of your OBS term named HEMOCULTDUE. Be careful about copying and pasting from this forum; the double quotes characters do not always translate well. I would just type the above out manually in your code to be sure.

Posted : July 3, 2019 5:05 am

babbott

(@babbott)

Posts: 8

Active Member

Topic starter

thank you again!

Posted : July 3, 2019 5:15 am

babbott

(@babbott)

Posts: 8

Active Member

Topic starter

thank you all.

final code:

{if DURATIONDAYS(LASTOBSDATE('FECIMMTEST'),str(._TODAYSDATE)) > 365 then MEL_ADD_ORDER('T','Labs','Fecal Immunochemical Test (FIT)','','ICD-Z12.11','Colorectal screening')'' + "Colorectal FIT test ordered" else "Patient is not due for colon FIT test until " + OBSANY("HEMOCULTDUE") +"." endif}

next steps: to add further if-then to identify if they've had a colonoscopy

Posted : July 3, 2019 5:17 am

Share:

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