The EMR queries were developed by QIDSS and the EMR Communities of Practice to help you extract data for submission to D2D.
| Telus PS | Accuro | Nightingale | OSCAR | P&P |
| NOTE: All queries are tested and validated prior to release. However, changes that take place after the queries are released may affect how accurate they are. Such changes could include EMR software updates, new medications, and changes to standard clinical definitions. They may result in false positives, that is, patients being flagged who do not have the specified condition. They may also result in false negatives, that is, patients not being flagged who do have the condition. Queries are also limited by the quality of your EMR data. |
Remember that the cancer screening rates are for data quality purposes only. They are NOT intended as measures of performance of cancer screening. Once the EMR rates are determined you can compare them to the CCO Screening Activity Report (SAR) rates. The results will then be rolled up into the EMR Data Quality indicator. Teams are encouraged to use these results to discuss ways of standardizing data entry and cleaning up the EMR accordingly, as next steps in the QI process. You may have your own queries and criteria for local cancer screening initiatives. The queries presented below could be used to replace them if you like, but we cannot adjust the criteria here to make it more “useful” to people in the field given the purpose of the indicators to reflect data quality and as such, the need to match the SAR criteria as closely as possible. Once you have tried running these queries pleas consider sharing your challenges and successes with your EMR CoP or improve@afhto.ca.
Telus PS
The D2D EMR Data Quality Cancer Screening v2 searches (.srx files) will extract data for the for up-to-date colorectal and cervical cancer screening rates. Save these searches to your desktop and import into your EMR. You might need the help of your QIDSS, IT staff or other person who usually run queries in your EMR. Instructions on how to import the searches into your EMR can be found in this guide, along with screenshots of the searches. Share your challenges and successes with the Telus PS CoP or contact us if you have any questions.
Accuro
The numerator and denominator queries, and instructions on how to calculate screening rates can be found in the Colorectal Screening guide and the Cervical Screening guide. You might need the help of your QIDSS, IT staff or any other person who usually run queries in your EMR. Share your challenges and successes with the Accuro CoP or contact us for more information.
Nightingale
Cervical and colorectal cancer screening queries can be run in data miner as illustrated in this guide. After calculating your EMR/SAR ratio, you might consider using the Health Maintenance (HM) module to clean up your EMR. Share you experiences with the Nightingale CoP or contact us with any questions or concerns.
OSCAR
Please download the D2D EMR Data Quality Cancer Screening v1 queries to your computer. Have a look at this guide for instructions on how to import the queries and screenshots – notice that a drop down menu allows you to select a specific physician depending on who you have a SAR report for. You might consider adding exclusion criteria to the queries to match the SAR criteria as closely as possible. Please contact us for more information and consider sharing your challenges and successes running the queries with the OSCAR CoP.
P&P
The current HMP module in P&P does not match the SAR criteria so work continues to build a query that is not based on billing data. Please contact us if you have a cancer screening query for P&P that you’d like to share or if you have any suggestions for this work.
Leave a Reply