Entity Definition

Logical Name : KeyCustomer
Physical Name : PA_KY_CT

A customer that has registered with the retailer and in addition to a unique identifier has provided name, address, phone, email and other personal contact information. KeyCustomer is the basis for establishing an account relationship between a customer and the retailer. It can be thoguht of as the registration (i.e. personal contact information) part of setting up an account relationship.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerID (FK)(PK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_CT Identity integer Customer(PA_CT)
PrivacyOptOutCode A two character retailer assigned code denoting which forms of contact the Customer has chosen to opt out of. CD_PVCY_OOUT Code2 char(2)
ConsumerRegistrationStateID (FK) Token ID for an instance of a ConsumerRegistrationState. ID_CNS_RGSTN_ST Identity integer ConsumerRegistrationState(CO_CNS_RGSTN_ST)


Parent Entity Verb Phrase Child Entity
Customer may be a KeyCustomer
ConsumerRegistrationState captures registration of KeyCustomer
KeyCustomer is classified by KeyOrganizationCustomerCompositeSegment
KeyCustomer is a member of CustomerAffiliation
KeyCustomer spends ExternalPurchasedCreditDebitCardSpendData
KeyCustomer is characterized by KeyCustomerAttributeValue
KeyCustomer is characterized by KeyIndividualCustomerCompositeSegment
KeyCustomer purchases through CustomerAccount
KeyCustomer has WalletShareEstimate
KeyCustomer uses KeyCustomerGeographicSegment
KeyCustomer refers CustomerReferral

Logical Views containing KeyCustomer

Logical View
Logical 05000 - Taxation - Macro View
Logical 05100 - Taxation - Rules View
Logical 06310 - Party - Role View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07000 - Core Customer Entities
Logical 07010 - Customer Account Information Extended
Logical 07015 - Customer Lifecycle and Registration
Logical 07017 - Consumer-Customer Lifecycle Context View
Logical 07019 - Party-Consumer-Customer Household View
Logical 07020 - Enterprise Anonymous Customer
Logical 07030 - Customer Segment Independent Characteristics
Logical 07040 - Customer Segment Dependent Behavior
Logical 07042 - Customer Wallet Share