Clip-and-Save SQL Articles

Articles

SQL: Accounts Receivable for Dates of Service
About This report shows the CURRENT aging for a set of PAST date of service transactions that you specify. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Insurance amounts age between the date of servi...
SQL: Accounts Receivable for Dates of Service, By Insurance
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 ...
SQL: Vaccine Record Error
About 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. A sample image of this SQL report run in the...
SQL: Second Dose of Flu
About 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.   A sample image of this SQL report run in the Database Viewer is shown below: Caveats To se...
SQL: Provider Schedule Review - Full Days and Half Days
About Based on a schedule date range, this shows how many full days, AM half days, and PM half days each of your clinicians worked. A sample image of this SQL report run in the Database Viewer is shown below: Caveats This uses every column...
SQL: Patient Age Distribution by PCP
About Shows active patients bucketed by age groups and by PCP.   A sample image of this SQL report run in the Database Viewer is shown below: Caveats None Code To highlight and copy the code below to your clipboard, simply click the ...
SQL: HEDIS-like: ADHD Followup
About This follows the HEDIS conventions for the ADHD initiation and followup metrics.   If you are not familiar with how this metric is computed, read this first: https://ecqi.healthit.gov/ecqm/measures/cms136v7 A sample image of this SQ...
SQL: Food Insecurity Review
About Gives the results of the most recent Food Insecurity risk assessment for patients seen in the office between a date range you specify. A sample image of this SQL report run in the Database Viewer is shown below: Caveats The Food Inse...
SQL: CPT Frequency of Dates
About Shows CPT codes with frequency for a given time period. A sample image of this SQL report run in the Database Viewer is shown below: Caveats The report gives both the frequency and total units for each CPT code.   Frequency is th...
SQL: Contracts Module Review
About See what contracted/expected payments you have from each of your payers. A sample image of this SQL report run in the Database Viewer is shown below: Caveats You must have payer Contracts loaded in OP.  See  Insurance Contra...
SQL: Contacts and Contact Information of Active Patients
About 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. A sample image of this SQL report run...
SQL: Invalid Appointment Types on Scheduled Appointments
About This SQL identifies Appointment Types on scheduled appointments that do not match an Appointment Type in your system. Caveats If the SQL returns no results, then there is no action necessary.  If results are returned, the appointmen...
SQL: Invalid Appointment Types Associated to Visit Templates
About This SQL identifies Appointment Types attached to Visit Templates that do not match an Appointment Type in your system. A sample image of this SQL report run in the Database Viewer is shown below: Caveats If the SQL returns no results, ...
SQL: Invalid Appointment Type Default in Patient Chart
About This SQL identifies patient charts that have a Default Appointment Type that does not match an Appointment Type in your system. A sample image of this SQL report run in the Database Viewer is shown below: Caveats If the SQL returns no...
SQL: Ages (In Months for Patients Less Than 1) of Patients Seen Between Dates
About 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. A sample image of this SQL report run in the Database View...
SQL: Active Patients with PCP and Medical Home
About 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. A sample image of this SQL ...