ContactAuth Phone summary

The following table delineates the ContactAuth Phone summary.

Table name: dbo.CONTACT_AUTH_PHONE_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` = `PHONE`.
`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 phone.
`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 phone.