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:
All data fields to be identified
The method of population is determined
Field entry data point variables to be cataloged
Specific data entry responsible party is to be identified
New system data field equivalent is to documented
Mapping scheme to be created from legacy to new system
New system data entry responsible party is to be identified
Data to be pushed from legacy to new system
Dual population to begin with parallel testing to ensue
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.