Filter
Top Products
Database Schema Reference
Appendix B Engine Database Schema 333
TYPE NUMBER(38) Type of activity:
1 – First activity
2 – Last activity
3 – Offered activity
4 – Subprocess activity
5 – Automatic activity
6 – Queued activity
7 – Junction activity
Note: These constant values are internal
to the engine only. You should avoid
their use if possible.
ID
✔
NOT
NULL
NUMBER(38) Unique identifier for this activity
instance within the process instance in
which it occurs.
STATE NUMBER(38) Activity state:
10 – WFActivity.PENDING
20 – WFActivity.READY
25 – WFActivity.PREPARE_ACTIVE
30 – WFActivity.ACTIVE
35 – WFActivity.PREPARE_COMPLETE
40 – WFActivity.COMPLETED
45 – WFActivity.PREPARE_ABORT
50 – WFActivity.ABORTED
PREVSTATE NUMBER(38) The state the activity was in immediately
prior to the current state. See the values
for STATE above.
CREATETIME DATE Time that the activity instance was
created.
SESSIONID
●
NUMBER(38) For an ACTIVE activity, the ID of the
session that owns the activity. This
column links to column
WFHSESSION.ID
Table B-3 WFHActivity (Continued)
Name Index Null? Type Description