Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 WORKFLOWSTARTDATE datetimeoffset   Default = sysdatetimeoffset() The date and time that the workflow started
 STARTSTATUSCODE tinyint   Default = 0 Indicates the start status for this workflow instance.
 STARTSTATUS nvarchar(7) (Computed) CASE [STARTSTATUSCODE] WHEN 0 THEN N'Pending' WHEN 1 THEN N'Started' WHEN 2 THEN N'Failed' END Provides a translation for the 'STARTSTATUSCODE' field.
 DATEADDED datetime   Default = getdate()
 COMPLETIONSTATECODE tinyint   Default = 0 Indicates the ActivityInstanceState for this workflow instance.
 COMPLETIONSTATE nvarchar(8) (Computed) CASE [COMPLETIONSTATECODE] WHEN 0 THEN N'None' WHEN 1 THEN N'Closed' WHEN 2 THEN N'Canceled' WHEN 3 THEN N'Faulted' END Provides a translation for the 'COMPLETIONSTATECODE' field.
 WORKFLOWENDDATE datetimeoffset The date and time that the workflow ended
 ISRUNNING bit (Computed) (CASE WHEN ((COMPLETIONSTATECODE = 0 ) and (STARTSTATUSCODE = 1 )) THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END ) True if the workflow has started and is running
 CANCEL_OR_FAULT_REASON nvarchar(max)   Default = '' The reason why the workflow was canceled or faulted.
 WORKFLOWINSTANCEID uniqueidentifier The internal Workflow Foundation workflow instance id.
 CUSTOMIDENTIFIER nvarchar(100)   Default = '' User-definable custom identifier.
 SEQUENCEID int   Identity column used to increment the default lookupid.
 LOOKUPID nvarchar(100) (Computed) (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'W-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) Unique identifer that supports user defined values as well as system generated values.

Foreign Key Field Type Null Notes Description
 BBWORKFLOWCATALOGID uniqueidentifier   BBWORKFLOWCATALOG.ID The ID of the workflow spec that defined this workflow instance.
 INITIATEDBY_APPUSERID uniqueidentifier   APPUSER.ID FK to APPUSER
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT

Index Name Field(s) Unique Primary Clustered
 IX_BBWORKFLOWINSTANCEINFO_BBWORKFLOWCATALOGID BBWORKFLOWCATALOGID      
 IX_BBWORKFLOWINSTANCEINFO_INITIATEDBY_APPUSERID INITIATEDBY_APPUSERID      
 IX_BBWORKFLOWINSTANCEINFO_WORKFLOWENDDATE WORKFLOWENDDATE      
 IX_BBWORKFLOWINSTANCEINFO_WORKFLOWINSTANCEID WORKFLOWINSTANCEID      
 IX_BBWORKFLOWINSTANCEINFO_WORKFLOWSTARTDATE WORKFLOWSTARTDATE      
 PK_BBWORKFLOWINSTANCEINFO ID
 UC_BBWORKFLOWINSTANCEINFO_LOOKUPID LOOKUPID    

Referenced by Field
 BBWORKFLOW_QUEUEMESSAGE_ERROR BBWORKFLOWINSTANCEINFOID
 BBWORKFLOWALERT BBWORKFLOWINSTANCEINFOID
 BBWORKFLOWBUSINESSACTIVITY BBWORKFLOWINSTANCEINFOID
 BBWORKFLOWDATAITEM BBWORKFLOWINSTANCEINFOID
 BBWORKFLOWLOG BBWORKFLOWINSTANCEINFOID
 BBWORKFLOWTASK BBWORKFLOWINSTANCEINFOID

Entity-Relationship diagram of this table