View Source

Recipe Name:	Identify immunocompromised patients due for a third COVID-19 vaccine
Rationale:	ATAGI has recommended that immunocompromised patients who have received 2 doses of vaccine two months or more ago are eligible for a third shot. See the full details here: atagi-recommendations-on-the-use-of-a-third-primary-dose.pdf
Target:	Any at risk patients as identified as immunocompromised in the COVID-19 at risk report
Recipe Limitations:	This report relies, among other details, on coded diagnoses in the patient record. As this is a requirement for accreditation and is also relevant for PIP-QI, we recommend to improve coding of conditions for all clinicians. Here are some helpful links: Data Cleansing Report Details Bulk clean up of free text diagnosis - BP users Bulk clean up of free text diagnosis - MD users
CAT Starting Point:	CAT Open - CAT4 view (all reports) loaded Population Extract Loaded and Extract Pane "Hidden"

Filter Steps:

Use the date range result filter to exclude any COVID-19 vaccines given between six months and two months ago:

CAT Recipes > Identify immunocompromised patients due for a third COVID-19 vaccine > image2021-11-24_10-32-45.png

In the example above my data is from the 1/11/2021. To only see patients who have received their vaccine between six months and two months ago I applied a date range filter that will show only those vaccines given after the 1/05/2021 (six months from the extract date) and the 'to' date needs to be two months from the date of your extract. In my case 1/09/2021 - six months is 1/05/2021.

Apply the filter by clicking on the recalculate icon on the top right of your screen: CAT GUIDES > Find high risk patients eligible for My Health For Life > 20210319_Pen_CS_clear_filters_recalculate_buttons.png

Report Steps

Click on the Immunisations/COVID-19/At Risk tab to see the COVID-19 at Risk report
Then click on the Dose 2 Astrazeneca, Dose 2 Pfizer and Dose 2 Unknown in the legend to select only those patients who had 2 vaccines already

CAT Recipes > Identify immunocompromised patients due for a third COVID-19 vaccine > image2021-11-24_10-8-4.png

Click on the 'Export' button to see the list of patients at risk with two vaccines given between six months and two months ago. This report doesn't just show immunocompromised patients, but until we publish a more specific report you can export the list into Excel by choosing the xlsx file option as shown below:

CAT Recipes > Identify immunocompromised patients due for a third COVID-19 vaccine > image2021-11-24_10-37-55.png

Then open the file in MS Excel. To filter the report you need to delete the top rows containing the headings so that you end up with a spreadsheet like this:

CAT Recipes > Identify immunocompromised patients due for a third COVID-19 vaccine > image2021-11-24_10-42-25.png

Highlight the 'Description' column and select 'Filter' from the Excel options:

CAT Recipes > Identify immunocompromised patients due for a third COVID-19 vaccine > image2021-11-24_10-43-32.png

Filter for all immunocompromised patients by typing 'immuno' and then clicking 'OK'

CAT Recipes > Identify immunocompromised patients due for a third COVID-19 vaccine > image2021-11-24_10-46-11.png

This will show you all patients with primary or acquired immunodeficiency who had two doses with the last one between 2 and 6 months ago.

The next CAT4 update will bring a report showing patients requiring a third shot, but to enable you to find those patients now this recipe will assist.