# ProviderWageBasedLeaveByLeavePolicyId Wage based leave __Activity name :__ GetProviderWageBasedLeaveByLeavePolicyId Returns the wage based leave for the given leave policy at provider level. 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: `ProviderLeavePolicy` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `leavePolicyId` | `guid` | ☑ | | The unique identifier of the leave policy | ## Columns The columns of the table `ProviderWageBasedLeaveByLeavePolicyId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `fromWage` | `double` | | ☐ | the from wage the employment has to earn to be applicable for the additional leave | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `leaveEntitlement_excessLeaveToStatutory` | `double` | | ☐ | The excess leave (bovenwetelijk verlof) linked employments are entitled to for a full time contract. Either excessLeaveToStatutory or wtr must have a value | | `leaveEntitlement_wtr` | `double` | | ☐ | The wrt leave (ADV/ATV verlof) linked employments are entitled to for a full time contract. Either excessLeaveToStatutory or wtr must have a value | | `upToAndIncludingWage` | `double` | | ☐ | the up to and including wage the employment has to earn to be applicable for the additional leave |