SQL-012: Read CL_CLAIM_COST_CATEGORY_CODE¶

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

Classification¶

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

Parameters¶

This SQL statement exposes no explicit input parameters in the analyzed source.

Tables¶

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

Sample SQL¶

Select
    CL_CLAIM_COST_CATEGORY_CODE.UPDATE_USER as UpdateUser,
    CL_CLAIM_COST_CATEGORY_CODE.UPDATE_NUM as UpdateNum,
    CL_CLAIM_COST_CATEGORY_CODE.UPDATE_DATE as UpdateDate,
    CL_CLAIM_COST_CATEGORY_CODE.MEDICAL_INDEMNITY_DISPLAY_CODE as MedicalIndemnityDisplayCode,
    CL_CLAIM_COST_CATEGORY_CODE.FIRST_ISSUE_DATE as FirstIssueDate,
    CL_CLAIM_COST_CATEGORY_CODE.EFFECTIVE_DATE as EffectiveDate,
    CL_CLAIM_COST_CATEGORY_CODE.COST_CATEGORY_GROUP_CODE as CostCategoryGroupCode,
    CL_CLAIM_COST_CATEGORY_CODE.CODE_DESCR_SHORT as CodeDescrShort,
    CL_CLAIM_COST_CATEGORY_CODE.CODE_DESCR as CodeDescr,
    CL_CLAIM_COST_CATEGORY_CODE.CODE as Code,
    CL_CLAIM_COST_CATEGORY_CODE.AWARD_FLAG as AwardFlag
From CL_CLAIM_COST_CATEGORY_CODE

Operations and processes¶

Reference code retrieval

Sources¶

Business\SAIF.Business.View.Claim\clsClaimCostCategoryCodeCollection.vb