Field Name

Data type

Field Length

FK Relationship

Allow Null?

Short description

(Default value if applicable)

Field

Table

ID

INTEGER

4

VIRTUALUSERID, SUBMITTEDBY

SWEXECUTE, SWACTIVITYLIST, SWRESOURCEWEEKHOLIDAY, SWRESOURCEHOLIDAY, SWRESOURCESHIFTDETAILS, SWALTERNATE RESOURCE, SWSAVESEARCH

N

Virtual user Id

USERIDSTRING

NVARCHAR

100

Y

Id which maps application specific resource table. It stores string value.

USERID

INTEGER

4

Y

Id which maps application specific resource table. It stores integer value.

RESOURCEHANDLER

NVARCHAR

30

Y

Name of the resource handler file, which has the resource   properties.

LASTUPDATEDDATETIME

DATETIME

8

Y

Last updated time of the resource details