SQL-021: External-view eligibility query¶

This document describes SQL-021, the external-view eligibility query statement or call used by SAIF.Business.

Classification¶

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

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 saif_claim_num || saif_claim_chk_value AS claim,
       injury_date,
       claim_id
  FROM cl_injury_claim clm
 WHERE clm.claim_id = :claimID
   AND external_view_flag = 'Y'

Operations and processes¶

Claim authorization and visibility checks

Business rules¶

BR-SB-006: Claims are externally viewable only when external view flag is Y

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

Sources¶

Business\SAIF.Business\ClaimServices.vb