On execution of a production fulfillment activity, a row is inserted into the relevant audience definition’s [Offer History]_details table. This provides a summary of the activity’s execution, which can be queried for reporting purposes.
The table contains the following fields:
•ChannelExecutionID
•TriggerExecutionID
•OfferExecutionID
•FirstExecutionDate
•LastExecutionDate
•ExportFileName
•ChannelName
•DeliveryMethod
•ActivityName
•ActivitySubName
•InteractionName
•OfferName
•FulfillmentCode
•TargetCount
•SeedCount
•InteractionStateDate
•InteractionEndDate
•IsRolledBack
•RolledBackDate
•MessageListMasterID
•MessageListInstanceID
•MessageID
•MessageListName
•MessageName
If system configuration setting OfferHistoryDetailsSandboxEnabled is set to True, on the next execution of the Validate Audience Definitions job, Sandbox versions of all Offer History Details tables are created. Thereafter, on interaction workflow Test execution, data is written to the same. If the setting is subsequently set to False, there is no effect on the existing offer history details sandbox tables; however, on interaction workflow Test execution, data is no longer written to the same. Note that a change to the setting's value takes a few minutes to be picked up, as it is cached by the Execution Service.