CustomerSubscriptionProgram

Entity Definition

Logical Name : CustomerSubscriptionProgram
Physical Name : LE_CT_SBSCRPTN_PRGM

As used in the ARTS ODM, a CustomerSubscriptionProgram is a subtype of CustomerMembershipProgram that customers pay to join with the expectation of receiving discretionary benefits (rewards). A customer subscription program may have one or more program levels and typically involve different levels of membership fees (which in turn offer different levels of rewards). Unlike CustomerLoyaltyPrograms, a subscription program (AS USED IN ARTS) involves paying a fee. It typically provides earned rewards that accrue greater value faster than a loyalty program. A subscription program typically requires periodic renewal (with a periodic fee).

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
SubscriptionProgramName A short trade or advertising name assigned to a CustomerSubscriptionProgram. Examples: EXECUTIVE_MEMBERSHIP ELITE_MEMBERSHIP Keep in mind these are typically applying to paid ClubMembershipPrograms. Accordingly the name is likely to reflect the nature of the program as it relates to a membership fee level. NM_CT_SBSCRPTN_PRGM Name varchar(40)

No Logical Relationships for CustomerSubscriptionProgram

Logical Views containing CustomerSubscriptionProgram

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