Entity Definition

Logical Name : Consumer
Physical Name : PA_CNS

A PartyRoleAssignment type that represents the association between a retailer on one hand and an individual or organization (Party) on the other hand where the party is a potential, current or ex-purchaser of goods and services from the retailer. We are using the term "Consumer" to reflect the idea that this PartyRoleAssignment represents parties that retailers are SELLING TO (or trying to sell to). In other entities we differentiate between parties that are in a pre-sale state (typically they're in the customer acquisition funnel), an active state (they have purchased items and are ActiveCustomers) , an inactive state (InactiveCustomers) or a "dead" state (ExCustomers).

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ConsumerID (PK) Token ID for a Consumer instance. ID_CNS Identity integer
PartyRoleAssignmentID (FK) Token identifier for a PartyRoleAssignmentInstance. ID_PRTY_RO_ASGMT Identity integer PartyRoleAssignment(PA_RO_PRTY)
PartyID (FK) A unique, system assigned identity for a Party. ID_PRTY Identity integer Party(PA_PRTY)


Parent Entity Verb Phrase Child Entity
PartyRoleAssignment is a Consumer
Party may be a Consumer
Consumer state changed by RegistrationEvent
Consumer is in a state determined by ConsumerRegistrationState
Consumer state changed by ConversionEvent
Consumer is in a state defined by ConsumerConversionState
Consumer iis referred by CustomerReferral

Logical Views containing Consumer

Logical View
Logical 02340 - Retail Transaction - Shipping View
Logical 02350 - Retail Transaction - Restriction Validation View
Logical 05050 - Taxation - Registration and Certification 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