The EMR queries below were developed by QIDSS and the EMR Communities of Practice to help you prepare data for D2D submission.
| 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. |
This indicator is intended to reflect the ENTIRE patient population served by a team, not just those who are rostered to the team. The definition is “the number of unique patients with a visit (i.e. appointment) to anyone in the team in the last 3 years”. This definition will continue to evolve in subsequent iterations of D2D as EMRs are increasingly capable of recording other meaningful patient encounters (e.g. phone calls) in a way that the data can easily be extracted. For D2D 4.0 the technical limitations of data extraction from EMRs dictate that only in-person encounters can be included in the definition.
Telus PS
The D2D- Patients Served v1 search looks at unique patients with an appointment in the last 3 years. Save the search to your desktop and import into your EMR. You might need the help of your QIDSS, IT staff or other person who usually runs queries in your EMR. Consider sharing your challenges and successes with the Telus PS CoP or contact us for more information.
Accuro
Please download the D2D- Patients Served v1 query from the publisher. The query returns patients with an appointment in the last 3 years and filters out “no shows”. You may need the help of your QIDSS, IT staff or any other person who usually runs queries in your EMR. Consider sharing your challenges and successes with the Accuro CoP or contact us for more information.
Nightingale
Please use this guide to extract data for the patients served indicator using data miner. If you have any questions or would like training on data miner, contact us for more information.
OSCAR
Please save the D2D- Patients Served v1 query to your computer. Here is a guide for importing the query and using the report generated by the query. Consider sharing your challenges and successes running this query with the OSCAR CoP or contact us for more information.
P&P
Thanks to efforts of the CoP an approach to accessing appointment data (i.e “date last seen”) has been programmed by the vendor. It’s called the Patient Utilization Report. This guide will show you how to access the report in the EMR. Please connect with the P&P CoP or contact us for more information.
Leave a Reply