---
title: "DIM_AUDIENCE_SERVICE_AUDIENCES"
slug: "dim-audience-service-audiences"
updated: 2026-08-11T17:47:25Z
published: 2026-08-11T17:47:25Z
canonical: "docs.thrivelearning.com/dim-audience-service-audiences"
---

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

> [!NOTE]
> The purpose of DIM_AUDIENCE_SERVICE_AUDIENCES is to join to BRG_USER_AUDIENCE, many to 1, to establish the names of audiences (and structures) individual users are a part of

> [!CAUTION]
> 🚨 Audience Managers ID, Audience Managers Permissions, People Managers ID and People Managers Permissions are due to be removed from the database, date TBC

| **COLUMN NAME** | **DATA TYPE (FIELD SIZE)** | **DESCRIPTION** | CURRENT AVAILABLE VALUES | EXAMPLE |
| --- | --- | --- | --- | --- |
| **Audience ID** | VARCHAR(16777216) | Identifier for the audience (user group) |  | 123a12b3cd4e5f67g890h1ij |
| **Audience Managers** | VARIANT | A list of users and the specific audience manager permissions they have |  | [ { "permissions": { "assignments": true, "canViewUserAnalytics": false, "manageContent": true, "manageMembers": true }, "userId": "123a12b3cd4e5f67g890h1ij" } ] |
| 🚨**Audience Managers ID** | VARCHAR(16777216) | User ID of the audience manager |  | 123a12b3cd4e5f67g890h1ij |
| 🚨**Audience Managers Permissions** | VARCHAR(16777216) | Audience manager permissions |  | null |
| **Audience Name** | VARCHAR(16777216) | Name of the audience |  | Sales North East |
| **Audience Type** | VARCHAR(16) | Flag to show if the audience is either an audience, direct or indirect | Direct Reports, Audiences, Indirect Reports | Direct Reports |
| **Content Privacy** | VARCHAR(16777216) | Content privacy within the audience | private, public, null | private |
| **Created At** | TIMESTAMP_NTZ(9) | Timestamp of audience creation |  | 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 |
| **Document Audience Type** | VARCHAR(16777216) | Type of audience | smart, manual, null | smart |
| **Is Audience** | BOOLEAN | Boolean indicator for audience) | TRUE, FALSE, null | TRUE |
| Legacy Rules | VARIANT | Checklist of rules to be added to a smart audience. Several requirements can be added, with the assumption that all must be met to be added to an audiences Currently Thrive will utilise both smart and legacy rules for assigning users to a smart audiences |  | [ { "_id": "123a12b3cd4e5f67g890h1ij", "accountActive": true, "createdAt": "2025-01-01T00:00:00.000+0000", "criteria": "fact", "name": "fc-user-active" }, { "_id": "123a12b3cd4e5f67g890h1ij", "createdAt": "2025-01-01T00:00:000+0000", "criteria": "datetime", "firstLogin": { "datetime": "2025-01-01T00:00:000+0000", "operator": ">" }, "name": "dc-first-login" } ] |
| **People Managers** | VARIANT | A list of users and the specific people manager permissions they have |  | [ { "permissions": { "analyticsAndReports": true, "canManageGoals": true, "canViewComplianceReports": true, "canViewLearnPage": true, "insights": true, "manage": true }, "userId": "123a12b3cd4e5f67g890h1ij" } ] |
| 🚨**People Managers ID** | VARCHAR(16777216) | User ID of the people manager |  | 123a12b3cd4e5f67g890h1ij |
| 🚨**People Managers Permissions** | VARCHAR(16777216) | People manager permissions |  | null |
| **Should Be Structure** | BOOLEAN | Boolean indicator for structure (group of audiences = structure) | TRUE, FALSE, null | FALSE |
| Smart Rules | VARIANT | Modern version of legacy rules which allows for and/or logic to be incorporated Currently Thrive will utilise both smart and legacy rules for assigning users to a smart audiences |  | { "args": [ { "args": [ { "args": [ { "kind": "str", "val": "status" } ], "kind": "func", "val": "ref" }, { "kind": "str", "vals": [ "new", "active" ] } ], "kind": "func", "name": "fc-user-active", "val": "in" }, { "args": [ { "args": [ { "kind": "str", "val": "firstLogin" } ], "kind": "func", "val": "ref" }, { "kind": "date", "val": "2025-01-01T00:00:00" } ], "kind": "func", "name": "dc-first-login", "val": "gt" } ], "kind": "func", "val": "and" } |
| **Structure ID** | VARCHAR(16777216) | Identifier for the structure (group of audiences) |  | 123a12b3cd4e5f67g890h1ij |
| **Structure Name** | VARCHAR(16777216) | Name of the structure |  | Sales |
| **Structure-Audience Name** | VARCHAR(16777216) | Concatenation of the structure and audience names |  | Sales - Sales North East |
| **Tenant ID** | VARCHAR(16777216) | Identifier for the tenant |  | eu-west-2_abcdefGh1 |
| **Updated At** | TIMESTAMP_NTZ(9) | Timestamp of audience updates |  | 2025-01-01T00:00:00.000+0000 |
| **User Sharing** | VARCHAR(16777216) | User sharing information within the audience | audience, null, yes, no | yes |