# EducationsByEmployeeId List of educations for an employee __Activity name :__ GetEducationsByEmployeeId Get list of educations for an employee Select loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/educations Insert loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/educations Update loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/educations Delete loket.nl (REST) API URL: /providers/employers/employees/{employeeId}/educations Select loket.nl (REST) API Operation: get /providers/employers/employees/{employeeId}/educations Insert loket.nl (REST) API Operation: post /providers/employers/employees/{employeeId}/educations - Catalog: `LoketNlRest` - Schema: `Education` - 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 | |---|:---:|:---:|:---:|---| | `employeeId` | `guid` | ☑ | | The unique identifier of the employee | ## Columns of Table Function The columns of the table function `EducationsByEmployeeId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `educationLevel_key` | `int32` | | ☐ | | | `educationLevel_value` | `string(80)` | | ☐ | | | `employeeCosts` | `double` | | ☐ | The costs of the education for the employee | | `employerCosts` | `double` | | ☐ | The costs of the education for the employer | | `endDate` | `datetime` | | ☐ | The end date of the entity. The date is up to and including. | | `endOfValidityDate` | `datetime` | | ☐ | The end date of the diploma validity . The date is up to and including. | | `furtherIndication_code` | `string` | | ☐ | | | `furtherIndication_description` | `string` | | ☐ | | | `furtherIndication_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `hasDiploma_key` | `int32` | | ☐ | | | `hasDiploma_value` | `string(80)` | | ☐ | | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `institute_city` | `string(24)` | | ☐ | City of the institute | | `institute_Name` | `string(70)` | | ☐ | Name of the institute | | `name` | `string(50)` | | ☐ | Name of the education | | `particularities` | `string(4000)` | | ☐ | Extra information about the education | | `startDate` | `datetime` | | ☐ | The date on which this education starts. | | `typeOfEducation_code` | `string` | | ☐ | | | `typeOfEducation_description` | `string` | | ☐ | | | `typeOfEducation_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `yearOfDiploma` | `int32` | | ☐ | Year in which the diploma was aquired |