SQL-024 Retrieve a federal benefit schedule row¶

Retrieves a single federal benefit-schedule row by claim and benefit-payment sequence number.

Classification¶

Field	Value
SQL ID	SQL-024
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	`[unqualified]**`
Command type	Text
Business object	`clsFederalBenefitSchedule`
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_SCHEDULE	SELECT	CLAIM_ID, BENEFIT_PAYMENT_SEQ_NUM

Sample SQL¶

-- Retrieve federal benefit schedule row
Select CL_BENEFIT_SCHEDULE.*
  From CL_BENEFIT_SCHEDULE
 Where CLAIM_ID = :ClaimID
   And BENEFIT_PAYMENT_SEQ_NUM = :BenefitPaymentSeqNum

Business rules¶

BR-012: Optimistic concurrency contention check

Sources¶

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