Entity Definition

Logical Name : CustomerMembershipProgramTerms

This entity captures and maintains the legal provisions behind a CustomerMembershipProgram. It defines the legal preconditions, limitations, obligations and rights for a CustomerRewardProgram. As modeled here it is used to supplement more general CustomerAccountTermsAndConditions.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
RevisionNumber (PK) The version number used to track modifications to the CustomerRewardProgramTermsAndConditions over time. AI_RVSN_NMB Number integer
CustomerAccountContractNarrative Narrative text for the CustomerRewardLegalTermsAndConditions. NA_CT_ACNT_CNTRT_NRTV DescriptionNarrative varchar(4000)
EffectiveDate Date this program legal terms and provisions document revision is in force. DC_EF_DT EffectiveDate date
ExpirationDate Date this program legal terms and provisions document revision is no longer in force. DC_EP_DT ExpirationDate date
StatusCode Current status of this terms and conditions revision. Retailers need to exercise care in assigning status codes. While a contract may be modified prior versions tied to older customer accounts may remain in force. Retailers need to define an appropriate contract life cycle management strategy as part of implementing this entity. CD_STS Code2Status char(2)
MembershipProgramID (FK) Token ID for a CustomerRewardProgram instance. ID_CT_MBRSHP_PRGM Identity integer CustomerMembershipProgram(CO_CT_MBRSHP_PRGM)


Parent Entity Verb Phrase Child Entity
CustomerMembershipProgram is governed by CustomerMembershipProgramTerms

Logical Views containing CustomerMembershipProgramTerms

Logical View
Logical 07010 - Customer Account Information Extended