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. |
No |
device_class_code |
VARCHAR | FK | Device class code from ccdw_dim_user_agent. |
No |
source_code_group_id |
INTEGER | FK | Foreign key to ccdw_dim_source_code_group. |
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 |