SQL-014: CL_INJURY_CLAIM denial-final lookup¶

This SQL statement implements the CL_INJURY_CLAIM denial-final lookup data-access path for clsClaimUnit.IsDeniedFinal in SAIF.Business.UnitStat. It participates in the read lifecycle handled by IsDeniedFinal getter.

Classification¶

Field	Value
SQL ID	SQL-014
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsClaimUnit.IsDeniedFinal`
Criteria property	`N/A (direct scalar SQL)`
Lifecycle method	`IsDeniedFinal getter`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimId`	Input	Decimal	N/A	Claim identifier bound from criteria.

Tables¶

Table	Access	Columns used
CL_INJURY_CLAIM	SELECT	See sample SQL

Sample SQL¶

SELECT ic.denied_final_flag

FROM cl_injury_claim ic

WHERE ic.claim_id = :ClaimId

Operations and processes¶

Denial and fraud eligibility

Business rules¶

BR-US-027: Denial-final checks and fully-fraudulent checks only apply to policy units effective on or after 2013-01-01

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.UnitStat\clsClaimUnit.vb