# PayrollRunsByPayrollAdministrationId List of payroll runs for an administration __Activity name :__ GetPayrollRunsByPayrollAdministrationId A list of payroll runs for an administration 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: `PayrollRun` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollAdministrationId` | `guid` | ☑ | | The unique identifier of an administration | ## Columns The columns of the table `PayrollRunsByPayrollAdministrationId` 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 payroll run was approved by the user | | `approvedBy_formattedName` | `string` | Approved By Formatted Name | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `approvedBy_id` | `guid` | Approved By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `approvedBy_initials` | `string(6)` | Approved By Initials | ☐ | The initials of the user | | `approvedBy_lastName` | `string(25)` | Approved By Last Name | ☐ | The last name of the user | | `approvedBy_prefix` | `string(10)` | Approved By Name Prefix | ☐ | The prefix of the user | | `availableForEmployeeDate` | `datetime` | Date Available to Employee | ☐ | The date on which the pay slips will be available to employees. | | `errorsAndWarnings_hasErrors` | `boolean` | | ☐ | Indicates whether the payrollrun has errors | | `errorsAndWarnings_hasWarnings` | `boolean` | | ☐ | Indicates whether the payrollrun has warnings | | `errorsAndWarningsHasErrors` | `boolean` | | ☑ | | | `errorsAndWarningsHasWarnings` | `boolean` | | ☑ | | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `methodOfCreation_key` | `int32` | Creation Method Key | ☐ | The key indicating how the payroll run was created. | | `methodOfCreation_value` | `string` | Creation Method Value | ☐ | The value describing how the payroll run was created. | | `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 | | `payrollRunStatus_key` | `int32` | Payroll Processing Status Key | ☐ | The key indicating the current status of the payroll run. | | `payrollRunStatus_value` | `string` | Payroll Processing Status Value | ☐ | The value describing the current status of the payroll run. * Ready for payroll processing. (key = 0) * Payroll processing completed. (key = 1) * Pro forma payroll processing completed. (key = 2) * Deleted by user (key = 5) * Payroll processing cancelled by user. (key = 6) * Error during payroll processing. (key = 7) * No payroll results, payroll processing cancelled. (key = 8) * Payroll processing approved. (key = 9) | | `payrollTaxReturnPeriod_periodNumber` | `int32` | | ☐ | The period number of the payroll period the record relates to | | `payrollTaxReturnPeriod_year` | `int32` | | ☐ | The year of the payroll period the record relates to | | `processingFinishedTime` | `datetime` | Processing Time | ☐ | Date-time when the calculations of the wages was finished | | `removedBy_formattedName` | `string` | Deleted By Name | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `removedBy_id` | `guid` | Deleted By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `removedBy_initials` | `string(6)` | Deleted By Initials | ☐ | The initials of the user | | `removedBy_lastName` | `string(25)` | Deleted By Last Name | ☐ | The last name of the user | | `removedBy_prefix` | `string(10)` | Deleted By Name Prefix | ☐ | The prefix of the user | | `removeTime` | `datetime` | Deletion Time | ☐ | The time at which the pay roll run was removed. | | `requestedBy_formattedName` | `string` | Requested By Formatted Name | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `requestedBy_id` | `guid` | Requested By ID | ☐ | The unique identifier of an object (GUID/UUID) | | `requestedBy_initials` | `string(6)` | Requested By Initials | ☐ | The initials of the user | | `requestedBy_lastName` | `string(25)` | Requested By Last Name | ☐ | The last name of the user | | `requestedBy_prefix` | `string(10)` | Requested By Name Prefix | ☐ | The prefix of the user | | `requestTime` | `datetime` | Request Time | ☐ | The time at which the payroll run was requested by the user | | `sendEmailToEmployee` | `boolean` | Send Email to Employee | ☐ | Indicates whether an email should be sent to the employees when the pay slip is available to them. NULL will be seen as false | | `sequenceNumber` | `int32` | Sequence Number | ☐ | An incremental number with a payrolling year to uniquely identify a payroll run. Null can be returned for those runs that dont contain "wages". | | `sequenceNumberApproved` | `int32` | Approved Sequence Number | ☐ | An incremental number with a payrolling year to uniquely identify an approved payroll run. | | `textPayment` | `string(32)` | Payment Text | ☐ | An optional text provided by an authorized user that will be displayed as a description for the payment. | | `textPaySlip` | `string(25)` | Payslip Text | ☐ | An optional text provided by an authorized user that will be displayed on the pay slip. | | `textTariffPaySlip` | `string(25)` | Payslip Rate Text | ☐ | An additional text to be displayed on the tariff payslip. |