# ccdw_dim_promotion

This table describes various promotions.

| Column Alias        | Data Type | Key    | Description                                                                                                       | Index? |
| ------------------- | --------- | ------ | ----------------------------------------------------------------------------------------------------------------- | ------ |
| `promotion_id (PK)` | INTEGER   | **PK** | Unique identifier for a promotion.                                                                                | Yes    |
| `npromotion_id`     | VARCHAR   |        | Natural key of the promotion, representing the ID of the promotion in the source system.                          | Yes    |
| `display_name`      | VARCHAR   |        | User-friendly display name for the promotion.                                                                     | No     |
| `promotion_class`   | VARCHAR   |        | Type or class of the promotion (for example, shipping, order, product).                                           | No     |
| `is_continuous`     | BOOLEAN   |        | Boolean indicating if the promotion is continuous.                                                                | No     |
| `valid_from`        | TIMESTAMP |        | Start date and time when the promotion is valid. Populated for promotions created or updated after February 2025. | No     |
| `valid_to`          | TIMESTAMP |        | End date and time when the promotion is valid. Populated for promotions created or updated after February 2025.   | No     |