Entity Definition

Logical Name : GeographicSegmentHierarchyGroup
Physical Name : CO_GEO_SGMT_HRC_GP

Identifies and names a particular set of GeographicLocations. It is used to aggregate individual locations into named groups which constitute geographic areas retailers may use to anlayze markets, administrative areas, geopollitical areas, etc. As with most ARTS hierarchy patterns, the lowest level of GeographicSegmentHierarchyGroup corresponds to an individual GeographicLocation.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GeographicSegmentHierarchyGroupID (PK) Token Identifier for a CustomerSegmentHierarchyGroup instance. ID_GEO_SGMT_HRC_GP Identity integer
GeographicSegmentHierarchyGroupName The business name for a CustomerSegmentHierarchyGroup instance. NM_GEO_SGMT_HRC_GP Name varchar(40)
ISOCountryCode (FK) The ISO-3166-1 two letter code denoting a locality in which the retailer does business. CD_CY_ISO Code2 char(2) ISO3166-1Country(LO_CY_ISO)
ISO_3166-2CountrySubDivisionID (FK) Token ID assigned to uniquely identify all country-primary subdivision instances. This token is non-signifcant and should be automatically generated. ID_ISO_3166_2_CY_SBDVN Identity integer ISO3166-2CountrySubdivision(CO_ISO3166_2_PRMRY_SBDVN)


Parent Entity Verb Phrase Child Entity
ISO3166-1Country identifies GeographicSegmentHierarchyGroup
ISO3166-2CountrySubdivision identifies GeographicSegmentHierarchyGroup
GeographicSegmentHierarchyGroup is a child of AssociatedGeographicSegmentHierarchyGroup
GeographicSegmentHierarchyGroup is a parent of AssociatedGeographicSegmentHierarchyGroup
GeographicSegmentHierarchyGroup is close to BusinessUnitGroupGeographicSegmentHierarchyGroup
GeographicSegmentHierarchyGroup defines aggregation group for GeographicalSegmentStatisticsArea
GeographicSegmentHierarchyGroup aggregates GeophysicalLocation

Logical Views containing GeographicSegmentHierarchyGroup

Logical View
Logical 05100 - Taxation - Rules View
Logical 07030 - Customer Segment Independent Characteristics
Logical 10108 - Enterprise - Physical Locations View
Logical 10108 - Enterprise - Physical Locations View