What are Report by Templates?
RBT’s are templates that tell OSCAR to search for specific information from the database. They are “database search templates” – similar to bookmarking a commonly searched for term.
This is a list of Report by Templates that can be downloaded. Click on a Category to filter the list.
Page
Categories
Update Date
Download
Automatic Appointment Emails 2020
Administrative , Communication with Patient , Email , Report Templates , Text
November 25, 2020
Download
Covid Monitoring Record
CDC , Clinical Counselling , Clinical RBT , Communication with Patient , COVID-19 , Decision Tools , eForms , History Taking , Infectious Disease , Report Templates , Virology
February 1, 2021
Download
List of patients attached to a provider without an email
Administrative , Communication with Patient , Email , Report Templates
April 24, 2021
Download
Primary Care Provider Patient Summary – 2019
BC , Communication with Patient , Complex Care Planning , eForms , End of Life , Geriatrics , Geriatrics , History Taking , Home Health , Hospitalists , Long Term Care Facilities , Primary Care Network , Report Templates , Vancouver Island Health Authority
December 2, 2019
Download
RBT Lists over 65yr not pneumovax immunised
Clinical RBT , Communication with Patient , Complex Care Planning , Decision Tools , Infectious Disease , Medication , Preventions , Report Templates , Respirology
July 22, 2021
Download
Report by templates for the Winter Covid Access Plan for BC
Clinical RBT , Communication with Patient , COVID-19 , Infectious Disease , Report Templates , Screening , Virology
March 2, 2021
Download
Search for Word or Text in Reminders 2021
Administrative , Clinical RBT , Coding Systems , Communication with Patient , Decision Tools , Report Templates
October 28, 2021
Download
Unique email by providerV2
Administrative , Communication with Patient , Email , Report Templates
November 23, 2020
Download
The following list of useful RBT template files
Tutorial: How to use Database Search Templates
60 Report by Template Examples Blank Report by Template
RBTcalculatedBMI
Flu shot RBT to show who has had it and who is pending
Prevention reconcilliation
Predicting vaccine orders for babies RBT-How many infant shots do you need this month? Immunization Number Predictor Reports total number of active patients who will be due for a needle next month It may not be named right and the SQL is a bit rough (but runs quickly) but the idea is to forecast how many vaccines you need next month if you immunize your babies
Pt_On_specific_drug_statin_V4
DxRegistrySearch_eFormUsed_DemoLink_provider_V2
CDMs previously Billed not billed this year
Colonoscopy Tally
COPD Patients with Spirometry in the last 2 years
diabetic HbA1C-LDL-meds
Disease Registry Not Using Specified eForm
eForm Lookup
eGFR lookup
Flu Shot Rates 2014
HbA1c lookup
HTN Dx
INR Flowsheet Lookup
INR Lab Review
Lab results by patient by test name
Mammogram Tally
Measurement Values yes or no
Medication number by age With Link
Patients eligible for OHIP-funded Zostavax program
Patients who list a Pen allergy that have an Rx for Pen RBT
Patients with Multiple Drug Allergies Incl Pen RBT
Patients with Multiple Drug Allergies RBT
Percentage of patients not on medication
Prevention Reports
Preventions due or overdue
Search eChart for Keyword
Search eforms1
Search for missing MMR shot in child RBT
Search for Word or Text in Reminders-SocialHx-FamHx-MedHx-OngoingConcerns-Encounter
Search for Word or Text in Reminders-SocialHx-FamHx-MedHx-OngoingConcerns-EncounterV2
Search for Word or Text in Reminders
Smoker Tally – Ontario E079 billing
Disease Registry Population Tools:
Disease Registry Population Tools Instructions – READ FIRST
1of3 PSP Panel Assessment Tool Active By clinic 2of3 PSP Panel Assessment Tool Active By Doctor 3of3 PSP Panel Assessment Tool Active By Disease Registry
1.Disease Registry Panel by Measurements 2.DisRegPanelbyLab 3.DisRegPanelbyMedication 4.SLOWPanelbyCPP 5.DisRegPanelbyBilling 6.DisRegPanelDoctor Disease Registry Codes2
Greasemonkey Script to provide a dropdown list in the Caseload view to easily see patient sets
Immunization Record and Greasemonkey Script
Demographic Clean-Up RBT Tools:
Counts disease registry entries per doctor Lists numbers of active patients per provider not seen over a period Number of all patients with active designation in clinic
