Interact | profile | Audience Levels | [AudienceLevelName]

The name of your audience level.

The name of the table containing the score override information for this audience level. This property is applicable if you have set enableScoreOverrideLookup to true. You have to define this property for the audience levels for which you want to enable a score override table. If you have no score override table for this audience level, you can leave this property undefined, even if enableScoreOverrideLookup is set to true.

Unica Interact looks for this table in the customer tables accessed by Unica Interact runtime servers, defined by the prodUserDataSource properties.

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_ScoreOverride. If you enter a fully-qualified name, for example, mySchema.UACI_ScoreOverride, Unica Interact does not prepend the schema name.

UACI_ScoreOverride

The name of the table containing the offer suppression information for this audience level. You have to define this property for the audience levels for which you want to enable an offer suppression table. If you have no offer suppression table for this audience level, you can leave this property undefined. If enableOfferSuppressionLookup is set to true, this property must be set to a valid table.

Unica Interact looks for this table in the customer tables accessed by runtime servers, defined by the prodUserDataSource properties.

UACI_BlackList

The name of the staging table for the contact history data for this audience level.

This table is stored in the runtime environment tables (systemTablesDataSource).

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_CHStaging. If you enter a fully-qualified name, for example, mySchema.UACI_CHStaging, Unica Interact does not prepend the schema name.

If contact history logging is disabled, this property does not need to be set.

UACI_CHStaging

The name of the contact history offer attributes table for this audience level.

This table is stored in the runtime environment tables (systemTablesDataSource).

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_CHOfferAttrib. If you enter a fully-qualified name, for example, mySchema.UACI_CHOfferAttrib, Unica Interact does not prepend the schema name.

If contact history logging is disabled, this property does not need to be set.

UACI_CHOfferAttrib

The name of the response history staging table for this audience level.

This table is stored in the runtime environment tables (systemTablesDataSource).

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_RHStaging. If you enter a fully-qualified name, for example, mySchema.UACI_RHStaging, Unica Interact does not prepend the schema name.

If response history logging is disabled, this property does not need to be set.

UACI_RHStaging

The name of the table for this audience level required for cross-session response tracking in the contact and response history tables accessible for the response tracking feature.

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_XSessResponse. If you enter a fully-qualified name, for example, mySchema.UACI_XSessResponse, Unica Interact does not prepend the schema name.

If cross session response logging is disabled, this property does not need to be set.

UACI_XSessResponse

This is the name of the database table that is used for logging user-defined event activities. Users defined events on the Events tab of the Interactive Channel summary pages in the Unica Interact interface. The database table you specify here stores information such as the event ID, name, how many times this event occurred for this audience level since the last time the event activity cache was flushed, and so on.

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_UserEventActivity. If you enter a fully-qualified name, for example, mySchema.UACI_UserEventActivity, Unica Interact does not prepend the schema name.

UACI_UserEventActivity

This is the name of the database table that is used for logging event pattern states, such as whether the pattern condition has been met or not, whether the pattern is expired or disabled, and so on.

If you have defined the schema property for this data source, Unica Interact prepends this table name with the schema, for example, schema.UACI_EventPatternState. If you enter a fully-qualified name, for example, mySchema.UACI_EventPatternState, Unica Interact does not prepend the schema name.

CREATE TABLE UACI_EventPatternState_Composite
(
   UpdateTime bigint NOT NULL,
   State varbinary(4000),
   ComponentNum bigint NOT NULL,
   ComponentStr nvarchar(50) NOT NULL,
   CONSTRAINT PK_CustomerPatternState_Composite PRIMARY KEY 
   (ComponentNum,ComponentStr,UpdateTime)
)

UACI_EventPatternState