Entity Definition

Logical Name : PromotionInitiative
Physical Name : CO_PRML_INITV

A retailer initiative aimed at achieving a defined outcome such as increasing customer net profitability, acquiring new customers, improving consumer awareness of the retailer and its offerings, educating and information consumers about retail products and services, etc

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PromotionalInitiativeID (PK) A token ID for a retailer's PromotionInitiative instance. ID_PRML_INITV Identity integer
PromotionInitiativeName A business name for the promotion initiative. NM_PRML_INITV DescriptionShort varchar(255)
PromotionNarrative A short narrative description of the promotion initative that explains its purpose, a high level view of how it works and other infromation to help business users understand it. NA_PRML_INITV DescriptionNarrative varchar(4000)
PromotionInitiativeEffectiveDateTime Date and time a promotional initiative starts DT_EF EffectiveDateTime datetime
PromotionalInitiativeExpirationDateTime Date and time a promotion initiative ends DT_EP ExpirationDateTime datetime
StatusCode The status of this PromotionInitiative instance. Sample values: A = Active i = Inactive P = Pending (for promotion initiatives to be launched in the future) CD_STS Code2Status char(2)
PromotionInitiativeTypeCode (FK) Defines a specific category of promotion initiative. See PromotionInitiativeType entity definition for a list of examples. CD_PRML_TYP Code varchar(20) PromotionInitiativeType(LU_PRML_INIT_TYP)
CampaignPromotionID (FK) 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 CampaignPromotion(CO_CMPGN_PRM)
AdvertisementID A reference to the advertisement associated with this PromotionInitiative. ID_ADVTSMT Identity integer
CatalogID Reference to the catalog this promotion is part of. ID_CTLG Identity integer
OccasionName (FK) The name ofr the Holiday instance NM_HLDY Name varchar(40) Holiday(CO_HLDY)


Parent Entity Verb Phrase Child Entity
Holiday is celebrated by PromotionInitiative
PromotionInitiativeType classifies PromotionInitiative
CampaignPromotion includes PromotionInitiative
PromotionInitiative includes ZLoyaltyProgram
PromotionInitiative can be a PromotionalOffer
PromotionInitiative can be a ConversionInitiative

Logical Views containing PromotionInitiative

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 04100 - Financial Ledger - Retail Transaction View
Logical 06100 - Calendar View
Logical 07015 - Customer Lifecycle and Registration
Logical 07040 - Customer Segment Dependent Behavior