Created in partnership with Sam Van. This RBT searches for appointments between dates for the specified provider(s).
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.…
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.
Provided By Ian Pun Search prevention Notes – Search ALL database for vaccine lot
Searches name of eforms generated e.g. Quantum, MRI, CT, EXR since a certain dateBy Ian Pun MD 2015-12-21
Report By Template to search for patients by diagnostic code, billing code, and provider
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…
Patient search by diagnostic code billed” description=”Lists ACTIVE patients with selected diagnostic code billed, by Provider
Search ALL demographic by name, address, city, phone, email, OHN, birthdate, postal code by Ian Pun MD