Entity Definition

Logical Name : GeographicSegmentHierarchy
Physical Name : CO_GEO_SGMT_HRC

A named hierarchal set of geographic segments. GEOGRAPHIC HIERARCHY <== CustomerSegmentationHierarchyName WORLD Root level CONTINENT Level 1 COUNTRY Level 2 STATE Level 3 COUNTY Level 4 MUNICIPALITY Level 5 NEIGHBORHOOD Level 6 The sample indented list illustrates the hierarchy levels for the SALES_ANALYSIS hierarchy. A given hierarchy may be associated with an authorizing country (for census geographic, economic, tax, government admin. purposes) or independent of a country. This is designed to provide a flexible way of geographically decomposing markets, customers, etc. As a rule, retailers will want to use different national statistics and allign their geocoding with the geocoding used for those national statistics. This is why there is an optional FK to ISO3166-1Country.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GeographicSegmentHierarchyID (PK) A token ID for a CustomerSegmentHierarchy ID_GEO_SGMT_HRC Identity integer
GeographicSegmentHierarchyName A business name assigned to a CustomerSegmentHierarchy. NM_GEO_SGMT_HRC Name varchar(40)
Definition Business definition for the CustomerSegmentHierarchy. This attribute captures a short narrative explanation of what the customer segment hierarchy represents and its intended use within a retail enterprise. DE_DFN DescriptionNarrative varchar(4000)
BasisNarrativeDescription Provides a place for retailers to identify where the customer segment hierarchy originates and how it is dervived. It is intended to document whether a customer segment hierarchy is imported from a source like Prism, VALS, etc. OR whether it is derived from inhouse hierarchical clustering analysis. This is important in capturing the design intent and methodology behind the customer segment hierarchy. NA_BSS_NRTV DescriptionNarrative varchar(4000)


Parent Entity Verb Phrase Child Entity
GeographicSegmentHierarchy defines hierarchy for GeographicSegmentHierarchyLevel

Logical Views containing GeographicSegmentHierarchy

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