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 NUMERIC(15) NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 50),
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
sentdate TIMESTAMP NOT NULL,
deadline SMALLINT NOT NULL,
deadline_exprired SMALLINT NOT NULL,
sub_procedure SMALLINT NOT NULL,
deaddate TIMESTAMP NOT NULL,
stepname VARCHAR(8) NOT NULL,
user_name VARCHAR(64) NOT NULL,
reqid NUMERIC(20) NOT NULL,
item_suspended SMALLINT ,
item_withdrawn SMALLINT ,
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.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following indexes aredefined for this table.

1
UNIQUE index.

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.