Entity Definition

Logical Name : Campaign
Physical Name : CO_CMPGN

An identified, named, defined collection of actions designed to accomplish a business goal for a retail enterprise. Campaigns may be undertaken to create public awareness for specific issues of importanct to the retailer, to promote the retailer's business, to accounce new store/web site openings, to educate the public and many other purposes. Campaigns are most typically associated with demand generation for a retail business. Campaigns are typically composed of more limited sets of activities referred to as CampaignPromotions in the ARTS data model.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
CampaignID (PK) Token ID for a Campaign ID_CMPGN Identity integer
CampaignName Business name for a Campagin NM_CMPGN DescriptionShort varchar(255)
EffectiveDateTime Date a Campaign begins and becomes effective. DT_EF EffectiveDateTime datetime
ExpirationDateTime Date a campaign ends and is no longer in effect. DT_EP ExpirationDateTime datetime
CampaignStatusCode Indicates current status of a Campaign Example values include: A - Active I - Inactive P - Pending (set up but not implemented) C - Canceled CD_STS_CMPGN Code2Status char(2)
BusinessDevelopmentProgram The name of an overarching program to acquire new customers, retain and grow sales from existing customers and reactivate in active customers. ID_BSN_DVLPMNT_PRGM Name varchar(40)


Parent Entity Verb Phrase Child Entity
Campaign is composed of CampaignPromotion

Logical Views containing Campaign

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level