⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_CPD_ACTIVITY relates to Continuing Professional Development activity/entries within the platform. It can be joined to DIM_USER_SERVICE_USERS on User ID, many to 1, to show which users have had CPD activity
.png?sv=2026-02-06&spr=https&st=2026-06-29T18%3A23%3A50Z&se=2026-06-29T18%3A34%3A50Z&sr=c&sp=r&sig=D85bIifnvQvPuQDJqpW%2F9unjJg74sW6wCyNmH7qnvhE%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Activity ID | VARCHAR(16777216) | Identifier for the CPD activity entry | 123a12b3cd4e5f67g890h1ij | |
Activity Timestamp | TIMESTAMP_NTZ(9) | Datetime the CPD activity took place | 2025-01-01T00:00:00.000+0000 | |
Category ID | VARCHAR(16777216) | Identifier of the related CPD category for this activity | 123a12b3cd4e5f67g890h1ij | |
Category Name | VARCHAR(16777216) | Name of the related CPD category for this activity. If no related category it will show unknown | CPD Sales Development | |
Completed Minutes | NUMBER(38,0) | The number of CPD activity minutes recorded for this entry | 240 | |
Created At | TIMESTAMP_NTZ(9) | Datetime the CPD activity entry was created | 2025-01-01T00:00:00.000+0000 | |
Description | VARCHAR(16777216) | Freetext description for the CPD activitiy entry, will show null if no description entered | Conference and breakouts around sales negotiation techniques | |
Doc Created At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Doc Updated At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Is Verified | BOOLEAN | Boolean indicator to show if the CPD activity entry is from completing learning within the platform | TRUE, FALSE | FALSE |
Name | VARCHAR(16777216) | Freetext name for the CPD activitiy entry | Sales Negotiation | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Type | VARCHAR(16777216) | The type of content the CPD activity entry is from. If it is not content related it will show custom | article, custom, elearning, event, file, mixed, quiz, url, video | custom |
Updated At | VARCHAR(16777216) | Datetime the CPD activity entry was last updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |