Clip-and-Save SQL Library

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 could become sluggish and affect your users. It is recommended to run large queries during hours when users are not running the OP software. When applying a SQL Query from the Clip-and-Save SQL Library, you may need a basic understanding of how to create an SQL query. To learn how to create an SQL query, see our Clip-and-Save SQL: Quickstart! article. For brief instructions and an animated image on how to quickly clip and save SQL code, click hereIf you are looking for Meaningful Use (MU) related SQLs for determining Medicaid volume, click here.

Any SQL reports that are not included in this library may be considered customized SQL reports. Customized SQL reports may need to be created/altered to meet specific needs, which could then include an additional charge. For questions on customized SQL reports, please contact OP Support

Warning: Access to Database Viewer is permission-based. A staff member who has access to the Database Viewer can theoretically run any report that contains any data. This includes data concerning medications, diagnoses, lab results, and other sensitive areas of a patient's chart. Therefore, your practice should limit Database Viewer/SQL access only to individuals at your practice who would normally have access to this information. See Providing Access in OP Database Viewer Basics for more information.

NoteIf you have not gone live with all the elements in the OP software or use a different scheduling or practice management system, the reports created by the Clip-and-Save SQLs may not function as intended after they are run in the OP Database Viewer.   

Clip-and-Save SQL Library

Tip: Java must be enabled in order to use the search and sort capability. To quickly find the form you want in this table:

  • Filter: Enter specific keywords (or a character string) in the filter bar.  As you enter characters in the filter bar, the rows not containing those characters will become hidden.  The visible rows display based upon the characters in the row that match the characters in the filter bar.  The more characters you enter, the more the table will be filtered.  Please only use keywords and correct spelling.  You can use letters and numbers. Do not use commas to separate keywords.
  • Sort: You can sort A - Z and Z - A by clicking on a column header. 

