BusinessUnitGroupGeographicSegmentHierarchyGroup

Entity Definition

Logical Name : BusinessUnitGroupGeographicSegmentHierarchyGroup
Physical Name : CO_BSNGP_GEO_AR

This entity establishes an association between a BusinessUnitGroup and a GeographicSegment HierarchyGroup which estalishes a business unit group geographic area used for marketing, sales, administration and other purposes. This entity links the retailer organization (represented by BusinessUnitGroup) to a geographic area (represented by GeographicSegmentHierarchy. Both the parent entities represents collections of individual business units and geographic POINTS. This entity enables retailers to identify and define explicit relationships between groups of business units and geographic areas. Note that it is up to the retailer to establish business rules governing how BusinessUnitGroup and GeographicSegmentHierarchyGroup entities are linked. The data model provides a structure only. Linking both group entities requires considerling their relative levels within their respective hierarchies. This can get quite complex.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
BusinessUnitGroupGeographicAreaID (PK) Token ID that identifies the combination of a BusinessUnitGroup and a named geographic segment group. ID_BSNGP_GEO_AR Identity integer
BusinessUnitGroupID (FK) A unique system assigned identifier for a group of BusinessUnits. ID_BSNGP Identity integer BusinessUnitGroup(CO_BSNGP)
GeographicSegmentHierarchyGroupID (FK) Token Identifier for a CustomerSegmentHierarchyGroup instance. ID_GEO_SGMT_HRC_GP Identity integer GeographicSegmentHierarchyGroup(CO_GEO_SGMT_HRC_GP)
EffectiveDate Date the BusinessUnitGroupGeographicSegmentHierarchyGroup is active and may be used to segment customers DC_EF EffectiveDate date
ExpirationDate Date the BusinessUnitGroupGeographicSegmentHierarchyGroup is no longer active and may NOT be used to segment customers DC_EP ExpirationDate date
StatusCode Status of the BusinessUnitGroupGeographicSegmentHierarchyGroup. Valid values: A - Active I - Inactive CD_STS Code2Status char(2)

Relationships

Parent Entity Verb Phrase Child Entity
BusinessUnitGroup is located in BusinessUnitGroupGeographicSegmentHierarchyGroup
GeographicSegmentHierarchyGroup is close to BusinessUnitGroupGeographicSegmentHierarchyGroup

Logical Views containing BusinessUnitGroupGeographicSegmentHierarchyGroup

Logical View
Logical 05000 - Taxation - Macro View
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View