Report by Template Recently accessed Patients
Created by Ian Pun – This will find the patients most recently accessed.
Open Source Clinical Applications and Resources
Open Source Clinical Applications and Resources
Tag Report By Template
Report By Template MMR
Reports active patients between 4 up to but not including 7 years old requiring an MMR shot. Created by Peter Hutten-Czapski
Appointment List RBT
A request was sent to OSCAR BC for a report by template that does the following: -Searches active patients by provider within specified dates, including an option to search by “all providers” -Counts and lists how many appointments the active…
EDD Lookup
I was asked by a colleague to create a Report by Template to search for patients due in a specific time range. This lists all patients with a due date in the date range chosen. It includes a link to…
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).
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