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.


    • Related Articles

    • Due for Colorectal Cancer Screening

      Colorectal Cancer Screening – (Due for FIT test (Lab test), Sigmoidoscopy, or Colonoscopy (Procedure reports)) Below is an example of the complete query example for those due for colorectal cancer screening. *Note, we are looking for patients between ...

    • Due for Cervical Cancer Screening

      Cervical Cancer Screening – (Due for pap smear if have not had total hysterectomy for benign reasons) Below is an example of the complete query example for those due for cervical cancer screening. *Note, we are looking for female patients between 25 ...

    • Due for Lipid Screening

      Lipid Screening – (Due for lipid panel, or had a cv risk assessment (requires a lipid panel), or is on a statin medication-suggesting treatment for ongoing conditions) Below is an example of the complete query example for those due for lipid ...

    • Due for Breast Cancer Screening

      Breast Cancer Screening – (Due for Mammogram if have not had bilateral mastectomy for benign reasons) Below is an example of the complete query example for those due for mammogram. *Note, we are looking for female patients between 45 and 74 years, ...

    • Alberta Screening and Prevention (ASaP) introduction

      Alberta Screening and Prevention (ASaP) began after it was determined that certain maneuvers allow primary care providers to have the biggest impact. The screening maneuver selection was completed by an ASaP working group that included primary care ...