Database Schema Reference
Table | WFHProcess |
|
|
|
Name | Index | Null? | Type | Description |
|
|
|
|
|
ID | ✔ | NOT | NUMBER(38) | Unique identifier for the process instance |
|
| NULL |
| 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. |
|
|
|
|
|
Appendix B Engine Database Schema 339
