The purpose of DIM_USER_SERVICE_USERS_ADDITIONAL_FIELDS is to show the additional field (custom field) key and value for each user within the platform. It should be joined to DIM_USER_SERVICE_USERS on User ID, 1 to many
Users who do not have any additional (custom) fields will still be included in this table, the Additional Field Key will show ‘no custom field’ and the Additional Field Value will show ‘not populated’
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Additional Field Key | VARCHAR(16777216) | Additional custom field - column name | department | |
Additional Field Value | VARCHAR(16777216) | Additional custom field - column value | Sales | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |