Why Are There Duplicates? Why Are There Doses Missing?

Consolidation of data from 25 million patients into the new CAIR2 database did not go perfectly. We estimate about 1% of the records migrated were either pre-existing duplicates that failed to merge or new duplicates created during the migration process. A further complication is that incoming data exchange doses for any duplicated patients are held in a pending file and not added to the patient record until the duplicate records are merged into a single record. Since the number of duplicated records is significant, we have developed a database clean-up strategy that we hope will merge these duplicate records and import all missing pending doses into the merged records.

Cleanup Has Begun

The CAIR2 cleanup process has now begun and we are in the process of clearing the duplicates and pendings from CAIR2. Please report any duplicate patients along with their CAIR PatientIDs to the CAIR2 Help Desk at CAIRHelpDesk@cdph.ca.gov.