Entity Definition

Logical Name : CustomerMembershipAccount
Physical Name : LE_CT_MBRSHP_ACNT

A type of CustomerAccount used to accumulate earned rewards and redeemed rewards based on a customer's net purchase history as well as other actions that correlate with longer term value to the retailer. There are an enormous variety of different kinds of CustomerRewardAccounts. ARTS models some basic types here. Retailers may extend the model by subtyping CustomerRewardAccount as required.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CustomerAccountID (FK)(PK) A unique identifier for a customer account. ID_CTAC Identity integer
EffectiveDate Date the Loyalty Account Enrollment is in effect. DC_EF EffectiveDate date
ExpirationDate Date the Loyalty Account Enrollment is no longer in effect. DC_EP ExpirationDate date
StatusCode Current status of this Loyalty Program Account Enrollment instance CD_STS Code2Status char(2)
CustomerAccountInitiationFeeAmount Some Customer membership programs require a fee to be paid to sign up and join. This attribute captures that fee. MO_CT_ACNT_INTTN_FE_AMT Money decimal(16,5)


Parent Entity Verb Phrase Child Entity
CustomerMembershipAccount is enrolled in CustomerMembershipProgramAccount

Logical Views containing CustomerMembershipAccount

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