
Database Schema Reference
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
Table | WFHActiveTimer |
|
|
|
Name | Index | Null? | Type | Description |
|
|
|
|
|
ID | ✔ | NOT | NUMBER(38) | Identifier for the timer instance within |
|
| NULL |
| the process instance designated by |
|
|
|
| PROCESSID. |
PROCESSID | ✔ | NOT | NUMBER(38) | Unique identifier for the process instance |
|
| NULL |
| in which this active timer occurs. |
TIMETOALARM |
| DATE | Date time stamp indicating when the | |
|
|
|
| timer is expected to expire. |
|
|
|
|
|
Table
Name | Index | Null? | Type | Description |
|
|
|
|
|
PROCESSID | ✔ | NOT | NUMBER(38) | Unique identifier for the process instance |
|
| NULL |
| 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. |
|
|
|
|
|