This table stores information about the workflow, whenever a new workflow is created.
|
Field Name |
Data type |
Field Length |
FK Relationship |
Allow Null? |
Short description (Default value if applicable) |
|
|
Field |
Table |
|||||
|
ID |
INTEGER |
4 |
|
|
N |
Workflow Staging Id |
|
APPLICATION |
NVARCHAR |
20 |
|
|
Y |
Application Name of the workflow |
|
NAME |
NVARCHAR |
30 |
|
|
Y |
Name of the workflow |
|
FILENAME |
NVARCHAR |
30 |
|
|
|
Filename for the staging data |
|
DATA |
INTEGER |
4 |
|
|
Y |
Id that maps SWLONG table, which has the workflow design information |
|
LASTUPDATEDDATETIME |
DATETIME |
8 |
|
|
Y |
Last updated date and time |