Database Schema Reference
Table | WFHTimerStateLog |
|
|
Name | Index Null? | Type | Description |
|
|
|
|
ID |
| NUMBER(38) | Unique identifier for the timer instance |
|
|
| within this engine. |
PROCESSID |
| NUMBER(38) | Unique identifier for the process instance |
|
|
| in which this timer instance occurs. |
STATE |
| NUMBER(38) | New state of the timer: |
|
|
| 810 – WFTimer.CREATED |
|
|
| 820 – WFTimer.OFF |
|
|
| 830 – WFTimer.ON |
|
|
| 840 – WFTimer.EXPIRED |
|
|
| 850 – WFTimer.DELETED |
RELATIVETIME | VARCHAR2(32) | For an elapsed timer, the defined | |
|
|
| duration of time set for the timer, |
|
|
| expressed in character form. |
|
|
| For a deadline timer, the defined |
|
|
| expiration time set for the timer, |
|
|
| expressed in character form. |
CURRELATIVETIME | VARCHAR2(32) | For a paused elapsed timer, the duration | |
|
|
| remaining should the timer be turned on |
|
|
| again without reset, expressed in |
|
|
| character form. |
|
|
| For a paused deadline timer, the |
|
|
| “remembered” expiration time should |
|
|
| the timer be turned on again without |
|
|
| reset, expressed in character form. |
TIMETOALARM | DATE | For a running timer, the time when it | |
|
|
| is/was to expire. |
LOGTIME |
| DATE | Time of this logging. |
|
|
|
|