SQL-052 Delete a 1502 DCBS transfer record

Deletes a DCBS 1502 transfer record by file ID and claim ID.

Classification

Field	Value
SQL ID	SQL-052
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	cls1502Transfer
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete (via SqlHelper.DataRequests.GetDeleteRequest)

Parameters

Parameter	Direction	Type	Max length	Description
FileId	Input	String	36	Row key
ClaimId	Input	Decimal	—	Row key

Tables

Table	Access	Columns used
CL_1502_DCBS_TRANSFER	DELETE	FILE_ID, CLAIM_ID

Sample SQL

-- Delete 1502 DCBS transfer record
DELETE CL_1502_DCBS_TRANSFER
 WHERE FILE_ID  = :FileId
   AND CLAIM_ID = :ClaimId

Operations and processes

• DCBS 1502 transfer handling

Sources

• SAIF.Business.Claim/cls1502Transfer.vb