# LeaveImportDataByEmployerId Get data to create an importfile __Activity name :__ GetLeaveImportDataByEmployerId Returns, for the given employer, a set of data that can be used as a base for importing leave through a csv file. Note that on importing, the columnnames must be in Dutch. (WerkgeverId PersnrVerl Persnr Naam Ingangsdatum Einddatum Soort Factor Eenheden) 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: `LeaveImport` ## 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 `LeaveImportDataByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employeeNumber` | `int32` | Employee Number | ☐ | The employee number to uniquely identify an employee within an employer | | `employerNumber` | `int32` | Employer Number | ☐ | The employer number is used in various overviews and exports to identify a specific employer in Loket (please note: this is not the identifier used in the REST API). | | `endDate` | `datetime` | End Date | ☐ | The end date of the leave | | `formattedName` | `string` | | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `isAccrual` | `int64` | | ☐ | Indicates whether the request is for accrual of leave. - -1 will result in a reduction of the employee's leave entitlement - 1 will result in an increase of the employee's leave entitlement | | `leaveTypeKey` | `int32` | | ☐ | The key for the leave type. | | `numberOfUnits` | `double` | Number of Units | ☐ | The number of leave units requested | | `payrollEmployeeNumber` | `int32` | | ☐ | The number of the employment in relation to the payroll administration. | | `startDate` | `datetime` | Start Date | ☐ | The start date of the leave |