Credit Breakdown by Payor for Service Date Range

Breaks down credits applied to services in a date range groups by insurance payor.

Select
   payorname,
   payornum,
   credtype,
   count(distinct cre_jnum) as "Number",
   sum(crsplamt) as "Paid"
From
   sos.rv_creditsplits
Where
   srv_date between '2001-01-01' and '2001-01-31'
   and payortype = 'I'
   and systranflag not in ('TT','TF')
group by
   credtype,
   payornum,
   payorname