Scope of the Migration
The Common View Customer Management System will merge three existing customer relationship management and marketing
systems. This Data Migration Specification describes the one time transfer of data from the Reservations, Gift Shop,
and Marketing databases to the Common View Customer Management System database.
This document defines, at a database level, the fields which will be migrated to the Common View Customer Management
System database to ensure all data is loaded correctly.
Data Profile
Source Data Systems
Reservations Database
Reference the Data Dictionary (DocID: KCR-135)
Gift Shop
Reference the Physical Data Model (DocID: KCGS-145) and Use Case Model (DocID: KCGS-75)
Marketing
Reference the Physical Data Model (DocID: KCM-145) and the Logical Data Model (DocID:KCM-125)
Data Attributes Profile and Dependencies
Reference output reports from WebSphere ProfileStage in the appendix of this document.
Data Mapping Table
Marketing
Target Table/ File
|
Target Column/Data Element
|
Data Type
|
Len
|
Target Column/Data Element Description
|
Source System
|
Source Table/ File
|
Source Column/Data Element
|
Data Transfer Rules
|
Customer
|
ID
|
Numeric
|
9
|
Primary identifier for customer
|
Marketing
|
Customer Reference Database
|
CUST_NO
|
Enforce uniqueness. Reject all customers with a customer number beginning with '55'.
|
Customer
|
NAME
|
Character
|
25
|
Format of name is a single character string, which can include businesses as well as individuals.
|
Marketing
|
Customer Reference Database
|
CUST_NAME
|
Use client formatting module(s) to validate format of customer name. Log all errors and reject record.
|
Customer
|
CREDIT_LIMIT
|
Numeric
|
7
|
This is an amount field in whole dollars.
|
Marketing
|
Customer Reference Database
|
CREDIT_AMT
|
Remove cents from source field. Move whole dollars only.
|
Customer
|
FIRST_CONTACT_DATE
|
Date
|
|
Date customer made first contact.
|
Marketing
|
Customer Reference Database
|
CONTACT
|
Date format in source is incorrect - need to make year four positions.
|
Customer
|
PURCH_NUMBER
|
Numeric
|
4
|
The total number of purchases customer has made since the first contact date.
|
Marketing
|
Customer History Database
|
See rules
|
Need to count all of the purchase records in the Customer History Database for each customer number and
place the total count in this target field.
|
Customer
|
PURCH_VALUE
|
Numeric
|
7
|
This is an amount field in whole dollars.
|
Marketing
|
Customer History Database
|
See rules
|
Need to aggregate the purchase amounts in all of the purchase records in the Customer History Database for
each customer number and place the total amount in this target field.
|
|