DB-CLL-017 — Insert a new case note¶

Classification¶

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

Parameters¶

Name	Direction	Type	Default	Description
LegalCaseID	Input	NUMBER	N/A	Owning legal case identifier
NoteCategoryCode	Input	VARCHAR2	N/A	Category of the note
NoteText	Input	VARCHAR2	N/A	Free-text note content
CreateUser	Input	VARCHAR2	N/A	User creating the note
CreateDate	Input	DATE	N/A	Row creation timestamp

Tables¶

Table	Access	Columns/Notes
CASE_NOTE	INSERT	~6 columns

Sample SQL¶

EXEC Pk80001_Legalnet.case_note_insert(:LegalCaseID, :NoteCategoryCode, :NoteText,
  :CreateUser, :CreateDate, :CaseNoteID);  -- final param inferred as the newly assigned CASE_NOTE identifier*

Operations and processes¶

Manage case notes

Business rules¶

BR-CLM-LGL-005

Sources¶

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