Download Report by Template (RBT)

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
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
COVID19 At Risk v3 – List of Non Vaccinated Patients
 Clinical RBT, Consent, COVID-19, Infectious Disease, Preventions, Report Templates, Screening, Virology August 7, 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

    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

    Icon

    Search Encounter for any text

    1.97 KB 100 downloads