RBT to show how many days a provider created OHIP bills for

Created by Adrian Starzynski.

This RBT by default shows a list of dates which a provider created OHIP bills for. It will let you choose the provider from dropdown as well as the start/end dates for the report. In Ontario, doctors normally create OHIP bills for each day they work so this RBT is a useful tool to find out how many days a provider worked, assuming each day has an OHIP bill.

If you want it to show the number of days worked instead of a list of dates, then modify the <query> portion of the RBT to the following (only difference is select count):

select count(distinct(billing_date)) from billing_on_cheader1 where provider_no = '{provider_no}' and status != 'D' and billing_date >= '{billing_date_from}' and billing_date <= '{billing_date_to}' and pay_program='HCP' order by billing_date

You could easily modify the above to see how many private pay days there were, just modify pay_program=’PAT’

Attached Files

File	Action
Show number of distinct OHIP billing dates.txt	Download