|
|
|
|
|
|
The Promotion Dimension describes every promotion (announced temporary price reduction) ever done by the grocery chain. The generated data file contains data for one thousand promotions by default.
Column Name |
Data Type |
Example |
Promotion_Key |
integer |
1 |
Promotion_Name |
varchar(128) |
July 4th Liquidation Promotion |
Price_Reduction_Type |
varchar(32) |
20 Cents off |
Promotion_Media_Type |
varchar(32) |
Magazine |
Ad_Type |
varchar(32) |
1 minute |
Display_Type |
varchar(32) |
POS |
Coupon_Type |
varchar(32) |
Register Receipt |
Ad_Media_Name |
varchar(32) |
Other |
Display_Provider |
varchar(128) |
Corporate |
Promotion_Cost |
integer |
492 |
Promotion_Begin_Date |
date |
3-6-2001 |
Promotion_End_Date |
date |
3-15-2001 |