user

Table Type: Metadata

This table contains the users in the system.

Columns

Column Type Modifiers Notes
id string Primary Key The ID of the user
db_last_updated datetime The last time the record was updated in the database
db_when_created datetime The time the record was created in the database
db_when_deleted datetime The time the record was deleted in the database or NULL
state string The user status - active, inactive or deleted
name string The name of the user. Prefer this when we want to show a user's name.
division_id string The division ID of the user
chat_jabber_id string
department string The department name the user is in
email string The user's email address
title string The user's title (Mr/Mrs/Miss/Ms etc.)
username string The user's username
manager_id string The ID of the user's manager
manager_name string The name of the user's manager
employer_info_official_name string
employer_info_employee_id string
employer_info_employee_type string
employer_info_date_hire string
preferred_name string
geolocation_id string The ID of the geolocation
geolocation_name string The name of the geolocation
geolocation_type string A string used to describe the type of client the geolocation is being updated from e.g. ios, android, web, etc.
geolocation_latitude double The latitude of the user's geolocation
geolocation_longitude double The longitude of the user's geolocation
geolocation_country string The country of the user's geolocation
geolocation_region string The region of the user's geolocation
geolocation_city string The city of the user's geolocation
team_id string The ID of the team the user is in
acd_auto_answer boolean Whether ACD auto answer is enabled for the user
language_preference string The user's language preference
date_last_login datetime The date the user last logged in
location_id string The ID of the location the user is normally in

Actions and Background Tasks

Actions