# ProviderLeavePoliciesByProviderId List of all the leave policies at provider level. __Activity name :__ GetProviderLeavePoliciesByProviderId Returns all the leave policies for the given provider. These leave policies can be used to define a leave policy at employer 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 | |---|:---:|:---:|:---:|---| | `providerId` | `guid` | ☑ | | The unique identifier of a provider | ## Columns The columns of the table `ProviderLeavePoliciesByProviderId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `accrualType_key` | `int32` | | ☐ | The key for the `accrualType` | | `accrualType_value` | `string` | | ☐ | The description for the `accrualType` | | `additionalLeave_allocationType_key` | `int32` | | ☐ | The key for the `additionalLeaveAllocationType` | | `additionalLeave_allocationType_value` | `string` | | ☐ | The description for the `additionalLeaveAllocationType` | | `additionalLeave_referenceDate1_day` | `int32` | | ☐ | The day of the first reference date. | | `additionalLeave_referenceDate1_month_key` | `int32` | | ☐ | The key for the `referenceMonth` | | `additionalLeave_referenceDate1_month_value` | `string` | | ☐ | The description for the `referenceMonth` | | `additionalLeave_referenceDate2_day` | `int32` | | ☐ | The day of the second reference date. | | `additionalLeave_referenceDate2_month_key` | `int32` | | ☐ | The key for the `referenceMonth` | | `additionalLeave_referenceDate2_month_value` | `string` | | ☐ | The description for the `referenceMonth` | | `dayOfTheMonthToPerformAutomaticLeaveCalculationOn` | `int32` | | ☐ | They day of the month on which the automatic accrual of (yearly or monthly) leave is performed. The yearly calculation is repeated every month to encompase any changes made that have affect on the past. If for example 31 is chosen and a specific month does not have that day the logic will pick the first available date of said month. | | `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. | | `leaveEntitlement_statutory` | `double` | | ☐ | The statutory leave (wetelijk verlof) linked employments are entitled to for a full time contract. | | `leaveEntitlement_wtr` | `double` | | ☐ | The wrt leave (ADV/ATV verlof) linked employments are entitled to for a full time contract. | | `leaveRequest_applyLeaveSchedule` | `boolean` | | ☐ | Indicates whether the leave schedule can be enterd and is so it is used when calculating the sugested leave hours for a leave request | | `leaveRequest_leavePattern_evenWeeks_friday` | `double` | | ☐ | | | `leaveRequest_leavePattern_evenWeeks_monday` | `double` | | ☐ | | | `leaveRequest_leavePattern_evenWeeks_saturday` | `double` | | ☐ | | | `leaveRequest_leavePattern_evenWeeks_sunday` | `double` | | ☐ | | | `leaveRequest_leavePattern_evenWeeks_thursday` | `double` | | ☐ | | | `leaveRequest_leavePattern_evenWeeks_tuesday` | `double` | | ☐ | | | `leaveRequest_leavePattern_evenWeeks_wednesday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_friday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_monday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_saturday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_sunday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_thursday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_tuesday` | `double` | | ☐ | | | `leaveRequest_leavePattern_oddWeeks_wednesday` | `double` | | ☐ | | | `leaveRequest_useHolidaysInCalculation` | `boolean` | | ☐ | Indicates whether the calculating for sugested leave hours for a leave request takes into account holidays. Is set to true no leave hours are calculated for "The historical date on which the employee was first employed. This field is used when an employee has multiple employments in time. In most cases this field should be used as the date on which the employee started working for the company." eg. When requesting leave for the 24th and 25th of december (25th being a national holiday) the calculation (8 hours a day) will return 8 when `useHolidaysInCalculation` is true and 16 when `useHolidaysInCalculation` is false | | `leaveUnitType_key` | `int32` | Leave Unit Type Key | ☐ | The key for the unit type | | `leaveUnitType_value` | `string` | Leave Unit Type Value | ☐ | The description for the leave unit type | | `name` | `string(50)` | Name | ☐ | The name of the leave policy | | `payoutLeaveImmediately` | `boolean` | | ☐ | If leave `accrualType` is set to based on hours worked (uren) then this field allows for the leave hours to be paid out directly instead of being accrued. | | `roundingMethod_key` | `int32` | | ☐ | The key for the roundingMethod | | `roundingMethod_value` | `string` | | ☐ | The description for the roundingMethod | | `roundTo_key` | `int32` | | ☐ | The key for the roundTo | | `roundTo_value` | `string` | | ☐ | The description for the roundTo |