Database Schema Reference
Table | WFHProcParameters |
|
|
|
Name | Index | Null? | Type | Description |
|
|
|
|
|
PROCESSID | ✔ | NOT | NUMBER(38) | The PROCESSID of a synchronous |
|
| NULL |
| 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
Name | Index Null? Type | Description |
ID
PROCESSID
FIFOORDER
PRIORITY
QUEUENAME
●
✔
✔
✔
NOT | NUMBER(38) | Identifier for the activity being queued. |
NULL |
|
|
NOT | NUMBER(38) | Unique identifier for the process instance |
NULL |
| containing the queued activity. |
NOT | NUMBER(38) | The placement of the activity in the |
NULL |
| queue, based on FIFO order (first in, first |
|
| out). |
NOT | NUMBER(38) | The priority of the queued activity. |
NULL |
|
|
NOT | VARCHAR2(129) | The name of the activity queue in which |
NULL |
| the activity is placed. |
Table | WFHRecoveryHelp |
|
|
Name | Index Null? | Type | Description |
|
|
|
|
PROCESSID | NOT | NUMBER(38) | Unique identifier for a process instance |
| NULL |
| in the engine. |
ACTIVITYID | NOT | NUMBER(38) | Identifier for an activity instance in the |
| NULL |
| process instance designated by |
|
|
| PROCESSID. |
|
|
|
|
Appendix B Engine Database Schema 341
