# WorkRelatedCostsSchemeMatrixByPayrollAdministrationId Work related costs scheme matrix (WKR) __Activity name:__ GetWorkRelatedCostsSchemeMatrixByPayrollAdministrationId Get the work related costs scheme matrix data (WKR) for a specific payroll 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: `WorkRelatedCostsScheme` ## 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 `WorkRelatedCostsSchemeMatrixByPayrollAdministrationId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `discretionaryScopeCumulative` | `decimal` | | ☐ | The amount of the given record | | `payrollPeriod_periodEndDate` | `datetime` | Payroll Period End Date | ☐ | The last day of the payroll period | | `payrollPeriod_periodNumber` | `int32` | Payroll Period Number | ☐ | The period number of the payroll period | | `payrollPeriod_periodStartDate` | `datetime` | Payroll Period Start Date | ☐ | The first day of the payroll period | | `payrollPeriod_year` | `int32` | Payroll Processing Year Period | ☐ | The year of the payroll period | | `workRelatedCostsCumulative` | `decimal` | | ☐ | The amount of the given record |