⏰ 👀 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-06-29T18%3A23%3A49Z&se=2026-06-29T18%3A34%3A49Z&sr=c&sp=r&sig=IouD4LmEhxrbZZrvvy7A9ENoZAp57SGQYDpx8h4Auc4%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 |