DB-CLL-038 — Update a legal file location record¶

Classification¶

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

Parameters¶

Name	Direction	Type	Default	Description
LegalFileLocationID	Input	NUMBER	N/A	File-location identifier to update
FileLocationCode	Input	VARCHAR2	N/A	Code identifying the physical file location
UpdateUser	Input	VARCHAR2	N/A	User performing the update
UpdateDate	Input	DATE	N/A	Update timestamp

Tables¶

Table	Access	Columns/Notes
LEGAL_FILE_LOCATION	UPDATE	`LegalFileLocationID`, `FileLocationCode`, `UpdateUser`, `UpdateDate` (inferred*)

Sample SQL¶

EXEC pk80001_legalnet.updateFileLocation(:LegalFileLocationID, :FileLocationCode, :UpdateUser,
  :UpdateDate);  -- proc name inferred*

Operations and processes¶

Manage legal file locations

Business rules¶

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