Report by Template Search between dates by provider
Created in partnership with Sam Van. This RBT searches for appointments between dates for the specified provider(s).
Open Source Clinical Applications and Resources
Open Source Clinical Applications and Resources
Tag RBT
Duplicate Charts Report by Template
Provided by Earl Wertheimer – A RBT to check for duplicate charts: How it works: The grouping is by name & DOB. The ‘having count(*) > 1; lists the duplicates, but only a single line for each set of dups.…
list of emails for patients seen within the past 36 months.
Created by Stanley Hurwitz. select distinct CONCAT( “/” , ‘Demographic’, “/” ) As “Demographic”,demo.last_name”Last Name”,demo.first_name”First Name”,demo.phone “Home Phone”,demo.phone2″Alternate Phone”,demo.email”Email”,b.billing_date “Billing Date” from billing b, billingmaster bm, demographic demo where (demo.email != “” and b.billing_no = bm.billing_no and demo.demographic_no = b.demographic_no…
Free text search for the following Fields – Social Hx, Family Hx, Medical Hx, Ongoing Concerns, Reminders, Encounter
This is a free text search for multiple fields Created By Earl Wertheimer and Gunther Klein. This search can be somewhat slower given the breadth and depth of the search.
Free Text Search in Preventions for Vaccines
Provided By Ian Pun Search prevention Notes – Search ALL database for vaccine lot
Search eforms by name – with date range
Searches name of eforms generated e.g. Quantum, MRI, CT, EXR since a certain dateBy Ian Pun MD 2015-12-21
Diagnostic code and billing code by Provider
Report By Template to search for patients by diagnostic code, billing code, and provider
Paxlovid COVID drug interaction RBT template
Created by Ian Pun: I wrote this RbT (with the help of chatGPT to convert the drugs to brand names) to search for interactions with paxlovid. Type in the medication and it’ll give the action to take (contraindictation/temporarily stop/reduce dose/continue…
RBT – ACTIVE patients by diagnostic code billed and Provider
Patient search by diagnostic code billed” description=”Lists ACTIVE patients with selected diagnostic code billed, by Provider
Report by Template to search Demographics
Search ALL demographic by name, address, city, phone, email, OHN, birthdate, postal code by Ian Pun MD