Admin Reports

UpdatedMay 3, 2022

By Peter Hutten-CzapskiPeter Hutten-Czapski

Report setup, running and administration

Dashboard Manager

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.

Age-Sex Report

This will give you the age sex distribution by provider and date

Visit Report

This report provides the number of visits by provider by location over the time period

PCN

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

Overnight Batch

This utility generates a file of patients being seen in the near future for checking for health card validity by uploading to the ministry

Surveillance Report

Reports on current surveys

Rehab Study

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.

Usage Report

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

Disease Registry

This utility allows you to search by provider or team all patients with a given disease registry entry.

Study

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