# PayrollResultsByPayrollRunId Payroll results for a payrollrun __Activity name :__ GetPayrollResultsByPayrollRunId Returns the payroll results and information on the employments for a given payrollrun. __Note :__ This endpoint is related to the `GetPayrollResultsByPayrollAdministrationId` endpoint. 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 | |---|:---:|:---:|:---:|---| | `payrollComponentSetId` | `guid` | ☐ | | A predefined set of payroll components to filter what payroll components are returned | | `payrollrunId` | `guid` | ☑ | | The unique identifier of the payroll run | ## Columns The columns of the table `PayrollResultsByPayrollRunId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employee_dateOfBirth` | `datetime` | Employee Date of Birth | ☐ | The date of birth | | `employee_employeeNumber` | `int32` | | ☐ | The employee number to uniquely identify a employee within a employer. | | `employee_formattedName` | `string(82)` | Employee Formatted Name | ☐ | Formatted name of the employee based on the value of `howToFormatLastName` | | `employee_gender` | `string(50)` | | ☐ | | | `employer_companyName` | `string` | | ☐ | Company name | | `employer_employerNumber` | `int32` | | ☐ | The employer number is used in various overviews and exports to identify a specific employer in Loket (please note: this is not the identifier used in the REST API). | | `employment_endDate` | `datetime` | | ☐ | The date on which the employment ends. | | `employment_organizationalEntity_department_code` | `int32` | | ☐ | | | `employment_organizationalEntity_department_description` | `string` | | ☐ | | | `employment_organizationalEntity_distributionUnit_code` | `int32` | | ☐ | | | `employment_organizationalEntity_distributionUnit_description` | `string` | | ☐ | | | `employment_organizationalEntity_function_code` | `int32` | | ☐ | | | `employment_organizationalEntity_function_description` | `string(50)` | | ☐ | | | `employment_payrollId` | `int32` | | ☐ | The payrolling number for this employment of the employee. Used by the payroll engine. This number is automatically generated and cannot be changed by the user. | | `employment_startDate` | `datetime` | | ☐ | The date on which this employment starts. | | `employment_workinghours_deviatingHoursPerWeek` | `double` | | ☐ | Fulltime hours are normally based as defined by the shift, this optional field is used to register a deviating value. The value can be less or more then the fulltime hours a week. | | `employment_workinghours_shift_fullTimeHoursPerWeek` | `decimal` | | ☐ | The full time hours for an employment that is linked to this shift. | | `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. | | `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 | | `payrollResults_payrollComponent_category_key` | `int32` | | ☐ | | | `payrollResults_payrollComponent_category_value` | `string` | | ☐ | | | `payrollResults_payrollComponent_column_key` | `int32` | | ☐ | | | `payrollResults_payrollComponent_costsEmployer_key` | `int32` | | ☐ | | | `payrollResults_payrollComponent_costsEmployer_value` | `string` | | ☐ | | | `payrollResults_payrollComponent_key` | `int32` | | ☐ | The number for the payroll component. This number has meaning to payroll professionals using Loket.nl who often know many of them by heart. | | `payrollResults_payrollComponent_value` | `string(14)` | | ☐ | The description of the payroll component | | `payrollResults_value` | `decimal` | | ☐ | Value/ amount (normaal tarief voor belasting, tabelloon) for the payrollcomponent. Only a 'normal' type payslip may have value for this. | | `payrollResults_valueSpecialTariff` | `decimal` | | ☐ | 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. |