# WorkflowTriggerMappingsByEmployerId
Workflowtrigger to workflowtemplate mapping
__Activity name:__ GetWorkflowTriggerMappingsByEmployerId
Get the list workflow triggers that are mapped to a workflowTemplate. Workflow triggers are triggers that trigger a workflow. With this resource one can manage which trigger will trigger what workflow.
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: `WorkflowTriggerMapping`
## 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 `WorkflowTriggerMappingsByEmployerId` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `createdBy_formattedName` | `string` | Created by Name | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> |
| `createdBy_id` | `guid` | Created By ID | ☐ | The unique identifier of an object (GUID/UUID) |
| `createdBy_initials` | `string(6)` | Created by Initials | ☐ | The initials of the user |
| `createdBy_lastName` | `string(25)` | Created by Last Name | ☐ | The last name of the user |
| `createdBy_prefix` | `string(10)` | Created by Prefix | ☐ | The prefix of the user |
| `createdOn` | `datetime` | Created On | ☐ | |
| `id` | `guid` | ID | ☐ | The unique identifier of an object (GUID/UUID) |
| `lastModifiedBy_formattedName` | `string` | | ☐ | preformated user name for displaying. \<lastname\>\", \"\<initials\>\" \"\<prefix\> |
| `lastModifiedBy_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |
| `lastModifiedBy_initials` | `string(6)` | | ☐ | The initials of the user |
| `lastModifiedBy_lastName` | `string(25)` | | ☐ | The last name of the user |
| `lastModifiedBy_prefix` | `string(10)` | | ☐ | The prefix of the user |
| `lastModifiedOn` | `datetime` | | ☐ | |
| `trigger_description` | `string(256)` | Trigger Description | ☐ | |
| `trigger_id` | `guid` | Trigger ID | ☐ | The unique identifier of an object (GUID/UUID) |
| `workflowTemplate_description` | `string(256)` | | ☐ | |
| `workflowTemplate_id` | `guid` | | ☐ | The unique identifier of an object (GUID/UUID) |