The EMR queries below 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. |
Telus PS
The D2D EMR Data Quality Depression Coded v1 searches (.srx files) will extract data necessary to calculate the percent of patients with depression whose diagnosis is recorded with a code in the appropriate place in the EMR. 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. This guide provides instructions on how to import the searches into your EMR. Screenshots of the query can be found here. Share you challenges and successes with improve@afhto.ca.
Accuro
Please find the D2D EMR Data Quality Depression Coded v1 numerator and denominator queries on Publisher. You might need the help of your QIDSS, IT staff or any other person who usually run queries in your EMR. Share you challenges and successes with us.
Nightingale
The D2D EMR Data Quality Depression Coded query has not been developed for Nightingale.
OSCAR
Download the D2D EMR Data Quality DepressionCoded v2 queries to your computer and import into your EMR. 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 improve@afhto.ca.
P&P
The D2D EMR Data Quality Depression Coded query has not been developed for P&P. Please contact improve@afhto.ca if you have a query for P&P that you’d like to share or if you have any suggestions for this work.
Leave a Reply