Entity Definition

Logical Name : CompositeHealthSegment
Physical Name : CO_HLTH_SGMT

An exploratory entity used to capture dietary, disability and may be extended to capture other health-related information for customer segmentation purposes. Note this is exploratory only because there are legal and regulatory privacy rules that limit the kinds of health information that can be collected (e.g. in the USA HIPPA). Retailers should not implement this without a careful review by their attorneys.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
HealthSegmentID (PK) Token ID for a Health-oriented customer composite segment ID_HLTH_SGMT Identity integer
DietaryHabitTypeCode (FK) Code that identifies a particular dietary habit. CD_DTRY_HBT_TYP Code varchar(20) DietaryHabitType(LU_DTRY_HBT)
DisabilityImpairmentTypeCode (FK) Identifies a retailer specified disability or impairment. CD_DSBLTY_IMPRMNT_TYP Code varchar(20) DisabilityImpairmentType(LU_DSBLTY_IMPRMNT)


Parent Entity Verb Phrase Child Entity
DisabilityImpairmentType characterizes CompositeHealthSegment
DietaryHabitType characterizes CompositeHealthSegment
CompositeHealthSegment characterizes KeyIndividualCustomerCompositeSegment

Logical Views containing CompositeHealthSegment

Logical View
Logical 07030 - Customer Segment Independent Characteristics