ec_pe_status table

The ec_pe_status table stores measures about process instances.

Column Description
process_instance Unique identifier of this process instance.
process_template Name of the parent process template.
version Version number of the parent process template.
priority Priority of this process instance.
module_name Module name related to the parent process template.
user_id Resource associated with this process instance.
user_guid GUID of the resource associated with this process instance.
status Status of this process instance.
status_changed Timestamp of the last status change of this process instance.
cur_activity The task that is currently executing within the process.
cur_activity_start The start time of the current task.
start_time Start time of this process instance.
end_time Completion time of this process instance.
exec_millis Total time taken (in milliseconds) by this process instance between its start_time and end_time.
proc_tpl_pk Unique identifier of the process template. It includes the process template name, module name, and module version. This is stored in the ec_proc_template table .
case_reference Identifier of array in ec_array table that holds the case references.
attribute1 The integer value of custom work attribute 1 for this process instance.
attribute2 - attribute4 The text values of custom work attributes 2 to 4, respectively, for this process instance.
attribute5 The decimal value of custom work attribute 5 for this process instance.
attribute6 - attribute7 The date-time values of custom work attributes 6 and 7, respectively, for this process instance.
attribute8 - attribute 14 The text value of custom work attributes 8 to 14, respectively, for this process instance.
attribute15 The integer value of custom work attribute 15 for this process instance.
attribute16 - attribute18 The decimal values of custom work attribute16 - attribute18, respectively, for this process instance.
attribute19 - attribute20 The date-time values of custom work attributes19 - attribute20, respectively, for this process instance.
attribute21 - attribute40 The text value of custom work attribute21- attribute40, respectively, for this process instance.

type

The type of process. The data can be one of "SYNC", "ASYNC_DETACHED" or "ASYNC_ATTACHED".
inst_process_id The numeric id of the process instance. This id can be used to join against the process engine tables.
parent_proc_ins_id The instance id of the immediate parent. This will be null if there is no parent.
root_proc_ins_id The root instance id. This will be the same as the PROCESS_INSTANCE column if there is no root instance.