⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_GOALS relates to any goals recorded against users within the platform. The table can be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have goals
.png?sv=2026-02-06&spr=https&st=2026-05-30T18%3A03%3A23Z&se=2026-05-30T18%3A14%3A23Z&sr=c&sp=r&sig=4bP4oLIUI2CjS%2Fdx7rqIl8yOccXQqL3nAU3rFsXnOWs%3D)
This data set excludes deleted goals
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Can Learner Add | BOOLEAN | Boolean indicator to show if the user can add this goal for themselves | TRUE, FALSE, null | FALSE |
Completed At | TIMESTAMP_NTZ(9) | Datetime the goal was completed, will be null if not yet complete | 2025-01-01T00:00:00.000+0000 | |
Created At | TIMESTAMP_NTZ(9) | Datetime the goal was created | 2025-01-01T00:00:00.000+0000 | |
Created By | VARCHAR(16777216) | User Id of the person who created the goal | 123a12b3cd4e5f67g890h1ij | |
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 | |
Due Date | TIMESTAMP_NTZ(9) | Datetime the goal is due to be completed, if no due date is applicable this will be null | 2025-01-01T00:00:00.000+0000 | |
Goal | VARCHAR(16777216) | Freetext to show what this goal is | Meet my sales target for Q3 | |
Goal ID | VARCHAR(16777216) | Identifier for the goal, multiple users may have the same goal | 123a12b3cd4e5f67g890h1ij | |
Is Goal Assigned | BOOLEAN | Boolean indicator to show if this goal has been assigned to the learner by their manager | TRUE, FALSE | TRUE |
Overall Goal Status | VARCHAR(16777216) | Status indicator for the overall goal | complete, open | complete |
Skill | VARCHAR(16777216) | Skill linked to the goal | sales | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the goal was last updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user who has this goal | 123a12b3cd4e5f67g890h1ij | |
Will Boost Level | BOOLEAN | Boolean indicator to show if completing this goal will boost the skill level for the user | TRUE, FALSE, null | FALSE |