# CalendarRevokeLeaveRequestsByEmployerId__embeddedCalendar List leave requests per employment (for calendar) __Activity name :__ GetCalendarRevokeLeaveRequestsByEmployerId For a calendar, this endpoint return the revoke leave requests calendar items PER specific employment. Please note: this endpoint only will return calendar items based on leave request with status 'geaccepteerd met intrekkingsverzoek.'. This endpoint only returns objects for which the employment meets the filter settings set at the user level. Note that filter settings are set for a user <-> employer <-> client combination. 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: `Calendar` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `endDate` | `datetime` | ☑ | | A valid date (yyyy-MM-dd). Last day of the timebox for which calendar data will be collected. | | `startDate` | `datetime` | ☑ | | A valid date (yyyy-MM-dd). First day of the timebox for which calendar data will be collected. | ## Columns The columns of the table `CalendarRevokeLeaveRequestsByEmployerId__embeddedCalendar` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `department_code` | `int32` | Department Code | ☐ | | | `department_description` | `string` | Department Description | ☐ | | | `department_key` | `guid` | Department Code | ☐ | The unique identifier of an object (GUID/UUID) | | `details` | `string` | | ☐ | In the future this object describes the calendar item in more detail. For now this object will always be NULL. | | `employee_firstName` | `string(28)` | Employee First Name | ☐ | The first name, given name, forename or Christian name as part of a persons personal name. | | `employee_formattedName` | `string(82)` | Employee Formatted Name | ☐ | Formatted name of the employee based on the value of `howToFormatLastName` | | `employee_id` | `guid` | Employee ID | ☐ | The unique identifier of an object (GUID/UUID) | | `employment_id` | `guid` | Employment ID | ☐ | The unique identifier of an object (GUID/UUID) | | `employment_incomeRelationshipNumber` | `int32` | | ☐ | The income relationship number that is required in the tax return. Together with the citizen service number (burgerservicenummer, BSN) and wage tax number, the income relationship number uniquely identifies an employment. | | `endDate` | `datetime` | End Date | ☐ | The last day of the period for which leave request information is available. | | `startDate` | `datetime` | Start Date | ☐ | The first day of the period for which leave request information is available. |