ContactAuth Email summary
The following table delineates the ContactAuth Email summary.
Table name: dbo.CONTACT_AUTH_EMAIL_SUMMARY
Column name | Column definition | Data type | Business rule |
|---|
business_unit_code
| The type is a classification of the entity. | NVARCHAR(50)
| Value of CONTACT_AUTH_EVENT.business_unit_code of the record. |
email_id
| Uniquely identifies the email address record. | BIGINT
| 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). | NVARCHAR(255)
| 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. | NVARCHAR(100)
| 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.
| NVARCHAR(10)
| 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. | DATETIME
| 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. | NVARCHAR(100)
| 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. | NVARCHAR(1)
| Value of CONTACT_AUTH_EVENT.double_verification_ind with the latest value in auth_datetime for that contact_level_value and business_unit_code. |
source_id
| API source_id of the feed containing the most recent authorization record. | INT
| The source_id from the API for the feed that supplied the most recent record for the email. |
sor_name
| API source name of the feed containing the most recent authorization record. | NVARCHAR(100)
| The source_id’s associated source name from the API for the feed that supplied the most recent record for the email. |
