The purpose of BRG_USER_AUDIENCE is to join to DIM_AUDIENCE_SERVICE_AUDIENCES, many to 1, and DIM_USER_SERVICE_USERS, many to 1, to establish the names of audiences (and structures) individual users are a part of
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Audience ID | VARCHAR(16777216) | Identifier for the audience (user group) | 123a12b3cd4e5f67g890h1ij | |
Audience Origin | VARCHAR(16) | Flag to show how the user is associated with the audience; either an audience, direct or indirect | Direct Reports, Audiences, Indirect Reports | Indirect Reports |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User Full Name | VARCHAR(16777216) | User details | John Smith | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |