# ccdw_aggr_source_code_activation

This table summarizes the activation of source codes.

| Column Alias             | Data Type | Key    | Description                                                                                                          | Index? |
| ------------------------ | --------- | ------ | -------------------------------------------------------------------------------------------------------------------- | ------ |
| `activation_date`        | DATE      |        | Date of source code activation.                                                                                      | No     |
| `registered`             | BOOLEAN   |        | Boolean indicating if the user was registered.                                                                       | No     |
| `site_id`                | SMALLINT  | **FK** | Foreign key to [`ccdw_dim_site`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_site.md).                           | No     |
| `device_class_code`      | VARCHAR   | **FK** | Device class code from [`ccdw_dim_user_agent`](/docs/commerce/b2c-commerce/guide/jdbc_ccdw_dim_user_agent.md).       | 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). | No     |
| `source_code_status`     | VARCHAR   |        | Status of the source code.                                                                                           | No     |
| `num_activations`        | INTEGER   |        | Total number of source code activations.                                                                             | No     |
| `num_source_codes`       | INTEGER   |        | Number of distinct source codes activated.                                                                           | No     |
| `num_source_code_groups` | INTEGER   |        | Number of distinct source code groups activated.                                                                     | No     |