Please find below EMR queries developed by QIDSS and the EMR Communities of Practice that will 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. |
Once you have tried running these queries consider sharing your challenges and success stories with your EMR CoP or with us so that others can benefit from improved and shared solutions!
Telus PS (Note – There are issues with queries developed in previous versions of PS. We are in the process of updating the queries and will be available at the launch of D2D (August 21, 2017)
The D2D EMR Data Quality Smoking Status v1.1.1 searches (.srx files) will extract data for the numerator and denominator for all patients (>=12 yrs) who have smoking status documented in the risk factors module. 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. Share you challenges and successes with the Telus PS CoP or contact us for more information.
Accuro
Please find the D2D EMR Data Quality Smoking Status v1 numerator and denominator queries on Publisher. Query criteria and instructions on how to generate rate data for the smoking status complete measure can be found in this guide. 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 for more information.
Nightingale
Instructions on how to build and run a query in Data Miner to generate data for the smoking status complete measure can be found in this guide. Contact us to share you challenges and successes.
OSCAR
Download the D2D EMR Data Quality Smoking Status v1 query 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 you challenges and successes with the OSCAR CoP or contact us for more information.
P&P
The P&P Smoking Status Query v1 file (.dat file) includes the numerator and denominator queries that will help you generate data for all patients >=12 yrs old with smoking status documented in Risk Factors. The data field used in the numerator query is a “learning field” and may need to be customized depending on how your team documents smoking status. You might need the help of your QIDSS, IT staff or other person who usually run queries in your EMR to import and run this query. Share your challenges and successes with the P&P CoP or contact us for more information.
Leave a Reply