Immunization Repository for a Large Healthcare Delivery System
Our client is one of the largest not-for-profit hospital and physician networks in the United States with over 15,000 providers and over 2 million patients under care.
Our client is engaged in development of an enterprise-wide registry of immunization records for all patients under care within 11 hospitals and affiliated outpatient clinics in order to comply with the government guidelines and improve continuity of care. Additionally, the organization is in the middle of multi-year implementation and rollout process of Epic EMR medical system across the entire delivery system and is intended to import real-time and legacy immunization data into EPIC.
Challenge
Hospitals and outpatient clinics in the clients’ network are running on multiple vendor and in-house EMR and ambulatory systems which are being used to store and manage immunization data. In total the entire network has accumulated more than 40 mil legacy immunization records over a number of years. The data is “dirty” – has significant structural and content variances even within the same system.
It is critical to preserve historical sequence of data across all systems. Due to historical inconsistencies in data representation and ongoing edits of current and past records by clinicians importing legacy and current immunization records concurrently presents a significant challenge. The organization decides to impose a temporary ban on edits of the current records until legacy data import is complete. This decision imposes strict constrains on the timeline for importing extensive amount of legacy data.
Solution
A joint team of First Line and client engineers, medical informaticians, analysts and hospital IT staff has worked together over a period of two years to design a sophisticated process and infrastructure to populate the immunization repository with historical and real-time data and export this data to Epic and government agencies. We have developed 13 interfaces from the client systems and outbound interfaces to Epic and state vaccination registry. The interfaces used a variety of protocols including HL7, Web Services, flat file ingestion and proprietary APIs. We have also implemented complex data transformations that accounted for specifics of individual systems and variances in structure and content of data.
In order to provide high throughput for legacy data import our engineers designed high performance parallel integration infrastruture with a routing logic to guarantee preservation of historical sequence of records.
Business User Interface
Our team has developed a User Interface layer on top of the integration infrastructure specifically designed for clinical analysts to perform data validation, monitoring and debugging of the workflow.
Outcome
Using our troubleshooting and monitoring tools the analytical team on the project has been able to identify patterns and problems in the data during dry run imports of the data in the test environment. Based on this analysis we refined and improved data transformation scripts to achieve the desired level of fault tolerance and scalability in the interfaces.
The integration pipeline designed and developed by the team has imported and processed 40 million immunization records into the immunization repository at a rate of 200 records per second with no loss of data, interface breakdowns or reaching server capacity limits. The outbound interfaces have imported all records to EPIC and sent them to the state registry. The pipeline is now continuously processing real time records from all organizations participating in the immunization repository.
Technologies
- InterSystems Cache, Ensemble, Objectscript, .NET, C#, MVC, Javascript, Ajax libraries
Download Case Study: Healthcare Immunization Repository Software
Download Case Study
related projects

Creating a website for a manufacturer of bathroom accessories
A client, their challenge, and our solution…
Show details
Pass to Work Application
Today’s COVID 19 pandemic has disrupted business processes and made it necessary to introduce new epidemiological safety requirements in any workplace. If you are an employer and need to make sure on a daily that your employees are healthy and not potential carriers of COVID-19, then here is a visitor management solution to implement this new process quickly.
Show details
“Pass to Visit” - Application for Permission to Access a Site
First Line Software developed a new visitor pass software, “Pass to Visit”, that screens visitors for Covid-19 symptoms. The application can easily be modified to ask visitors additional questions such as, “have you had any Covid-19 exposure prior to this visit?”
Show detailsContact Us
USA
Cambridge MA
1 Broadway,
14th Floor,
Cambridge MA 02142
USA
San Mateo CA
400 Concar Dr,
San Mateo California
94403
Netherlands
The Hague
Louis Couperusplein 2,
4th floor 2514HP,
The Hague
Australia
Sydney | Brisbane
12 Creek Street,
Brisbane QLD 4000
United Kingdom
Gloucestershire
Cowley House,
12 Black Jack Street Cirencester
Gloucestershire, GL7 2AA
Czech Republic
Praha
Na Hřebenech
II 1718/8,
140 00 Praha 4
Czech Republic
Brno
Centrum, Šumavská,
Šumavská 416/15,
602 00 Brno

Send us a note
We'll do our best to answer within one hour