---
title: "FCT_USER_TAGS"
slug: "fct-user-tags"
updated: 2026-02-17T10:38:29Z
published: 2026-02-17T10:38:29Z
canonical: "docs.thrivelearning.com/fct-user-tags"
---

> ## 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_USER_TAGS

> [!NOTE]
> FCT_USER_TAGS is related to any skills or topics 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 recorded skills or topics
> 
> 
> 
> ![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(622).png?sv=2026-02-06&spr=https&st=2026-11-05T19%3A57%3A07Z&se=2026-11-05T20%3A57%3A07Z&sr=c&sp=r&sig=eb6QRcU38%2FJo8PzNwaEbNjKZRwvYwkzV%2FnKin%2FFA4e4%3D)
> 
> 
> 
> ![](https://cdn.document360.io/3a0609fb-d96c-4ce1-aabe-d9338fb1e858/Images/Documentation/image(624).png?sv=2026-02-06&spr=https&st=2026-11-05T19%3A57%3A07Z&se=2026-11-05T20%3A57%3A07Z&sr=c&sp=r&sig=eb6QRcU38%2FJo8PzNwaEbNjKZRwvYwkzV%2FnKin%2FFA4e4%3D)

> [!WARNING]
> Any tags which were added and then subsequently deleted are not included within this dataset

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | CURRENT AVAILABLE VALUES | EXAMPLE |
| --- | --- | --- | --- | --- |
| **Created Date** | DATE | Date the tag was added to the users profile |  | 2025-01-01 |
| **Created Time** | VARCHAR(16777216) | Time the tag was added to the users profile |  | 00:00:00 |
| **Created Timestamp** | TIMESTAMP_NTZ(9) | Datetime the tag was added to the users profile |  | 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 |
| **Is Endorsed** | BOOLEAN | Flag to show if the tag is endorsed | TRUE, FALSE | TRUE |
| **Is Skill** | BOOLEAN | Flag to show if the tag is a skill | TRUE, FALSE | TRUE |
| **Is Target Set** | BOOLEAN | Flag to show if a target level has been set for the user for this tag | TRUE, FALSE | TRUE |
| **Skill Level** | NUMBER(25,0) | The skill level the user is currently at. If no skill level is set it will be null. If no skill level set but a target is set it will show 0 | NULL, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 | 3 |
| **Skill Target Level** | NUMBER(25,0) | The target skill level for the user to aim for. If no target skill level is set it will be null | NULL, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 | 3 |
| **Tag** | VARCHAR(16777216) | The tag the user has on their profile |  | Leadership |
| **Tag Count** | NUMBER(1,0) | A count of 1 for each users tag | 1 | 1 |
| **Tag Entry ID** | VARCHAR(16777216) | Unique identifier for the tag by user |  | 123a12b3cd4e5f67g890h1ij |
| **Tag Type** | VARCHAR(5) | If Is Skill = TRUE then the tag type is Skill, else Topic | Skill, Topic | Skill |
| **Target Outcome** | VARCHAR(25) | Text based column to show variance to target. Unknown as a catch all | Not Applicable (Topic), No Target Level Set, At Target, Below Target, Above Target, Unknown | At Target |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **Updated Date** | DATE | Date the tag was last updated on the users profile |  | 2025-01-01 |
| **Updated Time** | VARCHAR(16777216) | Time the tag was last updated on the users profile |  | 00:00:00 |
| **Updated Timestamp** | TIMESTAMP_NTZ(9) | Datetime the tag was last updated on the users profile |  | 2025-01-01T00:00:00.000+0000 |
| **User ID** | VARCHAR(16777216) | Identifier for the user |  | 123a12b3cd4e5f67g890h1ij |
| **Variance To Target** | NUMBER(38,0) | Difference between the skill level and skill taregt level. A minus shows the user is below their target level |  | 0 |