# NationalHolidaysByEmployerId List of national holidays __Activity name :__ GetNationalHolidaysByEmployerId Get a list of all national holidays for 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: `NationalHoliday` ## 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 `NationalHolidaysByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `deviations_enabled` | `boolean` | | ☐ | Indicates whether the national holiday is used to calculate leave hours for a leave request. This influences only new records. Old records using this national holiday will remain and show the corresponding information. | | `deviations_value` | `string(50)` | | ☐ | The description for the national holiday. | | `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) | | `nationalHoliday_dateInCurrentYear` | `datetime` | | ☐ | The date for the national holiday in the current year. | | `nationalHoliday_enabled` | `boolean` | | ☐ | Indicates whether the national holiday is used to calculate leave hours for a leave request | | `nationalHoliday_key` | `int32` | | ☐ | The key for the national holiday. This value is used in the `nationalHoliday` metadata object to refer to this configuration (and the possible deviations) | | `nationalHoliday_value` | `string(50)` | | ☐ | The description for the national holiday. |