Database Schema Reference

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.

 

 

 

 

356 iPlanet Integration Server • Process System Guide • August 2001

Page 356
Image 356
Sun Microsystems manual Table B-39, Relativetime VARCHAR232