SQL-019: Read CL_MCO_STATUS_REASON_CODE¶

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

Classification¶

Field	Value
SQL ID	SQL-019
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.
`:McoEligibilityStatusCode`	Input	N/A	N/A	MCO eligibility status code filter.

Tables¶

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

Sample SQL¶

Select
    CL_MCO_STATUS_REASON_CODE.CODE as Code,
    CL_MCO_STATUS_REASON_CODE.CODE_DESCR as CodeDescr,
    CL_MCO_STATUS_REASON_CODE.MCO_ELIGIBILITY_STATUS_CODE as McoEligibilityStatusCode,
    CL_MCO_STATUS_REASON_CODE.UPDATE_DATE as UpdateDate,
    CL_MCO_STATUS_REASON_CODE.UPDATE_NUM as UpdateNum,
    CL_MCO_STATUS_REASON_CODE.UPDATE_USER as UpdateUser
From CL_MCO_STATUS_REASON_CODE
WHERE
    CL_MCO_STATUS_REASON_CODE.CODE = :Code AND
    CL_MCO_STATUS_REASON_CODE.MCO_ELIGIBILITY_STATUS_CODE = :McoEligibilityStatusCode

Operations and processes¶

Reference code retrieval

Sources¶

Business\SAIF.Business.View.Claim\clsMcoStatusReasonCode.vb