SQL-014 Retrieve an in-progress award benefit payment¶

Retrieves a benefit-payment row restricted to benefit status '2' (In Progress) for award benefit-payment maintenance.

Classification¶

Field	Value
SQL ID	SQL-014
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsAwardBenefitPayment`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`ClaimID`	Input	Decimal	—	Claim identifier
`BenefitPaymentSeqNum`	Input	Decimal	—	Benefit payment sequence number

Tables¶

Table	Access	Columns used
CL_BENEFIT_PAYMENT	SELECT	CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM, BENEFIT_STATUS_CODE

Sample SQL¶

-- Retrieve award benefit payment (status 2)
Select CL_BENEFIT_PAYMENT.*
  From CL_BENEFIT_PAYMENT
 Where CLAIM_ID = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum
   And BENEFIT_STATUS_CODE = '2'

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

SAIF.Business.Claim/clsAwardBenefitPayment.vb