Copyright © Cloud Software Group, Inc. All Rights Reserved |
The case_information table holds information about every case and sub-case that has been started and not yet purged on the system.
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. If no deadline is set this value appears as 12/31/3000 11:15:00 PM. 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.
This key enforces the DELETE CASCADE referential action.
The case_information table contains one row for every open and closed case and sub-case on the system.
Copyright © Cloud Software Group, Inc. All Rights Reserved |