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...