SQL-015: Read operation¶

This document records the SQL used by clsMCOProviderTypeAdminFeeList in SAIF.Business.Claim.Bill.

Classification¶

Field	Value
SQL ID	SQL-015
Operation type	Read
Execution method	StringBuilder
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsMCOProviderTypeAdminFeeList`
Criteria property	`SqlText`
Lifecycle method	`SqlText`

Parameters¶

Parameter	Direction	Type	Max length	Description
`—`	—	—	—	No bound parameters detected in source.

Tables¶

Table	Access	Columns used
MCO_TYPE_ADMIN_FEE	READ	A, ADMIN_FEE_RATE, C, D, E, EFF_DATE, EXP_DATE, F, G, ID, M, MCO

Sample SQL¶

Select MCO_TYPE_ADMIN_FEE_SEQ_NUM as ID, ADMIN_FEE_RATE as AdminFeeRate, EFF_DATE as EffectiveDate, EXP_DATE as ExpirationDate, MCO_ID as McoID, PROVIDER_TYPE_CODE as ProviderTypeCode 
FROM MCO_TYPE_ADMIN_FEE Get all MCO Provider Admin Fees

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources¶

Business\SAIF.Business.Claim.Bill\AuditSupport\MCO\clsMCOProviderTypeAdminFee.vb