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
.png?sv=2022-11-02&spr=https&st=2026-01-30T20%3A45%3A49Z&se=2026-01-30T20%3A56%3A49Z&sr=c&sp=r&sig=h3aX8veflFv5F5WCpTrWhQBfJZCG9iGcnrVH05FkvsA%3D)
.png?sv=2022-11-02&spr=https&st=2026-01-30T20%3A45%3A49Z&se=2026-01-30T20%3A56%3A49Z&sr=c&sp=r&sig=h3aX8veflFv5F5WCpTrWhQBfJZCG9iGcnrVH05FkvsA%3D)
Any tags which were added and then subsequently deleted are not included within this dataset
⏰ 👀 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 |
|---|---|---|---|---|
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), | 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 |