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. |
The query criteria for childhood immunizations now reflect team-based care better:
- all patients are considered as opposed to rostered only
- billing data is not used since preventive care billing practices vary
- the ‘canned’ EMR preventive care reports are not used since they tend not to match the MOHLTC schedules
- and query criteria now matches more closely the Public Health/National Advisory Council on Immunization and MOHLTC 2015 immunization schedule (i.e. Rotavirus, an optional immunization, is included).
D2D results for this indicator may be lower than expected due to inclusion of this optional vaccine. Consider sharing your challenges and successes with your EMR Community of Practice or contact improve@afhto.ca.
Telus PS
The D2D- Childhood Immunization v1 searches (.srx files) will extract data for the numerator and denominator for all children with up-to-date immunizations. Save these searches to your desktop and import into your EMR. This guide provides instructions for importing the searches along with screenshots of the searches. You might need the help of your QIDSS, IT staff or other persons who usually run queries in your EMR. . Consider sharing your challenges and successes with the Telus PS CoP or contact improve@afhto.ca
Accuro
Please download the D2D- Childhood Immunization v1 queries from the publisher. 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 improve@afhto.ca
Nightingale
It appears that the Cumulative Bonus Report for childhood immunizations almost matches the current D2D definition. These instructions show you how to access the immunization data using the Health Maintenance (HM) report. To learn how to clean up immunization data so the HM report works effectively, have a look at this guide. Please consider sharing any feedback you might have with the Nightingale CoP or contact improve@afhto.ca
OSCAR
The D2D-Childhood Immunization v1 query generates the number and percentage of active patients 30-42 months (inclusive) who are up-to-date with immunizations. Please save the 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 to install the query into your EMR. Please consider sharing your challenges and successes running this query with the OSCAR CoP or contact improve@afhto.ca
P&P
If you have access to backend data for your P&P EMR, use this updated query – Childhood Immunization V2. It was originally developed by West Carleton FHT for D2D 3.0 (2015). and was updated by P&P in July 2018. Please consider sharing any front end workarounds you might have with the P&P CoP or contact improve@afhto.ca
Leave a Reply