Account feed layout definition

This page provides the feed layout definition. In addition, this page provides a table that helps to associate what fields in the layout go to which tables in the Account data model.

Feed layout to data model table mapping

In most of the feed layouts definition pages, we just show the feed layout. In the case of account, the data in the feed layout goes to multiple base tables in the data model. This table illustrates the tables in the data model that the fields in the field layout end up in.

The feed layout table follows this table to provide context before the full feed layout is described.

Here’s the source spreadsheet of this table for reference: Account Feed Layout and Field to Table Mapping Reference Only.xlsx.

Account feed layout

The following table represents the feed layout definition.

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
System of Record Name	`sor_name`	(Required) Name of the system that is the authoritative data source for a record.	`char(100)`
Source Party Profile Id	`source_party_profile_id`	(Required) This field is the natural primary key (only for customer membership). Can be linked to the profile ID in Party Profile feed layout. Unique identifier generated by legacy program systems, enrollment forms, etc. to identify the creation of a customer (can be identifier generated by the system, email address, etc.). Uses `source_party_profile_id` + `business_unit_code` for lookup.	`char(320)`
Business Unit Code	`business_unit_code`	This field is the natural primary key. 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. This field is used in aggregate calculations. Values are defined as part of on-boarding, in `BUSINESS_UNIT_LOOKUP`; `NULL` values will default to `enterprise`. Refer to Business unit for details.	`char(50)`
Source Account Id	`source_customer_account_id`	(Required) This field is the natural primary key. Uniquely identifies customer account in the legacy system. This field is used in aggregate calculations.	`char(320)`
Account Description	`account_desc`	A short description of the account, like "eComm account", "Loyalty points membership", etc.	`char(100)`
Account Type Code	`account_type_code`	Any account types as defined in the reference data. Values are defined as part of on-boarding, in `ACCOUNT_TYPE_LOOKUP`. Refer to Account type for details.	`char(50)`
Enrollment Associate Id	`enrollment_associate_id`	An ID of associate that enrolled the main customer into account.	`char(20)`
Account Open Date	`account_open_date`	Account open date (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Account Close Date	`account_close_date`	Account close date (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Account Close Reason	`account_close_reason`	Text value indicating the reason for account closure (duplicate, expired, etc.).	`char(100)`
Enrollment Location Id	`enrollment_location_id`	Identifies the location (store or website) where enrollment took place.	`char(100)`
Main Profile Indicator	`main_profile_ind`	Indicates whether this is the main member that is associated with the loyalty account.	`char(1)`
Active Membership Indicator	`active_membership_ind`	Indicates whether the customer is an active member.	`char(1)`
Membership Start Date	`membership_start_date`	Membership start date (`YYYY-MM-DD`).	`date`
Membership End Date	`membership_end_date`	Membership end date (`YYYY-MM-DD`).	`date`
Loyalty System Id	`loyalty_system_id`	Identifies a system of record for loyalty account.	`char(50)`
Loyalty Account Tier Code	`loyalty_account_tier_code`	The tier that the loyalty account had attained. For example: Base=$0-$399.99; Plus=$400-$1199.99 and 2 visits; VIP=$1200+ and 2 visits. Values are defined as part of on-boarding, in `LOYALTY_ACCOUNT_TIER_LOOKUP`. Refer to Loyalty account tier for details.	`char(50)`
Loyalty Account Tier Join Date	`loyalty_account_tier_join_date`	Date when the account was assigned the current tier (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Balance Points Quantity	`balance_points_qty`	Current points balance (the total rewards earned minus total rewards redeemed).	`integer`
Previous Loyalty Account Tier Code	`previous_loyalty_account_tier_code`	Previous tier that loyalty account had attained. Values are defined as part of on-boarding, in `LOYALTY_ACCOUNT_TIER_LOOKUP`. Refer to Loyalty account tier for details.	`char(50)`
Next Loyalty Account Tier Code	`next_loyalty_account_tier_code`	Next tier that loyalty account would attain. Values are defined as part of on-boarding, in `LOYALTY_ACCOUNT_TIER_LOOKUP`. Refer to Loyalty account tier for details.	`char(50)`
Loyalty Program Id	`loyalty_program_id`	Uniquely identifies a customer loyalty program in the legacy system. A structured and long-term marketing effort which provides incentives to repeat customers who demonstrate loyal buying behavior.	`char(100)`
Loyalty Program Description	`loyalty_program_desc`	Description of the customer loyalty program.	`char(100)`
Loyalty Program Start Date	`loyalty_program_start_date`	Starting date of customer loyalty program (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Loyalty Program End Date	`loyalty_program_end_date`	Ending date of customer loyalty program (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Loyalty Program Status	`loyalty_program_status`	Current status of customer loyalty program (active).	`char(100)`
Source Record Create Datetime	`source_rec_create_datetime`	The datetime when the record was created at source system (`YYYY-MM-DD HH:mm:ss`).	`datetime`
Source Record Update Datetime	`source_rec_update_datetime`	The datetime of the latest update of the record at source system (`YYYY-MM-DD HH:mm:ss`).	`datetime`