Store Dim Columns

The Store Dimensions table provides attribute information for the given store number, including information such as location, manager details, and related codes.

The following provides Store Dimensions column details, in alphabetical order.

Technical NameBusiness NameData Type (orc, parquet)Primary KeySensitive MetricsDSS Mapping
city_nmCity NameString---
drv_thru_pharm_indDrive Through Pharmacy IndicatorInteger---
geo_region_cdGeographic Region CodeString--Geo region cd
lat_dgrLatitude DegreeFloat---
long_dgrLongitude DegreeFloat---
postal_cdZip Code or Postal CodeString---
st_addr_line_1Street Address Line 1String---
st_addr_line_2Street Address Line 2String---
st_addr_line_3Street Address Line 3String---
st_addr_line_4Street Address Line 4String---
st_prov_nmState Province NameString---
state_prov_cdState or Province CodeString--Whse State
store_nbrStore NumberIntegerY--
store_type_cdStore Type CodeString---