Notifications
Clear all
Topic starter
Hello,
I need some help with a script that shows Active Insurance Carriers in the system. CPS 12.2 . Any help would be appreciated,
Posted : July 17, 2018 7:28 am
SELECT * FROM InsuranceCarriers where Inactive = 0
Posted : July 17, 2018 7:47 am
What additional script would be added to get a list of the payer ID associated with the active insurance carriers?
Posted : July 18, 2018 3:45 am
This will give you the GE Payor ID
SELECT ic.ListName,ic.Name,icc.ClaimPayerId,* FROM InsuranceCarriers ic
LEFT JOIN InsuranceCarrierCompany icc on icc.InsuranceCarriersId = ic.InsuranceCarriersId
WHERE Inactive = 0
Posted : July 18, 2018 8:44 am
Much appreciated!
Posted : July 18, 2018 9:23 am