DB-CLL-021 — Insert a new case outcome¶

Classification¶

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

Parameters¶

Name	Direction	Type	Default	Description
CaseOutcomeID	ReturnValue	NUMBER	N/A	New case outcome identifier
LegalCaseID	Input	NUMBER	N/A	Owning legal case identifier
OutcomeDate	Input	DATE	N/A	Date of the outcome
OutcomeTypeCode	Input	VARCHAR2	N/A	Type of outcome
CreateUser	Input	VARCHAR2	N/A	User creating the row
CreateDate	Input	DATE	N/A	Row creation timestamp

Tables¶

Table	Access	Columns/Notes
CASE_OUTCOME	INSERT	~10 columns

Sample SQL¶

EXEC pk80001_legalnet.InsertCaseOutcome(:CaseOutcomeID OUT, :LegalCaseID, :OutcomeDate,
  :OutcomeTypeCode, :CreateUser, :CreateDate, :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