ec_event

The ec_event table holds information about events that have been registered with the Event Collector.

Column Name Description
event_id The identifier of the event.
message_category The category of the message.
message_id The identifier of the message.
message The description of the event.
severity The severity of the event - one of the following:
  • TRACE
  • DEBUG
  • INFO
  • SERVICE
  • AUDIT
  • WARN
  • ERROR
  • FATAL
event_timestamp The time stamp at which the event occurred.
managed_obj_id
Valid values for this attribute depend on the value of the messageCategory attribute.
principal_id The unique identifier of the security principal associated with the event.
principal_name The name of the security principal associated with the event.
managed_obj_name

Valid values for this attribute depend on the value of the messageCategory attribute.

managed_obj_version Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_type Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_status
Status of the managed object.
managed_obj_url Valid values for this attribute depend on the value of the messageCategory attribute.
managed_obj_details Valid values for this attribute depend on the value of the messageCategory attribute.
parent_obj_id
Valid values for this attribute depend on the value of the messageCategory attribute.
app_name For BX (Process Services) events, this is the name of the application that generated the event. For BRM (Business Resource Management Services) events, this is the name of the process that generated the event.
wi_schedule_start Scheduled start date of the work item associated with the event.
wi_schedule_end Scheduled end date of the work item associated with the event.
wi_org_ent_list Offer set for the work item. This is the GUID, entity type, and model version, separated by the tab character. Multiple entities are separated by the newline character.
wi_priority Priority of the work item associated with the event.
ext_message Extended message for the message. This will generally contain more information. For example, the failure reason for a failed activity.
retry_time The time when the failed activity will be retried again.
resource_id Identifier of the resource associated with the event.
resource_name
Name of the resource associated with the event.
entity_id
Identifier of the organization model entity associated with the event.
entity_type
Type of the organization model entity associated with the event. This must be one of the following values:
  • ORGANIZATION
  • ORGANIZATIONAL_UNIT
  • GROUP
  • POSITION
  • PRIVILEGE
  • CAPABILITY
  • RESOURCE
  • LOCATION
  • ORGANIZATION_TYPE
  • ORGANIZATIONAL_UNIT_TYPE
  • POSITION_TYPE
  • LOCATION_TYPE
  • ORGUNIT_RELATIONSHIP_TYPE
  • POSITION_HELD
  • ORGUNIT_RELATIONSHIP
  • ORGUNIT_FEATURE
  • POSITION_FEATURE
  • PARAMETER_DESCRIPTOR
channel_id
Unique identifier of the presentation channel associated with the event.
app_act_name
Name of the process activity associated with the event. For example, StartEvent, ScriptTask, DBTask, gateway, Success, Failure.
app_act_model_id
The design time identifier of the process activity: the unique identifier of the process activity associated with the event from the model.
app_act_instance_id
The runtime identifier of the process activity: the unique identifier of the process activity associated with the event from the activity instance.
sys_action_comp_id
Identifier of the component that requested a system action check. (Typically this is "BRM".)
sys_action_id
Unique identifier of the requested system action.
root_proc_ins_id Identifier of the upper-most parent process.
parent_proc_ins_id
Identifier of the parent process associated with the event.
parent_act_ins_id
Identifier of the parent activity associated with the event.
sub_proc_ins_id
Identifier of the sub-process associated with the event.
sub_proc_name
Name of the sub-process associated with the event.
process_priority
Priority of the process instance associated with the event.
module_name
The process package name of the deployed process associated with the event. (This is not set for BRM (Business Resource Management Services) events.)
prior_step_id
Identifier of the previous activity (to the one associated with the event).
sub_proc_ver
Version of the sub-process associated with the event.
model_major_version
Major version number of a case data model.
model_version
Version number of a case model.
role_name
The role name given to a link between two case data classes.
iteration  
iteration_id  
host_task_name  
host_task_type  
interrupts_main_flow  
attribute1 Value (integer) of this custom work attribute
attribute2 Value (text) of this custom work attribute
attribute3 Value (text) of this custom work attribute
attribute4 Value (text) of this custom work attribute
attribute5 Value (decimal) of this custom work attribute
attribute6 Value (date-time) of this custom work attribute
attribute7 Value (date-time) of this custom work attribute
attribute8 Value (text) of this custom work attribute
attribute9 Value (text) of this custom work attribute
attribute10 Value (text) of this custom work attribute
attribute11 Value (text) of this custom work attribute
attribute12 Value (text) of this custom work attribute
attribute13 Value (text) of this custom work attribute
attribute14 Value (text) of this custom work attribute
attribute15 Value (integer) of this custom work attribute
attribute16 Value (decimal) of this custom work attribute
attribute17 Value (decimal) of this custom work attribute
attribute18 Value (decimal) of this custom work attribute
attribute19 Value (date-time) of this custom work attribute
attribute20 Value (date-time) of this custom work attribute
attribute21 Value (text) of this custom work attribute
attribute22 Value (text) of this custom work attribute
attribute23 Value (text) of this custom work attribute
attribute24 Value (text) of this custom work attribute
attribute25 Value (text) of this custom work attribute
attribute26 Value (text) of this custom work attribute
attribute27 Value (text) of this custom work attribute
attribute28 Value (text) of this custom work attribute
attribute29 Value (text) of this custom work attribute
attribute30 Value (text) of this custom work attribute
attribute31 Value (text) of this custom work attribute
attribute32 Value (text) of this custom work attribute
attribute33 Value (text) of this custom work attribute
attribute34 Value (text) of this custom work attribute
attribute35 Value (text) of this custom work attribute
attribute36 Value (text) of this custom work attribute
attribute37 Value (text) of this custom work attribute
attribute38 Value (text) of this custom work attribute
attribute39 Value (text) of this custom work attribute
attribute40 Value (text) of this custom work attribute
additional_attribs
Value (text) of this custom work attribute