SQL-007: Responsible-adjuster lookup by claim id¶

This document describes SQL-007, the responsible-adjuster lookup by claim id statement or call used by SAIF.Business.

Classification¶

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

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.
CL_CLAIM_RESPONSIBILITY	SELECT	See sample SQL and source implementation.

Sample SQL¶

SELECT cr.claim_resp_user AS RESP,
       cr.pseudo_user AS PSEUDO
  FROM cl_injury_claim cl,
       cl_claim_responsibility cr
 WHERE cl.claim_resp_code = cr.claim_resp_code
   AND cl.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