# DepartmentsByEmployerId
List of departments
__Activity name :__ GetDepartmentsByEmployerId
Get a list of all departments for the employer. This is the point where the departments available for use at employment level (organizational entity) are managed.
Select loket.nl (REST) API URL: /providers/employers/{employerId}/departments
Insert loket.nl (REST) API URL: /providers/employers/{employerId}/departments
Update loket.nl (REST) API URL: /providers/employers/{employerId}/departments
Delete loket.nl (REST) API URL: /providers/employers/{employerId}/departments
Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/departments
Insert loket.nl (REST) API Operation: post /providers/employers/{employerId}/departments
- Catalog: `LoketNlRest`
- Schema: `Departments`
- Retrieve: true
- Insert: true
- Update: false
- Delete: false
- Field Selection Method: NotRequired
- Base Path: `_embedded[*]`
## Parameters of Table Function
| Name | Data Type | Required | Default Value | Documentation |
|---|:---:|:---:|:---:|---|
| `employerId` | `guid` | ☑ | | The unique identifier of the employer |
## Columns of Table Function
The columns of the table function `DepartmentsByEmployerId` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `code` | `int32` | | ☐ | The visible identifier of the department. |
| `description` | `string(50)` | | ☐ | The visible description (i.e. name) of the department. |
| `emailLeaveRequest` | `string(255)` | | ☐ | Recipient e-mail adress for notification in case of leave requests. Typically this is the mailadress of a manager that would get a notification mail when a new leave requet is to be processed. |
| `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `subDepartmentOf_code` | `int32` | | ☐ | |
| `subDepartmentOf_description` | `string(50)` | | ☐ | |
| `subDepartmentOf_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |