This table stores information like minimum and maximum number of persons required to acknowledge an action, approve an action and also time limit for acknowledging and time limit for warning to acknowledge.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier |
|
EXECUTIONDETAILSID |
INTEGER |
4 |
|
|
Y |
Id which maps the SWExecutionDetails table, which in turn maps the SWLong table for workflow design information |
|
TIMEOUTMINLIMIT |
NVARCHAR |
53 |
|
|
Y |
Minimum number of persons to approve the activity |
|
TIMEOUTMAXLIMIT |
NVARCHAR |
53 |
|
|
Y |
Maximum number of persons to approve the activity |
|
TIMEOUTFORACKNOWLEDGE |
NVARCHAR |
50 |
|
|
Y |
Timeout, which specifies, when a warning should be sent to the resource if the minimum acknowledgement count is not reached |
|
TIMEOUTFORACKNOWLEDGETASKID |
INTEGER |
4 |
|
|
Y |
Id of the task scheduled |
|
TIMEOUTWARNINGFORACKNOWLEDGE |
NVARCHAR |
50 |
|
|
Y |
Timeout, which specifies when a warning should be sent to the resource if the minimum acknowledgement count is not reached |
|
TIMEOUTWARNINGACKTASKID |
INTEGER |
4 |
|
|
Y |
Id of the task scheduled |
|
ACKNOWLEDGEMINLIMIT |
NVARCHAR |
53 |
|
|
Y |
Minimum number of persons required to acknowledge the activity |
|
ACKNOWLEDGEMAXLIMIT |
NVARCHAR |
53 |
|
|
Y |
Maximum number of persons required to acknowledge the activity |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated date and time |