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 . | 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 |