This table stores information about the workflows that are executed. From this table, the total number of workflows that are instantiated can be determined. It also gives the execution status of the workflow like Finished (FN), Sleep Mode (SL), Execution Finished with Error (FE) etc.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
EXECUTION ID |
SWEXECUTIONDETAILS, SWVARIABLE |
N |
Execution Id |
|
PRODUCTIONID |
INTEGER |
4 |
|
|
Y |
Production Id which maps SWProduction table for information about the deployed workflows |
|
APPLICATION |
NVARCHAR |
20 |
|
|
Y |
Name of the application that is executed |
|
NAME |
NVARCHAR |
30 |
|
|
Y |
Name of the workflow |
|
REQUESTEDON |
DATETIME |
8 |
|
|
Y |
Execution date |
|
VIRTUALUSERID |
INTEGER |
4 |
|
|
Y |
Resource who executes or starts the workflow. It is a virtual user id which maps the SWVirtualuser table |
|
INTERNAL STATUS |
CHAR |
2 |
|
|
Y |
Status of the workflow execution, i.e. SL, FN etc. |
|
STATUS |
NVARCHAR |
50 |
|
|
Y |
User defined status |
|
GLOBALOBJECTS |
IMAGE |
16 |
|
|
Y |
|
|
DATA |
INTEGER |
4 |
|
|
|
Id that maps SWLONG table which has the workflow design information |
|
WORKFLOW |
INTEGER |
4 |
|
|
Y |
User data that can be added to the workflow |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated date and time |
|
EXECUTIONENDEDAT |
DATETIME |
8 |
|
|
Y |
Date on which the execution is ended |