SQL-017: Support-order existence

This query checks whether a claim is connected to at least one support-order record in the claim-support-order connector table.

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:ClaimID	Input	Decimal	N/A	Claim identifier used to test for a connected support-order row.

Tables

Table	Access	Columns used
CL_CLAIM_SUPPORT_ORDER_CONN	SELECT	CLAIM_ID

Sample SQL

-- ClaimServices.SupportOrderExists
SELECT COUNT(*)
  FROM CL_CLAIM_SUPPORT_ORDER_CONN soc
 WHERE CLAIM_ID = :ClaimID

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