---
title: "FCT_USER_TAGS_LEVELS_MONTHLY"
slug: "fct-user-tags-levels-monthly"
updated: 2026-02-17T10:39:00Z
published: 2026-02-17T10:39:00Z
canonical: "docs.thrivelearning.com/fct-user-tags-levels-monthly"
---

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

> [!NOTE]
> FCT_USER_TAGS_LEVELS_MONTHLY is related to any skills 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. The purpose of this table is to show month on month skill movement over the previous 6 months

> [!WARNING]
> **Any tags which were added and then subsequently deleted are not included within this dataset**
> 
> **History is retained based on Updated Date and stored for the previous two years and current calendar year only. This specific table shows movement for the previous 6 months**

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | **CURRENT AVAILABLE VALUES** | **EXAMPLE** |
| --- | --- | --- | --- | --- |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **User ID** | VARCHAR(16777216) | Identifier for the user |  | 123a12b3cd4e5f67g890h1ij |
| **Tag** | VARCHAR(16777216) | The tag the user has on their profile |  | Leadership |
| **Skill Level** | NUMBER(25,0) | The maximum skill level the user is in this month. 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 |
| Is Endorsed (current flag) | BOOLEAN | current “Is Endorsed” flag of the tenant, user, tag combo | TRUE, FALSE | TRUE |
| **Month Start** | DATE | First of that month |  | 01-12-2025 |
| **Skill Level Effective From** | DATE | Original Creation Date of user-tag-skill_level |  | 03-12-2024 |
| **Previous Skill Level** | NUMBER(25,0) | Previous month’s highest skill level | NULL, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 | 2 |
| **Skill Diff** | NUMBER(26,0) | “**Skill Level” - “Previous Skill Level”** | 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 | 1 |
| **Skill Movement** | VARCHAR(11) | text field to indicate if new, growth, regression or no change | new, progression, regression, no_change | progression |