Below are a few options for Accuro queries for the indicator: % of patients with diabetes who had 2 or more HbA1c tests within the past 12 months 

• Query 1: 
  • Please download the queries with the following names from the cloud: 
    • Q: DM - 2 HBA1C Numerator
    • Q: DM # of Patients Denominator
• Query 2
• Queries from the Proactive Diabetes Care during COVID 19 - Fostering patient self management, improving organization of care and optimizing digital tools for better patient health outcomes Poster at the AFHTO 2021 Conference

1)  % of pts from our Diabetes Registry (Dx code 250) that had a live or virtual visit in the last 12 months (visit with MD and/or DM team

a)  Query name: DMP Diabetes Registry Numerator. Description: % of pts from our Diabetes Registry that had a live or virtual visit in the last 12 months (visit with MD and/or DM team); DM Registry Numerator/DM Registry Denominator

b) Query name: DMP Diabetes Registry Denominator. Description: % of pts from our Diabetes Registry that had a live or virtual visit in the last 12 months (visit with MD and/or DM team); DM Registry Numerator/DM Registry Denominator

2)    % of pts from our Diabetes Registry that had 2 or more HbA1C test in the past 12 months
a.) Query name: DMP HbA1C (2 or more) Numerator. Description: % of pts from our Diabetes Registry that had 2 or more HbA1C test in the past 12 months; DMP HbA1C (2 or more) Numerator / DMP Diabetes Registry Denominator

3)    % of pts from our Diabetes Registry with a prescription for glucose monitoring device
a)  Query name: DMP Glucose Monitoring Numerator. Description: % of pts from our Diabetes Registry with a prescription for glucose monitoring device; DMP Glucose Monitoring Numerator/ DM Diabetes Registry Denominator 
 

Below are a few options for OSCAR queries for the indicator: % of patients with diabetes who had 2 or more HbA1c tests within the past 12 months 

• Query 1
• Query 2

Below are a few options for Telus PS queries for the indicator: % of patients with diabetes who had 2 or more HbA1c tests within the past 12 months 

• Query 1
• Query 2 
• Query 3
• Query 4

• Aggregate Primary Care Vaccination Report Info Sessions

• Prevention Care Letter Template for Patients - Telus PS 
• Prevention Care Stamp - Telus PS 

• The AZCOVIDVaccineAdministered stamp is used by clinics documenting the vaccine administration in the Immunizations section of Telus PS.
• The AZ stamp  is used by clinics where they chose to only use the stamp to document in the EMR and not having to enter the lot # and expiry for every patient in the Immunizations section of the profile, since all that information is recorded in COVAX.