RPI allows you to audit the usage of data warehouse tables and columns when running audiences in production interaction workflows. Such auditing is controlled by system configuration setting AuditAudienceFieldUsage. Table and column auditing is switched on when this setting is set to 1, and off when set to 0. When auditing table and column usage, the following audit tables are populated:
•DataflowAuditSummary: one row is created per audience segment. For each segment, the following are captured:
o OutputID
o DataflowInstanceID
o OutputName
o WorkflowAssociationInstanceID
o OutputCount
o ExecutionDate
o ResolutionTable
o ResolutionKey
•DataflowAuditFields: multiple rows are created per DataflowAuditSummary record. For each field, the following are captured:
o ID
o OutputID
o TableName
o ColumnName
o Operator
o Values
o DataflowInstanceID
•DataflowAuditExecutionLookup: if the audience is used in e.g. an email offer or in data extract file generation, a record in this table is used to link to the ChannelExecutionID, which can be used to link to the Channel Execution table in the client’s Interaction operational database and the Offer History tables in the data warehouse. The following are captured:
o OutputID
o ChannelExecutionID
o DataflowInstanceID