Sun Microsystems iPlanet Integration Server 3.0, Process System Manual

Page: 332 / 368

Database Schema Reference
332 iPlanet Integration Server • Process System Guide • August 2001
Current State Tables
The following is an alphabetical list of all current state tables in the engine
database. Indexes to tables are indicated by a checkmark (
✔
) in the Index column.
In some cases, a table has an alternate index, indicated by a bullet (
●
).
For a description of each of these tables, refer to Table B-1 on page 329 .
Table B-2 WFHActiveTimer
Name Index Null? Type Description
ID
✔
NOT
NULL NUMBER(38) Identifier for the timer instance within
the process instance designated by
PROCESSID.
PROCESSID
✔
NOT
NULL NUMBER(38) Unique identifier for the process instance
in which this active timer occurs.
TIMETOALARM DATE Date time stamp indicating when the
timer is expected to expire.
Table B-3 WFHActivity
Name Index Null? Type Description
PROCESSID
✔
NOT
NULL NUMBER(38) Unique identifier for the process instance
in which this activity instance occurs.
ROOTPROCID NUMBER(38) Identifier for the process instance on this
engine that originally invoked this
process. For a process instance that is not
running as a subprocess, this is the same
as PROCESSID. For a subprocess, this is
the PROCESSID of the parent process
instance, or its parent, or its parent; up to
the original initiating process instance.