ContactAuth Email summary

business_unit_code

The type is a classification of the entity.

Value of CONTACT_AUTH_EVENT.business_unit_code of the record.

email_id

Uniquely identifies the email address record. 

EMAIL.email_id where EMAIL.email_address = standardized value of  CONTACT_AUTH_EVENT.contact_level_value of the record with the latest value in auth_datetime and contact_level_value =EMAIL.

email_domain

An email domain is the web address that comes after the @ symbol in an email address that is identified by email_id (e.g., gmail.com).

Select email_domain from ir.EMAIL where EMAIL.email_id = CONTACT_AUTH_EMAIL_SUMMARY.email_id.

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.