# PayrollPeriodResultPayrollPeriodPayslipTypePayrollComponentResultsByPayrollAdministrationIdAndPayrollPeriodId Get payroll results for the given payroll period __Activity name :__ GetPayrollPeriodResultsByPayrollAdministrationIdAndPayrollPeriodId Returns the payroll results for the payroll period. __Note :__ This endpoint is related to the `GetPayrollRunResultsByPayrollRunId` endpoint. Both endpoints return the same output just in a different way. This endpoint returns the current state of the payroll results for the given period where as `GetPayrollRunResultsByPayrollRunId` returns the payroll results for the given payroll run (a payroll run can contain payroll results for multiple payroll periods). It's possible for payroll results to be created after the end of the payroll period it zelf. For example, the payroll periode 01-2020 ends at 31-01-2020 (in case of a monthly payroll period) it is possible that the payroll run for period 07-2020 contains payroll results for the period 01-2020 due to a retroactivity change for that period. This change in the payroll run for payroll period 07-2020 would require the system to reaquire the results for period 01-2020 (as they changed). 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: `PayrollResults` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | | `payrollComponentSet` | `guid` | ☐ | | A predefined set of payroll components to filter what payroll components are returned | | `payrollPeriodId` | `int32` | ☑ | | The unique identifier of the payroll period | ## Columns The columns of the table `PayrollPeriodResultPayrollPeriodPayslipTypePayrollComponentResultsByPayrollAdministrationIdAndPayrollPeriodId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) | | `payrollComponent_category_key` | `int32` | Payroll Component Category Key | ☐ | | | `payrollComponent_category_value` | `string` | Payroll Component Category Value | ☐ | | | `payrollComponent_column_key` | `int32` | | ☐ | | | `payrollComponent_column_value` | `string` | | ☐ | | | `payrollComponent_costsEmployer_key` | `int32` | | ☐ | | | `payrollComponent_costsEmployer_value` | `string` | | ☐ | | | `payrollComponent_key` | `int32` | Payroll Component Key | ☐ | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know many of them by heart. | | `payrollComponent_value` | `string(14)` | | ☐ | The description of the payroll component | | `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 | | `payslipType_key` | `int32` | Payslip Type Key | ☐ | | | `payslipType_value` | `string` | Payslip Type Value | ☐ | | | `value` | `decimal` | Value | ☐ | Value/ amount (normaal tarief voor belasting, tabelloon) for the payrollcomponent. Only a 'normal' type payslip may have value for this. | | `valueSpecialTariff` | `decimal` | Special Rate Value | ☐ | Value/ amount (speciaal tarief voor belasting) for the payrollcomponent. Both a 'normal' and 'special tariff' type payslip may a value for this. Also, both valueNormal and valueSpecialTariff may have a value at the same time. |