clsFederalAwardStatusCollection

clsFederalAwardStatusCollection retrieves federal award status rows either by claim or by worker (joined through the injury-claim table using legacy comma-join syntax).

Purpose

• Retrieves federal awards filtered by claim and status (SQL-022).
• Retrieves federal awards filtered by worker and status, joined through CL_INJURY_CLAIM (SQL-023).

Context

• Namespace: SAIF.Business.Claim
• Assembly/package: SAIF.Business.Claim.dll

Public members

Member	Signature	Purpose
Criteria.RetrieveSQL	ReadOnly Property RetrieveSQL As String	Retrieves federal awards for a claim, filtered by award-status code (SQL-022).
Criteria.RetrieveByWorkerSQL	ReadOnly Property RetrieveByWorkerSQL As String	Retrieves federal awards for a worker via a legacy comma-join to CL_INJURY_CLAIM (SQL-023).

Behavioral notes

• The worker-branch AwardStatusCode parameter is length 1, differing from the claim-branch parameter's length of 5 — a possible inconsistency.*
• Uses legacy comma-join syntax (FROM A, B WHERE ...) rather than ANSI JOIN.

Constraints and usage notes

• Choose the claim-scoped or worker-scoped retrieve method based on which key is available to the caller.

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Related documentation

• Library index
• API reference index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• SQL catalog

Sources

• SAIF.Business.Claim/clsFederalAwardStatusCollection.vb