SQL-023 Retrieve federal awards by worker and status¶

Retrieves federal award rows for a worker (joined through the injury-claim table) filtered by award-status code, using legacy comma-join syntax.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`WorkerID`	Input	Decimal	—	Worker identifier
`AwardStatusCode`	Input	String	1	Federal award status filter (worker branch — length differs from SQL-022)

Tables¶

Table	Access	Columns used
CL_FEDERAL_AWARD	SELECT (JOIN)	CLAIM_ID, AWARD_STATUS_CODE
CL_INJURY_CLAIM	SELECT (JOIN)	CLAIM_ID, WORKER_ID

Sample SQL¶

-- Retrieve federal awards by worker
Select CL_FEDERAL_AWARD.*
  From CL_FEDERAL_AWARD,
       CL_INJURY_CLAIM CLM
 Where CL_FEDERAL_AWARD.CLAIM_ID = CLM.CLAIM_ID
   and CLM.WORKER_ID = :WorkerID
   and CL_FEDERAL_AWARD.AWARD_STATUS_CODE = :AwardStatusCode

Sources¶

SAIF.Business.Claim/clsFederalAwardStatusCollection.vb