# 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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the UTC activation day.                                                                                    | Yes    |
| `utc_activation_time_id`     | SMALLINT     | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_date.md) for the standard activation day.                                                                               | Yes    |
| `std_activation_time_id`     | SMALLINT     | **FK** | Foreign key to [`ccdw_dim_time`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_time.md) for the standard activation time.                                                                              | No     |
| `std_activation_timezone_id` | SMALLINT     | **FK** | Foreign key to [`ccdw_dim_timezone`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/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`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_locale.md).                                                                                                           | Yes    |
| `user_agent_id`              | INTEGER      | **FK** | Foreign key to [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).                                                                                                   | Yes    |