System schema reference

System schema reference

When you install the standalone event pattern ETL process, you must run the provided SQL script to create four tables in the target database (the data source identified as TargetDS in the IBM Marketing Platform configuration settings). The processed event pattern data is stored in these tables, and you can retrieve the information using the descriptions here for reporting purposes.

UACI_ETLPatternEventInfo

This table contains the most recent event information for each specified event pattern, such as whether the pattern is enabled, the start and end time, and so on.

Field	Type	Length	Null?	Description
PatternEventId	INT64		false	The ID of this event pattern.
Name	VARCHAR	64	false	The name of the event pattern. Can be any text characters, minus standard disallowed special name characters.
CategoryId	INT64		false	Unique ID of the category that contains the event. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
CategoryName	VARCHAR	64	false	Name of the category. Can be any text characters, minus standard disallowed special name characters.
ICId	INT64		false	The unique ID of the Interact Channel to which the event pattern belongs. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
ICName	VARCHAR	64	false	The name of the Interact Channel to which the event pattern belongs.
SourceDB	VARCHAR	128	true	The data source from which this event pattern was transferred by the ETL process. This is usually the Interact runtime data source as specified in the ETL configuration file.
Type	INT32		true	The type of event pattern
UpdateTime	INT64		false	The date and time in the format of yyyyMMddhhmmss that this event pattern record was last updated.
StartTime	INT64		true	The date and time in the format of yyyyMMddhhmmss at which this event pattern starts to be in effect.
EndTime	INT64		true	The date and time in the format of yyyyMMddhhmmss at which this event pattern stops being in effect.
resetDuration	INT64		true	The extended time span during which the pattern retains its true state before it resets and begins evaluating events again.
isEnabled	INT32		true	Boolean value indicating whether the event pattern is active or not.

UACI_ETLPatternStateItem

This table contains pattern state instance details.

Field	Type	Length	Null?	Description
PatternStateInstanceId	INT64		false	Unique ID of the event pattern state instance. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
EventId	INT64		false	Unique ID of the event. Must be a globally unique positive integer within the internalIDLowerLimit and internalIDUpperLimit configuration parameter values for generated values.
EventCount	INT32		false
EventWeight	INT64		true

UACI_ETLPatternStateRun

This table tracks the details of each ETL run.

The date and time in the format of yyyyMMddhhmmss that this event pattern state run began.

The date and time in the format of yyyyMMddhhmmss that this event pattern state run was completed.

Indicates the current status of the given ETL operation, with values matching one of the following:

2: Completed with failures

3: Completed Successfully

UACI_ETLPatternState

Holds pattern states instances for a given AudienceID.

PatternStateInstanceId

The current state of the event pattern, from one of the following values:

1: pattern triggered

0: not triggered

TotalCountScore

ExpectedCountScore

Copyright IBM Corporation 2014. All Rights Reserved.