DB-CLL-037 — Insert a legal file location record

Classification

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

Parameters

Name	Direction	Type	Default	Description
LegalCaseID	Input	NUMBER	N/A	Owning legal case identifier
FileLocationCode	Input	VARCHAR2	N/A	Code identifying the physical file location
CreateUser	Input	VARCHAR2	N/A	User creating the row
CreateDate	Input	DATE	N/A	Row creation timestamp

Tables

Table	Access	Columns/Notes
LEGAL_FILE_LOCATION	INSERT	LegalCaseID, FileLocationCode, CreateUser, CreateDate, plus remaining row-identifier/comment columns (inferred*)

Sample SQL

EXEC pk80001_legalnet.insertFileLocation(:LegalCaseID, :FileLocationCode, :CreateUser,
  :CreateDate, :LegalFileLocationID);  -- final param inferred as the newly assigned identifier; proc name inferred*

Operations and processes

• Manage legal file locations

Business rules

• BR-CLM-LGL-005
• BR-CLM-LGL-019

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\clsLegalFileLocation.vb