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` for the UTC activation day.	Yes
`utc_activation_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` 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` for the standard activation day.	Yes
`std_activation_time_id`	SMALLINT	FK	Foreign key to `ccdw_dim_time` for the standard activation time.	No
`std_activation_timezone_id`	SMALLINT	FK	Foreign key to `ccdw_dim_timezone` for the standard activation time zone.	No
`source_code_group_id`	INTEGER	FK	Foreign key to `ccdw_dim_source_code_group`.	Yes
`source_code_status`	VARCHAR(50)		Status of the source code activation.	No
`activation_site_id`	SMALLINT	FK	Foreign key to `ccdw_dim_site` where the source code was activated.	Yes
`visitor_id`	VARCHAR(100)		Anonymous visitor ID.	No
`customer_id`	BIGINT	FK	Foreign key to `ccdw_dim_customer`.	Yes
`locale_id`	SMALLINT	FK	Foreign key to `ccdw_dim_locale`.	Yes
`user_agent_id`	INTEGER	FK	Foreign key to `ccdw_dim_user_agent`.	Yes