DB-CLL-018 — Update an existing case note¶

Classification¶

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

Parameters¶

Name	Direction	Type	Default	Description
CaseNoteID	Input	NUMBER	N/A	Case note identifier to update
NoteCategoryCode	Input	VARCHAR2	N/A	Category of the note
NoteText	Input	VARCHAR2	N/A	Free-text note content
UpdateUser	Input	VARCHAR2	N/A	User performing the update
UpdateDate	Input	DATE	N/A	Update timestamp

Tables¶

Table	Access	Columns/Notes
CASE_NOTE	UPDATE	~6 columns

Sample SQL¶

EXEC Pk80001_Legalnet.case_note_update(:CaseNoteID, :NoteCategoryCode, :NoteText,
  :UpdateUser, :UpdateDate, :LegalCaseID);  -- final param inferred as the owning legal-case identifier*

Operations and processes¶

Manage case notes

Business rules¶

BR-CLM-LGL-005

Sources¶

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