# AgentRoles - Catalog: `Freshdesk` - Schema: `Views` This is a read-only view. The Freshdesk API may not support changing the data or the Invantive UniversalSQL driver for Freshdesk does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshdesk API. ## View Columns The columns of the view `AgentRoles` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `available_since` | `datetime` | Available since | ☐ | | | `available` | `char` | Available | ☐ | | | `contact_active` | `char` | Contact Active | ☐ | | | `contact_created_at` | `datetime` | Contact Created at | ☐ | | | `contact_email` | `varchar2` | Contact Email Address | ☐ | | | `contact_job_title` | `varchar2` | Contact Job Title | ☐ | | | `contact_language` | `varchar2` | Contact Language | ☐ | | | `contact_last_login_at` | `datetime` | Contact Last Login at | ☐ | | | `contact_mobile` | `varchar2` | Contact Mobile Phone | ☐ | | | `contact_name` | `varchar2` | Contact Name | ☐ | | | `contact_phone` | `varchar2` | Contact Phone | ☐ | | | `contact_time_zone` | `varchar2` | Contact Time Zone | ☐ | | | `contact_updated_at` | `datetime` | Contact Updated at | ☐ | | | `created_at` | `datetime` | Created at | ☐ | Date/time at which the record was created. | | `id` | `int64` | ID | ☐ | | | `occasional` | `char` | Occasional | ☐ | | | `role_id` | `int64` | | ☐ | | | `signature` | `varchar2` | Signature | ☐ | | | `ticket_scope` | `int64` | Ticket Scope | ☐ | | | `updated_at` | `datetime` | Updated at | ☐ | Date/time at which the record was last updated. |