-
Last Updated: 03/05/2024 in Clip-and-Save SQL
Overview Note : The Database Viewer accesses the same database as OP. If you run a query that filters a lot of data, your database could become slower and affect your users. It is recommended to run queries during hours when users are no...
-
Last Updated: 09/13/2024 in Clip-and-Save SQL
About The Clip-and-Save SQL Library provides a list of SQL queries that you can copy and paste into OP Database Viewer. The Database Viewer accesses the same database as the OP software. If you run a query that filters a lot of data, your database ...
-
About This SQL shows all active patients with BMI greater than the 95th percentile for age. A sample image of this SQL report run in the Database Viewer is shown below: Caveats This will show you all active patients whose BMI is greater than...
-
Last Updated: 08/03/2023 in How To Overview Reports
The article explains how to clip and save SQL code from the Clip-and-Save SQL Library to the OP Database Viewer.
-
About This report shows all non-Completed and non-Canceled tasks from all departments for patients with some status other than ACTIVE. A sample image of this SQL report run in the Database Viewer is shown below: Caveats None. Code To highl...
-
About The OP software will automatically determine which encounters are ascribed to Medicaid and which encounters ones are not. This determination is based upon how you have set up insurance carriers. Run this SQL: Medicaid Plans SQL. You will be...
-
About This report shows all active patients with active-non medication allergies, along with detail about the allergy. A sample image of this SQL report run in the Database Viewer is shown below: Caveats None. Code To highlight and copy th...
-
About This report shows list of patients with either (or both) a nonzero credit (either insurance or patient-side) and a nonzero balance (either insurance or patient-side), along with next scheduled appointment (if any). A sample image of this SQ...
-
About This SQL shows patients who are behind on the AAP schedule of well-child care visits. It produces information similar to the DAR, with the added advantage that you can see how far behind a patient might be (13 months past their last annual...
-
About This report is intended to provide you with a list of assigned staff permissions. You will be able to see at a glance which permissions are assigned to which staff members. Further, you will be able to tell if the user was assigned the per...
-
About This report shows the CURRENT aging for a set of PAST date of service transactions that you specify. Similar to “Accounts Receivable for Dates of Service” but breaks out by insurance. A sample image of this SQL report run in the Database...
-
About This SQL will show all active patients of your practice for whom you have prescribed an ADHD medication in the past year and do not have a future follow up appointment on the schedule. The report will show: Last well visit which you code...
-
About This SQL will show all active patients, with no future appointment scheduled, for whom any Albuterol medication (such as "Albuterol" or "Ventolin" or "Proventil" or "Proair") was prescribed in the past year. For those patients, it will als...
-
About
This SQL will show a comparison of previous year to current year week-by-week well and sick visits. It is based on the following assumptions:
Since everyone uses different appointment type names, the query is based on the...
-
Last Updated: 04/18/2024 in Clip-and-Save SQL
This article describes how a user can edit SQL code to no longer display blue or white boxes when running a query.
-
About This report will look for diagnosis codes in Encounter and Well Visit notes that may be considered sensitive. A sample image of this SQL report run in the Database Viewer is shown below: Caveats This report does not read through the t...
-
This report shows phone numbers found in patients' Basic Information that contain something other than 10 numeric values.
-
This report shows phone numbers found in Family Contacts that contain something other than 10 numeric values.
-
This report shows phone numbers found in Staff Directory that contain something other than 10 numeric values.
-
This report shows phone numbers found in the Address Book that contain something other than 10 numeric values.