Entity Definition

Logical Name : GeographicSegmentPostalCode
Physical Name : CD_GEO_SGMT_PSTL_CD

Serves as a many to many cross reference between GeographicSegments and PostalCodes. It enables retailers to incorporate their national mail carreir postal codes into their geographic segmentation strategy for customers.

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)
PostalCodeID (FK)(PK) A token identifier for a generic postal code. Postal codes vary in format, structure and content from one country to another. This generic ID ensures that each postal code is unique across ALL COUNTRIES. ID_PSTL_CD Identity integer PostalCodeReference(LU_PSTL_CD_RFC)
ExpirationDate Date the association between a geographic segment and post code expires DC_EP ExpirationDate date
StatusCode Current status of the associatioin between a geographic segment and a postal code. Valid values are A - Active I - Inactive Values may be added as required for specific retailers. SC_GEO_SGMT_PSTL_CD Code2Status char(2)
EffectiveDate Date the association between a geographic segment and post code is in effect EC_EF EffectiveDate date


Parent Entity Verb Phrase Child Entity
GeographicSegment owns GeographicSegmentPostalCode
PostalCodeReference validates GeographicSegmentPostalCode

Logical Views containing GeographicSegmentPostalCode

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