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 Symbol to Pull Insured Person Information Into a Letter

General Discussion

Last Post by rwilliams 7 years ago

9 Posts

4 Users

0 Reactions

80 Views

RSS

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

Currently creating a letter for our Cologuard orders that will pull multiple items. I am searching for a symbol or function that will pull in the Insured Person Information as this is a requirement from the Cologuard company. I know this information is pulled on the patient profile, however I am not able to view the raw file for this report to see how it was built. Does anyone have any insight into this?

Thanks!

Sirna

Posted : March 29, 2018 12:59 am

bhoover

(@bhoover)

Posts: 360

Honorable Member

Hi,

I actually had to modify our patient profile report recently. It uses a stored procedure called 'MPMPatientProfile'. If you can take a look at the stored procedure you can see how the data is accessed. I don't know if you can do a lot with it in a handout. However, if you don't mind running a report instead you should be able to access it.

Also if there are specific items that you need there might be MEL symbols that you can use, but since you are asking about this I'm thinking that you might be looking for something that isn't included there.

Brad

Posted : March 29, 2018 1:07 am

joeg1962

(@joeg1962)

Posts: 843

Noble Member

Would Guarantor give you the name?

REGGUARANTOR

description

Returns the patient’s guarantor. If no guarantor has been entered for the patient, returns nothing.

type

Data symbol function

syntax

REGGUARANTOR()

Posted : March 29, 2018 5:51 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

No, but thank you!

Posted : March 29, 2018 6:58 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

The MEL code you are looking for is:
find("Insurance","InsPartyName", "PSIState","P") find("Insurance","InsPartyName", "PSIState","S")

Posted : March 29, 2018 7:29 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

When I copy this over it is not pulling the function. Looks to be missing the start and close bracket. Can you show me how you have this set to pull?
{find("Insurance","InsPartyName", "PSIState","P")}
{find("Insurance","InsPartyName", "PSIState","S")}

Posted : March 29, 2018 7:51 am

Sirna

(@sirna)

Posts: 384

Honorable Member

Topic starter

Also we are on CPS. Is this a MEL function for CPS or C-EMR?

Posted : March 29, 2018 7:53 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I am not using it inside of a letter, I am actually pulling the data into observation values within a function. I use the observation values inside of a form in the chart.
{! fn RefreshIns(){ OBSNOW("SW-INS CO1", INS_NAME("P")) OBSNOW("PINS_CPHONE", INS_PHONE("P")) OBSNOW("INS1ID#",INS_ID("P")) OBSNOW("INS1GRP#",INS_GRP("P")) OBSNOW("PRIMINSPART",find("Insurance","InsPartyName", "PSIState","P"))

OBSNOW("SW-INS CO2", INS_NAME("S")) OBSNOW("SI_CPHONE", INS_PHONE("S")) OBSNOW("SECONDINSID", INS_ID("S")) OBSNOW("SECINSGRP",INS_GRP("S")) OBSNOW("SECINSPART", find("Insurance","InsPartyName", "PSIState","S")) }}

This code was not used as part of our cologuard process. We faxed the order that was placed for cologuard in the emr which contained all of the fields required by cologuard and they accepted it.

On a side note we refuse to order cologuard any more as they would not perform eligibility and benefit checking for the patients which caused us to have to pay a few of the patients bills (at $600+ each!), even though we did not make a single penny on the test.

Posted : March 29, 2018 8:50 am

rwilliams

(@rwilliams)

Posts: 454

Honorable Member

I have heard there are differences between CPS and CEMR in the mldef files which is what the find function uses. I don't have access to CPS to test it. I know the Insurance tables in CPS are different from CEMR. If you want to send me your mldefs3.txt file I can take a look and see what is different.

In CEMR I used the below code in a letter and it worked.

{find("Insurance","InsPartyName", "PSIState","P")}

Posted : March 29, 2018 9:18 am

Share:

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

Powered by wpForo Powered by wpForo version 2.4.0