# Departments - Catalog: `Freshservice` - Schema: `Freshservice` - Primary Keys: `id` This is a read-only table. The Freshservice API may not support changing the data or the Invantive UniversalSQL driver for Freshservice does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshservice API. ## Table Columns The columns of the table `Departments` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `aantal_users` | `string` | Aantal users | ☐ | Custom field #0 of type custom_text. | | `adres` | `string` | Adres | ☐ | Custom field #0 of type custom_text. | | `asp_klant` | `string` | AZURE klant | ☐ | Custom field #0 of type custom_text. | | `asp_klantcode` | `string` | Nocore online URL | ☐ | Custom field #0 of type custom_text. | | `created_at` | `datetime` | | ☐ | Date/time at which the record was created. | | `datum_aangemaakt` | `string` | Created date | ☐ | Custom field #0 of type custom_text. | | `debiteur_nummer` | `string` | Debiteur nummer | ☐ | Custom field #0 of type custom_text. | | `description_custom_field` | `string` | Description | ☐ | Custom field #0 of type custom_text. | | `description` | `string` | | ☐ | | | `domain_names` | `string` | Domains for This Department | ☐ | Custom field #0 of type custom_text. | | `einddatum` | `string` | End Date | ☐ | Custom field #0 of type custom_text. | | `facility_apps_gegevens` | `string` | Facility Apps data | ☐ | Custom field #0 of type custom_text. | | `geblokkeerd` | `string` | Blocked | ☐ | Custom field #0 of type custom_text. | | `head_name_custom_field` | `string` | Afdelingshoofd | ☐ | Custom field #0 of type custom_text. | | `head_name` | `string` | | ☐ | | | `head_user_id` | `int64` | | ☐ | | | `id` | `int64` | | ☑ | | | `loonbureau` | `string` | Loonbureau | ☐ | Custom field #0 of type custom_text. | | `name_custom_field` | `string` | Department Name | ☐ | Custom field #0 of type custom_text. | | `name` | `string` | | ☐ | | | `nocore_online` | `string` | Nocore Online | ☐ | Custom field #0 of type custom_text. | | `plaats` | `string` | City | ☐ | Custom field #0 of type custom_text. | | `prime_user_id` | `int64` | | ☐ | | | `prime_user_name_custom_field` | `string` | Primaire gebruiker | ☐ | Custom field #0 of type custom_text. | | `prime_user_name` | `string` | | ☐ | | | `sla` | `string` | SLA | ☐ | Custom field #0 of type custom_text. | | `systeembeheerder` | `string` | Systeembeheerder | ☐ | Custom field #0 of type custom_text. | | `telefoonnummer` | `string` | Phone Number | ☐ | Custom field #0 of type custom_text. | | `updated_at` | `datetime` | | ☐ | Date/time at which the record was last updated. | | `zoeknaam` | `string` | Zoeknaam | ☐ | Custom field #0 of type custom_text. |