# LeaveRequestByLeaveRequestId Details of a leave request __Activity name :__ GetLeaveRequestByLeaveRequestId Get the details of a single leave request Select loket.nl (REST) API URL: /providers/employers/employees/employments/leaverequests/{leaveRequestId} Insert loket.nl (REST) API URL: /providers/employers/employees/employments/leaverequests/{leaveRequestId} Update loket.nl (REST) API URL: /providers/employers/employees/employments/leaverequests/{leaveRequestId} Delete loket.nl (REST) API URL: /providers/employers/employees/employments/leaverequests/{leaveRequestId} Select loket.nl (REST) API Operation: get /providers/employers/employees/employments/leaverequests/{leaveRequestId} - Catalog: `LoketNlRest` - Schema: `LeaveRequest` - Field Selection Method: NotRequired - Base Path: `content` This is a read-only table function. The loket.nl (REST) API may not support changing the data or the Invantive SQL driver for loket.nl (REST) does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the loket.nl (REST) API. ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `leaveRequestId` | `guid` | ☑ | | The unique identifier of the leave request | ## Columns of Table Function The columns of the table function `LeaveRequestByLeaveRequestId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `commentEmployee` | `string(4000)` | | ☐ | The comment left by the employee | | `commentHandler` | `string(4000)` | | ☐ | The comment left by the person handling the leave request | | `currentlyAvailableUnits` | `double` | | ☐ | The number of leave units (of the leaveType for this leave request) available to the employment. This value can be negative. | | `endDate` | `datetime` | | ☐ | The end date of the leave requested (last day of the leave) | | `handledBy_formattedName` | `string` | | ☐ | preformated user name for displaying. <lastname>", "<initials>" "<prefix> | | `handledBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `handledBy_initials` | `string(6)` | | ☐ | The initials of the user | | `handledBy_lastName` | `string(25)` | | ☐ | The last name of the user | | `handledBy_prefix` | `string(10)` | | ☐ | The prefix of the user | | `handledTime` | `datetime` | | ☐ | The date and time the leave request was handled | | `id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `isAccrual` | `boolean` | | ☐ | Indicates whether the request is for accrual of leave. - false will result in a reduction of the employee's leave entitlement - true will result in an increase of the employee's leave entitlement | | `leaveRequestStatus_key` | `int32` | | ☐ | | | `leaveRequestStatus_value` | `string` | | ☐ | | | `leaveType_key` | `int32` | | ☐ | | | `leaveType_value` | `string` | | ☐ | | | `numberOfUnits` | `double` | | ☐ | The number of leave units requested | | `startDate` | `datetime` | | ☐ | The start date of the leave requested | | `submittedBy_dateOfBirth` | `datetime` | | ☐ | The date of birth | | `submittedBy_employeeNumber` | `int32` | | ☐ | The employee number to uniquely identify a employee within a employer. | | `submittedBy_firstName` | `string(28)` | | ☐ | The first name of the employee | | `submittedBy_formattedName` | `string(82)` | | ☐ | Formatted name of the employee based on the value of `howToFormatLastName` | | `submittedBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `submittedBy_initials` | `string(6)` | | ☐ | The initials of the employee | | `submittedBy_lastName` | `string(25)` | | ☐ | The last name of the employee | | `submittedBy_lastNamePartner` | `string(25)` | | ☐ | The last name of the partner of the employee | | `submittedBy_photo` | `string` | | ☐ | A photo of the employee to use as a avatar/profile picture. The last part of the returned endpoint is the version of the logo this allows users to cache the image. Changing the value of the version will not influence the output. | | `submittedBy_prefix` | `string(10)` | | ☐ | The prefix of the employee | | `submittedBy_prefixPartner` | `string(10)` | | ☐ | The prefix of the partner of the employee | | `submittedOn` | `datetime` | | ☐ | The time the leave request was submitted | | `unitType_key` | `int32` | | ☐ | The key for the unit type | | `unitType_value` | `string` | | ☐ | The description for the unit type |