Urinalysis billed (BC)
Reports the number of 15130s billed in given time frame by provider
Urinalysis billed.txt
—
Plain Text,
0Kb
File contents
<report title="Urinalysis billed" description="Reports the number of 15130s billed in given time frame by provider" 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 = '15130'
group by provider_no;
</query>
<param id="start" type="date" description="Start date"> </param>
<param id="finish" type="date" description="Finish date"> </param>
</report>
