SQL-010: Legal-collection existence

This document describes SQL-010, the legal-collection existence statement or call used by SAIF.Business.

Classification

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

Parameters

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

Tables

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

Sample SQL

SELECT COUNT(*) FROM LEGAL_COLLECTION 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