⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_CPD_REQUIREMENTS relates to Continuing Professional Development time required for each user. It can be joined to DIM_USER_SERVICE_USERS on User ID, 1 to 1, to show which users have a CPD requirement
One row per Tenant ID, per User ID to be returned. Priority is dependant upon the maximum hours required, then ordered by Doc Updated At DESC
.png?sv=2026-02-06&spr=https&st=2026-09-14T21%3A02%3A00Z&se=2026-09-14T21%3A13%3A00Z&sr=c&sp=r&sig=p4IYMiBBf3EO7qRiKjc64%2BBGBO7V2I99ey9WbOayw80%3D)
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
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 | |
Required Minutes | NUMBER(38,0) | The maximum number of CPD minutes required for this user | 300 | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |