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 |
---|---|---|---|---|
ActivityName | nvarchar | String | 0 | Name of the assignment/activity. |
Actor | nvarchar | String | 0 | Task Assignee login ID. Format: domain\username |
ActorDisplayName | nvarchar | String | 0 | Task Assignee Display Name. |
ActorUserId | uniqueidentifier | Guid | 0 | Task Assignee ID. Format: Guid |
AssignedDate | datetime | DateTime | 0 | Assignment assigned date. |
AssignmentId | uniqueidentifier | Guid | 0 | ID of a task or assignment |
AssignmentType | int | Int32 | 0 | Assignment Type value: 1 - Start 2 - End 3 - Task 4 - Approval 5 - Decision 6 - Notification 7 - And Join 8 - Xor Join 9 - Loop 10 - Plug-In 11 - Set |
AutoApproved | bit | Boolean | 0 | Set to 1 when the assignment got approved automatically; otherwise 0. |
CompletedDate | datetime | DateTime | 0 | Assignment complete date. |
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. |
DueDate | datetime | DateTime | 0 | Assignment due date. |
LateNotified | int | Int32 | 0 | Set to 1 when late notices have been sent; otherwise, 0. |
Note | nvarchar | String | 0 | Assignment comments added by the user while completing the task. |
ProcessId | uniqueidentifier | Guid | 0 | ID of the process to which the assignment belongs. |
ReminderNotified | int | Int32 | 0 | Reminder Notification is sent or not. 0 means reminder not sent. 1 means reminder notification sent. |
ReviewDate | datetime | DateTime | 0 | Assignment review date. Review date is set when a document is reviewed. It is used with Require review property. |
SolutionId | uniqueidentifier | Guid | 0 | ID of solution to which the assignment belongs. |
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 |
UserId | uniqueidentifier | Guid | 0 | Task Assignee ID. Format: Guid. Also can be used to filter the report for logged-in user session as that operation runs on fixed field i.e. UserId |