BBWORKFLOWINSTANCETRACKING

Records information captured from Workflow Instance Tracking Records

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
EVENTTIME	datetimeoffset			The time the tracking record occurred.
INSTANCEID	uniqueidentifier			The Windows Workflow Foundation instance id for this record.
TRACELEVELCODE	tinyint		Default = 0	The System.Diagnostics.TraceLevel of the event.
TRACELEVEL	nvarchar(7) (Computed)	yes	CASE [TRACELEVELCODE] WHEN 0 THEN N'Off' WHEN 1 THEN N'Error' WHEN 2 THEN N'Warning' WHEN 3 THEN N'Info' WHEN 4 THEN N'Verbose' END	Provides a translation for the 'TRACELEVELCODE' field.
TRACKINGRECORDNUMBER	bigint		Default = ((0))	A sequence that defines the order in which tracking records are generated.
DATEADDED	datetime		Default = getdate()
ACTIVITYDEFINITIONID	nvarchar(510)		Default = ''
WORKFLOWSTATE	nvarchar(100)		Default = ''
REASON	nvarchar(1024)		Default = ''

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BBWORKFLOWINSTANCETRACKING_DATEADDED	DATEADDED
IX_BBWORKFLOWINSTANCETRACKING_EVENTTIME	EVENTTIME
IX_BBWORKFLOWINSTANCETRACKING_INSTANCEID	INSTANCEID
IX_BBWORKFLOWINSTANCETRACKING_TRACKINGRECORDNUMBER	TRACKINGRECORDNUMBER
PK_BBWORKFLOWINSTANCETRACKING	ID	yes	yes	yes