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 |