--- schema_version: "1" id: 17010d7117940a84b0a37d06496797049f5b3709da82704eee61a90c4d96d15a title: ccdw_fact_source_codes_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_source_codes_activation.md canonical_url: https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_fact_source_codes_activation.html source_site: developer.salesforce.com content_type: documentation content_hash: 94217f1f59c5fde17409e9dedeb56f29c66e9b5eae0281f217964ef8911a57e6 products: - Composable Storefront - Salesforce APIs --- # ccdw_fact_source_codes_activation This table records the activation of source codes. | Column Alias | Data Type | Key | Description | Index? | | ---------------------------- | ------------ | ------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------ | | `source_code_activation_id` | BIGINT | **PK** | Unique identifier for a source code activation event. | Yes | | `nsource_code_id` | VARCHAR(50) | | Normalized source code identifier. | No | | `utc_activation_timestamp` | TIMESTAMP | | UTC timestamp of the source code activation. | No | | `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 source code 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 | | `source_code_group_id` | INTEGER | **FK** | Foreign key to [`ccdw_dim_source_code_group`](https://developer.salesforce.com/docs/commerce/pwa-kit-managed-runtime/guide/jdbc_ccdw_dim_source_code_group.md). | Yes | | `source_code_status` | VARCHAR(50) | | Status of the source code activation. | No | | `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 source code 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 | | `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 |