The Store Dimensions feed provides attribute information for the given store number, including information such as location, manager details, and related codes. This data feed is the latest snapshot and contains only the attributes related to the store as of the current Date.

Endpoints

GET

/bulkfeeds/snapshot/storedimensions

Feed Details

The following table provides the Store Dimensions details.

Specification	Details
Feed Type	Dimension
Feed Availability	Supplier only
Refresh Frequency	Daily
Data Grain	Store Number
Incremental Data	Snapshot
File Format	orc, parquet, csv
Target Refresh Time	Monday - Friday: 3:00 PM CST Saturday and Sunday: 11:30 PM CST
History	NA

Feed Structure

The following table provides the Store Dimensions structure.

Sequence	Business Name	Technical Name	Data Type	Primary Key	Sensitive Metrics	DSS Mapping
1	Store Number	store_nbr	Integer	Y	-	Store Nbr
2	Store Name	store_nm	String	-	-	Store Name
3	Geographic Region Code	geo_region_cd	String	-	-	-
4	Manager Name	store_mgr_nm	String	-	-	Manager Last Name
5	Phone Number	ph_nbr	String	-	-	Phone Nbr
6	Store Type Description	store_type_desc	String	-	-	Store Type Descr
7	Operational Company Code	op_cmpny_cd	String	-	-	-
8	Financial Open Date	fin_open_dt	Date	-	-	Open Date
9	Business Gross Size Quantity	bu_gross_size_qty	Integer	-	-	-
10	Expand Size Quantity	expnd_size_qty	Integer	-	-	Expansion Size SQFT
11	Open Sunday Indicator	open_sun_ind	Integer	-	-	Open Sunday Flag
12	Business Company Code	bu_comp_cd	String	-	-	-
13	Business Company Description	bu_comp_desc	String	-	-	-
14	Financial Report Code	fin_rpt_cd	String	-	-	Financial Rpt Code
15	Merchandise Major Zone Number	mdse_maj_zone_nbr	Integer	-	-	MDSE Major Zone
16	Merchandise Sub Zone Number	mdse_sub_zone_nbr	Integer	-	-	MDSE Sub Zone
17	Subdivision Number	subdivision_nbr	String	-	-	-
18	Subdivision Name	subdivision_nm	String	-	-	Subdiv
19	Market Number	market_nbr	Integer	-	-	-
20	Market Name	market_nm	String	-	-	District
21	Relocation Flip Date	relo_flip_dt	Date	-	-	Expansion Open Date
22	Daylight Saving Timezone Indicator	daylight_sav_tz_ind	Integer	-	-	Timezone Daylight Savings
23	State Province Code	state_prov_cd	String	-	-	Whse State
24	Latitude Degree	lat_dgr	Decimal (9,6)	-	-	-
25	Longitude Degree	long_dgr	Decimal (9,6)	-	-	-
26	Street Address Line 2	st_addr_line_2	String	-	-	Street Address
27	Drive Through Pharmacy Indicator	drv_thru_pharm_ind	Integer	-	-	-
28	Primary Language Code	prmry_lang_cd	String	-	-	-
29	Soft Open Date	soft_open_dt	Date			Dry Run Date
30	Address Country Code	addr_cntry_cd	String	-	-	Country
31	Business Unit Area Number	buo_area_nbr	Integer	-	-	-
32	State Province Name	st_prov_nm	String	-	-	State
33	Business Size Unit of Measure Code	bu_size_uom_cd	String	-	-	-
34	Time Zone Name	tz_nm	String	-	-	Time Zone Standard
35	Operation Close Date	op_close_dt	Date	-	-	-
36	Temporary Close Date	temp_close_dt	Date	-	-	-
37	Prototype Number	proto_nbr	String	-	-	Store Prototype Nbr
38	Time Zone Code	tz_cd	String	-	-	Time Zone Standard
39	Daylight Savings Time Zone Name	dst_tz_nm	String	-	-	Time Zone Daylight Savings
40	Open Status Code	open_status_cd	String	-	-	-
41	Street Address Line 3	st_addr_line_3	String	-	-	Street Address
42	Daylight Savings Time Zone Code	dst_tz_cd	String	-	-	Time Zone Daylight Savings
43	Business Unit Public Close Time	bu_public_close_tm	String	-	-	-
44	Close Date	fin_close_dt	Date	-	-	-
45	Federal Information Processing Standard County Code	fips_cnty_cd	String	-	-	-
46	Store Type Code	store_type_cd	String	-	-	-
47	Open Status Description	open_status_desc	String	-	-	-
48	Banner Code	banner_cd	String	-	-	-
49	BUO Area Name	buo_area_nm	String	-	-	-
50	Temporary Reopen Date	temp_reopn_dt	Date	-	-	-
51	Street Address Line 4	st_addr_line_4	String	-	-	Street Address
52	Base Division Number	base_div_nbr	Integer	-	-	Subdiv
53	Banner Description	banner_desc	String	-	-	-
54	Business Unit Public Open Time	bu_public_open_tm	String	-	-	-
55	Planting Zone Code	wea_zone_cd	String	-	-	-
56	Grand Open Date	grand_open_dt	Date	-	-	Open Date
57	Open 24 HR Indicator	open_24_hr_ind	Integer	-	-	-
58	Real Estate Prototype Code	real_estat_proto_cd	String	-	-	-
59	Segment Number	seg_nbr	Integer	-	-	-
60	County Name	cnty_nm	String	-	-	Physical County Name
61	Public Close Date	public_close_dt	Date	-	-	-
62	Segment Name	seg_nm	String	-	-	-
63	City Name	city_nm	String	-	-	City
64	Region Number	region_nbr	Integer	-	-	-
65	Street Address Line 1	st_addr_line_1	String	-	-	Building Address
66	Region Name	region_nm	String	-	-	-
67	Zip Code or Postal Code	postal_cd	String	-	-	Zip Code