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:

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.