# DeclarationsForEmployer List of declarations for the employees of an employer __Activity name :__ GetDeclarationsByEmployerId Returns a list of declarations for the employments of the employer Select loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/declarations Insert loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/declarations Update loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/declarations Delete loket.nl (REST) API URL: /providers/employers/{employerId}/employees/employments/declarations Select loket.nl (REST) API Operation: get /providers/employers/{employerId}/employees/employments/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 | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | ## Columns of Table Function The columns of the table function `DeclarationsForEmployer` 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` | | ☐ | | | `employmentInformation_department_code` | `int32` | | ☐ | | | `employmentInformation_department_description` | `string` | | ☐ | | | `employmentInformation_department_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employmentInformation_employeeNumber` | `int32` | | ☐ | The employee number to uniquely identify an employee within an employer | | `employmentInformation_firstName` | `string(28)` | | ☐ | The first name, given name, forename or Christian name as part of a persons personal name. | | `employmentInformation_formattedName` | `string(82)` | | ☐ | Formatted name of the employee based on the value of `howToFormatLastName` | | `employmentInformation_function_description` | `string(50)` | | ☐ | | | `employmentInformation_function_group` | `string(5)` | | ☐ | | | `employmentInformation_function_key` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employmentInformation_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employmentInformation_incomeRelationshipNumber` | `int32` | | ☐ | The income relationship number that is required in the tax return. Together with the citizen service number (burgerservicenummer, BSN) and wage tax number, the income relationship number uniquely identifies an employment. | | `employmentInformation_payrollAdministration_clientNumber` | `int32` | | ☐ | The client number is a unique number for administrations that are used for payrolling. This field has no value if the administration is not used for payrolling. | | `employmentInformation_payrollAdministration_description` | `string(50)` | | ☐ | Description of the administration | | `employmentInformation_payrollAdministration_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `employmentInformation_payrollAdministration_name` | `string(70)` | | ☐ | Name of the payroll administration | | `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 |