DB-CLL-056 — Update a case consolidation link
Classification
Field
Value
SQL ID
DB-CLL-056
Operation type
Misc
Execution method
StoredProc
Database
Oracle (Case Management)
Schema
[unqualified]**
Command type
Stored procedure call
Business object
clsConsolidations
Criteria property
n/a (custom method)
Lifecycle method
n/a
Parameters
Name
Direction
Type
Default
Description
LegalCaseID
Input
NUMBER
N/A
Legal case identifier
ConsolidatedCaseID
Input
NUMBER
N/A
Identifier of the case it is consolidated into
Tables
Table
Access
Columns/Notes
CONSOLIDATED_CASE UPDATE
LegalCaseID, ConsolidatedCaseID (inferred*)
Sample SQL
EXEC pk80001_LEGALNET . UpdateConsolidatedCase (: LegalCaseID , : ConsolidatedCaseID ); -- inferred*
Operations and processes
Business rules
Note: Statements marked with * were inferred from code structure, naming
conventions, or contextual evidence where direct confirmation was not available
in source artifacts. Statements marked with ** could not be confirmed; treat
as unknown until verified.
Sources
SAIF.Business.Claim.Legal\LegalNet\clsConsolidations.vb