# EmploymentMasterDataReportByEmployerId Download master data report (Stamgegevens) __Activity name :__ GetEmploymentMasterDataReportByEmployerId Acquire the master data report (Stamgegevens) on employer level, as generated by the reporting service. 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: `EmployerReports` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `includeEmploymentsThatEndedBeforeReferenceDate` | `boolean` | ☑ | | If set to true records with an enddate before the reference will be included in the output. | | `referenceDate` | `datetime` | ☑ | | Set a reference date for choosing the date dependent data. | ## Columns The columns of the table `EmploymentMasterDataReportByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `DOCUMENT` | `byte[]` | Document | ☐ | |