# LeaveRequestsByEmployer List of leave requests for the employees of an employer __Activity name :__ GetLeaveRequestsByEmployerId Returns a list of leave requests for the employments of the employer 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: `LeaveRequest` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | ## Columns The columns of the table `LeaveRequestsByEmployer` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `commentEmployee` | `string(4000)` | Employee Comment | ☐ | The comment left by the employee | | `commentHandler` | `string(4000)` | Handler Comment | ☐ | 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` | End Date | ☐ | 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` | Handled by ID | ☐ | The unique identifier of an object (GUID/UUID) | | `handledBy_initials` | `string(6)` | Handled by Initials | ☐ | The initials of the user | | `handledBy_lastName` | `string(25)` | Handled by Last Name | ☐ | The last name of the user | | `handledBy_prefix` | `string(10)` | Handled by Prefix | ☐ | The prefix of the user | | `handledTime` | `datetime` | Handling Date | ☐ | The date and time the leave request was handled | | `id` | `guid` | ID | ☐ | 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` | Leave Type Key | ☐ | | | `leaveType_value` | `string` | Leave Type Value | ☐ | | | `numberOfUnits` | `double` | Number of Units | ☐ | The number of leave units requested | | `startDate` | `datetime` | Start Date | ☐ | 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` | Unit Type Key | ☐ | The key for the unit type | | `unitType_value` | `string` | Unit Type Value | ☐ | The description for the unit type |