# EmployeeBenefitById Find one - Catalog: `Robaws` - Schema: `Employees` - Select Robaws API URL: `/api/v2/employees/{id}` - Insert Robaws API URL: `/api/v2/employees/{id}` - Update Robaws API URL: `/api/v2/employees/{id}` - Delete Robaws API URL: `/api/v2/employees/{id}` - Field Selection Method: NotRequired - Base Path: `benefits[*]` - Select Robaws API Operation: `get /api/v2/employees/{id}` This is a read-only table function. The Robaws API may not support changing the data or the Invantive SQL driver for Robaws does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Robaws API. ## Columns of Table Function The columns of the table function `EmployeeBenefitById` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archivedAt` | `datetime` | | ☐ | | | `bankAccountNumber` | `string` | | ☐ | | | `civilStatus` | `string` | | ☐ | | | `collaborationEndDate` | `datetime` | | ☐ | | | `collaborationStartDate` | `datetime` | | ☐ | | | `competenceLevel` | `string` | Competence Level | ☐ | | | `costPerHour` | `decimal` | Cost per Hour | ☐ | | | `createdAt` | `datetime` | | ☐ | | | `dateOfBirth` | `datetime` | | ☐ | | | `deletedAt` | `datetime` | | ☐ | | | `dimonaExpirationDate` | `datetime` | | ☐ | | | `dimonaNumber` | `string` | | ☐ | | | `distance` | `decimal` | Distance | ☐ | | | `domicileAddress_addressLine1` | `string` | | ☐ | | | `domicileAddress_addressLine2` | `string` | | ☐ | | | `domicileAddress_city` | `string` | | ☐ | | | `domicileAddress_country` | `string` | | ☐ | | | `domicileAddress_latitude` | `double` | | ☐ | | | `domicileAddress_longitude` | `double` | | ☐ | | | `domicileAddress_postalCode` | `string` | | ☐ | | | `driverLicense` | `string` | Driver License | ☐ | | | `email` | `string` | Email | ☐ | | | `emergencyTel` | `string` | In Case of Emergency Phone | ☐ | | | `employeeRole_archivedAt` | `datetime` | | ☐ | | | `employeeRole_createdAt` | `datetime` | | ☐ | | | `employeeRole_deletedAt` | `datetime` | | ☐ | | | `employeeRole_id` | `string` | | ☐ | | | `employeeRole_name` | `string` | | ☐ | | | `employeeRole_updatedAt` | `datetime` | | ☐ | | | `employeeRoleId` | `string` | | ☐ | | | `employer_archivedAt` | `datetime` | | ☐ | | | `employer_createdAt` | `datetime` | | ☐ | | | `employer_deletedAt` | `datetime` | | ☐ | | | `employer_email` | `string` | | ☐ | | | `employer_fax` | `string` | | ☐ | | | `employer_generalLedgerAccount_archivedAt` | `datetime` | | ☐ | | | `employer_generalLedgerAccount_code` | `string` | | ☐ | | | `employer_generalLedgerAccount_createdAt` | `datetime` | | ☐ | | | `employer_generalLedgerAccount_deletedAt` | `datetime` | | ☐ | | | `employer_generalLedgerAccount_id` | `string` | | ☐ | | | `employer_generalLedgerAccount_name` | `string` | | ☐ | | | `employer_generalLedgerAccount_updatedAt` | `datetime` | | ☐ | | | `employer_generalLedgerAccountId` | `string` | | ☐ | | | `employer_gsm` | `string` | | ☐ | | | `employer_iban` | `string` | | ☐ | | | `employer_id` | `string` | | ☐ | | | `employer_invoiceAddress_addressLine1` | `string` | | ☐ | | | `employer_invoiceAddress_addressLine2` | `string` | | ☐ | | | `employer_invoiceAddress_city` | `string` | | ☐ | | | `employer_invoiceAddress_country` | `string` | | ☐ | | | `employer_invoiceAddress_latitude` | `double` | | ☐ | | | `employer_invoiceAddress_longitude` | `double` | | ☐ | | | `employer_invoiceAddress_postalCode` | `string` | | ☐ | | | `employer_invoiceRemarks` | `string` | | ☐ | | | `employer_kvk` | `string` | | ☐ | | | `employer_language` | `string` | | ☐ | | | `employer_legalForm_archivedAt` | `datetime` | | ☐ | | | `employer_legalForm_createdAt` | `datetime` | | ☐ | | | `employer_legalForm_deletedAt` | `datetime` | | ☐ | | | `employer_legalForm_id` | `string` | | ☐ | | | `employer_legalForm_legalAbbreviation` | `string` | | ☐ | | | `employer_legalForm_name` | `string` | | ☐ | | | `employer_legalForm_updatedAt` | `datetime` | | ☐ | | | `employer_legalForm_vatLiable` | `boolean` | | ☐ | | | `employer_legalFormId` | `string` | | ☐ | | | `employer_logicId` | `string` | | ☐ | | | `employer_name` | `string` | | ☐ | | | `employer_paymentConditionId` | `string` | | ☐ | | | `employer_planningEmail` | `string` | | ☐ | | | `employer_status` | `string` | | ☐ | | | `employer_supplyOrderRemarks` | `string` | | ☐ | | | `employer_tel` | `string` | | ☐ | | | `employer_updatedAt` | `datetime` | | ☐ | | | `employer_vatIdNumber` | `string` | | ☐ | | | `employer_vatTariff_additionalMention` | `string` | | ☐ | | | `employer_vatTariff_archivedAt` | `datetime` | | ☐ | | | `employer_vatTariff_category` | `string` | | ☐ | | | `employer_vatTariff_createdAt` | `datetime` | | ☐ | | | `employer_vatTariff_deletedAt` | `datetime` | | ☐ | | | `employer_vatTariff_description` | `string` | | ☐ | | | `employer_vatTariff_id` | `string` | | ☐ | | | `employer_vatTariff_name` | `string` | | ☐ | | | `employer_vatTariff_percentage` | `decimal` | | ☐ | | | `employer_vatTariff_updatedAt` | `datetime` | | ☐ | | | `employer_vatTariffId` | `string` | | ☐ | | | `employer_website` | `string` | | ☐ | | | `employerId` | `string` | | ☐ | | | `grossSalary` | `decimal` | Gross Salary | ☐ | | | `gsm` | `string` | Mobile | ☐ | | | `id` | `string` | ID | ☐ | | | `identityCardExpirationDate` | `datetime` | | ☐ | | | `identityCardNumber` | `string` | | ☐ | | | `image_archivedAt` | `datetime` | | ☐ | | | `image_contentType` | `string` | | ☐ | | | `image_createdAt` | `datetime` | | ☐ | | | `image_deletedAt` | `datetime` | | ☐ | | | `image_directory` | `boolean` | | ☐ | | | `image_id` | `string` | | ☐ | | | `image_name` | `string` | | ☐ | | | `image_parentId` | `string` | | ☐ | | | `image_previewUrl` | `string` | | ☐ | | | `image_size` | `int64` | | ☐ | | | `image_updatedAt` | `datetime` | | ☐ | | | `image_url` | `string` | | ☐ | | | `independentRegistration` | `boolean` | | ☐ | | | `limosaExpirationDate` | `datetime` | | ☐ | | | `limosaNumber` | `string` | | ☐ | | | `name` | `string` | Name | ☐ | | | `nationality` | `string` | Nationality | ☐ | | | `nssoIdNumber` | `string` | | ☐ | | | `nssoPayment` | `boolean` | | ☐ | | | `nssoPaymentExpirationDate` | `datetime` | | ☐ | | | `numberOfDependents` | `int32` | | ☐ | | | `planningGroup` | `string` | Planning Group | ☐ | | | `position` | `string` | | ☐ | | | `secondment` | `boolean` | | ☐ | | | `status` | `string` | Status | ☐ | | | `statute` | `string` | | ☐ | | | `subType` | `string` | Sub Type | ☐ | | | `surname` | `string` | Last Name | ☐ | | | `tel` | `string` | Phone | ☐ | | | `TEXT` | `string` | | ☐ | | | `type` | `string` | Type | ☐ | | | `updatedAt` | `datetime` | | ☐ | |