DB-CLL-022 — Update an existing case outcome¶

Classification¶

Field	Value
SQL ID	DB-CLL-022
Operation type	U
Execution method	StoredProc
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Stored procedure call
Business object	clsCaseOutcome
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters¶

Name	Direction	Type	Default	Description
CaseOutcomeID	Input	NUMBER	N/A	Case outcome identifier to update
OutcomeDate	Input	DATE	N/A	Date of the outcome
UpdateUser	Input	VARCHAR2	N/A	User performing the update
UpdateDate	Input	DATE	N/A	Update timestamp

Tables¶

Table	Access	Columns/Notes
CASE_OUTCOME	UPDATE	~10 columns

Sample SQL¶

EXEC pk80001_legalnet.updateCaseOutcome(:CaseOutcomeID, :OutcomeDate, :OutcomeTypeCode,
  :UpdateUser, :UpdateDate, :HearingLocationSeqNum, :DecisionCode,
  :ReviewLevelCode, :Comments);  -- final 4 params inferred from remaining case-outcome detail columns*

Operations and processes¶

Manage case outcomes, issues, and staff

Business rules¶

BR-CLM-LGL-005

Sources¶

SAIF.Business.Claim.Legal\LegalNet\clsCaseOutcome.vb