Default Customer audience level system tables
Campaign
is delivered with system table ddl scripts to create the tables that support the default
Customer
audience level. After installing
Campaign
, you must map these system tables to tables in the
Campaign
system database as follows:
Default audience level system tables
Unica
®
system table
Database Table Name
Customer Contact History
UA_ContactHistory
Customer Response History
UA_ResponseHistory
Customer Detailed Contact History Table
UA_DtlContactHist
Customer Segment Membership
UA_SegMembership
If these tables are mapped as listed above, then the sample reports provided with
Campaign
will work with a minimum number of changes.
The SQL statements used to create these tables and their related indices can be used as templates to create tables for other audience levels.
Copyright IBM Corporation 2013. All Rights Reserved.