Entity Definition

Logical Name : KeyIndividualCustomerCompositeSegment

A composite key customer segment that references composite demographic, psychographic, geographic, and other segments that describe independent characteristics of an individual customer (i.e. a person)

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
KeyCustomerCompositeSegmentID (PK) Token ID for a given Key Customer Composite Segment. ID_KY_CT_CMPST_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)
DemographicSegmentID (FK) Token ID for a DemographicSegment instance ID_DMOG_SGMT Identity integer CompositeDemographicSegment(CO_DMOG_SGMT)
PsychographicSegmentID (FK) Token ID for a composite psychographic customer segment. ID_PSYCHGRPH_SGMT Identity integer CompositePsychographicSegment(CO_PSYCHGRPH_SGMT)
ActivityInterestCode (FK) A lookup value that designates a valid activity or interest code used to segment customers. The code list must be defined by the retailer. CD_ACTV_INTRST Code varchar(20) ActivityInterest(CO_ACTV_INTRST)
KeyIndividualCustomerCompositeSegmentDescription Description of this COMPOSITE customer segment. The term individual here means we're looking at a PERSON party type vs. an organization. DY_KY_INDVDL_CT_CMPST_SGMT DescriptionShort varchar(255)
EffectiveDate Date a key customer - segment association is active and used to categorize individuals into segments. DC_ER EffectiveDate date
ExpirationDate Date a key customer - segment association is no longer active and used to categorize individuals into segments. DC_EP ExpirationDate date
StatusCode Indicates if this KeyCustomer - Segment association is active or inactive. Values: A- Active I - Inactive CD_STS Code2Status char(2)
HealthSegmentID (FK) Token ID for a Health-oriented customer composite segment ID_HLTH_SGMT Identity integer CompositeHealthSegment(CO_HLTH_SGMT)


Parent Entity Verb Phrase Child Entity
CompositePsychographicSegment characterizes KeyIndividualCustomerCompositeSegment
CompositeHealthSegment characterizes KeyIndividualCustomerCompositeSegment
ActivityInterest characterizes KeyIndividualCustomerCompositeSegment
CompositeDemographicSegment characterizes KeyIndividualCustomerCompositeSegment
KeyCustomer is characterized by KeyIndividualCustomerCompositeSegment

Logical Views containing KeyIndividualCustomerCompositeSegment

Logical View
Logical 07030 - Customer Segment Independent Characteristics