Entity Definition

Logical Name : GeographicSegment
Physical Name : CO_GEO_SGMT

A customer grouping based on common GeographicSegment. A GeographicSegment is an AREA and it can be a large area composed of lower level areas or a low level composed of a single location. Retailers will decide how to use geographic hierarchies and locations to segment customers. ARTS provides a very flexible schema so retailers have wide latitude to choose their geographic customer segmentation strategy. As a rule, retailers should choose a the LOWEST level geographic segment their systems and data will support because it is possible to aggregate up to higher levels. But it is very difficult to decompose higher level geographic areas to lower levels if those level segments are not defined.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GeographicSegmentID (PK) Token ID for a GeographicSegment which is used to categorize customers based on where they live, shop and work. ID_GEO_SGMT Identity integer
GeographicSegmentClassifierDescription A short description of this GeographicSegment. DE_GEO_SGMT_CLSFR DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
GeographicSegment is part of GeographicSegment_ISO3166-2CountrySubdivision
GeographicSegment owns GeographicSegmentPostalCode
GeographicSegment owns GeographicalSegmentStatisticsArea
GeographicSegment is referenced by Address

Logical Views containing GeographicSegment

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