Entity Definition

Logical Name : KeyCustomerGeographicSegment
Physical Name : CO_KY_CT_GEO_SGMT

Captures each geographic segment (a location reference) for a KeyCustomer. This is important because it tracks geographic segment based on a type of location (i.e. is it a residence, it is work place, is it a shopping place, etc.) Also it distinguishes between current active associations and past, no longer active associations. So customer moves can be tracked.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
KeyCustomerGeographicSegmentID (PK) Token identifier for a KeyCustomerGeographicSegmentID ID_KY_CT_GEO_SGMT Identity integer
CustomerID (FK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer KeyCustomer(PA_KY_CT)
StatusCode Indicates the status of this KeyCustomerGeographicSegment. Valid values are A - Active I - Inactive Note that ONLY one instant of the KeyCustomerGeographicSegment entity typemay be active at a time. CD_STS Code2Status char(2)
EffectiveDate Date this KeyCustomer is using the GeographicSegment (place). DC_EF EffectiveDate date
ExpirationDate Date this KeyCustomer is no longer using the GeographicSegment (place). DC_EP ExpirationDate date
CustomerPlaceUsageTypeCode (FK) Defines a valid kind of key customer geographic segment (place or location) usage. Valid values include: RESIDENCE WORK SHOPPING OTHER CD_CT_PLC_USG Code varchar(20) CustomerPlaceUsageType(LU_CT_PLC_USG)
ISO_3166-2CountrySubDivisionID (FK) 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)
PostalCodeID (FK) 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)
GeographicLocationID (FK) Token ID for a GeographicLocation ID_GEO_LCN Identity integer GeophysicalLocation(CO_GEO_LCN)


Parent Entity Verb Phrase Child Entity
GeophysicalLocation defines point location for KeyCustomerGeographicSegment
KeyCustomer uses KeyCustomerGeographicSegment
ISO3166-2CountrySubdivision defines national location for KeyCustomerGeographicSegment
CustomerPlaceUsageType validates KeyCustomerGeographicSegment
PostalCodeReference defines postal area for KeyCustomerGeographicSegment

Logical Views containing KeyCustomerGeographicSegment

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