APP_ACTIVATE_USER_CHANNEL_DETAILS
Update: Nov 19:
Added: COMPANY_DISPLAY_NAME
Updated Nov 14 to include:
Table updated to include data_type column and removed table_name column
Update: Nov 5:
Added: CHANNEL_DISPLAY_NAME
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. |
HEAD_COUNT | NUMBER | The total number of members in the channel. |
IS_EMPLOYEE | BOOLEAN | A true/false value indicating whether the user is an employee of the company. |
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 12 days ago