BBWORKFLOWINSTANCEINFO
Information about a specific Blackbaud workflow instance
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| 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) |
yes |
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) |
yes |
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 |
yes |
|
The date and time that the workflow ended |
| ISRUNNING |
bit (Computed) |
yes |
(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 |
yes |
|
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) |
yes |
(CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'W-' + CAST(SEQUENCEID AS nvarchar(20)) ELSE CUSTOMIDENTIFIER END) |
Unique identifier that supports user defined values as well as system generated values. |
Foreign Keys
| 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 |
Indexes
| Index Name |
Fields |
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 |
yes |
yes |
yes |
| UC_BBWORKFLOWINSTANCEINFO_LOOKUPID |
LOOKUPID |
yes |
|
|
Referenced by