⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
FCT_GOALS_TASKS relates to any tasks recorded against user goals within the platform. The table can be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users have tasks
.png?sv=2026-02-06&spr=https&st=2026-05-30T18%3A03%3A10Z&se=2026-05-30T18%3A14%3A10Z&sr=c&sp=r&sig=ajlQv47c%2Bi9uWr4CJqT0CbK27VcECA1z8qCnLwwNA54%3D)
This data set excludes tasks which are from deleted goals
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Created At | TIMESTAMP_NTZ(9) | Datetime the task was created | 2025-01-01T00:00:00.000+0000 | |
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 | |
Goal ID | VARCHAR(16777216) | Identifier for the overall goal, multiple users may have the same goal | 123a12b3cd4e5f67g890h1ij | |
Is Approval Required | BOOLEAN | Boolean indicator to show if this task requires approval | TRUE, FALSE | TRUE |
Is Evidence Required | BOOLEAN | Boolean indicator to show if this task requires evidence | TRUE, FALSE | FALSE |
Is Task Assigned | BOOLEAN | Boolean indicator to show if this task has been assigned to the user | TRUE, FALSE | TRUE |
Overall Task Status | VARCHAR(16777216) | Status indicator for the individual task | complete, open, in progress | complete |
Task | VARCHAR(16777216) | Freetext box to describe the task | Shadown 5% of my colleagues sales calls | |
Task ID | VARCHAR(16777216) | Identifier for the individual task, multiple users may have the same task | 123a12b3cd4e5f67g890h1ij | |
Task Type | VARCHAR(16777216) | Flag to show the type of task and whether it is content related | content, basic | basic |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
Updated At | TIMESTAMP_NTZ(9) | Datetime the task was last updated | 2025-01-01T00:00:00.000+0000 | |
User ID | VARCHAR(16777216) | Identifier for the user who has this task | 123a12b3cd4e5f67g890h1ij |