> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # workflow_instance table > A set of properties related to the workflow instance of one participant going through the flow ## 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](./workflow.mdx) | Yes | | status | Status of the workflow instance | Enum [WorkflowInstanceStatus](./enums/workflowinstancestatus.mdx) | Yes | | person\_id | Person ID of person going through the flow | FK [person](./person.mdx) | Yes | | contact\_id | Contact ID of contact contact going through the flow | FK [contact](./contact.mdx) | Yes | | variables | Instance data and variables | Clob | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | 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](./workflow-step.mdx) | 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](./workflow-step.mdx) | 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](./associate) | Employees, resources and other users - except for External persons | | [contact](./contact) | Companies and Organizations. | | [person](./person) | Persons | | [s\_shipment\_addr](./s-shipment-addr) | Addresses that are ready to be sent in a shipment. | | [workflow](./workflow) | SuperOffice specific info about a workflow | | [workflow\_step](./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](/en/automation/crmscript/reference/CRMScript.NetServer.WorkflowInstanceStatus.md) - [workflow_step table](/en/database/tables/workflow-step.md) - [Enum values for WorkflowInstanceStatus](/en/database/tables/enums/workflowinstancestatus.md) - [workflow table](/en/database/tables/workflow.md) - [s_shipment_addr table](/en/database/tables/s-shipment-addr.md) - [What's new in version 10.2.8.655](/release-notes/database/changes-10.2.8.md)