BBWORKFLOWBUSINESSACTIVITY
Information about a Workflow instance business activity
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| DISPLAYNAME |
nvarchar(255) |
|
Default = '' |
|
| DESCRIPTION |
nvarchar(500) |
|
Default = '' |
|
| ACTIVITYSTARTDATE |
datetimeoffset |
|
|
|
| ACTIVITYENDDATE |
datetimeoffset |
yes |
|
|
| STARTMESSAGE |
nvarchar(max) |
|
Default = '' |
|
| ENDMESSAGE |
nvarchar(max) |
|
Default = '' |
|
| DETAILLEVELCODE |
tinyint |
|
Default = 0 |
0=High, 1=Medium, 2=Low |
| DETAILLEVEL |
nvarchar(6) (Computed) |
yes |
CASE [DETAILLEVELCODE] WHEN 0 THEN N'High' WHEN 1 THEN N'Medium' WHEN 2 THEN N'Low' END |
Provides a translation for the 'DETAILLEVELCODE' field. |
| DATEADDED |
datetime |
|
Default = getdate() |
|
| PARENTBBWORKFLOWBUSINESSACTIVITYID |
uniqueidentifier |
yes |
|
The ID of a parent business activity that this activity is executing under. |
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| BBWORKFLOWINSTANCEINFOID |
uniqueidentifier |
yes |
BBWORKFLOWINSTANCEINFO.ID
|
FK to BBWORKFLOWINSTANCEINFO |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_BBWORKFLOWBUSINESSACTIVITY_ACTIVITYENDDATE |
ACTIVITYENDDATE |
|
|
|
| IX_BBWORKFLOWBUSINESSACTIVITY_ACTIVITYSTARTDATE |
ACTIVITYSTARTDATE |
|
|
|
| IX_BBWORKFLOWBUSINESSACTIVITY_BBWORKFLOWINSTANCEINFOID |
BBWORKFLOWINSTANCEINFOID |
|
|
|
| IX_BBWORKFLOWBUSINESSACTIVITY_DATEADDED |
DATEADDED |
|
|
|
| IX_BBWORKFLOWBUSINESSACTIVITY_DISPLAYNAME |
DISPLAYNAME |
|
|
|
| IX_BBWORKFLOWBUSINESSACTIVITY_PARENTBBWORKFLOWBUSINESSACTIVITYID |
PARENTBBWORKFLOWBUSINESSACTIVITYID |
|
|
|
| PK_BBWORKFLOWBUSINESSACTIVITY |
ID |
yes |
yes |
yes |
Referenced by