SQL-026: Read CL_WORK_RELEASE_CODE

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

Classification

Field	Value
SQL ID	SQL-026
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
:Code	Input	N/A	N/A	Lookup code used to select a single reference-data row.

Tables

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

Sample SQL

Select
    CODE as Code,
    CODE_DESCR as Description,
    WORK_CODE as WorkCode
From CL_WORK_RELEASE_CODE
WHERE
    Code = :Code

Operations and processes

• Reference code retrieval

Sources

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