SQL-047 Update a federal benefit schedule¶

Updates the next issue date on a federal benefit-schedule row, guarded by optimistic concurrency.

Classification¶

Field	Value
SQL ID	SQL-047
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsFederalBenefitSchedule`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`NextIssueDate`	Input	Date	—	Next issue date
`UpdateUser`	Input	String	30	Auditing user
`ClaimID`	Input	Decimal	—	Row key
`BenefitPaymentSeqNum`	Input	Decimal	—	Row key
`UpdateNum`	Input	Decimal	—	Optimistic-concurrency check value

Tables¶

Table	Access	Columns used
CL_BENEFIT_SCHEDULE	UPDATE	NEXT_ISSUE_DATE, UPDATE_NUM, UPDATE_USER_ID, UPDATE_DATE, CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM

Sample SQL¶

-- Update federal benefit schedule
Update CL_BENEFIT_SCHEDULE
   Set NEXT_ISSUE_DATE = :NextIssueDate,
       UPDATE_NUM      = UPDATE_NUM + 1,
       UPDATE_USER_ID  = :UpdateUser,
       UPDATE_DATE     = SYSDATE
 Where CLAIM_ID                = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum
   And UPDATE_NUM              = :UpdateNum

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/clsFederalBenefitSchedule.vb (not compiled)