--- schema_version: "1" id: 92974aa6550bb2270a54920ffc5185723b034e045f246feab7104d78fa33e37c title: ccdw_fact_promotion_activation collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/commerce-cloud/b2c-commerce/guides/jdbc/jdbc_ccdw_fact_promotion_activation.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_fact_promotion_activation.html source_site: developer.salesforce.com content_type: documentation content_hash: c3be2df546de8fb207673bc744ab1c0f8a4a992f35b63e961370daee50ae9d6f products: - Composable Storefront - Salesforce APIs --- # ccdw_fact_promotion_activation This table records instances where promotions are activated. | Column Alias | Data Type | Key | Description | Index? | | ---------------------------- | ------------ | ------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | `promotion_activation_id` | BIGINT | **PK** | Unique identifier for a promotion activation event. | Yes | | `utc_activation_timestamp` | TIMESTAMP | | UTC timestamp of the promotion activation. | Yes | | `utc_activation_day_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_date`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.md) for the UTC activation day. | Yes | | `utc_activation_time_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_time`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_time.md) for the UTC activation time. | No | | `utc_update_timestamp` | TIMESTAMP | | Last modified UTC timestamp of this record. | Yes | | `std_activation_timestamp` | TIMESTAMP | | Timestamp of the promotion activation, in standard time. | No | | `std_activation_day_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_date`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_date.md) for the standard activation day. | Yes | | `std_activation_time_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_time`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_time.md) for the standard activation time. | No | | `std_activation_timezone_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_timezone`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_timezone.md) for the standard activation time zone. | No | | `promotion_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_promotion`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_promotion.md). | Yes | | `campaign_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_campaign`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_campaign.md). | Yes | | `activation_site_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_site`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_site.md) where the promotion was activated. | Yes | | `visitor_id` | VARCHAR(100) | | Unique identifier for a visitor session. This ID persists across sessions and is associated with an anonymous tracking cookie (for example, dwanonymous). | No | | `customer_id` | BIGINT | **FK** | Foreign key to [`ccdw_dim_customer`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_customer.md). For unregistered buyers, this value is `1` and can't distinguish one unregistered buyer from another. | Yes | | `is_anonymous` | BOOLEAN | | Indicates whether customer is anonymous or registered. | No | | `locale_id` | SMALLINT | **FK** | Foreign key to [`ccdw_dim_locale`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_locale.md). | Yes | | `user_agent_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_user_agent`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_user_agent.md). | Yes |