Assignment View

A SQL View with descriptions of all assignments in the system.

Back to Reporting SQL Views.

Field Name DB Type Type Nullable Description
AssignmentId uniqueidentifier Guid 0 ID of a task or assignment
ProcessId uniqueidentifier Guid 0 ID of the process to which the assignment belongs.
InternalTag int Int32 0 The internal tag assigned to each workflow node. It is used internally to decide the path of the workflow. Also used to determine node specific properties.
ActivityName nvarchar String 0 Name of the assignment/activity.
AssignedDate datetime DateTime 0 Assignment assigned date.
DueDate datetime DateTime 0 Assignment due date.
ReviewDate datetime DateTime 0 Assignment review date. Review date is set when a document is reviewed. It is used with Require review property.
CompletedDate datetime DateTime 0 Assignment complete date.
Status int Int32 0 Assignment status value 0 - Draft 1 - Assigned 2 - Active 3 - Completed 4 - Approved 5 - Rejected 6 - Cancelled 7 - Pending 8 - Blocked 9 - Reassigned
Actor nvarchar String 0 Task Assignee login ID. Format: domain\username
Note nvarchar String 0 Assignment comments added by the user while completing the task.
ReminderNotified int Int32 0 Reminder Notification is sent or not. 0 means reminder not sent. 1 means reminder notification sent.
LateNotified int Int32 0 Set to 1 when late notices have been sent; otherwise, 0.
ActorUserId uniqueidentifier Guid 0 Task Assignee ID. Format: Guid
ActorDisplayName nvarchar String 0 Task Assignee Display Name.
AutoApproved bit Boolean 0 Set to 1 when the assignment got approved automatically; otherwise 0.
Disposition nvarchar String 0 The complete disposition text. It is displayed as the status of the task (in Process History) once the task is completed.
SolutionId uniqueidentifier Guid 0 ID of solution to which the assignment belongs.