ContactAuth Address summary

The following table delineates the ContactAuth Address summary.

Table name: dbo.CONTACT_AUTH_ADDRESS_SUMMARY

Column name	Column definition	Business rule
`business_unit_code`	The type is a classification of the entity.	Value of `CONTACT_AUTH_EVENT.business_unit_code` of the record.
`address_id`	Uniquely identified mailing address.	`ADDRESS.address_id` where it is = `CONTACT_AUTH_EVENT.contact_level_value` of the record with the latest value in `auth_datetime` and `contact_level_value` = `DIRECT MAIL`.
`auth_value`	The value of permission or preference code, for example: Newsletter/Catalog/Specials, or any other value for preference types, like preferred contact language.	Value of `CONTACT_AUTH_EVENT.auth_value` with the latest value in `auth_datetime` for that `contact_level_value` and `business_unit_code`.
`auth_code`	Always populated; value is either `OPT_IN` or `OPT_OUT`.	Value of `CONTACT_AUTH_EVENT.auth_code` with the latest value in `auth_datetime` for that `contact_level_value` and `business_unit_code`.
`auth_datetime`	Date time when opt-out transaction was captured by original system.	Value of `CONTACT_AUTH_EVENT.auth_datetime` with the latest value in `auth_datetime` for that `contact_level_value` and `business_unit_code`.
`auth_frequency`	When specifically noted, the frequency at which contact is authorized through a channel defined in this record contact level type code and value.	Value of `CONTACT_AUTH_EVENT.auth_frequency` with the latest value in `auth_datetime` for that `contact_level_value` and `business_unit_code`.
`double_verification_ind`	Indicates double opt-in. Double opt-in is a type of verification where a user should confirm his or her wish to be added to the mailing list twice.	Value of `CONTACT_AUTH_EVENT.double_verification_ind` with the latest value in `auth_datetime` for that `contact_level_value` and `business_unit_code`.