# YearsOfServiceBasedLeaveByLeavePolicyId years of service based leave __Activity name :__ GetYearsOfServiceBasedLeaveByLeavePolicyId Returns the years of service based leave for the given leave policy. Select loket.nl (REST) API URL: /providers/employers/leavePolicies/{leavePolicyId}/yearsofservicebasedleave Insert loket.nl (REST) API URL: /providers/employers/leavePolicies/{leavePolicyId}/yearsofservicebasedleave Update loket.nl (REST) API URL: /providers/employers/leavePolicies/{leavePolicyId}/yearsofservicebasedleave Delete loket.nl (REST) API URL: /providers/employers/leavePolicies/{leavePolicyId}/yearsofservicebasedleave Select loket.nl (REST) API Operation: get /providers/employers/leavePolicies/{leavePolicyId}/yearsofservicebasedleave Insert loket.nl (REST) API Operation: post /providers/employers/leavePolicies/{leavePolicyId}/yearsofservicebasedleave - Catalog: `LoketNlRest` - Schema: `LeavePolicy` - Retrieve: true - Insert: true - Update: false - Delete: false - Field Selection Method: NotRequired - Base Path: `_embedded[*]` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `leavePolicyId` | `guid` | ☑ | | The unique identifier of the leave policy | ## Columns of Table Function The columns of the table function `YearsOfServiceBasedLeaveByLeavePolicyId` 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` | | ☐ | 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 |