SQL Title
Description
Category
This report lists all patients seen between the two dates that you specify. It also lists their age on the date of service.
Chart
This report indicates how many patient visits, if any, active patients have had since their last checkup.
Chart
This report shows vaccines that were administered but were not billed between the two dates that you specify.Financial
This report locates all Contacts in your system and the patient chart(s) they're associated with.  This can be useful for evaluating whether you might have duplicate Contacts that need to be merged using the Merge Contacts feature.
Chart
This report shows all active patients plus the name of their contacts #1 and #2 (if they have them), along with the preferred method of contact for each of those contacts for reminder, recall, medical, and billing.Chart
Contracts Module ReviewThis report shows what contracted/expected payments you have from each of your payers.Financial
This report shows CPT codes with frequency for a given time period.Financial
This report shows active patients, their default sick and well appointment types, and all future scheduled appointments.
Chart
This report lists all billed diagnoses of patients seen between two dates you specify, along with the rendering provider’s name.
Chart
This SQL will show all active patients of your practice who have had at least one elevated BP in the past year (or time period you specify), as well as how many normal BPs you've measured on them in that same time period. If you have one elevated BP and 4 normals, you're probably OK. If you have 4 elevated ones and no normals, and no future follow up scheduled, you might want to do something about that.
Chart
This SQL is used to show active patients who have never been seen or who have not been seen since the reference date you specify.
Chart
This report shows notes that were finalized between two dates that you specify.
Chart
This SQL finds active insurance plans that are neither ranked as primary, secondary, or tertiary on the patient’s chart.
Chart
This report lists the results of the most recent Food Insecurity risk assessment for patients seen in the office between a date range you specify.Medical
This report shows all active patients aged 14 - 17 months old along with the number of checkups they had prior to being 15 months old.
Medical
This report will give you total Referrals, Tracking, and Response entries created within a date range. The report will list the date created, type of entry, and the refer MD.
Chart
This reports shows the number patient sick and well notes written for a date range, grouped by date of service.
Chart
This report shows which notes have been finalized and cosigned for dates of service in a date range you specify.  This can be filtered or modified to show what percent of nurse practitioner/PA notes have been finalized and cosigned. You will be able to deduce trends in the elapsed time periods between the notes being finalized and being cosigned.
Chart
Patient Age Distribution by PCPThis report shows active patients bucketed by age groups and by PCP.  Chart
This report shows all non-Completed and non-Canceled tasks from all departments for patients with some status other than ACTIVE.
Chart
This report fulfills the requirements of the Merck HPV “Health in Practice” (HIP) reporting program and shows commercially-insured 13 year olds seen in the past 24 months along with their HPV vaccine completion status.
Medical
This report shows all active patients’ Miscellaneous Notes and Billing Notes.
Chart
This report identifies pairs of charts where the first name, last name, and date of birth are the same.
Chart
This report shows all surveys and status and results by date.
Chart
Primary Contact InformationThis report displays all primary Family Contacts (or Family Contacts with a sort of 1) and their information as entered into OP.Chart
This SQL creates a report that helps you identify patients who were a certain age range during a period you specify. It also indicates patient status, primary, and secondary insurance. After the report is run, you can use the dropdown filters to see only the patients who meet specified criteria.
Chart
Shows all active patients, their PCPs, and who's done the most checkups on them beginning from a reference date you specify.
Chart
This report shows all phrases in your Phrase Construction Notebooks and where those phrases are located.
Chart
This report shows the following information: Patient chart number, First name, Last name, Location, Referral date, Provider to whom patient was referred, Referral category/type, Dx code(s), Referring provider, Status of referral.
Chart
This report shows possible chart errors for active patients in terms of their assigned VFC status (1= Medicaid, 2=self pay, 3=AIAN, 4=underinsured).
Chart
This report shows all sick and well notes that have not yet been finalized.
Chart
This report lists all patients seen between the two dates that you specify. It also lists their age on the date of service, where patients less than one year old are aged in months.
Chart
This determines the time elapsed when the appointment was booked and when the appointment took place. For a given day you specify, it shows the date-time stamp of when the appointment was booked, the actual appointment date/time, and how much time elapsed.  It also shows the patient number (for crosschecks), the type of appointment, who they were booked with on the schedule, the initials of the staff member who made the appointment, and final diagnosis.
Schedule
This report shows all active patients with active-non medication allergies, along with detail about the allergy.
Schedule
This reports indicates the elapsed time spent in all statuses for all appointments between two dates that you specify.
Schedule
This report shows all appointments scheduled, and by which staff member, for a period between two specified dates.
Schedule
This report shows patient name, DOB, patient phone number and schedule information (scheduled provider, date/time, and location) for patients who have more than one future appointment scheduled.
Schedule
This report displays all completed visits on the schedule for infants 30 days old or less on the day of the appointment, for an appointment date range you specify.
Schedule
This report looks for active patients under the age of 60 days old (at the time the report is run) who do not have a future appointment (of any kind) scheduled. It also lists if patients have had a recent visit in the office. This can be used as a transition of care tracking report for PCMH.
Schedule
This report shows all appointments with visit status “No Show,” along with confirmation status & date, location, appointment date, chart number, and type of visit for two schedule dates you specify.
Schedule
For a date range you specify, shows all patients seen for sick and well visits along with the rendering provider for that visit, along with the patient’s assigned PCP in the REGISTER.
Schedule
This report shows the patient name, DOB, patient phone number, and schedule information (scheduled provider, date/time, and location) for cancelled appointments in a date range that you specify.
Schedule
This report shows how frequently different rooms/resources were used between two schedule dates you specify.
Schedule
This report shows location, scheduled provider, appt date & time, patient name, chart number, DOB, appt type, primary phone number, visit status for the date range that you specify.
Schedule
This report shows list of patients who no-showed today, along with their no-show list prior to today.
Schedule
Invalid Appointment Types on Scheduled AppointmentsThis report provides results that identify Appointment Types on scheduled appointments that are not valid.Schedule
Invalid Appointment Types Associated to Visit TemplatesThis report provides results that identify Appointment Types attached to Visit Templates where the Appointment Type is no longer valid.Schedule
This report provides results that identify patient charts that have a Default Appointment Type that is no longer valid.Schedule
This report lists active patients with second hand smoke exposure in risk assessment, and whether or not they have the second hand smoke SNOMED in their RISK ASSESSMENT as a problem (any status).
Medical
This report shows all billed diagnoses for active patients between the two dates you specify.
Medical
This report shows all instances of a specific billed diagnosisfor active patients between two dates you specify. The diagnosis code is entered when you enter the the date range.
Medical
This report shows chart number, first name, and last name of all active patients who have “Synagis indicated” in their birth history.
Medical
This SQL will be used for North Carolina’s Lead Registry reporting. The report will run and produce all lead tests into a CSV file that can be uploaded to NCDHHS.
Medical
This report looks for active patients who are (on the run date of the report) between the ages of 1.8 years (that is 21.6 months) and not yet 2-years to see whether they pass or fail the HEDIS CIS-2 metric.
Medical

