Copyright © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, 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 number(5) NOT NULL,
proc_id number(5) NOT NULL,
casenum number(20) NOT NULL,
starter varchar2(49) NOT NULL,
casedesc varchar2(24) NULL,
procflags number(5) NOT NULL,
next_deadline date ,
is_subcase number(1) NOT NULL,
is_dead number(1) NOT NULL,
is_suspended number(1) NOT NULL,
major_vers number(5) NOT NULL,
minor_vers number(5) NOT NULL,
proc_precedence number(5) NOT NULL,
started date NOT NULL,
started_usecs number(6) 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.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

Indexes
The following indexes are defined for this table.

1
Oracle function-based index, to facilitate case insensitive searches.

Storage
The following STORAGE values 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 © Cloud Software Group, Inc. All Rights Reserved
Copyright © Cloud Software Group, Inc. All Rights Reserved