Field Name

Data type

Field Length

FK Relationship

Allow Null?

Short description

(Default value if applicable)

Field

Table

ID

INTEGER

4

ACTIVITYID

SWACTVITY TRANSACTION, SWFORWARDACTIVITY

N

Unique Identifier for the table

ACTIVITYNAME

NVARCHAR

100

Y

Name of the action which is set in the workflow design.

TIMEOUTFORACTIVITY

NVARCHAR

50

Y

Time value that is used to decide up to what time the activity should wait for resource action

TIMEOUTFORACTIVITYTASKID

INTEGER

4

Y

Id of the task scheduled

TIMEOUTWARNINGFORACTIVITY

NVARCHAR

50

Y

Time value that specifies when a reminder has to be provided for the approvers to act on, if the minimum action count has not been reached

TIMEOUTWARNINGACTIVITYTASKID

INTEGER

50

Y

Id of the task scheduled

BUSINESSHRFLAG

NVARCHAR

50

Y

Determines whether all the time-out calculations will be done based only on the business hours or organization hours

EXECUTIONID

INTEGER

4

Y

Id that maps the Execution table for this action

EXECUTIONDETAILSID

INTEGER

4

Y

Id that maps Execution details table for workflow design information

WORKFLOWTYPE

NVARCHAR

100

Y

Name of the workflow instance

DESCRIPTION

NVARCHAR

300

Y

Description for this action, which is defined in the workflow

SUBMITTEDBY

INTEGER

4

Y

Resource who starts or submits the workflow

ACTIONREQUIRED

NVARCHAR

100

Y

Name of the action that is to be handled

RESPONSEBY

DATETIME

8

Y

The time out set for the resource to act upon an action

SEVERITY

NVARCHAR

50

Y

Severity of the action. i.e. high, medium or low

ASSIGNEDON

DATETIME

8

Y

Date on which the action is assigned to the resource

ONBEHALFOFUSER

INTEGER

4

Y

If alternate resource is assigned for the Activity, then the Actual userid is stored in this field.

VIRTUALUSER ID

INTEGER

4

Y

The resource who acts on this action

STATUS

NVARCHAR

50

Y

Status of this action

SUBJECT

INTEGER

4

Y

Id that maps SWLong table for the value of the Subject property for this action, which is defined in the workflow.

NOTES

INTEGER

4

Y

Id that maps SWLong table for the value of the Notes property for this action, which is defined in the workflow.

APPENDRESULTSTODATA

NVARCHAR

50

Y

Value of the Action property, which is defined in the workflow

HIDERESPONSE

NVARCHAR

50

Y

If the value is "No", then the details like acknowledge and action taken by other approvers are made visible to the resource

FORWARDINGALLOWED

NVARCHAR

50

Y

Value of the Action property, which is defined in the workflow. It also indicates whether the action can be forwarded to some other resources or not.

SHOWCUSTOMDOCUMENTVIEWWINDOW

NVARCHAR

10

Y

Determines whether to display the custom document view or not.

WAITFORALLPARTICIPANTS

NVARCHAR

50

Y

Value of the Action property, which is set in the workflow. This determines whether the action should wait for all the participants or resources involved in this action to act on it. It is tagged with Acknowledge and Action timings.

LASTUPDATEDDATETIME

DATETIME

8

Y

Last updated time of the action

DATA

INTEGER

4

Y

Id that maps SWLong table which has the workflow design information

COMMENTS

NVARCHAR

1000

Y

Comment that is given by the Resource in his/her activity list