Entity Definition

Logical Name : CustomerLoyaltyProgram
Physical Name : LE_CT_LYLTY_PRGM

CustomerLoyaltyProgram is a subtype of CustomerMembershipProgram. It is presented as a subtype to highlight the importance of loyalty programs within the retail business community and to make it easier for ARTS ODM users to find and access loyalty program metadata. A loyalty program, as represented in the ARTS ODM has to following properties that distinguish it from other kinds of CustomerMembershipPrograms: If, it is free - customers are obligated to register and provide basic contact information Rewards are earned through customer actions (i.e. visits, purchases, referrals, etc.) A RETAILER SPONSORED group plan that customers may elect to join. As used here, join means that the customer provides personal contact information through a registration process and, for paid membership type programs pays a fee. Membership programs are typically implemented as initiatives that reward customers for patronizing the retailer. Membership programs involve monitoring activity over a designated period of time and based on activity volume and cumulative value of the customer's net purchases gives the customer discounts, cash payments, premium gifts, etc. based on the net value they have contributed to the retailer's profitability. NOTE: Some retailers offer different "levels" of paid CustomerRewardProgram membership. As modeled here, to avoid confusion with CustomerRewardProgramTier we recommend that retailers set the different program levels up as different customer reward programs.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
MembershipProgramID (FK)(PK) Token ID for a CustomerRewardProgram instance. ID_CT_MBRSHP_PRGM Identity integer
LoyaltyProgramName A promotional or trade name created to advertise and create awareness for a retailer loyalty type of CllubMembershipProgram. NM_CT_LYLTY_PRGM Name varchar(40)
LoyaltyThemeDescription A short narrative description of the common area of interest or topic for a loyalty program. Examples: BABY_CLUB PET_CLUB These allow retailers to tailor loyalty programs to customers with specific kinds of interest. DE_CT_LYLTY_PRGM_THM DescriptionShort varchar(255)

No Logical Relationships for CustomerLoyaltyProgram

Logical Views containing CustomerLoyaltyProgram

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 07010 - Customer Account Information Extended