AudienceView Connect
AudienceView Documentation

Encrypted Columns

The following are the recommended fields to be encrypted:

Field Description
ts_blacklist.blacklist_account_number Blacklisted credit card numbers
ts_order_payment.orderpayment_account_number Credit card number
ts_payment_so.paymentso_account_number Credit card number
ts_customer_payment.customerpayment_account_number Customer default account number
Information
When you encrypt any data field, the audit table is automatically updated.

The following are fields that do not require encryption:

Field Description
._authorization_code Authorization code that is returned by the payment processor.
._secondary_authorization_code Authorization code that is returned by the payment processor.
Information
  • AudienceView does not store CVV values, PIN numbers, or any raw track information.
  • Audit tables are used to log changes to the main table and should also be encrypted in the same way as the main table.