- Version
- Download 246
- File Size 0.85 KB
- File Count 1
- Create Date November 18, 2022
- Last Updated November 18, 2022
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 and Latest Versions
File | Action |
---|---|
Show number of distinct OHIP billing dates.txt | Download |