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.  The likely cleanup schedule is posted below and is listed by Sending Facility CAIR ID.  The Sending Facility is the entity that is submitting your Site’s electronic data to CAIR2.  Check with your EHR vendor to determine which Sending Facility your Site is using.  

Cleanup Schedule

Status SENDING FACILITY IDSENDING FACILITY NAME
CompletedDE-001134UCSF
CompletedSF-000013SUTTER HEALTH
CompletedKPSCAKAISER PERMANENTE SCAL
CompletedSF-002634CERNER CORPORATION (PRODUCTION)
CompletedSF-000020MEMORIALCARE
CompletedSF-000007ALLSCRIPTS
CompletedSF-000233JMPN-JOHN MUIR PHYSICIAN NETWORK
CompletedCHCMAINCOMMUNITY HEALTH CENTERS-MAIN VACCINE CLINIC
Completed43SCVMCBASCVHC-SCVMC
CompletedKPNCAKAISER PERMANENTE NCAL
CompletedSF-003836STC
CompletedSF-000019OCHIN
CompletedSF-000004LOMA LINDA UNIVERSITY HEALTH-SF-DX
CompletedSF-001529Office Ally
CompletedDE-003406STANFORD CHILDREN’S HEALTH
CompletedSF-003341STANFORD HOSPITAL AND CLINICS
CompletedSF-000028ALTAMED HEALTH SERVICES CORP.
CompletedSF-000091PROVIDENCE HEALTH AND SERVICES
CompletedDE-002649COMMUNITY REGIONAL MEDICAL CENTER
CompletedSF-000011ATHENAHEALTH
CompletedSF-000154ECLINICALWORKS (PROD)
MarchSF-000316CEDARS SINAI
MarchDE-001152SALINAS VALLEY MEMORIAL HEALTHCARE SYSTEM-DX
AprilSF-003267Greenway Health
AprilSF-001184IEHIE
April42SCPUEBLOSANSUM CLINIC PUEBLO MULTI-SPECIALTY
AprilKPSCAKAISER PERMANENTE SCAL
AprilUCLA-HSUCLA HEALTH SYSTEM
AprilUHCE54-UNITED HEALTH CENTERS – EARLIMART
April43GARDNERHCGARDNER HEALTH CENTER
April27CSVSCVCSVS CASTROVILLE
AprilKCMGI-PEDS2KIDS-CARE MEDICAL GROUP
AprilSF-002716Office Practicum
AprilSF-004273TIBURCIO VASQUEZ HEALTH CENTERS
April21MARINCCMARIN COMMUNITY CLINIC- SF
AprilPPO-MMMDMELISSA MANALO
AprilPLCHAPADECHAPA-DE INDIAN HEALTH PROGRAM
AprilSF-003888E-MDS
April10CMCKINGSCHILDRENS MEDICAL CENTERS OF FRESNO
AprilDE-000029UC IRVINE HEALTH
AprilSF-001437PRACTICE FUSION
AprilSF-004440UCSF CHILDREN’S HOSPITAL OAKLAND
AprilMCCN-NHMISSION CITY COMMUNITY NETWORK – NORTH HILLS
MaySF-000390CLINICAS DEL CAMINO REAL INC
MayNEVHC-SF-HCNEVHC-SAN FERNANDO HEALTH CENTER
MaySF-004178MONARCH HEALTHCARE-SF-004178
May45SCHCPEDSHASTA COMMUNITY HEALTH – PEDIATRICS
MaySAWALTON1WALTON PEDIATRICS
MayDE-000621KECK HOSPITAL OF USC
MayVFC-ROSEVENICE FAMILY CLINIC
MaySF-005026SCHOOL HEALTH CLINICS OF SANTA CLARA COUNTY
MaySF-002586DIGNITY HEALTH
MaySF-004046HealthFusion
MaySF-004439Physician’s Computer Company
MaySF-004275RAVENBELL CLINICS
MayTCHCI54-TULARE COMMUNITY HEALTH CLINIC
May10SANGRUJIVESANG MEDICAL CORP.
May01LLMCLIFELONG MEDICAL NEXTGEN SF
MaySF-000108STANLEY H. SCHWARTZ MD INC. MORENO VALLEY
MaySF-005052CMC VACAVILLE Hub
MayDE-003849JWCH INSTITUTE
MayDE-001438WASHINGTON HOSPITAL HEALTHCARE SYSTEM
MaySF-003204HEALTH CARE PARTNERS – PACIS
May49SONVLYCHCSONOMA VALLEY COMMUNITY HEALTH CENTER
MaySF-008167Costco
MayDE-00772115-KERN COUNTY HEALTH DEPT DX
May38NEMSNORTH EAST MEDICAL SERVICES – SAN FRANCISCO
May38MISSIONHCMISSION NEIGHBORHOOD HEALTH CENTER
MaySF-007858Script Management Partners (SMP)
MaySF-002498Shasta Networks
MayGOULDRRICHARD A. GOULD MD
MayDE-001795BEAVER MEDICAL GROUP REDLANDS MAIN
MaySF-000162HILL PHYSICIANS MEDICAL GROUP
May36PVHC-CRPOMONA VALLEY HEALTH CENTER – CROSSROADS
MaySF-004476PEACH TREE HEALTHCARE
MaySF-000027SANTA CRUZ HEALTH INFORMATION EXCHANGE
MaySF-007751CONTRA COSTA HEALTH SERVICES DX
MaySF-001728ELATIONEMR
MaySF-000051Clinicas de Salud del Pueblo
MaySF-007726Hill Physicians Medical Group (EPIC)

Please continue to report duplicated records to the CAIR2 Help Desk (CAIRHelpDesk@cdph.ca.gov) using the Duplicate Record Correction form. Also, continue to report to the CAIR Help Desk any missing doses in patients who are not duplicates.

‘Merge Patients’ Screen

The CAIR2 interface does have a ‘merge patients’ screen (see below) that is currently accessible only to CAIR2 staff due to needed upgrades to the interface. In the future, CAIR2 may allow clinic users to use this interface to merge duplicate patients as they encounter them. merge patients screen