Data Field Mapping & Data Migrations


All portfolio accounting systems will have data fields that are populated in some fashion.  These data fields are account identifiers that help a firm query account data in order to satisfy business processes and requirements.  To ensure that your business processes do not become interrupted, some basic steps must be followed to ensure field data accuracy during your Data Migration:

  1. All data fields to be identified

  2. The method of population is determined

  3. Field entry data point variables to be cataloged

  4. Specific data entry responsible party is to be identified

  5. New system data field equivalent is to documented

  6. Mapping scheme to be created from legacy to new system

  7. New system data entry responsible party is to be identified

  8. Data to be pushed from legacy to new system

  9. Dual population to begin with parallel testing to ensue

  10. Legacy system inputs to cease population

The mapping scheme below is a sample of how your firm could begin its data mapping process.  This file provides some guidelines to follow to ensure your firm's data fields keep their integrity.

 

How can Performance Measurement Solutions help?