SQL-039 Update remaining payment count on a benefit payment (stop processing)¶

Sets the remaining-payment count on a benefit payment when a released scheduled payment is detected during stop processing.

Classification¶

Field	Value
SQL ID	SQL-039
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsActiveBenefitSchedule`
Criteria property	`UpdateSchedSQL`
Lifecycle method	`ProcessBenefitPayment`

Parameters¶

Parameter	Direction	Type	Max length	Description
`RemainingPaymentCount`	Input	Decimal	—	Forced to 1 when a released scheduled payment exists
`ClaimID`	Input	Decimal	—	Row key
`BenefitPaymentSeqNum`	Input	Decimal	—	Row key

Tables¶

Table	Access	Columns used
CL_BENEFIT_PAYMENT	UPDATE	REMAINING_PAYMENT_COUNT, CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM

Sample SQL¶

-- Update remaining payment count (released scheduled payment)
Update CL_BENEFIT_PAYMENT
   Set REMAINING_PAYMENT_COUNT = :RemainingPaymentCount
 Where CLAIM_ID                = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum

Operations and processes¶

Benefit-payment stop processing

Business rules¶

BR-009: Benefit schedule update must affect a row

Sources¶

SAIF.Business.Claim/clsActiveBenefitSchedule.vb