# AchmeaInsuranceContractsByUserId
list of insurance contracts
__Activity name :__ GetAchmeaInsuranceContractsByUserId
Get a list of all Achmea insurance contracts accessible to the current user
Select loket.nl (REST) API URL: /achmeainsurancecontracts
Insert loket.nl (REST) API URL: /achmeainsurancecontracts
Update loket.nl (REST) API URL: /achmeainsurancecontracts
Delete loket.nl (REST) API URL: /achmeainsurancecontracts
Select loket.nl (REST) API Operation: get /achmeainsurancecontracts
- Catalog: `LoketNlRest`
- Schema: `Achmea`
- Field Selection Method: NotRequired
- Base Path: `_embedded[*]`
This is a read-only table. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API.
## Table Columns
The columns of the table `AchmeaInsuranceContractsByUserId` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `belongsToEmployerId` | `guid` | | ☐ | The unique identifier (a GUID/UUID) for the employer to which the Achmea isurance contract belongs. This id can be used for acquiring the list of employees for the employer. |
| `contractNumber` | `string(20)` | | ☐ | The contract number (Dutch: polisnummer) for the Achmea insurance contract. |
| `endDate` | `datetime` | | ☐ | The date at which the Achmea isurance contract ends. |
| `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `startDate` | `datetime` | | ☐ | The date at which the Achmea isurance contract starts. |