Planning a COVID-19 Vaccination Clinic
Identifying eligible patients
OntarioMD (OMD) has gathered many
useful resources to help clinicians prepare for a vaccination clinic. Some resources that you may find particularly helpful to plan your clinic:
Things to consider when planning to contact patients:
Track patients who have been called
Track patients who have declined/refused
Record consent given and how to flag patients who have not given consent
Resources for patients to educate themselves on what to expect at the vaccination clinic
COVaxON Mass Upload Assistance
Considerations when performing a Mass Upload to COVaxON:
How to do a Mass Upload to COVaxON (video)
Understand your clinic's policies and procedures around working with and extracting PHI from the EMR - OntarioMD Tips for Data Protection
Know your Vaccination Event number (VE#)
Identify if you have multiple VE#s. It is important patients are associated to the correct VE#.
Super Users access to Salesforce and login credentials
Access to and familiarity with running and editing queries
Familiarity with CSV files and spreadsheets
Additional support is available from OMD at COVaxON.Support@ontariomd.com
Tools (Queries/Searches) and Recommendations for EMR Data Extraction
Tips for Adjusting Data from Your CSV Export
Sample of Data Extract in Excel (contains dummy data)
Gender. Follow these instructions to change Gender if you only have F and M in the Excel spreadsheet:
Select (highlight) ONLY the column that contains the Gender. Make sure you select the full column.
Open the Find and Replace function (location depends on application i.e., Excel version, OpenOffice)
If using "Replace All", be sure no other data outside of the Gender column have been highlighted or selected.
- The DOB
MUST be in
YYYY-MM-DD format. To change DOB in the Excel spreadsheet, follow these instructions:
Select cells within the "Person Birthdate" column that you would like to change.
Right click and open the "Format Cells" function
From the left-hand side, select the "Date" category.
From the Type list, choose the format "YYYY-MM-DD". Select OK.
Note: If you cannot find the "YYYY-MM-DD" format, you can use the "Custom" category to create your "YYYY-MM-DD" format.
HCN MUST NOT have
Version Codes (VC) attached. If Health Card Numbers (HCN) have the VC in the same cell as in the example above, follow these instructions to remove:
Insert a new column to the right of the column that contains the Health Card Number
Enter the following formula in the first cell of the new column. (change A1 to the correct cell # in your spreadsheet that contains the first HCN)
Copy and paste that formula into the subsequent cells.
For queries developed by the eHealth Centre of Excellence to pull lists of patients with certain health conditions that fall under the Highest Risk, High Risk, and At Risk categories, click
.COVaxON Training for Primary Care Practices
OMD is offering training for primary care practices to administer COVID-19 vaccinations. Training sessions demonstrate how to access and use the provincial COVaxON Vaccination Management System.
Upcoming training sessions