Party profile 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

Source Party Profile Id

source_party_profile_id

(Required) Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of the profile (can be identifier generated by the system, email address, etc.).

char(320)

1000282652

Source System Pk 1

source_system_pk_1

Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of the consumer profile (can be identifier generated by the system, email address, etc.).

char(320)

Source System Pk 2

source_system_pk_2

Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of the consumer profile (can be identifier generated by the system, email address, etc.).

char(320)

Source System Pk 3

source_system_pk_3

Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of the consumer profile (can be identifier generated by the system, email address, etc.).

char(320)

Source System Pk 4

source_system_pk_4

Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of the consumer profile (can be identifier generated by the system, email address, etc.).

char(320)

Source System Pk 5

source_system_pk_5

Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of the consumer profile (can be identifier generated by the system, email address, etc.).

char(320)

Business Unit Code

business_unit_code

Business Unit identifies the structure of brands within an organizational entity. It is the way in which the brands within a company’s portfolio are related to, and differentiated from, one another. 

char(50)

enterprise

Source Record Create Datetime

source_rec_create_datetime

The datetime when the customer record was created at source system (YYYY-MM-DD HH:mm:ss). 

datetime

2021-01-10 09:00:00

Source Record Update Datetime

source_rec_update_datetime

The datetime of the latest update of the customer record at source system (YYYY-MM-DD HH:mm:ss).

datetime

Party Profile Type Code

party_profile_type_code

The type of the profile: patient, customer, prospect, etc.

char(50)

customer    

Party Profile Status Code

party_profile_status_code

Identifies a current status of the customer's account (active, not active, etc.). 

char(50)

active         

Source Main Location Id

source_main_location_id

Customer's main location assigned by the Client. Should be referenced in location ID in the location feed layout.

char(100)

17

Language Code

language_code

A standard language ISO 639-2 language code that customer indicated as a preferred communication language (eng).   

char(3)

eng

Employee Indicator

employee_ind

Indicates whether the customer is also an employee.

• y for yes

• n for no

char(1)

Employee Id

employee_id

Employee number.

char(20)

Prior Employee Indicator

prior_employee_ind

Indicates whether the customer was a former employee.

• y for yes

• n for no

char(1)

Employment Start Date

employment_start_date

Employment start date:

YYYY-MM-DD

date

Employment End Date

employment_end_date

Employment end date:

YYYY-MM-DD

date

Employer Name

employer_name

The name of an organization or company where person is employed.

char(250)

Web Registered Datetime

web_registered_datetime

Date and time when customer first registered on the website.

YYYY-MM-DD HH:mm:ss

datetime

Profile Origin Name

profile_origin_name

Name of the system that originally captured customer profile, for example: the system where the customer signed up through the email signup page, or the eComm system where the customer signed up for profile creation.  

char(250)

wow                    

Marital Status

marital_status

Party’s marital status.

char(50)

Single   

Deceased Indicator

deceased_ind

Indicates whether the party is deceased.

• y for yes

• n for no

char (1)

Business Name

business_name

Business name of the customer, for example, R & J Electrical. 

char(256)

Primary Record Indicator

primary_record_ind

The primary record indicator as a way for the client to indicate that this record is the primary if there are multiple records for the same source system primary key.

char(1)

Full Name

full_name

Customer's full name.

char(200)

Loyd Romine 

Prefix Name

prefix_name

The prefix portion of the name (Mr.).

char(32)

Title

title

Individual's title (Dr.).

char(30)

First Name

first_name

Individual's first name.

char(60)

Loyd                                                        

Middle Name

middle_name

Individual's middle name.

char(40)

Last Name

last_name

Individual's last name.

char(70)

Romine  

Suffix Name

suffix_name

The suffix portion of the name (Jr.)

char(15)

Birth Date

birth_date

Profile's date of birth.

YYYY-MM-DD

date

Gender Code

gender_code

Profile's gender:

• m for male

• f for female

• u for other

char(1)

m

Address Type Code 1

address_type_code_1

The type of address, such as billing, shipping, home, business, secondary mailing address, etc.

char(50)

billing      

Type 1 Address 1

address_1_1

Type 1 address line 1.

char(128)

7303 S Union Rd 

Type 1 Address 2

address_2_1

Type 1 address line 2.

char(128)

Type 1 Address 3

address_3_1

Type 1 address line 3.

char(128)

Type 1 Address 4

address_4_1

Type 1 address line 4.

char(128)

Type 1 Address 5

address_5_1

Type 1 address line 5.

char(128)

City 1

city_1

Type 1 city name.

char(64)

Stillwater

State Province 1

state_province_1

Type 1 state code.

char(64)

OK

Postal Code 1

postal_code_1

Type 1 postal code.

char(16)

74074

Country Code 1

country_code_1

Type 1 ISO 3166 (alpha-2) 2-character country code.

char(2)

US

Address Type Code 2

address_type_code_2

The type of address, such as billing, shipping, home, business, secondary mailing address, etc.

char(50)

Type 2 Address 1

address_1_2

Type 2 address line 1.

char(128)

Type 2 Address 2

address_2_2

Type 2 address line 2.

char(128)

Type 2 Address 3

address_3_2

Type 2 address line 3.

char(128)

Type 2 Address 4

address_4_2

Type 2 address line 4.

char(128)

Type 2 Address 5

address_5_2

Type 2 address line 5.

char(128)

City 2

city_2

Type 2 city name.

char(64)

State Province 2

state_province_2

Type 2 state code.

char(64)

Postal Code 2

postal_code_2

Type 2 postal code.

char(16)

Country Code 2

country_code_2

Type 2 ISO 3166 (alpha-2) 2-character country code.

