---
title: "DIM_USER_SERVICE_USERS"
slug: "dim-user-service-users"
updated: 2026-09-07T07:25:58Z
published: 2026-09-07T07:25:58Z
canonical: "docs.thrivelearning.com/dim-user-service-users"
---

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

# DIM_USER_SERVICE_USERS

> [!NOTE]
> The purpose of DIM_USER_SERVICE_USERS is to show meta data for each user within the platform. It can be joined to various FACT tables on User ID, 1 to many, to show activity by users. It can also be joined to BRG_USER_AUDIENCE, 1 to many, to show a row for each audience that user is a part of. Lastly joining to DIM_USER_SERVICE_USERS_ADDITIONAL_FIELDS, 1 to many, enables you to see the key value pairs for custom fields which have been added for this user

> [!CAUTION]
> 🚨 Tags Following is no longer being populated and is due to be removed from the database, date TBC. Please use DIM_USER_TAGS for this info

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | CURRENT AVAILABLE VALUES | EXAMPLE |
| --- | --- | --- | --- | --- |
| **Agreed Terms** | TIMESTAMP_NTZ(9) | Timestamp when user agreed the terms |  | 2025-01-01T00:00:00.000+0000 |
| **Audience** | VARIANT | A list of audiences the user is in and associated audience details |  | 123a12b3cd4e5f67g890h1ij |
| **Audience Name** | VARCHAR(16777216) | A comma separated list of audience names the user is in |  | Sales North East |
| **Audience ID Array** | ARRAY | list of audience ids the user is in |  | ["123a12b3cd4e5f67g890h1ij"] |
| Collaboration ID Array | ARRAY | A list of collaboration ids the user is in |  | ["123a12b3cd4e5f67g890h1ij"] |
| Collaboration Name | VARCHAR(16777216) | A comma separated list of collaboration names the user is in |  | North East Comms |
| **Compliance** | VARIANT | Variant field | 0, null | 0 |
| **Created At** | TIMESTAMP_NTZ(9) | Datetime the user record was created |  | 2025-01-01T00:00:00.000+0000 |
| **Current Level** | VARCHAR(16777216) | The current level of the user - relating to gamification within the platform | 1, 2, 3, 4, 5, null | 1 |
| **Deleted** | BOOLEAN | Boolean flag (true/false) to show if the user has been deleted from the platform | TRUE, FALSE, null | FALSE |
| **Direct Reports** | ARRAY | Details of any direct reports the user has |  | [“123a12b3cd4e5f67g890h1ij“] |
| **Direct Reports Count** | NUMBER(18,0) | Count of any direct reports the user has |  | 1 |
| **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 |
| **Document Direct Reports** | VARIANT | Details of any direct reports the user has |  | [“123a12b3cd4e5f67g890h1ij“] |
| **Domain** | VARCHAR(16777216) | For multi domain tenants the domain the user is part of will show within this field |  | thrivetribe.learn.link |
| **Email** | VARCHAR(16777216) | User email address |  | john.smith@emailaddress.com |
| **First Login** | TIMESTAMP_NTZ(9) | Datetime the user first logged into the platform |  | 2025-01-01T00:00:00.000+0000 |
| **First Name** | VARCHAR(16777216) | User first name |  | John |
| **Followers** | VARIANT | Details of any people who are following the user |  | null |
| **Has Accessed Hub** ⏰ 👀 **COMING SOON** | BOOLEAN | Boolean flag (true/false) to show if the user has accessed Hub | TRUE, FALSE | TRUE |
| **Has Direct Reports** | BOOLEAN | Boolean flag (true/false) to show if the user has direct reports | TRUE, FALSE, null | TRUE |
| **Has Indirect Reports** | BOOLEAN | Boolean flag (true/false) to show if the user has indirect reports | TRUE, FALSE, null | FALSE |
| **Has Picture** | BOOLEAN | Boolean flag (true/false) to show if the user has a profile picture | TRUE, FALSE, null | TRUE |
| **Hierarchy by Name** | VARCHAR(16777216) | Text showing the hierarchy from the user to their manager to their manager etc. |  | John Smith <-- Self |
| **Indirect Reports** | ARRAY | Details of any indirect reports the user has |  | [“123a12b3cd4e5f67g890h1ij“] |
| **Indirect Reports Count** | NUMBER(18,0) | Count of any indirect reports the user has |  | 1 |
| **Is Active** | BOOLEAN | Boolean flag (true/false) to show if the user is active | TRUE, FALSE, null | TRUE |
| Is In Collaboration | BOOLEAN | Boolean flag (true/false) to show if the user is in a collaboration | TRUE, FALSE | TRUE |
| **Language Code** | VARCHAR(16777216) | User’s language code (e.g. ‘en-gb’) |  | en-us |
| **Last Login** | TIMESTAMP_NTZ(9) | Datetime the user last logged into the platform; if SSO is active this may not show the last time they accessed the platform depending upon timeouts |  | 2025-01-01T00:00:00.000+0000 |
| **Last Name** | VARCHAR(16777216) | User last name |  | Smith |
| **Latest Activity Content ID** | VARCHAR(16777216) | The content id the user last had activity with |  | 123a12b3cd4e5f67g890h1ij |
| **Latest Activity Timestamp** | TIMESTAMP_NTZ(9) | The date time the user last had activity |  | 2025-01-01T00:00:00.000+0000 |
| **Latest Activity Type** | VARCHAR(16777216) | The type of activity the user last had |  | viewed |
| **Level** | VARCHAR(16777216) | Text field | 0, null | 0 |
| Login Method | VARCHAR(16777216) | Identifies the method the user will log into the platform with |  | email |
| **Manager Email** | VARCHAR(16777216) | The user’s managers email address |  | john.smith@emailaddress.com |
| **Manager First Name** | VARCHAR(16777216) | The user’s managers first name |  | John |
| **Manager Full Name** | VARCHAR(16777216) | The user’s managers full name |  | John Smith |
| **Manager ID** | VARCHAR(16777216) | The user’s managers ID |  | 123a12b3cd4e5f67g890h1ij |
| **Manager Last Name** | VARCHAR(16777216) | The user’s managers last name |  | Smith |
| **Manager Ref** | VARCHAR(16777216) | The user’s managers reference |  | 123456A |
| **My Reports** | ARRAY | Details of any users reporting into me |  | [“123a12b3cd4e5f67g890h1ij“] |
| **Onboarded** | BOOLEAN | Boolean flag (true/false) | TRUE, FALSE, null | TRUE |
| **Position Created At** | TIMESTAMP_NTZ(9) | Datetime the position was created |  | 2025-01-01T00:00:00.000+0000 |
| **Position End Date** | TIMESTAMP_NTZ(9) | Datetime the position ended |  | 2025-01-01T00:00:00.000+0000 |
| **Position ID** | VARCHAR(16777216) | Identifier for the position |  | 123a12b3cd4e5f67g890h1ij |
| **Position Start Date** | TIMESTAMP_NTZ(9) | Datetime the position started |  | 2025-01-01T00:00:00.000+0000 |
| **Position Title** | VARCHAR(16777216) | Position title |  | Sales Rep |
| **Position Updated At** | TIMESTAMP_NTZ(9) | Datetime the position was updated |  | 2025-01-01T00:00:00.000+0000 |
| **Ref** | VARCHAR(16777216) | User reference |  | 123456A |
| **Single Sign On** | BOOLEAN | Boolean flag (true/false) to show if SSO is enabled | TRUE, FALSE, null | TRUE |
| Skill (Level) | VARCHAR(16777216) | Comma separated list of all skills the user has added to their profile. Where applicable the current level will show in brackets after the skill |  | objection handling (2), communication (1) |
| **Summary** | VARCHAR(16777216) | User bio |  | Hi, my name is John Smith and I have 10 years experience in sales |
| 🚨**Tags Following** | VARIANT | List of topics the user is following |  | [“sales“] |
| **Team Members** | VARIANT | A list of the user’s team members ids |  | [“123a12b3cd4e5f67g890h1ij“] |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **Thrive Role** | VARCHAR(16777216) | User’s role within the platform | learner, learneradmin, null, administrator | learner |
| **Thrive Status** | VARCHAR(16777216) | User’s status on the platform | active, suspended, new, null | active |
| **Time Zone** | VARCHAR(16777216) | User’s timezone |  | Europe/London |
| Topic | VARCHAR(16777216) | Comma separated list of all topics the user has added to their profile |  | sales, newcastle |
| **Updated At** | TIMESTAMP_NTZ(9) | Datetime user was last updated |  | 2025-01-01T00:00:00.000+0000 |
| **User Full Name** | VARCHAR(16777216) | User full name |  | John Smith |
| **User ID** | VARCHAR(16777216) | Identifier for the user |  | 123a12b3cd4e5f67g890h1ij |
| **Username(Email)** | VARCHAR(16777216) | User’s username(email) |  | john.smith@emailaddress.com |
| **Users Following** | VARIANT | Details of any people who the user is following |  | [“123a12b3cd4e5f67g890h1ij“] |