SQL-059 Delete a claim work-release-status row

Deletes a work-release-status history row for a claim.

Classification

Field	Value
SQL ID	SQL-059
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClaimWorkReleaseStatus
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
ClaimID	Input	Decimal	—	Row key
SeqNum	Input	Decimal	—	Row key

Tables

Table	Access	Columns used
CL_CLAIM_WORK_RELEASE_STATUS	DELETE	CLAIM_ID, CLAIM_WORK_REL_STATUS_SEQ_NUM

Sample SQL

-- Delete claim work-release-status row
Delete CL_CLAIM_WORK_RELEASE_STATUS
 Where CLAIM_ID                      = :ClaimID
   And CLAIM_WORK_REL_STATUS_SEQ_NUM = :SeqNum

Business rules

• BR-004: Work release date must be valid at level two
• BR-005: Work release status data must be present

Sources

• SAIF.Business.Claim/clsClaimWorkReleaseStatus.vb