char(2)

Home Phone Country Code

home_phone_country_code

ISO 3166 (alpha-2) 2-character country code of home phone.  

char(2)

US

Home Phone Number

home_phone_num

Customer's home phone number, including area code. 

char(32)

+1 405-377-5000

Mobile Phone Country Code

mobile_phone_country_code

ISO 3166 (alpha-2) 2-character country code of mobile phone.  

char(2)

US

Mobile Phone Number

mobile_phone_num

Customer's mobile phone number, including area code. 

char(32)

19786789012

Work Phone Country Code

work_phone_country_code

ISO 3166 (alpha-2) 2-character country code of work phone.  

char(2)

Work Phone Number

work_phone_num

Customer's work phone number, including area code. 

char(32)

Other Phone Country Code 1

other_phone_country_code_1

ISO 3166 (alpha-2) 2-character country code of other phone.  

char(2)

Other Phone Number 1

other_phone_num_1

Other phone number, including area code. 

char(32)

Other Phone Number Type Code 1

other_phone_num_type_code_1

The type of customer's other phone number. 

char(50)

Other Phone Country Code 2

other_phone_country_code_2

ISO 3166 (alpha-2) 2-character country code of other phone.  

char(2)

Other Phone Number 2

other_phone_num_2

Customer's other phone number, including area code. 

char(32)

Other Phone Number Type Code 2

other_phone_num_type_code_2

The type of customer's other phone number. 

char(50)

Personal Email Address

personal_email_address

Customer's personal email address.

char(320)

will_stuart_jones_redpoint@hotmail.com 

Personal Email Original Create Datetime

personal_email_original_create_datetime

The very first date when the email was captured by the client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW.

YYYY-MM-DD

date

Personal Email Original Create Source Code

personal_email_original_create_source_code

The source that captured this email for the first time. Can be client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW. 

char(100)

Work Email Address

work_email_address

Customer's work email address.

char(320)

Work Email Original Create Datetime

work_email_original_create_datetime

The very first date when the email was captured by the client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW.

YYYY-MM-DD

date

Work Email Original Create Source Code

work_email_original_create_source_code

The source that captured this email for the first time, can be client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW. 

char(100)

Other Email Address 1

other_email_address_1

Customer's other email address.

char(320)

Other Email Address Type Code 1

other_email_address_type_code_1

The type of customer's other email address. 

char(50)

Other Email Original Create Datetime 1

other_email_original_create_datetime_1

The very first date when the email was captured by the client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW.

YYYY-MM-DD

date

Other Email Original Create Source 1

other_email_original_create_source_code_1

The source that captured this email for the first time, can be client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW. 

char(100)

Other Email Address 2

other_email_address_2

Customer's other email address.

char(320)

Other Email Address Type Code 2

other_email_address_type_code_2

The type of customer's other email address. 

char(50)

Other Email Original Create Datetime 2

other_email_original_create_datetime_2

The very first date when the email was captured by the client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW.

YYYY-MM-DD

date

Other Email Original Create Source 2

other_email_original_create_source_code_2

The source that captured this email for the first time, can be client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW. 

char(100)

Other Email Address 3

other_email_address_3

Customer's other email address.

char(320)

Other Email Address Type Code 3

other_email_address_type_code_3

The type of customer's other email address. 

char(50)

Other Email Original Create Datetime 3

other_email_original_create_datetime_3

The very first date when the email was captured by the client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW.

YYYY-MM-DD

date

Other Email Original Create Source 3

other_email_original_create_source_code_3

The source that captured this email for the first time. Can be client's source system (CRM, POS, Loyalty enrollment, etc.) for ongoing feeds. For historical load, might be mapped from client's DW. 

char(100)

Social Login 1

social_login_1

Login used by social media.

char(320)

Social Platform 1

social_platform_1

Name of the social media that login value corresponds to, e.g., Instagram.  

char(100)

Social Login 2

social_login_2

Login used by social media.

char(320)

Social Platform 2

social_platform_2

Name of the social media that login value corresponds to, e.g., Instagram.  

char(100)

Social Login 3

social_login_3

Login used by social media.

char(320)

Social Platform 3

social_platform_3

Name of the social media that login value corresponds to, e.g., Instagram.  

char(100)

Social Login 4

social_login_4

Login used by social media.

char(320)

Social Platform 4

social_platform_4

Name of the social media that login value corresponds to, e.g., Instagram. 

char(100)

Social Login 5

social_login_5

Login used by social media.

char(320)

Social Platform 5

social_platform_5

Name of the social media that login value corresponds to, e.g., Instagram.  

char(100)

Custom Match Attribute 1

custom_match_attribute_1

User-defined custom match attribute.

char(256)

Custom Match Attribute Name 1

custom_match_attribute_name_1

The name of the custom match attribute.   

char(100)

Custom Match Attribute 2

custom_match_attribute_2

User-defined custom match attribute.

char(256)

Custom Match Attribute Name 2

custom_match_attribute_name_2

The name of the custom match attribute.   

char(100)

Custom Match Attribute 3

custom_match_attribute_3

User defined custom match attribute.

char(256)

Custom Match Attribute Name 3

custom_match_attribute_name_3

The name of the custom match attribute.   

char(100)

Custom Match Attribute 4

custom_match_attribute_4

User defined custom match attribute.

char(256)

Custom Match Attribute Name 4

custom_match_attribute_name_4

The name of the custom match attribute.   

char(100)

Custom Match Attribute 5

custom_match_attribute_5

User defined custom match attribute.

char(256)

Custom Match Attribute Name 5

custom_match_attribute_name_5

The name of the custom match attribute.  

char(100)