SQL-031: Retrieve MCO short description

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

Classification

Field	Value
SQL ID	SQL-031
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	may
Criteria property	RetrieveMcoPlan
Lifecycle method	May read

Parameters

Parameter	Direction	Type	Max length	Description
:mcoPlanId	Input	N/A	N/A	Managed care organization plan identifier.

Tables

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

Sample SQL

SELECT MCO_SHORT_DESCR FROM MCO_PLAN WHERE MCO_PLAN_ID = :mcoPlanId

Operations and processes

• Claim summary and detail retrieval

Sources

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