SQL-031 Retrieve an active award for pending processing¶

Retrieves an active (AWARD_STATUS_CODE = 'A') award row for a claim, ahead of setting it to Pending.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`ClaimID`	Input	Decimal	—	Claim identifier
`AwardNum`	Input	Decimal	—	SAIF award number (status filter 'A' is literal)

Tables¶

Table	Access	Columns used
CL_AWARD	SELECT	CLAIM_ID, SAIF_AWARD_NUM, AWARD_STATUS_CODE

Sample SQL¶

-- Retrieve active award
Select CL_AWARD.*
  From CL_AWARD
 Where CL_AWARD.CLAIM_ID = :ClaimID
   And CL_AWARD.SAIF_AWARD_NUM = :AwardNum
   And CL_AWARD.AWARD_STATUS_CODE = 'A'

Operations and processes¶

Set award to Pending

Business rules¶

BR-011: Award must be successfully updated to pending

Sources¶

SAIF.Business.Claim/clsSetAwardPaymentPending.vb