Open topic with navigation

TIBCO® BPM Enterprise 5.5.0

# sc_workitem_status

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

Column | Description
--- | ---
work_item_id | Unique identifier of this work item.
process_instance_id | Identifier of the parent process instance from which this work item was generated.
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_entities | JSON array of org entities that are GUIDs, names, and types.
user_id | Resource associated with this work item.
comp_user_id | Resource completing this work item.
schedule_start | Scheduled start date and time (in UTC) for this work item.
schedule_end | Scheduled end date and 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.
work_group_id | The ID of the work resource pattern this work item belongs to, if there is one.
attribute1 | The fixed-point number (0 decimals) 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 floating-point number value of custom work attribute 5 for this work item.
attribute6 - attribute7 | The date time and timezone 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.
attribute15 | The fixed-point number (0 decimals) value of custom work attribute 15 for the event.
attribute16 - attribute18 | The floating-point number values of custom work attribute16 - attribute18, respectively, for the event.
attribute19 - attribute20 | The date time and timezone values of custom work attributes19 - attribute20, respectively, for the event.
attribute21 - attribute40 | The text value of custom work attribute21- attribute40, respectively, for the event.
generic_attr_id | Identifier of future generic attributes. If there are no generic attributes, the value is NULL.

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO® BPM Enterprise

Copyright © 2015-2024. Cloud Software Group, Inc. All Rights Reserved.