# ProposedLeaveHoursByEmploymentId Get the proposed number of leave hours for an employment __Activity name :__ GetProposedLeaveHoursByEmploymentId Returns the numberOfHours (only in hours) calculated based on the employments working- hours/schedual __Note:__ The function will only work if the employment is either linked to no leave policy or linked to only leave policy(s) that use hours as the unit of leave. Further more how the leave hours are calculated can be managed in the leave policy with the `applyLeaveSchedule` and `working hours` resource with the field `calculateUsingWorkPattern.leaveHours` The order is as follows. If calculateUsingWorkPattern.leaveHours is true the work patern from workinghours is used otherwise if applyLeaveSchedule is set to true the `leavePattern` is used otherwise the workinghours are used 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: `Leave` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employmentId` | `guid` | ☑ | | The unique identifier of the employment | | `endDate` | `string` | ☐ | | The end date of the leave period | | `startDate` | `string` | ☐ | | The start date of the leave period | ## Columns The columns of the table `ProposedLeaveHoursByEmploymentId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `additionalInformation` | `string` | | ☐ | Provides additional information on the calculation. | | `employmentId` | `guid` | Employment ID | ☐ | The unique identifier (a GUID/UUID) | | `methodOfCalculation` | `string` | | ☐ | Indicates which method was used to calculate the proposed leave hours. | | `proposedLeaveHours` | `double` | | ☐ | The proposed number of leave hours |