Entity Definition

Logical Name : PromotionalOfferGroup
Physical Name : CO_TYP_PRM

An infrastructural entity defining types of Promotions which allows Promotions to be grouped together for reporting purposes.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PromotionalOfferTypeCode (PK) A classification code used to categorize promotion offer types. Examples include: PRC_REC - Price reduction through a percent or flat amount discount BOGO - Buy one get one (or more generally buy qty of N and get M for X$ MIX_MATCH - Buy X and get one of Y,Z,A for M$ PRC_MTCH - Price match a lower competitor price (markdown set based on delta between retailer and competitor price GIVEAWAY - Item or stored value media given to customer COUPON - A coupon that is treated as tender resuting in a discount. USUALLY debited as an AR when paid for by a supplier or other 3rd party REBATE - A payment or credit given to a customer on a deferred basis (although some retailers offer "instant" rebates that behave more like discounts). Rebates are often sponsored by suppliers or other parties outside the retail enterprise. OTHER - Anything else This list is a starting point for retailers. CD_PRM_OFR_TYP Code varchar(20)
Description A human readable descripton of the Promotion Type. DE_PRM_OFR_TYP DescriptionShort varchar(255)


Parent Entity Verb Phrase Child Entity
PromotionalOfferGroup categorizes PromotionalOfferGroupOfferType

Logical Views containing PromotionalOfferGroup

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 07040 - Customer Segment Dependent Behavior