Notifications
Clear all
Topic starter
I was wanting to write a crystal report that would tell me if any insurances are missing an SOP code. Does anyone know if there is a table and field that I would use to pull that information from. Thanks!!
Posted : September 7, 2016 4:58 am
I am on CEMR 9.8 There is a table.field that pulls SOP codes. That is INSURECO.INSSOURCEOFPAYMENTSID Hope that this helps.
Posted : September 7, 2016 9:16 am
I never converted it to a report but I have an Oracle SQL query for it. It probably works in CPS as well.
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 : September 14, 2016 6:03 am
