Entity Definition

Logical Name : CampaignPromotion
Physical Name : CO_CMPGN_PRM

An identified, named defined set of activities that occurs under the aegis of a Campaign. Promotions are squarely aimed at generating demand for a retailer's products and services. They take place as part of a Campaign. Promotions are aimed at altering the state of an audience in a way that influences them to initiate and increase the frequency, recency and monetary value (sales) of their interaction with the retailer. A CampaignPromotion is composed of PromotionalOffers.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CampaignPromotionID (PK) Token ID for a CampaignPromotion. This represents the unique identifier for a PROMOTION which is taking place within the context of a campaign. ID_CMPGN_PRM Identity integer
CampaignID (FK) Token ID for a Campaign ID_CMPGN Identity integer Campaign(CO_CMPGN)
PromotionName Business name of a promotion. NM_PRM DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
Campaign is composed of CampaignPromotion
CampaignPromotion includes PromotionInitiative

Logical Views containing CampaignPromotion

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level