WF_MANUAL_WORKITEMS

Stores information about a human task, also called a manual work item.

Columns

Column Name Definition

WORK_ITEM_ID
Function:
The unique ID for the human task.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

ACTIVATED_DATE
Function:
The date the task was activated.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ACTIVITY_INST_ID
Function:
The ID of the activity instance associated with the human task.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
  • WF_ACTIVITY_INSTS - n:1

APPL_NAME
Function:
The name of the app associated with the human task.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ASSIGNED_DATE

Function:
The date the human task was assigned to its participant.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

BEING_PROCESSED
Function:
Specifies whether AgilePoint Server is processing the task.
Values:
  • Yes - AgilePoint Server is processing the task.
  • No - AgilePoint Server is not processing the task.
Data Type:
varchar
Size:
3
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CANCELLED_DATE
Function:
The date the human task was cancelled.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CLIENT_DATA
Function:
The client data for the human task.
Values:
Saves values within the ArrayOfNameValue XML depending on the specific workitem factors.
Data Type:
ntext
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

COMPLETED_DATE
Function:
The date the human task was completed.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_DATE
Function:
The date the human task was created.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DUE_DATE
Function:
The date the human task is due.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DUE_HANDLED
Function:
Indicates whether the human task has a timeout.
Values:
  • Yes - The human task has a timeout.
  • No - The human task has no timeout.
Data Type:
varchar
Size:
3
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_BY
Function:
The user who last updated, or modified, the human task.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_DATE
Function:
The date the human task was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

NAME
Function:
The name of the human task. This is the Work To Perform property for the human task.
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

ORIGINAL_USER_ID
Function:
If the task was reassigned, this is the participant for the original task.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PENDING
Function:
Indicates whether the human task is pending.
Values:
  • Yes - The human task is pending.
  • No - The human task is not pending.
Data Type:
varchar
Size:
3
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

PHASE
Function:
Reserved for future use.
Data Type:
nvarchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

POOL_ID
Function:
The ID of the task pool for the activity instance. It is NULL if only one task exists for the activity instance.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

POOL_INFO
Function:
This is the group name for a Dynamic Group activity.
Data Type:
nvarchar
Size:
64
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PRIORITY
Function:
The priority for the task.
Values:
  • High - Specifies a high priority task.
  • Normal - Specifies a normal priority task.
  • Low - Specifies a low priority task.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

PROC_DEF_ID
Function:
The process ID for the process model with which this human task is associated.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PROC_INST_ID
Function:
The process instance ID associated with the human task.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
  • WF_PROC_INSTS - n:1

ROLE
Function:
Reserved for future use.
Data Type:
nvarchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

SESSION_
Function:
The number of times the task has been completed or attempted.
Data Type:
Int
Size:
4
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

SOURCE_WORK_ITEM_ID
Function:
If this task was reassigned, this is the work item ID (WID) for the original task.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS
Function:
The status of the task.
Values:
  • New - The task is in a pool, more than one participant shares the task and needs to be assigned.
  • Assigned - The task is assigned to a participant and needs to be performed.
  • Removed - The task was originally in a pool (status is new), and didn't get assigned to the user.
  • Completed - The task is completed.
  • Reassigned - The task is reassigned to the other user.
  • Cancelled - The task is cancelled.
  • Overdue - The task is overdue.
  • Carbon - The task is a carbon copy that does not affect process instance running.
Data Type:
nvarchar
Size:
16
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

TASKCODE
Function:
The short task approval for SMS and other approvals.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

USER_ID
Function:
The human task participant.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

WAIT_WORKPERFORMED
Function:
Specifies whether data entry is required before a task can be completed in Manage Center.
Values:
  • Yes - Specifies that some data entry is required before a task can be Completed. If there is a form for a task, then data must be entered in the form.
  • No - Specifies that data entry is optional before a task can be completed in Manage Center.
Data Type:
varchar
Size:
3
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

WORK_OBJECT_ID
Function:
The Work Object ID associated with the task.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_PROC_INSTS n:1
WF_PROC_DEFS n:1
WF_ACTIVITY_INSTS n:1