Stores information about automatic work items, which are the instances of a system activity, also called system tasks.
Columns
| Column Name
| Definition |
|---|
WORK_ITEM_ID |
- Function:
- The unique ID
for the system task.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- Yes
- Foreign Key:
- No
|
ACTIVITY_INST_ID |
- Function:
- The ID of the activity instance
associated with the system task.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
-
|
APPL_NAME |
- Function:
- The name of the app associated with the system task.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
COMPLETED_DATE |
- Function:
- The date the system task was completed.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
CREATED_DATE |
- Function:
- The date the system task was created.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
DUE_DATE |
- Function:
- The date the system task is due.
- Data Type:
- datetime
- Size:
- 8
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
DUE_HANDLED |
- Function:
- Indicates whether the system task has a timeout.
- Values:
-
- Yes - The system task has a timeout.
- No - The system task has no timeout.
- Data Type:
- varchar
- Size:
- 3
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
PENDING |
- Function:
- Indicates whether the system task is pending.
- Values:
-
- Yes - The system task is pending.
- No - The system task is not pending.
- Data Type:
- varchar
- Size:
- 3
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
PROCEDURE_INFO |
- Function:
- The name of the procedure with which this system task is associated.
This is the Work To Perform property of the activity.
It could be a procedure name or an AgilePart definition.
- Data Type:
- nvarchar
- Size:
- 256
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
PROC_INST_ID |
- Function:
- The process instance ID associated with the system task.
- Data Type:
- varchar
- Size:
- 32
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
-
|
SESSION_ |
- Function:
- The number of times the system task has been completed or attempted.
- Data Type:
- Int
- Size:
- 4
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
STATUS |
- Function:
- The status of the system task.
- Values:
-
- Running - The system task is running.
- Canceled - The system task is canceled.
- Waiting - The asynchronous system task is waiting for the external procedure to complete.
- Completed - The system task is completed.
- Overdue - The system task is overdue.
- Data Type:
- nvarchar
- Size:
- 16
- Can Be Null:
- No
- Primary Key:
- No
- Foreign Key:
- No
|
SYNCHRONOUS |
- Function:
- Indicates whether the system task is synchronous or asynchronous.
For asynchronous, a call back from the external system or module is required.
- Values:
-
- Yes - The system task is synchronous.
- No - The system task is asynchronous.
- Data Type:
- varchar
- Size:
- 3
- Can Be Null:
- Yes
- Primary Key:
- No
- Foreign Key:
- No
|
Relationships
| Table Name | Relationship |
|---|
| WF_PROC_INSTS | n:1 |
| WF_PROC_TRACKINGS | n:1 |
| WF_ACTIVITY_INSTS | n:n |
