In With the Old and Out With the New

1
In With the Old and Out With the New

• (Data Migration and
• Review of New Data Elements)

2
Planning Activities

• TEAM
• The amount of data will affect your timelines and
  effort
• Most time spent is during mapping, scrubbing,
  and testing after the import

3
Mapping the Data

• Database design
• Literals, codes, table references

4
Cleanup the Source Data

• Scrub invalid data BEFORE importing
• Source system - integrity checks?
• Business rule changes and consistency
• Data dates string vs. datetime, single
  digit vs. multi-digit codes

5
Cleanup the Source Data

• Not required to get the data compliant
• Application unable to handle certain conversions
• Import time dependent on source integrity and
  consistency over the years
• Best approach before importing

6
Verify the Reference Tables

• Race, State, Country, County/City
• Ensures the mapping will be complete

7
Verify and Test the Import Routine

• Before running all the years
• Ensuring source data will match the import
  expectations

8
Prepare the Environment

• Setup appropriate indexes, rebuild clustered
  indexes, verify sequences.
• Consider breaking up the import to run from more
  than one platform
• Allows migrate in a reasonable timeframe

9
Coordinate Data Activity

• Consider stopping activity on source system for a
  set time
• Simplify issues on data synchronization

10
Verify Migrated Data

• Use online screens to validate data
• Ensure online edits and migrated data were
  synchronized

11
Test the Migrated Data

• After import, check for any inconsistencies
• Field level dumps for valid entries
• Compare back to source data

12
Recorded Live Births - Florida

• Mar-Dec 04 184,225
• (Jan-Dec 04 218,220)
  
• Jan-Apr 05 71,987

13
Home Births Planned?

• 2004
• Planned 688 (74.9)
• Unplanned 215 (23.4)
• Unk. 15 (1.6)
• 2005
• Planned 249 (71.6)
• Unplanned 96 (27.6)
• Unk. 3 (0.9)

14
Infant Transferred

• 2004
• Yes 2,100 (1.1)
• No 181,128 (98.3)
• Unk. 997 (0.5)
• 2005
• Yes 761 (1.1)
• No 71,185 (98.9)
• Unk. 41 (0.1)

15
Mother Transferred

• 2004
• Yes 712 (0.4)
• No 182,641 (99.1)
• Unk. 872 (0.5)
• 2005
• Yes 292 (0.4)
• No 71,674 (99.6)
• Unk. 21 (0.0)

16
Mother Received WIC

• 2004
• Yes 79,630 (43.2)
• No 101,469 (55.1)
• Unk. 3,131 (1.7)
• 2005
• Yes 30,686 (42.6)
• No 40,228 (55.9)
• Unk. 1,073 (1.5)

17
Infant Breastfed

• 2004
• Yes 138,949 (75.4)
• No 43,336 (23.5)
• Unk. 1,940 (1.1)
• 2005
• Yes 54,835 (76.2)
• No 16,555 (23.0)
• Unk. 597 (0.8)

18
Infant Living at Time of Report

• 2004
• Yes 183,621 (99.7)
• No 546 (0.3)
• Unk. 58 (0.0)
• 2005
• Yes 71,745 (99.7)
• No 212 (0.3)
• Unk. 30 (0.0)

19
Principal Source of Payment

• 2004
• Medicaid 79,941 (43.4)
• Private Ins. 84,508 (45.9)
• Self-Pay 14,040 (7.6)
• Other 4,343 (2.4)
• Unk. 1,393 (0.8)
• 2005
• Medicaid 31,412 (43.6)
• Private Ins. 32,150 (44.7)
• Self-Pay 6,364 (8.8)
• Other 1,806 (2.5)
• Unk. 255 (0.4)