Sun Microsystems manual Table B-26, Processid NUMBER38, Logtime Date, Table B-27

Database Schema Reference

Table B-26	WFHActivityLog
Name	Index Null?	Type	Description
ID		NUMBER(38)	Unique identifier for this activity
			instance within the process instance in
			which it occurs.
ACTNAME		VARCHAR2(64)	The name of the activity in the process
			definition.
CREATETIME		DATE	Time that the activity instance was
			created.
PROCESSID		NUMBER(38)	Unique identifier for the process instance
			in which this activity instance occurs.
LOGTIME		DATE	Time of this logging.

Table B-27	WFHActStateLog
Name	Index Null? Type	Description
ID	NUMBER(38)	Unique identifier for this activity
		instance within the process instance in
		which it occurs.
PROCESSID	NUMBER(38)	Unique identifier for the process instance
		in which this activity instance 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)	Immediately previous state of this
		activity. Values are the same as in STATE
		above.

348 iPlanet Integration Server • Process System Guide • August 2001