-
About 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 e...
-
About This report shows patients sick and well notes written for a date range, grouped by date of service. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Counts one note per patient, per report date ra...
-
About 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. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Only patients with ...
-
About This report identifies pairs of charts where the first name, last name, and date of birth are the same. A sample image of this SQL report run in the Database Viewer is shown below: Caveats It is quite possible that you will have NO re...
-
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 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. For example, at runtime, you might enter start dates ...
-
About This SQL 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. A sample im...
-
About This report shows active patients, their default sick and well appointment types, and all future scheduled appointments. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Only patients with the ACTIV...
-
About 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 wi...
-
About Shows all active patients, their PCPs, and who's done the most checkups on them beginning from a reference date you specify. A sample image of this SQL report run in the Database Viewer is shown below: Caveats Checkup attribution is...
-
About This report lists all billed diagnoses of patients seen between two dates you specify, along with the rendering provider’s name. A sample image of this SQL report run in the Database Viewer is shown below: Caveats The diagnosis coul...
-
About This report shows possible chart errors for active patients in terms of their assigned VFC status (1= Medicaid, 2=self pay). It does not address VFC assignment errors for AIAN children, underinsured children, or CHIP children. A sample...
-
About This report lists all patients seen between the two dates that you specify. It also lists their age on the date of service. A sample image of this SQL report run in the Database Viewer is shown below: Caveats "Seen” is defined as a ...
-
About The SQL finds active insurance plans that are neither ranked as primary, secondary, or tertiary on the patient’s chart. A sample image of this SQL report run in the Database Viewer is shown below: Caveats This only looks at patients w...
-
About This report shows all active patients’ Miscellaneous Notes and Billing Notes. 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, sim...
-
About 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 o...
-
About This report shows all phrases in your Phrase Construction Notebooks and where those phrases are located. A sample image of this SQL report run in the Database Viewer is shown below: Caveats None. Code To highlight and copy the code belo...
-
About This report shows all surveys and status and results by date. A sample image of this SQL report run in the Database Viewer is shown below: Caveats None. SQL Code: Firebird To highlight and copy the code below to your clipboard, s...
-
About This report shows notes that were finalized between two dates that you specify. A sample image of this SQL report run in the Database Viewer is shown below: Caveats The date range you specify is the date range when finalization occu...
-
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...