The following table delineates the ContactAuth SMS summary.
Table name: dbo.CONTACT_AUTH_SMS_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. |
phone_iso_2_country_code
| Standard 2-character country code for the phone. | NVARCHAR(2)
| PHONE.phone_iso_2_country_code where PHONE.phone_id = CONTACT_AUTH_EMAIL_SUMMARY.phone_id.
|
phone_id
| Uniquely identifies the phone record. | BIGINT
| PHONE.phone_id where PHONE.phone_num = standardized value of CONTACT_AUTH_EVENT.contact_level_value of the record with the latest value in auth_datetime and contact_level_value = SMS.
|
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 SMS. |
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 SMS. |