This report shows all the active problems for all your active patients. It indicates the ICD and SNOMED (if any) codes that are attached to the problems. Finally, it lists the creation date/last updated date for each of the problems on the list.

Medical
This report shows all active patients who have ever had a BMI computed. It lists the most recent date of BMI computation, age at computation, BMI, BMI percentile (for under 18 years old), and appropriate ICD-10 Z code for that BMI.
Medical
This report identifies active patients with a coded diagnosis of persistent asthma on their problem list (either active or inactive problem status).
Medical
This report shows all patients 18 and under who have received one or more immunizations of any type during a specified time period and classifies them into one of three age groups: <1 year old, 1-6 years old, and 7-18 years old.  It also classifies them by VFC category number (1 = Medicaid, 2 = self pay, 3 = AIAN, 4 = underinsured, 5 = not VFC eligible). Many states require this in their annual VFC re-enrollments.
Medical
This report looks for active patients who are (on the run date of the report) between the ages of 1.8 years (that is 21.6 months) and not yet 2-years and looks to see whether they pass or fail the HEDIS CIS-3 metric.
Medical
This tells you, for active patients who have Nexplanon listed as an ongoing/chronic med, the date you entered it in their chart. 
Medical
This SQL shows patients who are overdue for Well Visits per Bright Futures guidelines.
Medical
HPV Due VaccinesThis SQL is used to indicate who is due for HPV: active patients between 11-21 who haven't completed the series (Either 2 or 3 doses) who are slightly past the minimum spacing requirements.
Medical
This report shows list of active patients ages 16-21 and the total number of meningitis B vaccines that they have received.
Medical
This report shows all active patients ages 16 and up and lists the number of meningococcal ACWY vaccines they have had administered (either by the practice or legacy vaccines).
Medical
Reach Out and Read ProgramThis SQL creates a report that tells you how many checkups you did between dates you specify that fell in one of several age "bins" between 6 months and 5 years old.
Medical
This report shows all active patients that are 13-18 years old along with whether they have completed (“pass”) or not completed (“fail") the HPV series.
Medical
This SQL shows all active patients with BMI greater than the 95th percentile for age.
Medical
How many of your patients with asthma in their problem list have had an asthma action plan written/updated in the last _______ months/years? This SQL is intended to answer that question. The date in "most_recent_AAP" will be the date the last asthma action plan was written/updated, and blank if the patient has never had one.
Medical
This report shows the number of active patients by medical home location, VFC status, and age “bucket”.  It can be used as an aid in allocating vaccine inventory among multi-site practices.
Medical
This report shows patient name, prescription information, prescriber, and pharmacy (for e-prescriptions) for prescriptions written between two dates you specify.
Medical
This report fulfills the Merck program requirement for “Number of active patients ages 19-26 seen in the past 24 months who have received three total doses of HPV (“pass”) or not (“fail”).
Medical
This report looks at all patients who have open (PENDING) referrals but do not have an ACTIVE patient status within the practice.
Medical
This SQL shows the percentage of sick-visit patient's that came in for a flu-related visit.
Medical
This report shows the total number of surveys with a certain name, done before a certain age, for all active patients between a certain age range.
Medical
This SQL shows all kids that are 1 - 3 years old who had a checkup on the date they were seen in a selected date range.  If they had a fluoride done (LOINC code "XFLUOR") sometime in that period (not necessarily the same day as the checkup), then it puts the date in "FLUORIDE DATE" column.
Medical
Second Dose of FluThis SQL Shows active patients who have received one (and only one) dose of flu this season and who have received 0 or 1 doses in previous years.  Medical
This report shows all active patients and the number of vaccines they have had recorded in their chart.  Blank means 0. You can change the dropdown filter to show only blanks.
Medical
Vaccine Record ErrorThis report finds vaccine records in OP without CVX codes. Records without CVX codes will not compute vaccine predictive logic accuracy and may cause errors when interacting with your state vaccine registry.Medical
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.
Financial
This report shows all encounter notes with nothing billed on those dates of service for a date of service range you specify.
Financial
This report shows the CURRENT aging for a set of PAST date of service transactions that you specify.
Financial
A well note will show as “unbilled” if no CPT codes of any kind were billed on that date of service.
Financial
This report shows all CPTs and charges, payments and adjustments, claim notes and adjustment codes, diagnoses, and age of patient at the time of service for a date of service range that you specify.
Financial
This SQL shows all patients with nonzero patient or insurance credits. You can apply a filter in the dropdown to exclude whatever it is you don't want to see.
Financial
This SQL shows all patients with nonzero patient or insurance credits. You can apply a filter in the dropdown to exclude whatever it is you don't want to see. It also includes patient name columns.
Financial
This report shows all encounter notes reflecting dates of Saturday or Sunday where neither 99050 or 99051 was billed for a date of service range that you specify.
Financial
This report shows the frequency and total units billed for each CPT by insurance.
Financial
This report lists the average payment for well visit by insurance carrier based on the date range you specify.
Financial
This report looks for all patients with balances who also have an active credit card on file (stored in the CC_ON_FILE table).
Financial
This report shows patient chart number, first & last name, date of service, DOB, age, and billed CPT code.
Financial
This report shows list of patients with either (or both) a nonzero credit (either insurance or patient-side) and a nonzero balance, along with next scheduled appointment (if any).
Financial
This report shows all open claims (either insurance-side or patient-side) with a date of service between the dates you specify.  It also assigns an aging bucket of <30, 31-60, 61-90, 91-120, and 121+.
Financial
This report lets you see all claim statuses that took effect in a given date range you specify.
Financial
This report shows entire CPT code record for all CPT codes, including all fee schedules for all CPTs entered into OP.
Financial
This report shows all patients with balances, aged from patient responsibility date, grouped by guarantors.  It also gives a family total balance, and the date and amount (if any) of the last patient payment on the account.
Financial
This report shows how to get the numbers 99201 to 99205 and 99211 to 99215 that each provider saw at each location (along with totals) for the specified date range.
Financial
This report shows the chart number, DOB, claim (invoice) number, date of service, CPT code, insurance code, charge, place of service, diagnosis code(s), payment, and adjustment amounts for the date range you specify.
Financial
This report shows payments and adjustments received during a user-defined period, for dates of service performed during another user-defined period.
Financial
This report shows all patients with a balance, aged into 0-30, 31-60, 61-90, 91-120, and 121+ day buckets.  This report also shows guarantor ID and name, patient status PCP, and the next appointment scheduled (if applicable).
Financial
This SQL lets you pick a date range (say, this week) and takes all your CPT codes for charges rendered, matches them to your contracted allowables, and tells you the expected amount you'll receive, based on your insurance contracts.
Financial
The report identifies total payments for the sick visit code of a sick-and-well visit and compares it to the contract amount for the sick visit.  This can be used as a way to identify carriers who reduce payment for a sick visit when combined with a well visit.
Financial
This report looks at all the completed appointments on the schedule, finds the associated billed insurance, and counts the total number of encounters.
Financial
This report shows the practice-entered cost of a CPT code (e.g labs or vaccines) and total payment for that CPT code for a date range you specify.
Financial
This report shows the entire charge and payment activity on a particular chart/account for a specified date range.
Financial
This SQL provides you with aging of all balances, grouped by payer and aging bucket (e.g. 0-30, 31-60, etc). Insurance balances and patient balances are shown separately.
Financial
This report is similar to  HEDIS Immunization Metric for Adolescents (IMA). It takes all currently-active patients who were 13 years old as of a reference date you specify, and determines whether they have had 2 or 3 HPV, at least one dose of Td/Tdap, and at least one dose of meningitis ACWY vaccine.  If all three of these metrics are ‘pass,’ then the child also gets a ‘pass’ for the entire IMA measure.
Medical
This report is similar to HEDIS W34. It takes all currently-active patients who were 3-6 years old as of a reference date you specify, and determines whether they had a checkup in the previous 365 days of the reference date.
Medical
This report provides data for an average to “time to paid claim” in days by insurance. This report is based on the date range of claims that you specify.
Financial
This report shows patient number, date of service, rendering provider, appointment type, CPT, total insurance paid and total insurance adjusted, for a date of service range you specify and a payment date range you specify.
Financial
This report looks at all adjustments for a period and totals them by adjustment code.
Financial

This report looks at the number of claims per calendar month (for a date range you specify) that were completely written off  on the insurance-side. This is a good general monitor for performance around timely filing and appeals for your billing department.

Financial
The SQL is used to see what was charged for a certain time period and the payments that came in (at ANY subsequent time) for that work. The report breaks down the data by billing provider.
Financial
This report looks at all patient charts who do not have a guarantor assigned. It also lists if they have a balance and the status of the account.
Financial
This SQL finds individual line items that are over/underpaid when the total claim is in balance. A practice whose accounts are correct (at least in this way) will receive no results when this report is run.
Financial
This report indicates instances of when a well visit (9938x, 9939x) was billed on the same day as a sick visit (99201-5, 99212-5). It also indicates the patient and what rendering provider.

Financial
This report shows the vaccines given in the office between two dates you specify. It also shows the VFC status, payments, and adjustments for each vaccine.
Financial
The SQL is used to see what was charged for a certain time period and the payments that came in (at ANY subsequent time) for that work.
Financial
The SQL is used to see what was charged for a certain time period and the payments that came in (at ANY subsequent time) for that work. The report breaks down the data by rendering provider.
Financial
Identifies total insurance adjustments by type between two dates you specify.
Financial
Shows number of each type of sick visit, sum of new and established sick visits, and grand total of sick visits for a period you specify, grouped by location and rendering provider.
Financial

Shows number of each type of well visit, sum of new and established well visits, and grand total of well visits for a period you specify, grouped by location and rendering provider.

Financial
This report shows claims which are “out” to a secondary insurance, along with primary and secondary insurance responsibility dates and aging days (i.e. the elapsed time from the secondary insurance responsibility date to today).
Financial
This report looks at what you were paid for each vaccine serum that has been billed and completely adjudicated.  It compares what you were paid to the cost of the vaccine, assuming you have put the cost per dose in FEE4 in the CPT code tables.
Financial
This report shows patients who were billed J0561 (long acting injectable penicillin) with something other than 6 or 12 units between two dates that you specify.
Financial
This report looks for all active patients who have an active insurance policy that contains a specified prefix. The SQL code consists of the prefix ‘ABC’, but it can be altered to find the insurance policy prefix you desire.
Financial
This report lists the patient chart number, patient balance, and how many statements there are for the unpaid claim with the most statements.
Financial
Revenue Per Visit

This SQL provides you an average revenue-per-visit for each payer during a period you specify.

Financial
This report shows posted credits (where money came into the office) of method CC (credit card), CA (cash), or CK (check) on a date you specify, along with the staff member who posted the credit in OP.
Front Desk
This report displays all active entries in your address book.
Front Desk
This report shows active entries in the Address Book with specialty name.
Front Desk
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 permission as an individual, group, or both.
Practice Management
This SQL shows, grouped by month, how many nurse, sick, well, and sick-and-well visits your providers conducted.
Productivity
This report looks for the total number of sick and well E&M done by rendering providers per month based on a date range you specify.
Productivity
This report indicates which staff member (other than a provider) opened sick and well notes for a period. The report is based upon the staff ID number in the Entered by field on the visit's Visit Info tab for a Patient's Well or Encounter note. Data in this report is summed by staff member, according to the date range you select.
Productivity
This SQL is intended to indicate who the vaccinator was for all the shots given in your office during a selected date range.
Productivity
This SQL creates a report to show encounters by rendering provider along with the total payments received by rendering provider for a period between two dates that you specify.
Productivity
This report shows the count of nurse visits, sick/procedure visits, well visits, and well-with-sick/procedure visits by rendering providers for a period that you specify.
Productivity
This report shows how to get the numbers 99201 to 99205 and 99211 to 99215 that each provider saw at each location (along with totals) for the specified date range.Productivity
This SQL report summarizes total visits and patients by insurance for a date range you specify.

Productivity
This report shows how many full days, AM half days, and PM half days each of your clinicians worked based on a scheduled date range.Productivity
This report shows all active patients with the PCP and Medical Home that is selected in the Basic Information of their patient chart. Blank fields indicate that the patient chart does not contain the information.
Chart
HEDIS Like: ADHD FollowupThis follows the HEDIS conventions for the ADHD initiation and followup metrics.Chart
Medicaid Volume - Confirm Medicaid Payers for AttestationThis report identifies unique Medicaid encounters (patient and date of service) for Medicaid, for 90 days beginning on a reference date you specify. It is meant to be used to make sure you have properly labeled all the different Medicaid insurance plans iMU
Some CPT codes that you may use in the OP software may not properly reflect patient encounters. A practice might use a fake CPT code like “99999” to reflect a no-show charge, a bounced-check charge, or track something internally. Therefore you will want to List the codes you want to exclude with the SQL codeMU
The OP software will consider this two encounters, while for meaningful use purposes this must be counted as one single encounter. To exclude the dental MCO, you may list it here.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 2.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 4.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 4.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 4.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 7.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 7.MU
This report shows the detail information for patients who met or did not meet the requirement for Objective 7.MU
MU State Group 1 GroupThis SQL Code provides attestation results for states that were grouped into Group 1 in the MU: State Group SQL Table. The report is based on the provider's decision to provide group attestation results.MU
This SQL Code provides detailed attestation results at the patient level for states that were grouped into Group 1 in the MU: State Group SQL Table. The report provides patient-level detail for audit purposes.MU
MU State Group 1 IndividualThis SQL Code provides attestation results for states that were grouped into Group 1 in the MU: State Group SQL Table. The report is based on the provider's decision to provide individual attestation results.MU
MU State Group 2 GroupThis SQL Code provides attestation results for states that were grouped into Group 2 in the MU: State Group SQL Table. The report is based on the provider's decision to provide group attestation results.MU
This SQL Code provides detailed attestation results at the patient level for states that were grouped into Group 2 in the MU: State Group SQL Table. The report provides patient-level detail for audit purposes.MU
This SQL Code provides attestation results for states that were grouped into Group 2 in the MU: State Group SQL Table. The report is based on the provider's decision to provide individual attestation results.
MU
MU State Group 3 GroupThis SQL Code provides attestation results for states that were grouped into Group 3 in the MU: State Group SQL Table. The report is based on the provider's decision to provide group attestation results.MU
This SQL Code provides detailed attestation results at the patient level for states that were grouped into Group 3 in the MU: State Group SQL Table. The report provides patient-level detail for audit purposes.MU
This SQL Code provides attestation results for states that were grouped into Group 3 in the MU: State Group SQL Table. The report is based on the provider's decision to provide individual attestation results.MU
This SQL Code provides attestation results for states that were grouped into Group 4 in the MU: State Group SQL Table. The report is based on the provider's decision to provide group attestation results.MU
This SQL Code provides detailed attestation results at the patient level for states that were grouped into Group 4 in the MU: State Group SQL Table. The report provides patient-level detail for audit purposes.MU
This SQL Code provides attestation results for states that were grouped into Group 4 in the MU: State Group SQL Table. The report is based on the provider's decision to provide individual attestation results.MU
Confirm Medicaid Designation of Plans in OP is CorrectThis query provides an estimated total number of encounters during the selected period for all active Medicaid plans (and only active Medicaid plans).MU
Total Volume per LocationThis SQL code is used to calculate the total volume per location metric. This SQL looks at the location breakdown of billed encounters by rendering provider, for the period under review.MU
ADHD RecallThis 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.Chart
Depression RecallThis SQL will show all active patients of your practice for whom you have prescribed a Depression medication in the past year and do not have a future follow up appointment on the schedule.Chart
This SQL will show all active patients of your practice for whom you have prescribed an Anxiety medication in the past year and do not have a future follow up appointment on the schedule.
Chart
BMI Recall
This report will pull all active patients when their last BMI was >=95%. It also shows the age at which their BMI was done, the date, and their last sick and well encounter.
Chart
Anticipated Payment
This report will estimate what your payments will be in light of severely reducing your charges. The SQL can be used for SBA loans to substantiate decreased future payment for present and past work.
Financial
High Utilizers 
This is a group of similar SQLs that show utilization patterns of all patients in your practice between two dates you specify.
Productivity
Asthma RecallThis 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.Chart
Phone Message ReviewThis SQL will show all originating phone messages and who wrote them between two dates you specify.Chart
Extended Time RecallThis SQL will show all active patients whose default sick or well appointment type is an extended appointment type.Chart
Compare Prior Year to Current Year Week-by-Week Visit CountsThis SQL will show a comparison of prior year to current year week-by-week well and sick visits.Productivity
This SQL shows Encounter Template use counts for a specified date range.Chart
This report will show Problem List entries that may be considered sensitive. This report can be used as a guide to clean-up of patient records that are visible to staff in OP and parents/patients on the Patient Portal.
Medical
This report will show contraceptive medications that may be considered sensitive. The SQL can be modified to include other sensitive medications. This report can be used as a guide to clean-up of patient records that are visible to staff in OP and parents/patients on the Patient Portal.
Medical
This report looks at all Problem List entries and returns a list where a SNOMED or ICD code has not been entered. This report will include Problem List entries with a status of Active, Tracking, or Resolved, including those that are marked as Hidden.
Medical
This report will look for diagnosis codes in Encounter and Well Visit notes that may be considered sensitive.
Medical
This report will look for diagnosis codes in Encounter and Well Visit notes that may be considered sensitive. This report will additionally include the Rendering Provider.

Medical

The report will list the Diagnostic Test requisitions that can be considered sensitive. 
Medical
This report is used to view a patient's Portal Account status found in OP.
Front Desk
Patients Administered COVID VaccineThis report is used to view patients that have received a COVID vaccine. The report will display the first and second date the vaccine was administered.
Medical
Childhood Immunization (Combo 10)
This report looks for active patients who are (on the run date of the report) between the ages of 1.8 years (that is 21.6 months) and not yet 2 years and looks to see whether they pass or fail.
Medical
COVID Vaccine Status
COVID vaccine status for all active patients at the Practice.
Medical
Invalid Phone Fields: Active Patients Only
This report shows phone numbers found in ACTIVE patient's Basic Information that contain something other than 10 numeric values.Maintenance
Invalid Phone Fields: Active Contacts Only
This report shows phone numbers found in ACTIVE family Contacts that contain something other than 10 numeric values.Maintenance
Invalid Phone Fields: Active Staff Only
This report shows phone numbers for ACTIVE staff members found in the Staff Directory that contain something other than 10 numeric values.Maintenance
Invalid Phone Fields: Active Payers Only
This report shows phone numbers for ACTIVE payers found in Insurance Payers' Basic Information that contain something other than 10 numeric values.Maintenance
Invalid Phone Fields: Basic Information
This report shows phone numbers found in patients' Basic Information that contain something other than 10 numeric values.
Maintenance
Invalid Phone Fields: Family Contacts
This report shows phone numbers found in Family Contacts that contain something other than 10 numeric values.
Maintenance
Invalid Phone Fields: Staff Directory
This report shows phone numbers found in Staff Directory that contain something other than 10 numeric values.
Maintenance
Invalid Phone Fields: Address Book
This report shows phone numbers found in the Address Book that contain something other than 10 numeric values.
Maintenance
Invalid Phone Fields: Practice
This report shows phone numbers found in the Practices table that contain something other than 10 numeric values.
Maintenance
Invalid Phone Fields: Locations
This report shows phone numbers found in the Locations table that contain something other than 10 numeric values.
Maintenance
Invalid Phone Fields: Insurance Payer
This report shows phone numbers found in Insurance Payers' Basic Information that contain something other than 10 numeric values.
Maintenance
Active Patients with F Category Diagnoses
This report shows any active patient with an "F" category diagnosis, Mental, Behavioral, and Neurodevelopmental disorders.Medical
Beyfortus Population Evaluation
This SQL analyses patient records of all ACTIVE patients < 8 months old and lists their Beyfortus (“Babymab”) status as “due” or “ok.” It also lists their current VFC status, most recent weight (in kg), and whether the baby qualifies for 50 mg or 100 mg based on the most recent weight.Medical
Beyfortus Doses Given Overview
This shows all Beyfortus doses your office has administered, whether they were first or second season doses, the total volume given documented, the number of Beyfortus product units billed on a claim, the admin code used, and the number of admin units billed on a claim.
Medical