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.
Field
Type
Length
Null?
Description
Starttime
DATETIME
false
The date and time in the format of yyyyMMddhhmmss that this event pattern state run began.
Endtime
DATETIME
true
The date and time in the format of yyyyMMddhhmmss that this event pattern state run was completed.
Status
INT32
false
Indicates the current status of the given ETL operation, with values matching one of the following:
0: Preparing
1: In Progress
2: Completed with failures
3: Completed Successfully
UACI_ETLPatternState
Holds pattern states instances for a given AudienceID.
Field
Type
Length
Null?
Description
PatternStateInstanceId
INT64
false
AudienceId
VARCHAR
128
false
AudienceLevel
VARCHAR
64
false
PatternId
INT64
false
State
INT32
false
The current state of the event pattern, from one of the following values:
1: pattern triggered
0: not triggered
-1: expired
-2: disabled
TotalCountScore
INT64
false
ExpectedCountScore
INT64
false
UpdateTime
INT64
false
ActivationTime
INT64
true
Copyright IBM Corporation 2014. All Rights Reserved.