The following table delineates the ContactAuth SMS summary.
Table name: dbo.CONTACT_AUTH_SMS_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. |
phone_iso_2_country_code
| Standard 2-character country code for the phone. | PHONE.phone_iso_2_country_code where PHONE.phone_id = CONTACT_AUTH_EMAIL_SUMMARY.phone_id.
|
phone_id
| Uniquely identifies the phone record. | 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. | 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. |
