SQL-039: Mco lookup family

This document describes SQL-039, the mco lookup family statement or call used by SAIF.Business.

Classification

Field	Value
SQL ID	SQL-039
Operation type	Read
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	MCOInfo
Criteria property	N/A
Lifecycle method	constructor hydration

Parameters

This SQL statement has no explicit parameters in the provided findings.

Tables

Table	Access	Columns used
MCO_PLAN	SELECT	See sample SQL and source implementation.
MCO_GSA_LOCATION	SELECT	See sample SQL and source implementation.

Sample SQL

SELECT MCO_PLAN_ID AS PlanID, MCO_CERT_NUM AS CertificationNumber, EFF_DATE AS EffectiveDate, EXP_DATE AS ExpirationDate,
       APPLY_DISCOUNT_CODE AS ApplyDiscountCode, APPLY_ADMIN_FEE_CODE AS ApplyAdminFeeCode,
       CASE_MANAGEMENT_FEE_AMT AS CaseManagementFeeAmount, PROVIDER_LOCATION_SEQ_NUM AS ProviderLocationID,
       CASE_MANAGEMENT_LATE_FEE_AMT AS CaseManagementLateFeeAmount, MCO_SHORT_DESCR AS Description
  FROM MCO_PLAN
SELECT MCO_ID AS McoID, LOCATION_NAME AS LocationName, EFF_DATE AS EffectiveDate, EXP_DATE AS ExpirationDate, MCO_PLAN_ID AS PlanID
  FROM MCO_GSA_LOCATION

Operations and processes

• Lookup and reference-data hydration

Note: Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business\MCOInfo.vb