Detailed reporting is accessible only to ImmsBC Admin users.
A variety of reports are available through the App Launcher by searching Reports from the Home Screen, or from the Reporting Dashboard.
Creating a list of my daily appointments or an end-of-day pharmacy report for PharmaNet entry
Summary report displaying appointments by Vaccine Type & MACS by service type
Customized Report: Detailed completed vaccinations reporting by Agent type
Reporting for vaccinations given in Long Term Care/Assisted Living (LTC/AL) facilities
Investigating PharmaNet payment discrepancies
Basic Pharmacy Reports
Pharmacy specific reports include:
- Daily Immunization PharmaNet
- Daily Clients by Appointment Status
- Daily Completed Immunizations
- Detailed Patient List (Today)
- External Transfer Line List
- Adjusted Inventory
- Inventory QoH(History)
- Inventory on Hand
- Inventory Transactions
- Discarded Inventory
See instruciton on how to locate these reports: Instructions on accessing reports in ImmsBC
Additional information is available through a recorded webinar: "ImmsBC Lunch and Learn: January 12, 2022 (Reporting)". Sign into BCPhA e-training to view.
Creating a list of my daily appointments or an end-of-day pharmacy report for PharmaNet entry
Pharmacy specific “Pharm - Detailed Patient List (Today)” and “Pharm - Daily Immunization PharmaNET” reports are available through the App Launcher by searching Reports from the Home Screen, or from the Reporting Dashboard. Click on “All Reports” and select the appropriate report. See “Reporting in ImmsBC” for more details.
Summary report displaying appointments by Vaccine Type & MACS by service type
Detailed reporting is accessible only to ImmsBC Admin users.
Name and link to report: Pharm - Vaccine Type & MAC Appts Summary
Description of report: This summary report reflects number of the different vaccine types and MAC subtypes.
This report is ideal to see what appointments booked and review inventory levels to ensure supply is available to meet the bookings. If you are booked up for one vaccine (e.g., no more COVID-19 vaccines, no more FluMist), be sure to remove the Vaccine Information options from your pharmacy profile.
Instructions
- Imms Admin users only: Use this link to go directly Pharm - Vaccine Type & MAC Appts Summary
- Click on the "filter" icon at the top to view filter options.
- Click on "Location name" and enter your ImmsBC location name.
- Set custom date range.
- View by immunization appointment types and add or remove MACS appointments in view.
- Turn off the "Subtotal" toggle at the bottom to reduce rows.
- Refer to the far right Total column to summarize number of COVID and influenza appointments.
Customized Report: Detailed completed vaccinations reporting by Agent type
Pharmacies can use the Pharm - Daily Immunization PharmaNET report: https://bcphsa.lightning.force.com/lightning/r/Report/00O5o000000X1ccEAC/view? queryScope=userFolders
Please follow these instructions:
- Click on the “Filter” button at the top
- Filter your data with “Location: Name” = “[insert your ImmsBC pharmacy name here]” or "[insert your group name]"
- Then select the date range (custom).
- Go to the column "Location: Name" and click on the arrow and choose "Group Rows by This Field"
- If you want sum totals, go to the column “Administered Agent” and click on the arrow and choose “Group Columns by This Field”.
- At the bottom of the screen you will see a toggle called “Detailed Rows”, turn that off.
- Refer to the "Count" field as the number of vaccinations provided (the Sum Dosage data is not relevent).
For summary data by location, set fields:
- In the table, click on the down arrow beside Location: Name choose “Group rows by this field”
- Scroll to the field “Administered Agent”, click on the down arrow, and choose “Group columns by this field”
- To count vaccinations, use the Count column and ignore the Sum Dosage columns.
To view the data by date, include these additional steps:
- The report will now split into two. With the bottom set of data, click on the dropdown arrow under the column Date/Time Administered and choose Group Rows by this Field
- Under the bottom set of data, turn off the Detail Rows toggle. This will now remove the bottom dataset.
- Now use the filter to determine the data range of data you are looking for.
- Export the file and be sure to export the file as Formatted Report.
- Download the report and delete the Sum Dosage data, as it is not relevant and you will only want to use the Count column.
See Monitoring Appointments for further details.
Reporting for vaccinations given in Long Term Care/Assisted Living (LTC/AL) facilities
For a summary report combining vaccination counts for a group of pharmacies:
Begin by going to Pharm – Daily Immunization PharmaNet. Two separate reports will have to be run, one for LTC/AL (documented into facility profile) and one for the various locations.
LTC/AL report
For a full report set the filters to:
- Location: Health Authority select “All” and then unselect "BC Pharmacy Association"
- Pharmacy Billing Location: Supply Location Name to contains [enter your pharmacy name] or [enter your Group Name]
- Appointment Date/Time select timeframe
- To count vaccinations, use the Count column and ignore the Sum Dosage columns.
For summary data by location and agent type, set fields:
- In the table, click on the down arrow beside Location: Name choose “Group rows by this field”
- Scroll to the field “Administered Agent”, click on the down arrow, and choose “Group columns by this field”
- To count vaccinations, use the Count column and ignore the Sum Dosage columns.
To view the data by date, include these additional steps:
- The report will now split into two. With the bottom set of data, click on the dropdown arrow under the column Date/Time Administered and choose Group Rows by this Field
- Under the bottom set of data, turn off the Detail Rows toggle. This will now remove the bottom dataset.
- Now use the filter to determine the data range of data you are looking for.
- Export the file and be sure to export the file as Formatted Report.
- Download the report and delete the Sum Dosage data, as it is not relevant and you will only want to use the Count column.
To view the data by date, include these additional steps:
- The report will now split into two. With the bottom set of data, click on the dropdown arrow under the column Date/Time Administered and choose Group Rows by this Field
- Under the bottom set of data, turn off the Detail Rows toggle. This will now remove the bottom dataset.
- Now use the filter to determine the data range of data you are looking for.
- Export the file and be sure to export the file as Formatted Report.
- Download the report and delete the Sum Dosage data, as it is not relevant and you will only want to use the Count column.
Investigating PharmaNet payment discrepancies
When using these reports be sure to open the ‘filter’ options and enter your clinic location name and the date range you want to investigate.
Report: All Complete Pharmacy Imms
This report will provide you with the total number of ImmsBC records you’ve entered during date range you are investigating.
Click Here (Imms Admin access only)
Report: Complete Pharmacy Imms with Success Claims
This report will provide you with the total number of ImmsBC records that have resulted in a successful PharmaNet claim during the date range you are investigating. Note that one of the columns called “Claim:Created date”, provides you with the date that the claim was submitted to PharmaNet, which can inform you whether a claim may have been delayed and submitted in the month following the actual ImmsBC entry date.
Click Here (Imms Admin access only)
Report: Complete Pharmacy Imms without Success Claim
This report will provide you with the total number of ImmsBC records that failed to generate a PharmaNet claim. The ImmsBC team will re-process these claims.
Click Here (Imms Admin access only)