SQL-009: Responsibility-code validation

This document describes SQL-009, the responsibility-code validation statement or call used by SAIF.Business.

Classification

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

Parameters

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

Tables

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

Sample SQL

SELECT COUNT(*) FROM CL_CLAIM_RESPONSIBILITY WHERE CLAIM_RESP_CODE = :RespCode

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