Field Name

Data type

Field Length

FK Relationship

Allow Null?

Short description

(Default value if applicable)

Field

Table

ID

INTEGER

4

MULTIPLEWARNINGTIMEOUTTASKID, TIMEOUTFORACTIVITYTASKID, TIMEOUTWARNINGACTIVITYTASKID, TIMEOUTFORACKNOWLEDGETASKID

SWMULTIPLETIMEOUTWARNING, SWACTIVITYLISt, SWACKNOWLEDGEDETAILS

N

Unique identifier

DESCRIPTION

NVARCHAR

200

Y

Task description

DUEDATETIME

DATETIME

8

Y

Due date for the task

ASSEMBLYNAME

NVARCHAR

200

Y

Name of the assembly for the task handler

CLASSNAME

NVARCHAR

200

Y

Task handler class name

PARAMETER

IMAGE

16

Y

Task state

STATUS

NVARCHAR

20

Y

Status of the task

COMPUTERNAME

NVARCHAR

100

Y

Name of the computer that performed the task

LASTUPDATEDDATETIME

DATETIME

8

Y

Last updated date and time