Entity Definition

Logical Name : CustomerReferral
Physical Name : CO_CT_RFC

CustomerReferral records the time and circumstances when a current Customer refers another party (Consumer) to the retailer AND that Consumer converts into a KeyCustomer (i.e. buys something and registers). Note that the FK to Consumer and ConsumerConversionState is important because it allows the retailer to track subsequent conversion events that track the referred consumer's journey to becomeing a KeyCustomer. This is important because a referral may involve supplementary retailer ConversionInitiatives to affect the change -- and that could impact the amount and timing of the CustomerReferralReward.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerReferralID (PK) Token ID for a CustomerReferral ID_CT_RFC Identity integer
ReferralDateTime Date and time the CustomerReferral was submitted to the retailer. DT_RFC AuditDateTime datetime
Referred (FK) Token ID for a Consumer instance. ID_CNS_RFC Identity integer Consumer(PA_CNS)
CustomerReferralStatusCode Indicates the current status of this CustomerReferral. Sample values are: PENDING - newly created waiting for retailer, review DENIED - referred party is already a customer, fails to convert to Customer (KeyCustomer) or is dead (or otherwise unconvertable from a consumer to a customer) APPROVED - Consumer referral is approved SC_CT_RFC Code2Status char(2)
RewardStatusCode Indicates the status of a reward attached to this referral. This is to insure that each referral reward is issued one time for approved referrals. Valid values: P - Pending - C - Completed - reward/recognition given to referring Customer. SC_RWD Code2Status char(2)
CustomerReferral (FK) A token ID for a ConversionEvent ID_CT_RFC_CVN_EV Identity integer ConversionEvent(CO_CVN_EV)
ReferringKey (FK) A unique system assigned identifier for a person or organization that purchases a product or service from the retailer. ID_RFC_KY_CT Identity integer KeyCustomer(PA_KY_CT)
ChannelID (FK) Token Identifier for a channel instance ID_CHNL Identity integer ConversionEvent(CO_CVN_EV)


Parent Entity Verb Phrase Child Entity
KeyCustomer refers CustomerReferral
Consumer iis referred by CustomerReferral
ConversionEvent completes CustomerReferral
CustomerReferral is rewarded by CustomerReferralReward

Logical Views containing CustomerReferral

Logical View
Logical 07017 - Consumer-Customer Lifecycle Context View