Contents of the Outcome Table
As Actions trigger, outcome rows are inserted into the Outcome table. The Outcome table has the following columns:
Outcome Table Column
Description
Run ID
ID of the run. The Run ID helps distinguish between the outcome of one run versus the outcome of the run before or after it. Because of the Run ID, you do not need to truncate the outcome table after every run because you can associate the outcome with a specific run.
Entity ID
ID of the account, customer, household, site, etc., for which the trigger system fired.
Entity Type
Single character entity type code, such as “a”, “c”, “h”, “s”, etc.
Component ID
ID of the Action component that fired. (Also Rule ID.)
Outcome Message
XML format of the text message associated with the Action component. (Most information is in this column.) This is the message that was typed in the text box when the component was created, plus the XML representation of any of the fields that were selected for inclusion in the outcome on the Outcome table of the associated Action component. Dates in the outcome message are formatted according to the then it will be formatted according to the locale setting found in the Configuration Utility’s Advanced Configuration settings.
Outcome ID
A numerical, primary key field. The value is set by a trigger upon insert.
Firing Time
The date/time stamp at the time the final event occurred that caused the Action to fire
Copyright IBM Corporation 2012. All Rights Reserved.