“Is there any report that will tell me how many claims were filed to the carriers? I’m looking to identify which carrier we send the most claims to.”
There is no report, however, this query will tell you how many items were billed for each carrier. Please note that if you generate a claim, but then do not print it out (or send it electronically), OM will still see it as having been billed.
SELECT pay.payorname AS "Carrier", car.companynum AS "NEIC", COUNT( DISTINCT j.JNUM) AS "Number of Services Billed" FROM sos.JOURNAL j JOIN sos.JCHGSPLITS jc ON j.jnum=jc.jnum JOIN sos.PTPAYORS ptp ON jc.ptpayornum=ptp.ptpayornum JOIN sos.PAYORS pay ON ptp.payornum=pay.payornum JOIN sos.CARRIERS car ON pay.payornum=car.payornum WHERE pay.payortype='i' AND ( jc.firstbilled IS NOT NULL) AND j.trandate>'1980-01-01' GROUP BY "Carrier","NEIC" ORDER BY "Carrier","NEIC"