Entity Definition

Logical Name : GeographicSegment_ISO3166-2CountrySubdivision
Physical Name : CO_ISO_3166_2_GEO_SGMT_CY_SBDVN

This entity identifies the ISO 3166-2 country and subdivisions mapped to a given retailer defined Geographic Segment. This is used where a geographic segment is to consist of collections of countries and/or subdivisions within countries. This is a world view that looks at the planet and breaks it into countries and countries into states, provinces, territories, etc.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
GeographicSegmentID (FK)(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 GeographicSegment(CO_GEO_SGMT)
ISO_3166-2CountrySubDivisionID (FK)(PK) 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)
EffectiveDate Date this GeographicSegment association becomes effective. DC_EF EffectiveDate date
ExpirationDate Date this GeographicSegment association is no longer in effect DC_EP ExpirationDate date
StatusCode Current status of this GeographicSegment association. SC_GEO_SGMT_CY_SBDVN Code2Status char(2)


Parent Entity Verb Phrase Child Entity
GeographicSegment is part of GeographicSegment_ISO3166-2CountrySubdivision
ISO3166-2CountrySubdivision includes GeographicSegment_ISO3166-2CountrySubdivision

Logical Views containing GeographicSegment_ISO3166-2CountrySubdivision

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