The EMR queries below were developed by QIDSS and the EMR Communities of Practiceto 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 CHF Coded v1 searches (.srx files) will extract data necessary to calculate the percent of patients with diabetes 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 screenshots of the searches along with instructions on how to import the searches into your EMR. Share you challenges and successes with the Telus PS CoP or contact improve@afhto.ca.
Accuro
Please find the D2D EMR Data Quality CHF 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 the Accuro CoP or contact us.
Nightingale
The D2D EMR data quality CHF coded denominator query has not been developed. Please contact us if you have a query for Nightingale that you’d like to share or if you have any suggestions for this work.
OSCAR
Download the D2D EMR Data Quality CHF Coded v1 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 the OSCAR CoP or contact improve@afhto.ca.
P&P
The D2D EMR Data Quality Diabetes Coded query has not been developed. Please contact us 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