# PayrollComponentResultsByPayrollAdministrationIdAndPayrollComponent__embeddedPayrollComponentResults Get the results of the given payroll period and the one before __Activity name :__ GetPayrollComponentResultsByPayrollAdministrationIdAndPayrollComponent Returns the results of a specific payrollcomponent for a range of payroll periods so a comparison can be made. 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 | | `payrollPeriodIdEnd` | `int32` | ☑ | | The unique identifier of the payroll period | | `payrollPeriodIdStart` | `int32` | ☑ | | The unique identifier of the payroll period | ## Columns The columns of the table `PayrollComponentResultsByPayrollAdministrationIdAndPayrollComponent__embeddedPayrollComponentResults` 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) | | `payrollPeriod_periodNumber` | `int32` | Payroll Period Number | ☐ | The period number of the payroll period the record relates to | | `payrollPeriod_year` | `int32` | Payroll Processing Year Period | ☐ | The year of the payroll period the record relates to | | `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. |