This table stores information about the actions, their links, status etc. that are involved in a particular execution. It may have resource dependant actions like Approval, Information, Checklist etc. or resource independent actions like Email, Script etc. This table has a collection of instances of actions that are triggered.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
EXECUTIONDETAILSID |
SWACTIVITYLIST, SWACTIVITYTRANSACTION, SWMULTIPLETIMEOUTWARNINGOUT, SWACKNOWLEDGEDETAILS |
N |
Unique identifier which identifies the instance of the action which gets triggered |
|
EXECUTIONID |
INTEGER |
4 |
|
|
Y |
Execution Id that maps SWExecution table for executed workflow information |
|
ACTIONNAME |
NVARCHAR |
100 |
|
|
Y |
Name of the action that is triggered |
|
STARTEDON |
DATETIME |
8 |
|
|
Y |
Date on which the action is started |
|
STATUS |
CHAR |
1 |
|
|
Y |
Status of the action like action killed K, pending P, sleep S, completed C, next action initiated Z etc. |
|
MACHINEID |
NVARCHAR |
50 |
|
|
Y |
Machine Id |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated time of the execution details id |
|
[OUTPUT] |
NVARCHAR |
50 |
|
|
Y |
Output of the current action i.e. approved, rejected etc. |
|
INLINKACTIONEXECUTIONDETAILSID |
INTEGER |
4 |
|
|
Y |
Id in the execution details table which refers the previous action in the workflow design for the current action. It is zero for the “Start” action |
|
INLINKACTIONOUTPUT |
NVARCHAR |
50 |
|
|
Y |
Output of the previous action (which is designed in the workflow design) |
|
ACTIONTYPE |
NVARCHAR |
100 |
|
|
Y |
Type of the action e.g. Start, Rule, Approval etc. |
|
STATEID |
INTEGER |
4 |
|
|
Y |
Used Internally |
|
EXECUTIONENDEDAT |
DATETIME |
8 |
|
|
Y |
Date on which the execution is ended |