Contact authorization feed layout sample

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 2 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 2 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