# PayslipsByEmploymentId List of payslips for an employment __Activity name :__ GetPayslipsByEmploymentId __Availability:__ This is endpoint is available for the Loket.nl application only. It is not available for external parties Get a list of payslips for the specified employment, including the GUID of the corresponding payroll run. The function of this endpoint is dependent on the role of the user; * For users with the role of 'werknemer'; The endpoint only returns results for payrollruns that have the status 'approved' AND for which results of the payroll are available for ESS (based on the ESS-date of the payrollrun) . * For users with any other role (in most cases); the endpoin returns results for approved payrollruns irregardless of the ESS date. This is a read-only table function. The Loket.nl REST API may not support changing the data, or the Invantive UniversalSQL driver for Loket.nl REST does not support it. In the latter case, use the table NativePlatformScalarRequests to upload data to the Loket.nl REST API. - Catalog: `LoketNlRest` - Schema: `Payslip` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | ## Columns The columns of the table `PayslipsByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `approvalTime` | `datetime` | Approval Time | ☐ | The time at which the payslip was approved. | | `numberOfPayslips` | `int32` | Number of Payslips | ☐ | The number of different types of payslips for the given payroll period. | | `payrollPeriod_periodEndDate` | `datetime` | Payroll Period End Date | ☐ | The last day of the period for which the tax return message was created | | `payrollPeriod_periodNumber` | `int32` | Payroll Period Number | ☐ | The period number of the payroll period the record relates to | | `payrollPeriod_periodStartDate` | `datetime` | Payroll Period Start Date | ☐ | The first day of the period for which the tax return message was created | | `payrollPeriod_testYear` | `boolean` | Payroll Processing Period Test Year | ☐ | Indicates whether the payroll periode is part of a test year. In Loket it is possible to run a year of a payrolladministration as a so-called test year. This is typically done to test the configuration of a new payroll administration, by running payrollruns within the context of a test year. Please note: if the payroll run belongs to a test year the results of the run should not be regarded as actual data but as test data. | | `payrollPeriod_year` | `int32` | Payroll Processing Year Period | ☐ | The year of the payroll period the record relates to | | `payrollrunId` | `guid` | Payroll Run ID | ☐ | The unique identifier of an object (GUID/UUID) |