SQL-013: Read CL_CLAIM_RESPONSIBILITY¶

This SQL document describes how Criteria uses an inline Oracle query to support claim-domain read behavior.

Classification¶

Field	Value
SQL ID	SQL-013
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`Criteria`
Criteria property	`retrievesql`
Lifecycle method	`Criteria read`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:ClaimRespCode`	Input	N/A	N/A	Claim responsibility code.

Tables¶

Table	Access	Columns used
CL_CLAIM_RESPONSIBILITY	SELECT	See sample SQL for referenced columns.

Sample SQL¶

Select
    CL_CLAIM_RESPONSIBILITY.CLAIM_RESP_CODE as ClaimRespCode,
    CL_CLAIM_RESPONSIBILITY.CLAIM_RESP_USER as ClaimRespUser,
    CL_CLAIM_RESPONSIBILITY.CLAIM_SUPERVISOR_CODE as ClaimSupervisorCode,
    CL_CLAIM_RESPONSIBILITY.CLAIM_ASSISTANT_USER as ClaimAssistantUser,
    CL_CLAIM_RESPONSIBILITY.PSEUDO_NAME as PseudoName,
    CL_CLAIM_RESPONSIBILITY.PSEUDO_PHONE as PseudoPhone,
    CL_CLAIM_RESPONSIBILITY.PSEUDO_USER as PseudoUser,
    CL_CLAIM_RESPONSIBILITY.RESPONSIBILITY_TYPE_CODE as ReponsibilityTypeCode,
    CLAIM_SUPERVISOR.CLAIM_SUPERVISOR_USER as SupervisorMailID,
    CLAIM_SUPERVISOR.CLAIM_SECTION_CODE as SectionCode
From CL_CLAIM_RESPONSIBILITY, CLAIM_SUPERVISOR
WHERE
    CL_CLAIM_RESPONSIBILITY.CLAIM_SUPERVISOR_CODE = CLAIM_SUPERVISOR.CLAIM_SUPERVISOR_CODE AND
    CL_CLAIM_RESPONSIBILITY.CLAIM_RESP_CODE = :ClaimRespCode

Operations and processes¶

Claim responsibility retrieval

Sources¶

Business\SAIF.Business.View.Claim\clsClaimResponsibilityData.vb