Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TASKSUBJECT nvarchar(255)   Default = ''
 TASKDESCRIPTION nvarchar(max)   Default = ''
 DATEASSIGNED datetimeoffset   Default = sysdatetimeoffset()
 DATEDUE datetimeoffset
 DATECOMPLETED datetimeoffset
 CATEGORY nvarchar(50)   Default = ''
 CUSTOMIDENTIFIER nvarchar(100)   Default = '' User-definable custom identifier.
 SEQUENCEID int   Identity column used to increment the default lookupid.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 TASKSTATUSCODE tinyint   Default = 0 Indicates if the task is open, completed, or cancelled.
 TASKSTATUS nvarchar(9) (Computed) CASE [TASKSTATUSCODE] WHEN 0 THEN N'Open' WHEN 1 THEN N'Completed' WHEN 2 THEN N'Cancelled' END Provides a translation for the 'TASKSTATUSCODE' field.
 HIDDEN bit   Default = 0
 USERCANCANCEL bit   Default = 0
 USERCANCOMPLETE bit   Default = 0
 LOOKUPID nvarchar(100) (Computed) (CASE LEN(CUSTOMIDENTIFIER) WHEN 0 THEN 'T-' + 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
 BBWORKFLOWINSTANCEINFOID uniqueidentifier   BBWORKFLOWINSTANCEINFO.ID FK to BBWORKFLOWINSTANCEINFO
 BBWORKFLOWINBOXID uniqueidentifier   BBWORKFLOWINBOX.ID FK to BBWORKFLOWINBOX
 COMPLETEDBY_APPUSERID uniqueidentifier APPUSER.ID FK to APPUSER
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 TASKPAGEID uniqueidentifier PAGEDEFINITIONCATALOG.ID The ID of a page that displays information and actions about this task
 BBWORKFLOWBUSINESSACTIVITYID uniqueidentifier BBWORKFLOWBUSINESSACTIVITY.ID The workflow business activity that was executing when this task was assigned.

Index Name Field(s) Unique Primary Clustered
 IX_BBWORKFLOWTASK_BBWORKFLOWBUSINESSACTIVITYID BBWORKFLOWBUSINESSACTIVITYID      
 IX_BBWORKFLOWTASK_BBWORKFLOWINBOXID BBWORKFLOWINBOXID      
 IX_BBWORKFLOWTASK_BBWORKFLOWINSTANCEINFOID BBWORKFLOWINSTANCEINFOID      
 IX_BBWORKFLOWTASK_DATEADDED DATEADDED    
 IX_BBWORKFLOWTASK_DATECHANGED DATECHANGED      
 IX_BBWORKFLOWTASK_DATECOMPLETED DATECOMPLETED      
 IX_BBWORKFLOWTASK_DATEDUE DATEDUE      
 PK_BBWORKFLOWTASK ID  
 UC_BBWORKFLOWTASK_LOOKUPID LOOKUPID    

Trigger Name Description
 TR_BBWORKFLOWTASK_AUDIT_UPDATE
 TR_BBWORKFLOWTASK_AUDIT_DELETE

Referenced by Field
 BBWORKFLOWTASKDATAITEM BBWORKFLOWTASKID

Entity-Relationship diagram of this table