Download Report by Template (RBT)

This is a list of Report by Templates that can be downloaded. Click on a Category to filter the list.

(Note: Nov 30,17 – this is just a test sample of downloads…)

Page	Categories	Update Date	Download
A report by template querying the BC antenatal record for due dates and postal codes	Clinical RBT, Decision Tools, Midwifery, Obstetrics, Report Templates	May 12, 2021	Download
Appointment Counter by provider and MRP	Administrative, Report Templates	August 29, 2019	Download
Automatic Appointment Emails 2020	Administrative, Communication with Patient, Email, Report Templates, Text	November 25, 2020	Download
BMI Calculator Tools	Clinical RBT, COVID-19, Decision Tools, Obesity, Report Templates	March 20, 2021	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
Details of scanned documents	Administrative, Report Templates, Scanned Documents	December 19, 2020	Download
ER patients not admitted	Administrative, Outpatient, Report Templates	December 16, 2018	Download
Flu shot RBT to show who has had it and who is pending	Clinical RBT, Decision Tools, Infectious Disease, Long Term Care Facilities, Medication, Preventions, Report Templates, Screening	October 18, 2020	Download
Function to parse eform_data values	Report Templates	June 6, 2018	Download
List of patients attached to a provider without an email	Administrative, Communication with Patient, Email, Report Templates	April 24, 2021	Download
Ontario RBT for COVID 19	Clinical RBT, COVID-19, Decision Tools, Infectious Disease, Medication, Report Templates, Virology	March 14, 2021	Download
Patients with Multiple Drug Allergies (MDA) 2 Query by Examples and 2 Report by Templates	Decision Tools, Medication, Query by Example, Report Templates	July 19, 2019	Download
Prevention Reconciliation	Clinical RBT, Decision Tools, Report Templates, Screening	July 23, 2019	Download
Preventions Due or Overdue	Clinical RBT, Decision Tools, History Taking, Preventions, Report Templates, Screening	October 19, 2020	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 – Immunization Card (+optional GM/TM script)	Browser Addons, Clinical RBT, COVID-19, Greasemonkey Scripts, Infectious Disease, Report Templates, Virology	April 5, 2021	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
RBT Message Search with Key Word Lookup	Administrative, Report Templates	May 14, 2021	Download
Report By Template Medication Number By age – with link	Geriatrics, Medication, Polypharmacy, Report Templates	July 18, 2018	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 eChart for Key Word	Clinical RBT, Decision Tools, Report Templates	July 17, 2021	Download
Search Encounter for any text	Report Templates	April 24, 2018	Download
Search for missing MMR shot in Child Report By Template	Clinical RBT, Infectious Disease, Pediatrics, Report Templates	July 18, 2019	Download
Search for patients who have been presribed PENICILLIN that have a PENICILLIN allergy listed	Allergies, Antibiotics, Clinical RBT, Decision Tools, Query by Example, Report Templates	July 19, 2019	Download
Search Lab Results for Abnormal values	Report Templates	November 29, 2018	Download
Search pharmacy name or phone	Antibiotics, Clinical RBT, Medication, Medication Coverage, Report Templates	March 27, 2020	Download
Unique email by providerV2	Administrative, Communication with Patient, Email, Report Templates	November 23, 2020	Download
Unsigned encounters in case management with link to echart	Administrative, Report Templates	January 11, 2019	Download
Unsigned encounters in tmp saved with link to echart	Administrative, Report Templates	January 11, 2019	Download

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.

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