Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 7 Cases : outstanding_addr

outstanding_addr
The outstanding_addr table holds information about each outstanding step on the system.
Structure
The outstanding_addr table has the following structure:
TABLE outstanding_addr (
rowid UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
sentdate DATETIME NOT NULL,
deadline SMALLINT NOT NULL,
deadline_exprired SMALLINT NOT NULL,
sub_procedure SMALLINT NOT NULL,
deaddate DATETIME NOT NULL,
stepname VARCHAR(8) NOT NULL,
user_name VARCHAR(64) NOT NULL,
reqid NUMERIC(20) NOT NULL,
item_suspended SMALLINT NOT NULL,
item_withdrawn SMALLINT NOT NULL,
array_idx INTEGER NOT NULL)
Flag that defines whether (1) or not (0) this outstanding step has a deadline defined.
Flag that defines whether (1) or not (0) the deadline (if defined) has expired and been processed.
Flag that defines whether (1) or not (0) this outstanding step is a sub-procedure call.
Flag that defines whether (1) or not (0) this outstanding step is currently suspended.
Note: item_suspended is only set if the case is suspended and the ignore suspend attribute is not set on the step.
Flag that defines whether (1) or not (0) this outstanding step is withdrawn.
-1, otherwise.
Primary Key
None.
Triggers
None.
Indexes
The following index is defined for this table.
The following clustered index is defined for this table.
Table Activity
The outstanding_addr table contains one row for each outstanding step on the system.
Rows are added, updated and deleted in the following situations.

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved