KEYWORDS:
Michigan Childhood Immunization Registry (MCIR), Southeastern Michigan Childhood Immunization Registry(SEMCIR), Primary Care Physicians (PCP), relational-database
BACKGROUND:
MCIR is an electronic immunization information system, which provides a comprehensive multi-clinic immunization records with history and assessment to PCPs and parents for children up through 19 years. SEMCIR developed physician database to help outreach teams monitoring PCP activities associated with MCIR. Over 6000 primary physicians, 65 major hospitals and thousands of clinics information are stored in database. However as data quantity increases, more redundancy data and more complex relationships among physicians, clinic and MCIR were produced concurrently. There are about 15% of the physician and 45% of the clinic information are redundancy data, which largely affect record accuracy.
OBJECTIVE:
1. To eliminate redundancy data and present the complicated relationships more precisely and efficiently by creating relational schema.
2.To help our outreach team improve tracking accuracy.
3.To help track provider enrollment, training, web access and utilization of MCIR.
METHOD:
The over 30 data fields were divided into three groups: physician individual information, clinic/hospital information and their relationships with MCIR. SQL and VB programming were used to populate data based on existing information. Future data will be updated by SEMCIR staff daily based on outreach team activities.
RESULT:
6179 records with both physicians and clinics were reduced to 5503 physicians and 3636 clinics records, with the data-redundancy reduced 11% and 41% accordingly. A user-friendly interface is created to better present their relationships.
CONCLUSION:
the renovated physician database dramatically reduced redundancy data and provides more precise information for improved MCIR outreach and management.
LEARNING OBJECTIVES:
1.To describe the use of a provider database.
2.To describe the renovation on physician database to accommodate the expansion on both data quantity and complexity for a multi-county registry in a dynamic healthcare environment.
3.To understand the functions of a database as a physician /client management tool.
4.To describe the maintenance of the database, time saving and assistance to MCIR staff.
Back to Winning the Match Game: Improving Deduplication Processes
Back to The 2003 Immunization Registry Conference (October 27-29, 2003)