SQL-037 Update a 1502 DCBS transfer as processed¶

Marks a DCBS 1502 transfer record as processed and increments its optimistic-concurrency counter; the only schema-qualified statement in the library.

Classification¶

Field	Value
SQL ID	SQL-037
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`cls1502Transfer`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate (via SqlHelper.DataRequests.GetUpdateRequest)`

Parameters¶

Parameter	Direction	Type	Max length	Description
`ProcessedDate`	Input	Date	—	Processed timestamp being set
`UpdateUser`	Input	String	30	Auditing user
`FileId`	Input	String	36	Row key
`ClaimId`	Input	Decimal	—	Row key
`UpdateNum`	Input	Decimal	—	Optimistic-concurrency check value

Tables¶

Table	Access	Columns used
CL_1502_DCBS_TRANSFER	UPDATE	PROCESSED_DATE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, FILE_ID, CLAIM_ID

Sample SQL¶

-- Mark 1502 transfer as processed (only schema-qualified statement: CLM_DBA)
UPDATE CLM_DBA.CL_1502_DCBS_TRANSFER
   SET PROCESSED_DATE = :ProcessedDate,
       UPDATE_NUM     = UPDATE_NUM + 1,
       UPDATE_USER_ID = :UpdateUser,
       UPDATE_DATE    = SYSDATE
 WHERE FILE_ID    = :FileId
   AND CLAIM_ID   = :ClaimId
   AND UPDATE_NUM = :UpdateNum

Operations and processes¶

DCBS 1502 transfer handling

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/cls1502Transfer.vb