workflow_instance table - SuperOffice

workflow_instance Table (528)

A set of properties related to the workflow instance of one participant going through the flow

Fields

Name	Description	Type	Nullable
workflow_instance_id	Primary key	PK	No
workflow_id	The flow this instance belongs to	FK workflow	Yes
status	Status of the workflow instance	Enum WorkflowInstanceStatus	Yes
person_id	Person ID of person going through the flow	FK person	Yes
contact_id	Contact ID of contact contact going through the flow	FK contact	Yes
variables	Instance data and variables	Clob	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
current_step	Next step to be executed when conditions are met	FK workflow_step	Yes
wait_until	Don’t evaluate conditions until given time (set by a waiting step, and status Suspended). An event may change the wait_until or status to Running.	DateTime	Yes
last_communication_step	Last completed step with email/sms to customer	FK workflow_step	Yes
dropout_reason	Reason for dropout/failure	String(255)	Yes
step_started	The currently executing step was started at this time	DateTime	Yes
step_level	Some steps have multiple levels, this indicates what level is reached	Int	Yes

workflow_instance table relationship diagram

Indexes

Fields	Types	Description
person_id	FK	Index
contact_id	FK	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
person	Persons
s_shipment_addr	Addresses that are ready to be sent in a shipment.
workflow	SuperOffice specific info about a workflow
workflow_step	A set of steps related to a workflow.

Replication Flags

None

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.

Related topics

Enum WorkflowInstanceStatus Enum values for WorkflowInstanceStatus workflow_step table workflow table workflowinstancestatus s_shipment_addr table

⌘I