Due for Diabetes Screening

Due for Diabetes Screening

Due for diabetes screening-(No glucose fasting or hemoglobin A1c lab tests in the last 5 years)

Below is an example of the complete query example for those due for diabetes screening.

*Note, we are looking for patients over 40, with no lab results found on either the labs tab, the ASaP template, or the scanned documents. This may differ based on clinic workflows.


  1. Click ‘New’ on the queries window, enter a name for the query in the bottom description box, and while creating the query, uncheck the notify on chart and appointments.

    1. Click edit query, then click ‘new line’, select client and ok. Enter the demographic information, as below. 

    1. If you want to specify a doctor, select one from the dropdown as well. Click save line.
  1. Next, create new lines to look for patients without the diabetes labs.
*Note the criteria shown below on the query line is the information found on the labs tab of a patient chart.
    1. Enter the result date criteria, in the last 5 years, and check off the NOT in the top right.
    2. The test description should match the description found on the labs tab of a patient’s chart.
    3. Click save line.

*Note the test description may differ by zone, confirm correct labeling in your zone.

  1. Next, create new lines to look for patients without the diabetes labs documented in the ASaP template.
    1. Click new line, select chart notes.
    2. On the left, select the ASaP template.
    3. At the bottom, for the other dates, select the glucose fasting date, then complete the phrase, in the last 5 years, and check off NOT in the top right corner.
    4. Click save line.
    5. Repeat this for the A1C date in the ASaP template.

  1. Next, create new lines to look for patients without the diabetes labs in the scanned documents.
    1. Click new line, select scans.
    2. Enter the result date criteria, in the last 5 years, and check off the NOT in the top right.
    3. Below, it is looking for the notes section, this is the description seen on the charting overview.
      1. Or select a scan type if you have them specific for these lab results.
    4. Then complete the phrase, in the last 5 years, and check off NOT in the top right corner.
    5. Click save line.

  1. Close.
  2. Run the report and double click on a name from the report and click charting to check a few charts to make sure it is running accurately.
  3. If correct, check off notify on chart and notify on appointment as applicable.