SQL-002: Provider location MCO enrollments

This statement supports the clsMCOProviderList retrieval path by reading provider-domain data from Oracle tables and projecting the result into business objects or DTO lists.

Classification

Field	Value
SQL ID	SQL-002
Operation type	Read
Execution method	StringBuilder-assembled
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsMCOProviderList
Criteria property	N/A - direct query
Lifecycle method	Constructor

Parameters

Parameter	Direction	Type	Max length	Description
:ProviderLocationID	Input	Decimal	N/A	Filters MCO enrollment rows for one provider location.

Tables

Table	Access	Columns used
MCO_PROVIDER	SELECT	PROVIDER_LOCATION_SEQ_NUM, MCO_PLAN_ID, EFF_DATE, EXP_DATE

Sample SQL

SELECT
  PROVIDER_LOCATION_SEQ_NUM AS ProviderLocationID,
  MCO_PLAN_ID AS McoPlanID,
  EFF_DATE AS EffectiveDate,
  EXP_DATE AS ExpirationDate,
  NEW_PATIENTS_FLAG AS NewPatientsFlag,
  DIRECTORY_FLAG AS DirectoryFlag,
  ADMIN_FEE_RATE AS AdminFeeRate,
  RATE_PT_OT_ST AS FeeRatePtOtSt,
  RATE_RAD AS FeeRateRad,
  RATE_WC_CTC AS FeeRateCtc,
  RATE_ASC AS FeeRateAsc,
  ADMIN_FEE_FLAG AS AdminFeeFlag
FROM MCO_PROVIDER
WHERE PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationID

Operations and processes

• Retrieve MCO provider enrollments

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• SQL catalog
• API reference

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

Sources

• Business\SAIF.Business.View.Provider\clsMCOProvider.vb