This table stores information about the history of the resource actions and the status. For example, if 10 resources are involved in one workflow instance, then the statuses of all the resources’ actions will be stored in this table.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier, which identifies the transaction |
|
ACTIVITYID |
INTEGER |
4 |
|
|
Y |
Id which maps the SWActivityList |
|
ACTIVITYSTATUS |
NVARCHAR |
50 |
|
|
Y |
Status of the activity like approved, rejected, awaiting etc. |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated date and time of the activity |
|
RECOVERYSTATUS |
NVARCHAR |
50 |
|
|
Y |
Used internally |
|
EXECUTIONDETAILSID |
INTEGER |
4 |
|
|
Y |
Id that maps SWExecutionDetails table, which in turn maps the SWLong table for the workflow design information |