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

{USER.PHONE} MEL function does not seem to pull successfully

MEL, SQL, Oracle

Last Post by Anonymous 1 second ago

10 Posts

4 Users

0 Reactions

92 Views

RSS

Dustin

(@dustin)

Posts: 5

Active Member

Topic starter

I am attempting to use the {USER.PHONE} MEL insert on a letter, but nothing appears when I preview the letter. Has anyone else seen this issue?

Does someone know where the PHONE information is pulling? I would assume from USER MANAGEMENT?

Dustin Jones
UAMS

Posted : January 25, 2018 7:59 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

The CPS 12 help file shows this note on USER.PHONE:

This information comes from and can be changed in Administration. Go to System > User and Resource Management > Users > User Management to view or change data.

Posted : January 25, 2018 10:15 am

Dustin

(@dustin)

Posts: 5

Active Member

Topic starter

Thank you for the quick response. But that seems to be the issue. I have already verified my USER ACCOUNT has all available phone number fields completed (screenshot_1). I verified the {USER.PHONE} MEL code is entered correctly on the letter (screenshot_2). But creating a preview of the letter from a patient's chart desktop does not pull the {USER.PHONE} MEL information (screenshot_3).

Posted : January 26, 2018 3:10 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

Have you run a trace yet to see what is happening? Also, is that a period or a dash in that last screen shot where the phone number should be?

Posted : January 26, 2018 3:31 am

Dustin

(@dustin)

Posts: 5

Active Member

Topic starter

Can't say I know how to run a trace.

That is a period, with a space between the '}' and the period.

Posted : January 26, 2018 3:36 am

DavidShower

(@davidshower)

Posts: 1255

Noble Member

MEL trace logs are stored in :C:\Users\username\AppData\Local\Centricity\Logs on the server you are actually running the CPS client on.

Keyboard shortcuts
Ctrl + Alt + M Start/stop MEL tracking - this is the one you would want.
Ctrl + Alt + S Start/stop SQL tracking
Ctrl + Alt + T Start/stop DB tracking

You would turn on tracing, load your handout, then turn off tracing. Go to the path were the trace log is and search for USER.PHONE and see if there are any errors around that area. You could post that section here if nothing jumps out at you.

Posted : January 26, 2018 4:35 am

Dustin

(@dustin)

Posts: 5

Active Member

Topic starter

Thank you so much! It looks like the USER.PHONE execution is returning a NULL value. Not sure why that may be?

01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] >{PATIENT.LASTNAME}
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>Patient.LASTNAME
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"Test Patient"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>end
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"Test Patient"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] >{PATIENT.LABELADDRESS}
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>Patient.LABELADDRESS
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"4021 West Cypress Road\r\nNorth Little Rock, AR\t 72116"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>end
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"4021 West Cypress Road\r\nNorth Little Rock, AR\t 72116"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] >{PATIENT.LABELNAME}
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>Patient.LABELNAME
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"Erx Test Patient"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>end
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"Erx Test Patient"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] >{USER.PHONE}
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>User.PHONE
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>NULL
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>end
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>NULL
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] >{USER.REALNAME}
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>User.REALNAME
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"Dustin Jones"
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] execute>end
01/26/2018 10:51:03.667 INFO Process Id #10256 ML Thread [MelTrace] results>"Dustin Jones"

Posted : January 26, 2018 4:55 am

trichards

(@trichards)

Posts: 58

Trusted Member

I find it to be much more simple to have the user's current location they are logged in at pull the Location of Care phone and fax numbers.

EXAMPLES:

Phone: {LOC.FORMATPRIMPHONE}
Fax: {LOC.FORMATFAXPHONE}

Hope this helps!

Posted : January 26, 2018 4:58 am

Dustin

(@dustin)

Posts: 5

Active Member

Topic starter

I actually thought of doing this and was not finding these particular MEL symbols using the INSERT function. I went ahead and entered the MEL codes manually and they seem to be working. I will do this moving forward. Thank you!

Posted : January 26, 2018 5:07 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

MEL can be very picky. Suggest you try (1) deleting that whole line and start typing in again, and/or (2) delete the line use the [insert symbol] function to have the command code re-inserted.

I see problems like this, but more often related to the various versions of single double quote marks.

Posted : January 29, 2018 12:55 am

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