# EmployerDataAuditTrailByEmployerId Get the employer data audit trail __Activity name :__ GetEmployerDataAuditTrailByEmployerId Get the mutations for the all the tables linked to the employer containing employer-related data. 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: `AuditTrail` ## Parameters of Table Function | Name | Data Type | Required | Default Value | Documentation | |---|:---:|:---:|:---:|---| | `employerId` | `guid` | ☑ | | The unique identifier of the employer | | `endDate` | `string` | ☑ | | The end date | | `startDate` | `string` | ☑ | | The start date | ## Columns The columns of the table `EmployerDataAuditTrailByEmployerId` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `employer_companyName` | `string(70)` | | ☐ | Company name | | `employer_employerNumber` | `int32` | | ☐ | 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). | | `employer_id` | `guid` | | ☐ | The unique identifier (GUID/UUID) | | `entity_key` | `int32` | | ☐ | The key of the entity | | `field_key` | `int32` | | ☐ | The key of the field | | `field_value` | `string(50)` | | ☐ | Description of the field | | `identification_description` | `string(255)` | | ☐ | Extra identifying information for the mutation | | `mutationOrigin_key` | `int32` | | ☐ | The key of the mutationOrigin | | `mutationOrigin_value` | `string(50)` | | ☐ | Description of the mutationOrigin | | `mutationType_key` | `int32` | | ☐ | The key of the mutationType | | `mutationType_value` | `string(50)` | | ☐ | Description of the mutationType | | `newValue` | `string(250)` | | ☐ | The value of the field after the change. Incase of an delete the nieuwValue will be NULL. | | `oldValue` | `string(250)` | | ☐ | The value befor the change. Incase of an create the oldValue will be NULL. | | `performedBy_formattedName` | `string` | | ☐ | preformatted user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> | | `performedBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) | | `performedBy_initials` | `string(6)` | | ☐ | The initials of the user | | `performedBy_lastName` | `string(25)` | | ☐ | The last name of the user | | `performedBy_prefix` | `string(10)` | | ☐ | The prefix of the user | | `timeStamp` | `datetime` | | ☐ | The time the mutation was performed |