SQL-023: Read CL_WORK_STATUS_CODE

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

Classification

Field	Value
SQL ID	SQL-023
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_WORK_STATUS_CODE	SELECT	See sample SQL for referenced columns.

Sample SQL

Select
    CODE as Code,
    CODE_DESCR as Description,
    CODE_SHORT_DESCR as ShortDescription,
    WORK_CODE as WorkCode
From CL_WORK_STATUS_CODE
ORDER BY CODE_DESCR

Operations and processes

• Reference code retrieval

Sources

• Business\SAIF.Business.View.Claim\clsWorkStatusCodeTable.vb