Contact authorization feed layout sample

The following table provides sample values for the feed layout definition. In addition, you can use the attached sample file for testing and baseline configuration.

cfl_contact_auth_20240116.csv

Required fields are marked as (Required) in the field description column; fields not marked as required are optional.

Business name	Field name	Field description	Field data type/length	Sample value 1	Sample value 2
System of Record Name	`sor_name`	(Required) Name of the system that is the authoritative data source for a record.	`char(100)`	`ERP`	`ERP`
Authorization Date Time	`auth_datetime`	(Required) A date time when the preference was captured by the source system: `YYYY-MM-DD HH:mm:ss`	`datetime`	`2020-01-01 10:10:00`	`2020-06-01 10:10:00`
Business Unit Code	`business_unit_code`	Business Unit (BU) identifies the structure of brands within an organizational entity. When provided, permission or preference is applied only to that BU, otherwise it's enterprise-wide (in case of multi-BU clients). Values will be defined as part of on-boarding, in the BUSINESS_UNIT_LOOKUP section of Reference Data tab; NULL values will be defaulted to 'enterprise'.	`char(50)`	`enterprise`	`enterprise`
Contact Level Type Code	`contact_level_type_code`	(Required) Contact level type identifies a level the preference or permission is for: global level, email, phone, direct mail address, SMA, etc. Valid values are: `email` `direct_mail` `phone` `sms` `fax` `soc_media` `party_profile`	`char(50)`	`email`	`sms`
Contact Level Value	`contact_level_value`	(Required) The contact item that a permission or preference is being provided for: When contact level type is email: actual email address When contact level type is phone: phone number When contact level type is SMS: phone number Should be left `NULL` when contact level type is direct mail; use mailing address fields instead to support address formatting.	`char(320)`	`will_stuart_jones_redpoint@hotmail.com`	`19786789012`
Contact Level Additional Code	`contact_level_addtl_code`	Can be used for an ISO 3166 (alpha-2) 2-character country code when `contact_level_value` is a phone number, or the type of social media when `contact_level_value` is social media account, etc.	`char(50)`		`US`
Authorization Code	`auth_code`	(Required) Authorization values that indicate permission to contact (`opt_in` or `opt_out`) Valid values are: `opt_in` `opt_out`	`char(10)`	`opt_in`	`opt_in`
Authorization Value	`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.	`char(100)`	`Newsletter`	`Heart`
Authorization Frequency	`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.	`char(100)`	`Weekly`	`Daily`
Address 1	`address_1`	Address Line 1	`char(128)`
Address 2	`address_2`	Address Line 2	`char(128)`
Address 3	`address_3`	Address Line 3	`char(128)`
Address 4	`address_4`	Address Line 4	`char(128)`
City	`city`	City Name	`char(64)`
State Province	`state_province`	State Code	`char(64)`
Postal Code 1	`postal_code_1`	Postal Code 1	`char(16)`
Postal Code 2	`postal_code_2`	Postal Code 2	`char(16)`
Country Code	`country_code`	ISO 3166 (alpha-2) 2-character country code	`char(2)`
Double Verification Indicator	`double_verification_ind`	Indicates double opt-in. Double opt-in is a type of email subscription where a user should confirm his or her consent to be added to the mailing list twice. Valid value is `y`.	`char(1)`		`y`