# ActualOrganizationalEntitiesByEmployerId
List of actual organizational entities for an employer
__Activity name:__ GetActualOrganizationalEntitiesByEmployerId
Get the list of actual organizational entities for an employer
Select loket.nl (REST) API URL: /providers/employers/{employerId}/actualorganizationalentities
Insert loket.nl (REST) API URL: /providers/employers/{employerId}/actualorganizationalentities
Update loket.nl (REST) API URL: /providers/employers/{employerId}/actualorganizationalentities
Delete loket.nl (REST) API URL: /providers/employers/{employerId}/actualorganizationalentities
Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/actualorganizationalentities
- Catalog: `LoketNlRest`
- Schema: `Actuals`
- Field Selection Method: NotRequired
- Base Path: `_embedded[*]`
This is a read-only table function. 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.
## Parameters of Table Function
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `employerId` | `guid` | ☑ | | The unique identifier of the employer |
| `referenceDate` | `datetime` | ☐ | | Set a reference date for choosing the date dependent data. |
## Columns of Table Function
The columns of the table function `ActualOrganizationalEntitiesByEmployerId` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `employmentId` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `organizationalEntity_department_code` | `int32` | | ☐ | |
| `organizationalEntity_department_description` | `string` | | ☐ | |
| `organizationalEntity_department_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `organizationalEntity_deviatingFunctionDescription` | `string(50)` | | ☐ | The deviating function description of the employment. This description deviates from the value of the `function` field. |
| `organizationalEntity_deviatingFunctionGroup` | `string(5)` | | ☐ | The deviating function group description of the employment. Only applies when a deviating function description is defined. |
| `organizationalEntity_distributionUnit_code` | `int32` | | ☐ | |
| `organizationalEntity_distributionUnit_description` | `string` | | ☐ | |
| `organizationalEntity_distributionUnit_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `organizationalEntity_endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. |
| `organizationalEntity_function_description` | `string(50)` | | ☐ | |
| `organizationalEntity_function_group` | `string(5)` | | ☐ | |
| `organizationalEntity_function_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `organizationalEntity_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `organizationalEntity_internalTelephoneExtensionNumber` | `string(15)` | | ☐ | The phone number of the standard working location (standplaats) for the employment. |
| `organizationalEntity_placeOfEmployment` | `string(24)` | | ☐ | The standard working location (standplaats) for the employment. |
| `organizationalEntity_standardFunction_category` | `int32` | | ☐ | |
| `organizationalEntity_standardFunction_code` | `string(6)` | | ☐ | |
| `organizationalEntity_standardFunction_key` | `int32` | | ☐ | |
| `organizationalEntity_standardFunction_value` | `string` | | ☐ | |
| `organizationalEntity_startDate` | `datetime` | | ☐ | The start date of the entity. A (linked chain)[./#section/Data/Date-chains] is maintained within this resource. |