---
title: SAIF.Business.View.Provider SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-24
library: SAIF.Business.View.Provider
reference_type: package
---

# SAIF.Business.View.Provider SQL catalog

This page indexes all SQL statements used by this library. Every discovered statement is a read operation.

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-view-provider.md) | Provider location DCBS cost charges | StringBuilder | [PROVIDER_DCBS_COST_CHARGE](../database-tables.md#provider_dcbs_cost_charge) | ``clsDCBSCostChargeList`` |
| [SQL-002](SQL-002-saif-business-view-provider.md) | Provider location MCO enrollments | StringBuilder | [MCO_PROVIDER](../database-tables.md#mco_provider) | ``clsMCOProviderList`` |
| [SQL-003](SQL-003-saif-business-view-provider.md) | Provider by provider ID | Inline | [PROVIDER](../database-tables.md#provider), [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id) | ``clsProvider`` |
| [SQL-004](SQL-004-saif-business-view-provider.md) | Provider by primary tax ID | Inline | [PROVIDER](../database-tables.md#provider), [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id) | ``clsProvider`` |
| [SQL-005](SQL-005-saif-business-view-provider.md) | Provider address by location | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_ADDRESS](../database-tables.md#provider_address) | ``clsProviderAddress`` |
| [SQL-006](SQL-006-saif-business-view-provider.md) | Provider address collection by location | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_ADDRESS](../database-tables.md#provider_address) | ``clsProviderAddressCollection`` |
| [SQL-007](SQL-007-saif-business-view-provider.md) | Provider collection by dynamic filter | Inline | [PROVIDER](../database-tables.md#provider), [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id) | ``clsProviderCollection`` |
| [SQL-008](SQL-008-saif-business-view-provider.md) | Provider ineligibility period by ID | Inline | [PROVIDER_INELIG_PERIOD](../database-tables.md#provider_inelig_period) | ``clsProviderIneligibilityPeriod`` |
| [SQL-009](SQL-009-saif-business-view-provider.md) | Provider ineligibility periods by location | Inline | [PROVIDER_INELIG_PERIOD](../database-tables.md#provider_inelig_period) | ``clsProviderIneligibilityPeriodCollection`` |
| [SQL-010](SQL-010-saif-business-view-provider.md) | Provider location by ID | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location) | ``clsProviderLocation`` |
| [SQL-011](SQL-011-saif-business-view-provider.md) | Provider locations by provider | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location) | ``clsProviderLocationCollection`` |
| [SQL-012](SQL-012-saif-business-view-provider.md) | Provider locations by type | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location) | ``clsProviderLocationCollection`` |
| [SQL-013](SQL-013-saif-business-view-provider.md) | Child provider relationships by location | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_RELATIONSHIP](../database-tables.md#provider_relationship) | ``clsProviderRelationshipCollection`` |
| [SQL-014](SQL-014-saif-business-view-provider.md) | Parent provider relationships by location | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_RELATIONSHIP](../database-tables.md#provider_relationship) | ``clsProviderRelationshipCollection`` |
| [SQL-015](SQL-015-saif-business-view-provider.md) | Provider search by dynamic criteria | StringBuilder | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_TYPE_CODE](../database-tables.md#provider_type_code), [PROVIDER_ADDRESS](../database-tables.md#provider_address), [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id), [PROVIDER_IDENTITY](../database-tables.md#provider_identity), [PROVIDER_SERVICE](../database-tables.md#provider_service), [MCO_PROVIDER](../database-tables.md#mco_provider) | ``clsProviderSearch`` |
| [SQL-016](SQL-016-saif-business-view-provider.md) | Provider service contracts by location | StringBuilder | [PROVIDER_SERVICE_CONTRACT](../database-tables.md#provider_service_contract) | ``clsProviderServiceContractList`` |
| [SQL-017](SQL-017-saif-business-view-provider.md) | Provider services by location | StringBuilder | [PROVIDER_SERVICE_CODE](../database-tables.md#provider_service_code), [PROVIDER_SERVICE](../database-tables.md#provider_service) | ``clsProviderServiceList`` |
| [SQL-018](SQL-018-saif-business-view-provider.md) | Provider tax IDs by provider | Inline | [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id) | ``clsProviderTaxIDCollection`` |
| [SQL-019](SQL-019-saif-business-view-provider.md) | Provider type by code | Inline | [PROVIDER_TYPE_CODE](../database-tables.md#provider_type_code) | ``clsProviderType`` |
| [SQL-020](SQL-020-saif-business-view-provider.md) | Provider type catalog | Inline | [PROVIDER_TYPE_CODE](../database-tables.md#provider_type_code) | ``clsProviderTypeCollection`` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [API reference](../api/index.md)

## Sources
- `Business\SAIF.Business.View.Provider\clsDCBSCostCharge.vb`
- `Business\SAIF.Business.View.Provider\clsMCOProvider.vb`
- `Business\SAIF.Business.View.Provider\clsProvider.vb`
- `Business\SAIF.Business.View.Provider\clsProviderAddress.vb`
- `Business\SAIF.Business.View.Provider\clsProviderAddressCollection.vb`
- `Business\SAIF.Business.View.Provider\clsProviderCollection.vb`
- `Business\SAIF.Business.View.Provider\clsProviderIneligibilityPeriod.vb`
- `Business\SAIF.Business.View.Provider\clsProviderIneligibilityPeriodCollection.vb`
- `Business\SAIF.Business.View.Provider\clsProviderLocation.vb`
- `Business\SAIF.Business.View.Provider\clsProviderLocationCollection.vb`
- `Business\SAIF.Business.View.Provider\clsProviderRelationshipCollection.vb`
- `Business\SAIF.Business.View.Provider\clsProviderSearch.vb`
- `Business\SAIF.Business.View.Provider\clsProviderServiceContract.vb`
- `Business\SAIF.Business.View.Provider\clsProviderServices.vb`
- `Business\SAIF.Business.View.Provider\clsProviderTaxIDCollection.vb`
- `Business\SAIF.Business.View.Provider\clsProviderType.vb`
- `Business\SAIF.Business.View.Provider\clsProviderTypeCollection.vb`