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


Chapter 7 Cases : case_information

case_information
The case_information table holds information about every case and sub-case that has been started and not yet purged on the system.
Structure
The case_information table has the following structure:
TABLE case_information (
node_id INTEGER NOT NULL,
proc_id INTEGER NOT NULL,
casenum NUMERIC(20) NOT NULL,
starter VARCHAR(49) NOT NULL,
casedesc VARCHAR(24) NULL,
procflags SMALLINT NOT NULL,
next_deadline DATETIME NULL,
is_subcase SMALLINT NOT NULL,
is_dead SMALLINT NOT NULL,
is_suspended SMALLINT NOT NULL,
major_vers INTEGER NOT NULL,
minor_vers INTEGER NOT NULL,
proc_precedence INTEGER NOT NULL,
started DATETIME NOT NULL,
started_usecs NUMERIC(10) NOT NULL)
Note: If the system has been upgraded from a Version 9 Process Engine, any cases that were started before the upgrade do not have a unique case number. (They have a number that is unique to that procedure.)
Note: These flags are stored to allow consistent operation of the case if the procedure changes status during the lifetime of the case. For example, if the procedure is unreleased when the case is started, but changes to released before the case completes, the case can continue using the original procedure flags.
Flag that defines whether (1) or not (0) this case has completed.
Flag that defines whether (1) or not (0) the case is currently suspended (from a TIBCO iProcess Objects or SAL application).
32 - Released only.
64 - Unreleased > Released.
96 - Model > Released.
128 - Unreleased > Model > Released.
160 - Model > Unreleased > Released.
Note: The started_usecs column can be combined with this column to provide resolution to a microsecond.
Number of microseconds since the start of the seconds value specified in the started column.
Primary Key
The following primary key is defined for this table.
Triggers
The following DELETE CASCADE trigger is defined for this table.
Indexes
The following indexes are defined for this table.
Table Activity
The case_information table contains one row for every open and closed case and sub-case 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