Metadata hierarchy: MDWT_Adventure_Works_Demo ยป MDWT_AdventureWorksDW
| Column Name | Data Type | Is Key | Short description |
| PromotionKey | smallint | Surrogate primary key | |
| BKSpecialOfferID | int | Natural key from source system | |
| PromotionName | varchar | Promotion Name | |
| PromotionType | varchar | Promo type | |
| PromotionCategory | varchar | Is promotion offered to resellers or directly to customers? | |
| DiscountPct | smallmoney | Promotion discount percent | |
| PromotionStartDate | datetime | Promotion start date | |
| PromotionEndDate | datetime | Promotion end date | |
| MinQty | int | Minimum quantity required for promotion | |
| MaxQty | int | Maximum quantity permitted for promotion | |
| AuditKey | int | What process loaded this row? |
| Column Name | Data Type |