Contact Optimization system table mapping reference

To integrate Contact Optimization with Campaign, map all the Contact Optimization system tables to the Campaign tables.

You can exchange data between Contact Optimization and Campaign by mapping the Contact Optimization tables in Campaign. Map all the Contact Optimization system tables, contact history tables, and segment membership tables to the Campaign tables.

Use the following table to get information about the Contact Optimization system tables and the corresponding database tables:

Table 1. Contact Optimization system table mapping

A two-columned table lists the name of the Contact Optimization system tables in one column, and the database table name in the second column.
Contact Optimization System Table Database Table

Optimize Session Table

UACO_OptSession

Optimize Process Table

UACO_OptimizeProcess

Optimize Run History Table

UACO_SesnRunHist

Optimize Session Segment Table

UACO_SesnSegment

Optimize Offer Segment Table

UACO_OfferSeg

Optimize Session Offer Table

UACO_SesnOffer

Optimize Rule Table

UACO_Rule

Optimize Exception Rule Table

UACO_RException

Optimize Exception Rules Constraint Table

UACO_RExConstraint

Optimize Rules Constraint Table

UACO_RConstraint

Optimize Rule OfferList Table

UACO_ROfferList

Optimize Rule Offer Table

UACO_ROffer

Optimize Rule Segment Table

UACO_RSegment

Optimize Proposed Contact Base Table

UACO_PCTBase

Optimize Proposed Attribute Base Table

UACO_POABase

Optimize Optimized Contact Base Table

UACO_OCTBase