---
title: "FCT_GOALS"
slug: "fct-goals"
updated: 2026-05-29T10:37:52Z
published: 2026-05-29T10:37:52Z
canonical: "docs.thrivelearning.com/fct-goals"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thrivelearning.com/llms.txt
> Use this file to discover all available pages before exploring further.

# FCT_GOALS

> [!CAUTION]
> ⏰ 👀 COMING SOON - This data set is currently in development and is subject to change

> [!NOTE]
> **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**

![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(822).png?sv=2026-02-06&spr=https&st=2026-11-05T19%3A46%3A50Z&se=2026-11-05T20%3A46%3A50Z&sr=c&sp=r&sig=P0449sCbGRCfQbDXERXy1hXAKbEFr20YGwGLIrnlXXg%3D)

> [!WARNING]
> 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 |