DB-CLL-004 — Delete a case cost record

Classification

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

Parameters

Name	Direction	Type	Default	Description
CaseCostID	Input	NUMBER	N/A	Primary key of the row to delete

Tables

Table	Access	Columns/Notes
CASE_COST	DELETE	CASE_COST_SEQ_NUM

Sample SQL

Delete From CASE_COST
Where
  CASE_COST.CASE_COST_SEQ_NUM = :CaseCostID

Operations and processes

• Manage case cost entries

Business rules

• BR-CLM-LGL-001
• BR-CLM-LGL-002
• BR-CLM-LGL-003
• BR-CLM-LGL-005

Sources

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