SQL-008: Claim existence check

This document describes SQL-008, the claim existence check statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-008
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	ClaimServices
Criteria property	N/A
Lifecycle method	IsValidClaim

Parameters

This SQL statement has no explicit parameters in the provided findings.

Tables

Table	Access	Columns used
CL_INJURY_CLAIM	SELECT	See sample SQL and source implementation.

Sample SQL

SELECT COUNT(*) FROM CL_INJURY_CLAIM WHERE claim_id = :ClaimID

Variant:

SELECT COUNT(*) FROM CL_INJURY_CLAIM WHERE saif_claim_num = :ClaimNum

Operations and processes

• Claim authorization and visibility checks

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

Sources

• Business\SAIF.Business\ClaimServices.vb