Notifications
Clear all
Topic starter
Can anyone direct me to information on how to do SOP mapping. I am not sure what this is as I don't work muchon the PM side. We are currently submitting our PQRS through claims based reporting. I know that in 2016 that will change and I want to make sure we are ready. Also do we have to do this before upgrading to SP11 or can we do it afterwards?
Thank you for any help
Posted : December 2, 2015 6:21 am
You can add the SOP prior to SP11. This is how to get to it in the EMR: Setup -> Settings -> Orders -> Ins. Co. and Plans. Select the company and select the LOWER "Change" button. This will bring up a window and you'll have a dropdown there for "Source of Payment".
Since we had so many I changed a lot of the values through the database so if you know SQL, I can probably give you some tips.
Jill
Posted : December 2, 2015 6:57 am
Topic starter
Jill
I have CPS and am not exactly sure where you perform this function in CPS. Do you know if it is on the EMR side or the PM side?
Terry
Posted : December 2, 2015 8:13 am
The instructions I gave were from the EMR side. We did not do anything on the GPMS side.
Posted : December 2, 2015 8:22 am
We had someone fill it out manually but I was asked to run a report on all of the insurance companies that did not have a SOP. This is the SQL I used:
SELECT BUSINESS.NAME, INSURECO.PLANCODE, BUSINESS.ADDRESS1, BUSINESS.CITY, BUSINESS.STATE, BUSINESS.ZIP from insureco
INNER JOIN BUSINESS on INSURECO.BUSID = BUSINESS.BUSID
WHERE INSURECO.INSSOURCEOFPAYMENTSID is Null
ORDER BY BUSINESS.NAME
Posted : December 2, 2015 12:13 pm
Topic starter
I can not see how to get into settings>setup. I go to admin and under codes is a settings folder but all it has in it is ICD 10 settings and data mappings. I am unsure how to proceed
Posted : December 2, 2015 12:27 pm
You can also look for codes undefined / unknown using the following.
select i.inssourceofpaymentsid, b.searchname, b.primphone, b.address1, b.city, b.state
from insureco i, business b
where i.busid = b.busid
and b.isinsco = 'Y'
and i.inssourceofpaymentsid =145
ORDER BY 2
We had several that were PRIVATE so I updated in chunks using the insurance name and REGEXP
update insureco
set inssourceofpaymentsid = 90
where busid in (select busid from
business
where isinsco = 'Y'
and REGEXP_LIKE (searchname, '^Y|W'))
Sorry, we don't use CPS so I don't know where you would go.
Posted : December 2, 2015 1:15 pm
rwilliams, was this an EMR (Oracle) query by chance? I could not get it to work in SQL.
Posted : December 3, 2015 11:58 am
It is an EMR query. Chances are that the table names are different in CPS but my guess is that the query should be fairly similar.
Posted : December 4, 2015 4:09 am
