Notifications
Clear all
Topic starter
We are in the process of bringing up Encoda and moving away from Centricity EDI. I was asked to get a report of the insurance carriers w/the clearinghouse loaded so the manager can make sure of who hasn't been switched over. I am using the tables of Clearinghouse, Insurance Carrier Company Processing and Insurance Carriers.
I can produce a report of the clearinghouses and get everything including those that have been set up for Encoda. However, if I try and report the clearinghouse along with the Insurance company name and insurance carrier ID, it only pull the Centricity clearinghouse but it's not even pulling all of those.
I don't understand why it's not letting me get this and I'm tired of beating my head against the wall. Any suggestions of what I might be doing wrong?
Linda
Posted : April 20, 2018 2:56 am
Topic starter
Update: I found this sql script but I was told that it was missing some carriers.
select
ic.InsuranceCarriersId,
ic.Inactive,
ic.Name,
ic.ListName,
icc.ClaimPayerId,
ch.ClearinghouseName
from
InsuranceCarriers as ic
join InsuranceCarrierCompany as icc
on icc.InsuranceCarriersId = ic.InsuranceCarriersId
join Clearinghouse as ch
on ch.ClearinghouseId = icc.ClaimClearinghouseId
Our manager then asked if I could get those carriers that don't have a clearinghouse ID at all (we have some that are setup that way, not sure why though). I've just gotten into writing scripts so this is new territory. Is there a change I could make to this to pull any and all carriers, regardless if there is a clearinghouse or not?
Posted : April 20, 2018 8:19 am
