Location 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.

clf_Location_20240109.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 Open Store	Sample Value Closed Store
System of Record Name	`sor_name`	(Required) Name of the system that is the authoritative data source for a record.	`char(100)`	`ERP`	`ERP`
Source Location ID	`source_location_id`	(Required) This field is the natural primary key. Uniquely identifies a Location in the source system (location can be a store or website). This field is used in aggregate calculations.	`char(100)`	`17`	`18`
Business Unit Code	`business_unit_code`	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. 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)`	`enterprise`	`enterprise`
Location Name	`location_name`	Location name.	`char(300)`	`LOWER FALLS MA`	`UPPER FALLS MA`
Location Type Code	`location_type_code`	(Required) Defines the type of location. Examples below (could have more types): B&M (brick and mortar store) WEB (website) Warehouse Headquarters This field is used in aggregate calculations. Values are defined as part of on-boarding, in `LOCATION_TYPE_LOOKUP`. Refer to Location type for details.	`char(50)`	`b&m`	`b&m`
Location Status Code	`location_status_code`	(Required) closed, open, opening soon. This field is used in aggregate calculations. Values are defined as part of on-boarding, in `LOCATION_STATUS_LOOKUP`. Refer to Location status for details.	`char(50)`	`open`	`closed`
Division Code	`division_code`	A code that identifies business subdivisions.	`char(50)`	`USA`	`USA`
Division Description	`division_desc`	Description of the division code.	`char(100)`	`United States of America`	`United States of America`
Region Code	`region_code`	A code that identifies the principal subdivisions (e.g., provinces or states) of all countries.	`char(50)`	`EST`	`CEN`
Region Name	`region_name`	Region name.	`char(60)`	`Eastern District`	`Central District`
District Code	`district_code`	A code that identifies the districts.	`char(50)`	`S06`	`S06`
District Name	`district_name`	District name.	`char(60)`	`Team 1 (John)`	`Team 1 (John)`
Employee Quantity	`employee_qty`	The number of employees at the location.	`integer`	`10`	`3`
Vanity Name	`vanity_name`	Name of the center that the location is part of (Ridge Plaza, City Center, etc.).	`char(300)`
Geography Code	`geography_code`	A code that identifies country subdivisions and places.	`char(50)`
Geography Name	`geography_name`	The name of the geography code that identifies country subdivisions and places.	`char(60)`
Main Page Address	`main_page_address`	Main web page address of a web store. Example: `amazon.com`, `lowes.com`, etc.	`char(255)`	`https://www.xyz.com/lower-falls-ma`	`https://www.xyz.com/upper-falls-ma`
Manager Name	`manager_name`	The name of location's manager.	`char(200)`
Manager Email Address	`manager_email_address`	The email address of location's manager.	`char(320)`	`managerJohn@xyz.com`	`managerDave@xyz.com`
Location Email Address	`location_email_address`	Location's email address.	`char(320)`
Address 1	`address_1`	Location's address line 1.	`char(128)`	`200 Avenue A`	`351 Mohawk Trl`
Address 2	`address_2`	Location's address line 2.	`char(128)`
Address 3	`address_3`	Location's address line 3.	`char(128)`
Address 4	`address_4`	Location's address line 4.	`char(128)`
City	`city`	City.	`char(64)`	`Lower Falls`	`Upper Falls`
State Province	`state_province`	Location's state code.	`char(64)`	`MA`	`MA`
Postal Code 1	`postal_code_1`	Location's postal code.	`char(16)`	`02841`	`02841`
Country Code	`country_code`	ISO 3166 (alpha-2) 2-character country code.	`char(2)`	`US`	`US`
Phone Country Code	`phone_country_code`	ISO 3166 (alpha-2) 2-character country code for location's phone number.	`char(2)`
Phone Number	`phone_num`	Location's phone number.	`char(32)`	`978-123-4567`	`781-123-4567`
Open Date	`open_date`	Store Open Date: `YYYY-MM-DD`. This field is used in aggregate calculations.	`date`	`2001-03-12`	`2000-08-13`
Close Date	`close_date`	Store Close Date: `YYYY-MM-DD`. This field is used in aggregate calculations.	`date`		`2020-05-12`
Location Cluster Indicator	`location_cluster_ind`	Indicates if there are multiple sub-locations within location (for example, in a retail store: men's, women's, kids; in a health-care facility: pharmacy, lab, urgent care, etc.). Valid values: `y` /`n` / `null`.	`char(1)`
Currency Code	`currency_code`	Location's primary currency code (`EUR` - E.U. Euro , `GBP` - British pound, `USD` - U.S. Dollar). Values listed in `CURRENCY_LOOKUP`.	`char(3)`	`usd`	`usd`
Display Url	`display_url`	Display URL is the URL of each store to display in emails.	`char(4000)`
Visit Us Line Text	`visit_us_line_text`	PFS visit us is a line of copy included in emails for each store.	`char(300)`
Latitude	`latitude`	Latitude. This field is used in aggregate calculations.	`decimal(10,7)`
Longitude	`longitude`	Longitude. This field is used in aggregate calculations.	`decimal(10,7)`
Sunday Open Time	`sun_open_time`	Time when the store opens on Sunday in 24-hour clock format `24HH:mm` (`10:00`).	`char(20)`	`08:00`	`08:00`
Sunday Close Time	`sun_close_time`	Time when the store closes on Sunday in 24-hour clock format `24HH:mm` (`18:00`).	`char(20)`	`17:00`	`17:00`
Monday Open Time	`mon_open_time`	Time when the store opens on Monday in 24-hour clock format `24HH:mm` (`09:00`).	`char(20)`	`08:00`	`07:30`
Monday Close Time	`mon_close_time`	Time when the store closes on Monday in 24-hour clock format `24HH:mm` (`20:00`).	`char(20)`	`18:00`	`18:00`
Tuesday Open Time	`tue_open_time`	Time when the store opens on Tuesday in 24-hour clock format `24HH:mm` (`09:00`).	`char(20)`	`08:00`	`07:30`
Tuesday Close Time	`tue_close_time`	Time when the store closes on Tuesday in 24-hour clock format `24HH:mm` (`20:00`).	`char(20)`	`18:00`	`18:00`
Wednesday Open Time	`wed_open_time`	Time when the store opens on Wednesday in 24-hour clock format `24HH:mm` (`09:00`).	`char(20)`	`08:00`	`07:30`
Wednesday Close Time	`wed_close_time`	Time when the store closes on Wednesday in 24-hour clock format `24HH:mm` (`20:00`).	`char(20)`	`18:00`	`18:00`
Thursday Open Time	`thu_open_time`	Time when the store opens on Thursday in 24-hour clock format `24HH:mm` (`09:00`).	`char(20)`	`08:00`	`07:30`
Thursday Close Time	`thu_close_time`	Time when the store closes on Thursday in 24-hour clock format `24HH:mm` (`20:00`).	`char(20)`	`18:00`	`18:00`
Friday Open Time	`fri_open_time`	Time when the store opens on Friday in 24-hour clock format `24HH:mm` (`09:00`).	`char(20)`	`08:00`	`07:30`
Friday Close Time	`fri_close_time`	Time when the store closes on Friday in 24-hour clock format `24HH:mm` (`20:00`).	`char(20)`	`18:00`	`18:00`
Saturday Open Time	`sat_open_time`	Time when the store opens on Saturday in 24-hour clock format `24HH:mm` (`10:00`).	`char(20)`	`08:00`	`07:30`
Saturday Close Time	`sat_close_time`	Time when the store closes on Saturday in 24-hour clock format `24HH:mm` (`20:00`).	`char(20)`	`18:00`	`18:00`