Credit Breakdown by Payor Type for Service Date Range

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

 

Select
   payortype,
   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 systranflag not in ('TT','TF')
group by
   credtype,
   payortype

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.