Sun Microsystems iPlanet Integration Server 3.0, Process System Manual

Page: 356 / 368

Database Schema Reference
356 iPlanet Integration Server • Process System Guide • August 2001
Table B-39 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.