Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.