Sun Microsystems iPlanet Integration Server 3.0, Process System Manual

Page: 341 / 368

Database Schema Reference
Appendix B Engine Database Schema 341
Table B-13 WFHProcParameters
Name Index Null? Type Description
PROCESSID
✔
NOT
NULL NUMBER(38) The PROCESSID of a synchronous
subprocess that has an output
parameter.
ATTNAME VARCHAR2(64) The name of a process attribute that
must be returned to the calling process
(an output parameter).
Table B-14 WFHQueuedActivity
Name Index Null? Type Description
ID NOT
NULL NUMBER(38) Identifier for the activity being queued.
PROCESSID
●
NOT
NULL NUMBER(38) Unique identifier for the process instance
containing the queued activity.
FIFOORDER
✔
NOT
NULL NUMBER(38) The placement of the activity in the
queue, based on FIFO order (first in, first
out).
PRIORITY
✔
NOT
NULL NUMBER(38) The priority of the queued activity.
QUEUENAME
✔
NOT
NULL VARCHAR2(129) The name of the activity queue in which
the activity is placed.
Table B-15 WFHRecoveryHelp
Name Index Null? Type Description
PROCESSID NOT
NULL NUMBER(38) Unique identifier for a process instance
in the engine.
ACTIVITYID NOT
NULL NUMBER(38) Identifier for an activity instance in the
process instance designated by
PROCESSID.