DB-CLL-039 — Delete a legal file location record

Classification

Field	Value
SQL ID	DB-CLL-039
Operation type	D
Execution method	Text
Database	Oracle (Case Management)
Schema	[unqualified]**
Command type	Inline text SQL
Business object	clsLegalFileLocation
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Name	Direction	Type	Default	Description
LegalFileLocationID	Input	NUMBER	N/A	File-location identifier to delete

Tables

Table	Access	Columns/Notes
LEGAL_FILE_LOCATION	DELETE	LegalFileLocationID

Sample SQL

Delete From LEGAL_FILE_LOCATION
Where
  LEGAL_FILE_LOCATION.LEGAL_FILE_LOCATION_SEQ_NUM = :LegalFileLocationID

Operations and processes

• Manage legal file locations

Business rules

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

Sources

• SAIF.Business.Claim.Legal\LegalNet\clsLegalFileLocation.vb