# ProviderYearsOfServiceBasedLeaveByLeavePolicyId years of service based leave __Activity name :__ GetProviderYearsOfServiceBasedLeaveByLeavePolicyId Returns the years of service based leave for the given leave policy at providerlevel. 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 `ProviderYearsOfServiceBasedLeaveByLeavePolicyId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `from_numberOfMonths` | `int32` | | ☐ | the number of months of service to be applicable for the additional leave | | `from_numberOfYears` | `int32` | | ☐ | the number of years of service 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 | | `upToAndIncluding_numberOfMonths` | `int32` | | ☐ | the number of months of service to be applicable for the additional leave | | `upToAndIncluding_numberOfYears` | `int32` | | ☐ | the number of years of service to be applicable for the additional leave |