Entity Definition

Logical Name : Site
Physical Name : LO_STE

A geographical location at which the enterprise's business is conducted. Contains one or more of RetailStore, DistributionCenter, InventoryLocation and AdminstrativeCenter. A Site may include multiples spaces "owned by" mutliple retailers. Examples of this include malls, shopping centers, etc. This means that a STORE may exist within a site - and an in-store map (which consists of many decomposable spaces) will be required for each store.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
SiteID (PK) Token ID for a Site ID_STE Identity integer
TimeZoneCode A code denoting which TimeZone the Site is in. CD_TZ Code6 char(6)
ICAOcode (FK) International code used to designate airport/weather reporting stations. This is the closest thing to an international standard for designating weather forecasting/current condition reporting areas. It's value for ARTS is that it is an international standard ICAO = International Civil Aviation Organization CD_ICAO Code4External char(4) METARweatherSite(LU_METAR_WTHR_STE)
SiteTypeCode (FK) Identifies a valid category of site (physical place). CD_STE_TY Code varchar(20) SiteType(LU_STE_TY)
GeographicLocationID (FK) Token ID for a GeographicLocation ID_GEO_LCN Identity integer GeophysicalLocation(CO_GEO_LCN)
OperationalPartyID (FK) A token identifier for an instance of an OperationalParty. ID_OPR_PRTY Identity integer OperationalParty(PA_PRTY_OPR)
RetailSiteTypeCode Classifies the retail business function of a site (as opposed to its physical instantiation as represented by SiteTypeCode). Valid sample values include: RETAIL_STORE SHOWROOM DEMO KIOSK VENDING MACHINE SITE etc. The values assigned to this attribute are determined by the retailer. CD_RTL_STE_TYP Code varchar(20)
SiteNorthAngleOffsetDegrees The degree offset representing the angular orientation of NORTH with respect to the Site's local coordinate system. A perfectly aligned site will have an offset value of 0. A site that is oriented perpendicular to NORTH will have an offset of 90 (counter clockwise). The degrees are measured in a COUNTER CLOCKWISE direction from NORTH which is assumed to be 0 degrees. In most scenarios the site will be viewed on a XY axsis that represents a local cartesian space. This offset documents the angular difference from the location's orientation from NORTH. Supports transformation of site plan coordinates from NORTH orientation. QU_STE_NRTH_ANGL_OFS_DEG LineNumber smallint


Parent Entity Verb Phrase Child Entity
GeophysicalLocation is physical place of Site
METARweatherSite is weather reporting location for Site
SiteType classifies Site
OperationalParty owns or rents Site
Site contains BusinessUnitSite
Site is reached via SiteContactMethod
Site is divided into Location
Site is assigned WorkstationSiteAssignment
Site locates WorkerTimePunchEntry

Logical Views containing Site

Logical View
Logical 02110 - Item Inventory - Location View
Logical 02200 - Transaction Macro View
Logical 02316 - Distributed Order Management View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 06210 - Access Control - Rules View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06400 - Store Equipment View
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10100 - Enterprise - Locations Macro View
Logical 10102 - EnterpriseWeather
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View
Logical 10110 - Enterprise - Location Retailer Organization View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till
Logical 10200 - Enterprise - Merchandise View
Logical 10400 - Enterprise - Channels
Logical 11150 - Worker - Time Punch View