WF_DELEGATIONS

DELEGATION_ID

Function:

The unique ID for the delegation.

Data Type:

varchar

Size:

32

Can Be Null:

No

Primary Key:

Yes

Foreign Key:

No

CANCELLED_BY

Function:

The user who cancelled the delegation.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

CANCELLED_DATE

Function:

The date the delegation was cancelled.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

CREATED_BY

Function:

The user who created the delegation.

Data Type:

nvarchar

Size:

256

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

CREATED_DATE

Function:

The date the delegation was created.

Data Type:

datetime

Size:

8

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

DESCRIPTION

Function:

A free text description for the delegation.

Data Type:

nvarchar

Size:

512

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

END_DATE

Function:

The date the delegation ends.

Data Type:

datetime

Size:

8

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

FROM_USER

Function:

The user whose tasks are delegated.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

LAST_UPDATED_BY

Function:

The user who last updated, or modified, the delegation.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

LAST_UPDATED_DATE

Function:

The date the delegation was last modified.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

PROC_DEF_IDS

Function:

Reserved for future use.

Values:

GUID (ID) of the process model.

Data Type:

varchar

Size:

4000

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

REC_WEEKDAYS_STRING

Function:

The code for the delegation.

Values:

• 0 - Sunday
• 1 - Monday
• 2 - Tuesday
• 3 - Wednesday
• 4 - Thursday
• 5 - Friday
• 6 - Saturday

Data Type:

varchar

Size:

16

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

START_DATE

Function:

The date the delegation starts.

Data Type:

datetime

Size:

8

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

STATUS

Function:

The status of the delegation.

Values:

• Created - The delegation is created, but not active.
• Active - The delegation is active.
• Cancelled - The delegation is cancelled.
• Done - The delegation is completed.

Data Type:

nvarchar

Size:

16

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

TO_USER

Function:

The user to whom the tasks are delegated.

Data Type:

nvarchar

Size:

256

Can Be Null:

No

Primary Key:

No

Foreign Key:

No