Notifications
Clear all
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
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
Topic starter
No, but thank you!
Posted : March 29, 2018 6:58 am
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
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
Topic starter
Also we are on CPS. Is this a MEL function for CPS or C-EMR?
Posted : March 29, 2018 7:53 am
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
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
