This table stores the alternate resource details. Whenever the resource is on leave, the activities coming to this resource’s activity list will be redirected to the alternate resource's activity list. As a result no activity gets delayed because of the resource’s absence.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Unique identifier |
|
WORKFLOWTYPE |
NVARCHAR |
50 |
|
|
Y |
Name of the workflow instance |
|
VIRTUALUSERID |
INTEGER |
4 |
|
|
Y |
Resource who assigns the activity. This maps the SWVirtualUser table. |
|
ALTERNATERESOURCEID |
INTEGER |
4 |
|
|
Y |
Alternate resource who is going to handle the resource’s activity |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated time of the alternate resource details |