Automating Vaccine Data Entry into State Databases
- Expedite the vaccine data collection and integration into Michigan’s immunization registry
Challenge
To vaccinate Detroit’s population, the City took over a portion of the TCF downtown convention center and was instantly inundated with thousands of citizens seeking doses of the Moderna and Pfizer vaccines. While nursing teams were able to keep up with the patient volume, the vaccinations required meticulous documentation in both the Michigan Care Improvement Registry (MCIR), a Michigan state system for tracking vaccine administration and dose inventory, as well as Detroit’s own vaccination monitoring system. These duplicated efforts and overall data entry workload required that the City bring on dozens of National Guard members to assist, and the manual nature of the data entry tasks resulted in a high error rate, causing inventory and tracking logjams downstream.
Solution
By automatically ingesting data from the City’s patient appointment scheduling tool, and prepopulating that data in a dashboard that connected directly to MCIR, People.Health created a tool that minimized manual data entry. The system had the additional ability to flag “problem” patients – those who were scheduled to receive doses from two different vaccine manufacturers, or scheduled to receive more than two doses – so that on-site staff could intervene and prevent potentially dangerous situations from occurring. People.Health aggregated all of the data collected during the appointment scheduling and vaccination processes (age, race, ethnicity, disability status, dose number, etc.) to create an insights dashboard giving City leadership a high-level view of the patient population’s vaccination status.
Results
People.Health’s solution both streamlined the vaccination data entry process and eliminated the errors caused by manual data entry, enabling the City to reduce its reliance on the National Guard and other temporary staff extensions.
