Entity Definition

Logical Name : PersonActivityInterest
Physical Name : CO_PRS_ACTV_INTRST

Identifies a specific activity or interest that a Person has. This is used as part of consumer/customer segmentation based on the kinds of things a person is interested in and the kinds of things customers do that inflence what kinds of products and services they purchase.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PersonPartyID (FK)(PK) A unique, system assigned identity for a Party. ID_PRTY_PRS Identity integer Person(PA_PRS)
SegmentationPrecedenceOrder (PK) A retailer assigned value that tells what level of importance is assigned to this PersonActivityInterest by a retailer for the purpose of segmenting customers. This value must be a positive, whole number and must be UNIQUE within the PersonPartyID. AI_SGMT_PRCDN_ORD LineNumber smallint
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)
IntensityLevelCode A code that indicates the level of interest or enthusiasm a person has in an activity or interest. Sample Values: LOW - interested but not fully engaged MEDIUM - interested and engaged HIGH - interested, enagaged and obsessed CD_INTSY_LV Code varchar(20)
LeisureProfessionalTypeCode A code that characterizes the involvement of a person in an activity (or interest) as professional (i.e. it's an aspect of their vocation) or liesure (something they're involved with for fun). Sample Values: PROFESSIONAL LIESURE OTHER CD_LSUR_PRFSL_TYP Code varchar(20)


Parent Entity Verb Phrase Child Entity
ActivityInterest is engaged in by PersonActivityInterest
Person engages in PersonActivityInterest

Logical Views containing PersonActivityInterest

Logical View
Logical 07030 - Customer Segment Independent Characteristics