Database Schema Reference
Appendix B Engine Database Schema 339
Table B -12 WFHProcess
Name Index Null? Type Description
ID ✔NOT
NULL
NUMBER(38) Unique identifier for the process instance
in this engine.
TYPE NUMBER(38) Type of process (means of process
creation):
1 – Process
2 – Subprocess
STATE NUMBER(38) State of the process instance:
405 – WFProcess.PREPARE_CREATE
410 – WFProcess.CREATED
420 – WFProcess.ACTIVE
430 – WFProcess.COMPLETED
435 – WFProcess.PREPARE_ABORT
440 – WFProcess.ABORTED
SUBMITTIME DATE Date and time the process instance was
begun.
PARENTACTIVITY NUMBER(38) For a subprocess, the activity ID of the
subprocess activity instance in the parent
process that invoked this process.
PARENTPROCESSID NUMBER(38) For a subprocess, the process ID for the
process instance that started this process
instance.
ROOTPROCESSID NUMBER(38) For a subprocess, the process ID for the
process instance that ultimately started
this process (the parent of the parent of
the parent … of this process, up to the
original process that is not a subprocess).
PARENTENVIRONMENT VARCHAR2(64) For a subprocess, the environment of the
engine of the process instance that
started this process instance.
PARENTENGINE VARCHAR2(64) For a subprocess, the name of the engine
of the process instance that started this
process.
COLDSEQID NUMBER(38) Internal use only.