ec_wi_status table

The ec_wi_status table holds information about work items and their usage.

Column Description
work_item_id Unique identifier of this work item.
process_instance Identifier of the parent process instance from which this work item was generated.
process_name Identifier (name) of the process template from which the parent process instance was generated.
proc_tpl_pk The reference to the process template, module name, and module version, referenced in the ec_proc_template table .
activity_name Name of the activity from which the work item was derived.
activity_ins_id Instance identifier of the activity from which the work item was derived. This value is unique even if the activity is executed multiple times - for example, as part of a loop.
org_ent_guids The GUID of the QUERY.
org_ent_names The RQL expression text.
org_ent_types QUERY.
org_ent_vers The comma-separated list of the organizational entity versions to which this work item was offered.
user_id Resource associated with this work item.
user_guid GUID of the resource associated with this work item.
comp_user_id Resource completing this work item.
comp_user_guid GUID of the resource completing this work item.
schedule_start Scheduled start date/time (in UTC) for this work item.
schedule_end Scheduled end date/time (in UTC) for this work item.
first_offer_time First time that this work item was offered or allocated.
first_open_time First time that this work item was opened.
last_open_time Last time that this work item was opened.
completion_time Completion time of this work item.
active_dur Total duration (in milliseconds) that this work item was active - that is, the time between its first_offer_time and its completion_time, disregarding any intermediate states.
wait_dur Total duration (in milliseconds) that this work item was waiting - that is, the time between its first_offer_time and its first_open_time.
action_dur Total duration (in milliseconds) that this work item was being actioned - that is, the time between its first_open_time and its completion_time.
work_time_dur Total working time duration (in milliseconds) for this work item, that is, the cumulative time between its first and last form submission activities.
status Status of this work item.
status_changed Time that the status of this work item was last changed.
priority Priority of the work item.
attribute1 The integer value of custom work attribute 1 for this work item.
attribute2 - attribute4 The text values of custom work attributes 2 to 4, respectively, for this work item.
attribute5 The decimal value of custom work attribute 5 for this work item.
attribute6 - attribute7 The date-time values of custom work attributes 6 and 7, respectively, for this work item.
attribute8 - attribute 14 The text value of custom work attributes 8 to 14, respectively, for this work item.
generic_attr_id

(currently unused in this release)

Identifier of future generic attributes. If there are no generic attributes, the value is NULL.
case_reference Identifier of array in ec_array table that holds the case references.
attribute15 The integer value of custom work attribute 15 for the event.
attribute16 - attribute18 The decimal values of custom work attribute16 - attribute18, respectively, for the event.
attribute19 - attribute20 The date-time values of custom work attributes19 - attribute20, respectively, for the event.
attribute21 - attribute40 The text value of custom work attribute21- attribute40, respectively, for the event.
inst_process_id The numeric id of the process instance. This id can be used to join against the process engine tables.
root_proc_ins_id The root instance id. The root instance will be the same as the PROCESS_INSTANCE column if there is no root instance.
inst_task_id The numeric id of the process engine activity. This id can be used to join against the process engine tables.