Counselling billed by provider (BC)
Reports the number of counselling billed in a time frame
Counselling billed by provider.txt
—
Plain Text,
0Kb
File contents
<report title="Counselling billed by provider" description="Reports the number of counselling billed in a time frame" active="1">
<query>
select p.provider_no, p.last_name,p.first_name, count(billing_code)
from billing b, billingmaster bm, provider p
where b.provider_no = p.provider_no and b.billing_no = bm.billing_no
and b.billing_date >= '{start}' and b.billing_date <= '{finish}'
and (bm.billing_code = '12120' or bm.billing_code = '00120' or bm.billing_code = '15320' or bm.billing_code = '16120' or bm.billing_code = '17120' or bm.billing_code = '18120')
group by provider_no;
</query>
<param id="start" type="date" description="Start date"> </param>
<param id="finish" type="date" description="Finish date"> </param>
</report>
