# InformationForEmployerUserDeleteByEmployerIdAndUserId Information about the employer user to determine if the user can be deleted __Activity name :__ GetInformationForEmployerUserDeleteByEmployerIdAndUserId Get information about the user to determine if the user can be deleted or unlinked from the given employer. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `EmployerUser` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `userId` | `guid` | ☑ | | The unique identifier of an user | ## Columns The columns of the table `InformationForEmployerUserDeleteByEmployerIdAndUserId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `numberOfActiveConnections` | `int32` | | ☐ | Indicates if the user still has active connections (connections with externe software by means of an Oauth flow. e.g. Exact online, Twinfield and Accountview connections for journal data). | | `numberOfActiveIntegrations` | `int32` | | ☐ | Indicates if the user still has active integrations. Integrations are other Oauth clients that by means of the Oauth flow gained access to the loket API. | | `numberOfLinkedEmployers` | `int32` | | ☐ | If a user is linked to multiple employers the user has to be unlinked from all but one employer befor the user can be truly deleted. Both actions have their own endpoint * DeleteEmployerUserByUserId * DeleteLinkBetweenEmployerUserAndEmployerByEmployerIdAndUserId | | `numberOfUnreadNotifications` | `int32` | | ☐ | Indicates if the user still has unread notifications. If the user has unread notifications they can be transfered to another user with access to the same employer |