# PayrollrunInitiationvaluesByPayrollAdministrationIdAndPeriodId Initiationvalues of a payrollrun __Activity name :__ GetPayrollrunInitiationvaluesByPayrollAdministrationIdAndPeriodId Get the initiation values for initiating a payrollrun for a specific period. Select loket.nl (REST) API URL: /providers/employers/payrolladministrations/{payrollAdministrationId}/payrollruns/{periodId}/initiationvalues Insert loket.nl (REST) API URL: /providers/employers/payrolladministrations/{payrollAdministrationId}/payrollruns/{periodId}/initiationvalues Update loket.nl (REST) API URL: /providers/employers/payrolladministrations/{payrollAdministrationId}/payrollruns/{periodId}/initiationvalues Delete loket.nl (REST) API URL: /providers/employers/payrolladministrations/{payrollAdministrationId}/payrollruns/{periodId}/initiationvalues Select loket.nl (REST) API Operation: get /providers/employers/payrolladministrations/{payrollAdministrationId}/payrollruns/{periodId}/initiationvalues - Catalog: `LoketNlRest` - Schema: `InitiatePayrollRun` - Field Selection Method: NotRequired - Base Path: `content` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `payrollPeriodId` | `int32` | ☑ | | The unique identifier of the payroll period | | `payrollrunId` | `guid` | ☑ | | The unique identifier of the payroll run | ## Columns of Table Function The columns of the table function `PayrollrunInitiationvaluesByPayrollAdministrationIdAndPeriodId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `availableForEmployeeDate` | `datetime` | | ☐ | The date on which the pay slips will be available to employees. | | `emailAddressPayrollRunApproved` | `string` | | ☐ | The email address to send an email to, after starting the payroll run has been approved." | | `emailAddressPayrollRunFinished` | `string` | | ☐ | The email address to send an email to, after the payroll run has been calculated. | | `emailAddressPayrollRunStarted` | `string` | | ☐ | The email address to send an email to, after starting the payroll run proces. | | `payrollPeriod_periodEndDate` | `datetime` | | ☐ | The last day of the period for which the tax return message was created | | `payrollPeriod_periodNumber` | `int32` | | ☐ | The period number of the payroll period the record relates to | | `payrollPeriod_periodStartDate` | `datetime` | | ☐ | The first day of the period for which the tax return message was created | | `payrollPeriod_testYear` | `boolean` | | ☐ | 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` | | ☐ | The year of the payroll period the record relates to | | `sendEmailToEmployee` | `boolean` | | ☐ | Indicates whether an email should be sent to the employees when the pay slip is available to them. |