ACTIVATE_USER_CHANNEL_DETAILS
Update: May 28, 2025
- PRIMARY_COMPANY_ID has been deprecated and will appear blank - this field will be removed in the future
- Primary locations will be excluded for a user if the user's primary location does not belong to the account receiving the export. In those cases, the following will now be displayed in the export:
- PRIMARY_LOCATION_ID = '00000000-0000-0000-0000-000000000000'
- PRIMARY_LOCATION_NAME = 'other'
Update: Nov 19, 2024
Added: COMPANY_DISPLAY_NAME
Update: Nov 14, 2024
Table updated to include data_type column and removed table_name column
Update: Nov 5
Added: CHANNEL_DISPLAY_NAME
Table Schema
| column_name | data_type | description |
|---|---|---|
| ACTIVATE_USER_ID | TEXT | The unique ID number assigned to each user in the company's internal system. |
| ACTIVATE_USER_NAME | TEXT | The full name of the user associated with the activate_user_id. |
| ALL_GROUP_ROLES | TEXT | All of the roles and groups that the user belongs to within the company. |
| ALL_PERMISSIONS | TEXT | All of the access permissions granted to the user within the company's systems. |
| CHANNEL_DISPLAY_NAME | TEXT | Display name of the channel associated with the channel_id |
| CHANNEL_ID | TEXT | The unique ID number assigned to each channel in the company's internal system. |
| CHANNEL_NAME | TEXT | The name of the channel that the user has access to. |
| CHANNEL_TYPE | TEXT | The category or type of channel, e.g. public, private, or direct message. |
| CHILDREN_CHANNEL_IDS | VARIANT | The IDs of any sub-channels nested within the parent channel. |
| COMPANY_CHANNEL_ID | TEXT | The Channel ID of the company channel the user first joined |
| COMPANY_NAME | TEXT | The name of the company channel that the user first joined |
| DOMAIN | TEXT | The website domain associated with the company and its channels. |
| EMAIL_OPT_IN | BOOLEAN | Whether the user has opted in for marketing email notifications |
| FIRST_CHANNEL_ACTIVITY_AT | TIMESTAMP_NTZ | The timestamp of the user's first activity within the channel. |
| IS_WORKPLACE_ADMIN | BOOLEAN | A true/false value indicating whether the user has admin permissions for the channel. |
| IS_WORKPLACE_MEMBER | BOOLEAN | A true/false value indicating whether the user is a member of the channel. |
| JOINED_CHANNEL_AT | TIMESTAMP_NTZ | The timestamp when the user first joined or was added to the channel. |
| LANGUAGE_PREFERENCE | TEXT | The preferred language setting for the user's account. |
| LAST_BOOKED | TIMESTAMP_NTZ | The timestamp of the user's most recent booking activity within the channel. |
| PARENT_CHANNEL_IDS | VARIANT | The IDs of all channels directly above the current channel in the channel hierarchy. |
| PARENT_CHANNEL_NAME | TEXT | The name of the channel directly above the current channel in the channel hierarchy. |
| PARENT_ID | TEXT | The ID of the channel directly above the current channel in the channel hierarchy. |
| PARENT_PERMISSIONS | TEXT | The permissions inherited by the current channel from channels higher in the hierarchy. |
| PRIMARY_COMPANY_ID | TEXT | The ID of the user's primary company. |
| PRIMARY_LOCATION_ID | TEXT | The ID of the user's primary location. |
| PRIMARY_LOCATION_NAME | TEXT | The name of the user's primary location channel. |
| USER_CREATED_AT | TIMESTAMP_NTZ | The timestamp when the user's account was first created. |
| USER_EMAIL | TEXT | The email address associated with the user's account. |
| USER_LAST_SEEN_AT | TIMESTAMP_NTZ | The timestamp of the user's most recent activity within the company's systems. |
| USER_STATUS | TEXT | The status of the user's account, e.g. active, inactive, suspended, etc. |
| COMPANY_DISPLAY_NAME | TEXT | The display name of the company channel that the the user first joined |
Updated 5 months ago