Mental health plans billed by provider (BC)

File contents

<report title="Mental health plans billed by provider" description="Reports the number of Mental health plan billings 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 = '14043'

group by provider_no;
</query>

<param id="start" type="date" description="Start date"> </param>
<param id="finish" type="date" description="Finish date"> </param>
</report>