Event Monitor tables
The data model below represents the tables that make up the Event Monitor.
The following lists describe the content of the tables in the Event Monitor:
EM_WORKINSTANCE
A work instance is the primary entity in the Event Monitor system. It wraps a group of work instance events together, for example, in EngageOne, a work instance might wrap all activity surrounding a particular document instance.
| WORKINSTANCEID | Primary key |
| EXTERNALSOURCE | Set to EngageOne. |
| STARTTIME | The start time of the work instance. |
| ENDTIME | The end time of the work instance. |
| EXTERNALID | The work item ID, which provides a unique identifier in EngageOne for a document instance as it moves through the system. |
| WORKINSTANCENAME | Optional descriptive name for the work instance. |
| WORKFLOWTEMPLATEID | Optional foreign key to a workflow template. |
| CREATETIMESTAMP | Audit create timestamp. |
A work instance event contains the data relating to a particular event within the system. Every event is identified by a process type. For example, in EngageOne, process types include Create Document, Import Template, etc. See EngageOne events for a complete list. An event also has what is called an event type. See EM_EVENTTYPE that follows.
| WORKINSTANCEVENTID | Primary key |
| WORKINSTANCEID | Parent work instance foreign key. |
| EVENTTYPEID | Event type foreign key. |
| PROCESSTYPEID | Process type foreign key. |
| USERID | User ID of the user who created the event. |
| STARTTIME | Start time of the event. |
| ENDTIME | End time of the event. |
| COMMENTS | Optional comments on the event. |
| WORKINSTANCEVENTNAME | Optional name of the event. |
| WORKFLOWEVENTID | If this event corresponds to a workflow event, this will be the workflow event foreign key. |
| CREATETIMESTAMP | Audit create timestamp. |
EM_PROCESSTYPE
A process type defines the type of the event. For example, the event Create Document, Import Template, Login, etc. See EngageOne events for a list of process types.
| PROCESSTYPEID | Primary key |
| PROCESSTYPE | Application defined process
types. For example, create.document, import.template, etc. |
| EXTERNALSOURCE | EngageOne. |
| DESCRIPTION | Application defined description of the process type. |
| CREATETIMESTAMP | Audit create timestamp. |
EM_EVENTTYPE
An event type is the priority of the event. There are four event type priorities defined in the EM system (EM_EVENTTYPE table): Error, Warning, Informational, and Debug. You can define and name as many event types as you require, but each must have a corresponding priority from one of the four mentioned above. This means an application could have multiple Error event types, and multiple Warning event types, etc.
| EVENTTYPEID | Primary key. |
| EVENTTYPE | Identifies the type of event |
| EXTERNALSOURCE | EngageOne. |
| PRIORITY | One of four possible values: 0 = Error, 1 = Warning, 2 = Informational, 3 = Debug. |
| DESCRIPTION | Application defined description of the event type. |
| CREATETIMESTAMP | Audit create timestamp. |
EM_WORKINSTANCEPROPERTIES
The work instance entity allows for properties to be assigned, ranging from standard/stock properties to any additional properties you want defined.
| WORKINSTANCEPROPERTYID | Primary key. |
| WORKINSTANCEID | The work instance foreign key. |
| PROPERTYNAME | Application defined property
string, for example, document.id. |
| PROPERTYVALUE | The value of the property. |
EM_WORKINSTANCEEVENTPROPERTIES
Similar to work instance properties, work instance events support additional properties exceeding the standard/stock attributes of the work instance event.
| WORKINSTANCEEVENTPROPERTYID | Primary key. |
| WORKINSTANCEEVENTID | The work instance foreign key. |
| PROPERTYNAME | Application defined property
string, for example, document.id. |
| PROPERTYVALUE | The value of the property. |
EM_WORKFLOWTEMPLATE
The Event Monitor system allows for a workflow, which can be tied to work instance events. The workflow template and workflow event tables are pre-populated by the application prior to events being logged.
| WORKFLOWTEMPLATEID | Primary key |
| TEMPLATENAME | Name of the template. |
| EXTERNALSOURCE | EngageOne. |
| EXTERNALDOMAIN | Additional, optional criteria used to categorize the template, above and beyond the use of the external source. |
| TEMPLATEDESCRIPTION | Description of the template. |
| CREATETIMESTAMP | Audit create timestamp. |
EM_WORKFLOWEVENT
A workflow event is a step within an application workflow.
| WORKFLOWEVENTID | Primary key. |
| WORKFLOWTEMPLATEID | Workflow template foreign key. |
| WORKFLOWEVENTNAME | The name of the step within the workflow corresponding to this workflow event. |
| CREATETIMESTAMP | Audit create timestamp. |