# DeclarationsByEmploymentId List of declarations for an employment __Activity name :__ GetDeclarationsByEmploymentId Returns a list of declarations for the employments of the employer Select loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/declarations Insert loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/declarations Update loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/declarations Delete loket.nl (REST) API URL: /providers/employers/employees/employments/{employmentId}/declarations Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/{employmentId}/declarations - Catalog: `LoketNlRest` - Schema: `Declarations` - 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 | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | ## Columns of Table Function The columns of the table function `DeclarationsByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `dateOfLastChangeByEmployee` | `datetime` | | ☐ | The time the declaration was last changed | | `dateOfSubmissionByEmployee` | `datetime` | | ☐ | The time the declaration was submitted | | `declarationComment` | `string(4000)` | | ☐ | The comment left by the employee | | `declarationDate` | `datetime` | | ☐ | The date to which the declaration is applicable. As requested by the employee. | | `declarationStatus_key` | `int32` | | ☐ | | | `declarationStatus_value` | `string` | | ☐ | | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `numberOfUnits` | `double` | | ☐ | The number of units requested | | `payrollComponent_description` | `string(14)` | | ☐ | The description of the payroll component | | `payrollComponent_key` | `int32` | | ☐ | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know it by heart. | | `processedInPayrollPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the period | | `processedInPayrollPeriod_periodNumber` | `int32` | | ☐ | The period (month [1 to 12] , 4 weeks [1 to 13] or week [1 to 53]) of the payroll period | | `processedInPayrollPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the period | | `processedInPayrollPeriod_year` | `int32` | | ☐ | The year of the payroll period |