SQL-006: Responsible-adjuster lookup by claim number¶
This document describes SQL-006, the responsible-adjuster lookup by claim number statement or call used by SAIF.Business.
Classification¶
| Field | Value |
|---|---|
| SQL ID | SQL-006 |
| Operation type | Read |
| Execution method | Inline |
| Database | Oracle |
| Schema | [unqualified]** |
| Command type | Text |
| Business object | ClaimServices |
| Criteria property | N/A |
| Lifecycle method | GetResponsibleAdjuster(String) |
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.saif_claim_num = :Claim
Operations and processes¶
Note: Statements marked with
**could not be confirmed; treat as unknown until verified.
Sources¶
Business\SAIF.Business\ClaimServices.vb