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

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.