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 |