Due for Colorectal Cancer Screening

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 50 and 74 years, with no lab or procedure 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 FIT, sigmoidoscopy, or colonoscopies.
*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 2 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.

  1. Next, create new lines to look for patients without the FIT or colonoscopy 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 FIT date, then complete the phrase, in the last 2 years, and check off NOT in the top right corner.
    4. Click save line.
    5. Repeat this for the colonoscopy date in the ASaP template, in the last 10 yrs.

  1. Next, create new lines to look for patients without the sigmoidoscopy or colonoscopy reports 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, looking for the notes section, this is the description seen on the charting overview.
      1. Or select a scan type for sigmoidoscopy if you have one.
    4. On the image date enter ‘in the last 5 years’ and check off NOT in the top right corner.
    5. Click save line.
    6. Repeat the above, this time with the scan type colonoscopy, and the image date in the last 10 years, checking off the NOT in the top right corner.
    7. Click save line.

*Note Scan types may differ per clinic setup. This example shows the use of scan types (dropdown field) as well as the description (free text field).

  1. Save line and 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 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 ...

    • Building CDS queries

      Building CDS queries can be a daunting task, call technical support to assist in building or editing any query if you are not comfortable. The first thing to do is determine the criteria of patients to look for and identify how the criteria is noted ...

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

    • ASaP template use

      The ASaP template should be applied to all patients charts for support in tracking screening maneuvers. Here are some of the benefits to using ASaP to its fullest: Keep all healthcare team members providing the same information. Allows for easy ...

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