GeographicSegmentHierarchyLevel

Entity Definition

Logical Name : GeographicSegmentHierarchyLevel
Physical Name : CO_GEO_SGMT_HRC_LV

An identified, named level within a GeographicSegmentHierarchy. Here's an appropriate use of a customer segment hierarchy. 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 GEOGRAPHIC HIERARCHY. Note that some types of Customer Segments will not require a hierarchy. Care must be exercised when defining customer segments to avoid inappropriate use of segement hierarchies.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
HierarchyLevelNumber (FK) The relative position of a level within a CustomerSegmentHierarchy. Level 0 is the ROOT or highest level of a hierarchy. The level number is incremented for the next LOWER level. IC_HRC_LV_NMB LineNumber smallint GeographicSegmentHierarchyLevel(CO_GEO_SGMT_HRC_LV)
GeographicSegmentHierarchyID (FK)(PK) A token ID for a CustomerSegmentHierarchy ID_GEO_SGMT_HRC Identity integer GeographicSegmentHierarchy(CO_GEO_SGMT_HRC)
HierarchyLevelNumber (PK) The relative position of a level within a CustomerSegmentHierarchy. Level 0 is the ROOT or highest level of a hierarchy. The level number is incremented for the next LOWER level. IC_HRC_LV_NMB LineNumber smallint
Parent (FK) A token ID for a CustomerSegmentHierarchy ID_GEO_SGMT_HRC_LVL_PRNT Identity integer GeographicSegmentHierarchyLevel(CO_GEO_SGMT_HRC_LV)
LevelName Business name for a CustomerSegmentHierarchyLevel. NM_LV Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
GeographicSegmentHierarchyLevel is part of GeographicSegmentHierarchyLevel
GeographicSegmentHierarchy defines hierarchy for GeographicSegmentHierarchyLevel
GeographicSegmentHierarchyLevel defines level for AssociatedGeographicSegmentHierarchyGroup
GeographicSegmentHierarchyLevel is part of GeographicSegmentHierarchyLevel

Logical Views containing GeographicSegmentHierarchyLevel

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