Entity Definition

Logical Name : CustomerMembershipProgramLevel
Physical Name : CO_CT_MBRSHP_PRGM_LV

A retailer defined subtype of membership represented as a level. Retailers may establish different tiers of membership and offer different levels of benefits and charge different membership fees. Note that a membership level is different from a customer loyalty tier. A membership program level is something that a customer chooses to enroll in or modify upon renewal. A customer loyalty tier is assigned by the retailer based on a defined set of rules for measuring different kinds of customer activity (like net purchase value, RFM, etc.) and based on a range assigining a customer to particluar tier. A customers position over time may change from one tier to another based on their activity with the retailer.

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 CustomerMembershipProgram(CO_CT_MBRSHP_PRGM)
LevelNumber (PK) A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. IC_LV_NMB Number integer
LevelCode A code that identifies a membership level. Membership levels typically offer different kinds of rewards and, where fees are involved charge different fee amounts. Examples of codes include: PLATINUM GOLD SILVER BRONZE CD_LV Code varchar(20)
LevelInitialFeeAmount The initial fee that is charged to join as a member. Only applies if the CustomerMembershipProgram is a paid for program. Examples includ various chains like Costco, Sam's Club, BJ's - all charge a fee based on membership program level. MO_LV_INT_FE_AMT Money decimal(16,5)
LevelPeriodicRenewalFeeAmount The periodic renewal fee for a specific membership level. Some shopping club memberships (e.g. Costco, Sam's, BJs) require an annual fee to renew membership. Some programs (e.g. REI) require only a one time fee to join. MO_LV_PRDC_RNWL_FE_AMT Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
CustomerMembershipProgram is stratified into CustomerMembershipProgramLevel
CustomerMembershipProgramLevel is further stratified into CustomerMembershipEarnedRewardTier
CustomerMembershipProgramLevel enrolls CustomerMembershipProgramAccount

Logical Views containing CustomerMembershipProgramLevel

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