SQL-022 Retrieve federal awards by claim and status

Retrieves federal award rows for a claim filtered by award-status code.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
ClaimID	Input	Decimal	—	Claim identifier
AwardStatusCode	Input	String	5	Federal award status filter (claim branch)

Tables

Table	Access	Columns used
CL_FEDERAL_AWARD	SELECT	CLAIM_ID, AWARD_STATUS_CODE

Sample SQL

-- Retrieve federal awards by claim
Select CL_FEDERAL_AWARD.*
  From CL_FEDERAL_AWARD
 Where CLAIM_ID = :ClaimID
   And AWARD_STATUS_CODE = :AwardStatusCode

Sources

• SAIF.Business.Claim/clsFederalAwardStatusCollection.vb