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
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
⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
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 |