Entity Definition

Logical Name : CustomerMembershipProgramType

A reference entity that classifies CustomerMembershipPrograms for reporting and analysis. The classification of clubs is up to each retailer. Note that rebates are handled separately from membership so creating a "rebate membership type" is superflous.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
ProgramTypeCode (PK) Designates a category of CustomerMembershipProgram. Sample values include: LOYALTY SUBSCRIPTION CD_PRGM_TYP Code varchar(20)
ProgramTypeDescription Short description of this CustomerMembershipProgramType. DE_PRGM_TYP DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
CustomerMembershipProgramType defines processing rules for CustomerMembershipProgram

Logical Views containing CustomerMembershipProgramType

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