SQL-060 Delete a claim work-status row

Deletes a return-to-work status history row for a claim.

Classification

Field	Value
SQL ID	SQL-060
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClaimWorkStatus
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_STATUS	DELETE	CLAIM_ID, CLAIM_WORK_STATUS_SEQ_NUM

Sample SQL

-- Delete claim work-status row
Delete CL_CLAIM_WORK_STATUS
 Where CLAIM_ID                  = :ClaimID
   And CLAIM_WORK_STATUS_SEQ_NUM = :SeqNum

Business rules

• BR-003: Work status date cannot be in the future

Sources

• SAIF.Business.Claim/clsClaimWorkStatus.vb