Entity Definition

Logical Name : MerchandiseHierarchyGroupLocation
Physical Name : LO_MR _HRC_GP

A join entity that associates a merchandise hierarchy group with a named location within a Site. This is used on an INTERIM basis to locate items. In ARTS the MerchandiseHierarchyGroup entity at the lowest level corresponds to an individual item. Of course it can represent higher-level categories of items as well. This join entity allows retailers to locate categories of items as well as individual items. This gives them a choice of the level of granularity they will support for locating items. Keep in mind that LOCATION is also a generalized nested entity and typically items will be tied to LOCATIOINS that represent fixtures or a fairly limited area within a Site. It is up to the retailer to establish constraints and boundaries on the association of items and locations. This approach is not a complete treatment of location and items. It is based on the need to support the ARTS XML location schemas which are incomplete representations of location aimed at supporting location services.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
LocationID (FK)(PK) A unique system assigned identifier for the Location. ID_LCN Identity integer Location(LO_LCN)
MerchandiseHierarchyGroupID (FK)(PK) Unique system assigned identifier for a group or class of merchandise. ID_MRHRC_GP Identity integer MerchandiseHierarchyGroup(CO_MRHRC_GP)
EffectiveDateTime Date and time this merchandise-location association becomes active. TS_EF EffectiveDateTime datetime
ExpirationDateTime Date and time this merchandise-location association becomes inactive. TS_EP ExpirationDateTime datetime
StatusCode Current state of this MerchandiseHierarcyGroupLocation association. Valid values: A - Active I - Inactive CD_STS Code2Status char(2)
LocationMerchandiseDescription Short narrative business description of this MerchandiseHierarchyGroupLocation association. This is stop gap pending the development of a proper planogram-based location. DE_LCN_MR DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
Location houses MerchandiseHierarchyGroupLocation
MerchandiseHierarchyGroup is housed in MerchandiseHierarchyGroupLocation

Logical Views containing MerchandiseHierarchyGroupLocation

Logical View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View