Complete physicals billed by provider
Reports the number of complete physicals billed in a time frame
Complete Physicals billed by provider.txt
—
Plain Text,
0Kb
File contents
<report title="Complete physicals billed by provider" description="Reports the number of complete physicals 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 = '12101' or bm.billing_code = '00101' or bm.billing_code = '15301' or bm.billing_code = '16101' or bm.billing_code = '17101' or bm.billing_code = '18101')
group by provider_no;
</query>
<param id="start" type="date" description="Start date"> </param>
<param id="finish" type="date" description="Finish date"> </param>
</report>
