OSCAR comes with a series of prebuilt dashboard reports that allow for detailed and sophisticated practice analytics. This utility allows one to import export enable or disable indicators.
Most practices will only use the build in reports in Dashboard but see Dashboard Setup for instructions on how to import or write your own dashboard indicator.
Query By Example
This allows administrative staff to run report SQLs directly on the OSCAR database. You have to know the OSCAR database structure and the SQL language. For safety Updates and Deletes are not allowed. This is the simplest place and approach to tune your queries for report by template.
Report by Template
This is the user friendly way to run specialized reports from the database. The queries can be shared and uploaded.
See report by template for details.
This will give you the age sex distribution by provider and date
This report provides the number of visits by provider by location over the time period
PCN gives a list of patients and their status
OSCAR On Call Clinic
This utility lets you record the on call dates for the clinic.
Flu Billing Report
This report gives a report of the patients given influenza vaccine by year and practice
This utility generates a file of patients being seen in the near future for checking for health card validity by uploading to the ministry
Reports on current surveys
Select forms can be reported on with this utility
Patient List by Appointment Time
This yields a text file of appointments for the provider by date and time. This can be opened in a spreadsheet program for analysis.
Provider Service Report
Similar to the above this report provides summary statistics for encounters by program.
The report provides data on usage by provider in a given date range. It yields information as to practice size, demographics, number of appointments, encounter notes, billings, problem lists, documents, prescriptions, reminders and alerts, and labs
This utility allows you to search by provider or team all patients with a given disease registry entry.
This allows you to manage patients associated with a study and flag them on the appt screen. Patients in an active study show up with a capital sigma Σ next to their name.
PHCP (Setting: Provider, dx category) (deprecated)
This will work only if you have a dxphcpgroup table in your schema
CKD Screening Report (async) (special purpose)
This report creates an XML report on the system for patients at risk for CKD. Its most of use for research and clinics associated with the ORN.
Pre-Implementation Report (special purpose)
This is a report for the Ontario Renal Network CKD
Manage Patient Letter
Use this section to customize the patient letter generated from the screening report.
eForm Report Tool
This tool allows you to generate temporary tables with values pulled from eForms of any given type for further analysis through report by template or other fashion
copyright © 2012-2021 by Peter Hutten-Czapski MD under the Creative Commons Attribution-Share Alike 3.0 Unported License