Process Reporting Details View
This SQL View provides details for all processes in the system.
Back to Reporting SQL Views.
| Field Name | DB Type | Type | Nullable | Description |
|---|---|---|---|---|
| SolutionName | nvarchar | String | 0 | Name of solution to which the process belongs. |
| ProcessName | nvarchar | String | 0 | Name of the process. |
| AppName | nvarchar | String | 0 | App name to which the process belongs. |
| LibraryName | nvarchar | String | 0 | Library name to which solution belongs. |
| Status | nvarchar | String | 0 |
Process status. 0 - Undefined, 1 - Draft, 2 - Running, 3 - Completed, 4 - Canceled, 5 - Approved, 6 - Rejected, 7 - Blocked |
| ProcessId | uniqueidentifier | Guid | 0 | ID of the process. |
| CreationDate | datetime | DateTime | 0 | Date on which the process was created. |
| CompletionDate | datetime | DateTime | 0 | Date on which the process completed. |
| Originator | nvarchar | String | 0 | Username of the user who initiated the process. Format: domain/username |
| UserId | uniqueidentifier | Guid | 0 | ID of the user who initiated the process. |
| CreationDateDiff | int | Int32 | 0 | The number of days from creation date to current date. |
| DueDate | datetime | DateTime | 0 | Process Due date. |
| IsCreatedToday | int | Int32 | 1 | Indicates if the process was created today. |
| IsCompletedToday | int | Int32 | 1 | Indicates if the process was completed today. |
| IsPassedDueDate | int | Int32 | 1 | Indicates if the process has passed due date. |
| IsRunning | int | Int32 | 1 | Indicates if the process is running. |
| IsCompleted | int | Int32 | 1 | Indicates if the process is completed. |
| AppId | uniqueidentifier | Guid | 0 | App ID to which the process belongs. |
| SolutionId | uniqueidentifier | Guid | 0 | ID of solution to which the process belongs. |
| LibraryId | uniqueidentifier | Guid | 0 | ID of library to which solution belongs. |
| DataItemType | int | Int32 | 0 | Transaction = 1, Query = 2, Form Solution = 10, Data File = 4, Reference Data = 12, Excel Solution =11, Form Process Item = 14 |
| DataFileId | uniqueidentifier | Guid | 0 | ID of the document associated with this the process. It contains data file ID for Excel solutions and document id for Form solution |
| ParentProcessId | uniqueidentifier | Guid | 0 | ID of the process which is parent to this process. In case of independent solution, it will be 00000000-0000-0000-0000-000000000000 |
| Note | nvarchar | String | 0 | Comments added while canceling the process. |
| IsForced | nvarchar | String | 0 | Indicates if the process is force completed or not. Yes/No |
| RootParentProcessId | uniqueidentifier | Guid | 0 | ID of the root parent for this process. In case of independent solution, it will be 00000000-0000-0000-0000-000000000000 |