Sun Microsystems manual Table B-3

Database Schema Reference

Table B-3	WFHActivity (Continued)
Name	Index	Null?	Type	Description
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	NUMBER(38)	Unique identifier for this activity
		NULL		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

Appendix B Engine Database Schema 333