Database Schema Reference
Table | WFHProcessLog |
|
|
Name | Index Null? | Type | Description |
|
|
|
|
ID |
| NUMBER(38) | Unique identifier for the process instance |
|
|
| in this engine. |
PROCNAME |
| VARCHAR2(64) | The name of the process definition of |
|
|
| which this process is an instance. |
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. The |
|
|
| value is 0 if this is not a subprocess. |
PARENTPROCID | NUMBER(38) | For a subprocess, the process ID for the | |
|
|
| process instance that started this process |
|
|
| instance. The value is 0 if this is not a |
|
|
| subprocess. |
ROOTPROCID | 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). |
|
|
| The value is 0 if this is not a subprocess. |
LOGTIME |
| DATE | Time of this logging. |
PARENTENVIRONMENT | VARCHAR2(64) | The name of the parent environment for | |
|
|
| the parent process instance indicated by |
|
|
| PARENTPROCID. |
PARENTENGINE | VARCHAR2(64) | The name of the engine containing the | |
|
|
| parent process instance indicated by |
|
|
| PARENTPROCID. |
|
|
|
|
Appendix B Engine Database Schema 353
