---
title: SAIF.Business.View.Provider database tables
summary: Database tables used by this library with relationships and usage context.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-24
library: SAIF.Business.View.Provider
reference_type: package
---

# SAIF.Business.View.Provider database tables

This page catalogs database tables accessed by this library.

## Table catalog

| Table | Database | Schema/Link | CRUD | Purpose | Primary business object |
| --- | --- | --- | --- | --- | --- |
| [MCO_PROVIDER](#mco_provider) | Oracle | [unqualified]** | R | MCO enrollment and fee-rate rows for a provider location. | `clsMCOProviderList` |
| [PROVIDER](#provider) | Oracle | [unqualified]** | R | Provider master rows keyed by provider sequence number and primary tax ID. | `clsProvider` |
| [PROVIDER_ADDRESS](#provider_address) | Oracle | [unqualified]** | R | Address rows associated with provider locations. | `clsProviderAddress` |
| [PROVIDER_DCBS_COST_CHARGE](#provider_dcbs_cost_charge) | Oracle | [unqualified]** | R | DCBS cost-charge rows for provider locations. | `clsDCBSCostChargeList` |
| [PROVIDER_IDENTITY](#provider_identity) | Oracle | [unqualified]** | R | Alternate identity values used by provider search. | `clsProviderSearch` |
| [PROVIDER_INELIG_PERIOD](#provider_inelig_period) | Oracle | [unqualified]** | R | Provider-location ineligibility periods. | `clsProviderIneligibilityPeriod` |
| [PROVIDER_LOCATION](#provider_location) | Oracle | [unqualified]** | R | Provider location demographic, contact, and classification rows. | `clsProviderAddress` |
| [PROVIDER_RELATIONSHIP](#provider_relationship) | Oracle | [unqualified]** | R | Parent/child relationships between provider locations. | `clsProviderRelationshipCollection` |
| [PROVIDER_SERVICE](#provider_service) | Oracle | [unqualified]** | R | Service assignments for provider locations. | `clsProviderSearch` |
| [PROVIDER_SERVICE_CODE](#provider_service_code) | Oracle | [unqualified]** | R | Reference descriptions and specialty mappings for provider service codes. | `clsProviderServiceList` |
| [PROVIDER_SERVICE_CONTRACT](#provider_service_contract) | Oracle | [unqualified]** | R | Provider-location service contracts. | `clsProviderServiceContractList` |
| [PROVIDER_TAX_ID](#provider_tax_id) | Oracle | [unqualified]** | R | Provider tax-ID and registered-name rows. | `clsProvider` |
| [PROVIDER_TYPE_CODE](#provider_type_code) | Oracle | [unqualified]** | R | Provider type reference-data rows. | `clsProviderSearch` |

## MCO_PROVIDER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | MCO enrollment and fee-rate rows for a provider location. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, MCO_PLAN_ID, EFF_DATE, EXP_DATE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsMCOProviderList`, `clsProviderSearch` |

### Operations referencing this table
- [Search providers](operations/provider-search.md)
- [Retrieve MCO provider enrollments](operations/provider-location-ancillary-data.md)

### Business rules referencing this table
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)

### SQL referencing this table
- [SQL-002: Provider location MCO enrollments](sql/SQL-002-saif-business-view-provider.md)
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
---
## PROVIDER

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provider master rows keyed by provider sequence number and primary tax ID. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_SEQ_NUM, PRIMARY_TAX_ID |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION, PROVIDER_TAX_ID |
| **Business objects** | `clsProvider`, `clsProviderCollection` |

### Operations referencing this table
- [Retrieve provider by ID](operations/provider-retrieval.md)
- [Retrieve provider by primary tax ID](operations/provider-retrieval.md)
- [Retrieve provider collection](operations/provider-retrieval.md)

### Business rules referencing this table
- None documented

### SQL referencing this table
- [SQL-003: Provider by provider ID](sql/SQL-003-saif-business-view-provider.md)
- [SQL-004: Provider by primary tax ID](sql/SQL-004-saif-business-view-provider.md)
- [SQL-007: Provider collection by dynamic filter](sql/SQL-007-saif-business-view-provider.md)
---
## PROVIDER_ADDRESS

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Address rows associated with provider locations. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, PROVIDER_ADDRESS_SEQ_NUM, PROVIDER_ADDRESS_CODE, CITY_NAME, STATE_CODE, ZIP_CODE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsProviderAddress`, `clsProviderAddressCollection`, `clsProviderSearch` |

### Operations referencing this table
- [Retrieve provider addresses](operations/provider-address-retrieval.md)
- [Search providers](operations/provider-search.md)

### Business rules referencing this table
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)

### SQL referencing this table
- [SQL-005: Provider address by location](sql/SQL-005-saif-business-view-provider.md)
- [SQL-006: Provider address collection by location](sql/SQL-006-saif-business-view-provider.md)
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
---
## PROVIDER_DCBS_COST_CHARGE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | DCBS cost-charge rows for provider locations. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, EFF_DATE, EXP_DATE, COST_CHARGE_FACTOR |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsDCBSCostChargeList` |

### Operations referencing this table
- [Retrieve DCBS cost charges](operations/provider-location-ancillary-data.md)

### Business rules referencing this table
- None documented

### SQL referencing this table
- [SQL-001: Provider location DCBS cost charges](sql/SQL-001-saif-business-view-provider.md)
---
## PROVIDER_IDENTITY

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Alternate identity values used by provider search. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, IDENTITY_VALUE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsProviderSearch` |

### Operations referencing this table
- [Search providers](operations/provider-search.md)

### Business rules referencing this table
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)

### SQL referencing this table
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
---
## PROVIDER_INELIG_PERIOD

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provider-location ineligibility periods. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_INELIG_PERIOD_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, PROVIDER_INELIG_REASON_CODE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsProviderIneligibilityPeriod`, `clsProviderIneligibilityPeriodCollection` |

### Operations referencing this table
- [Retrieve provider ineligibility period](operations/provider-ineligibility-period-retrieval.md)
- [Retrieve provider ineligibility periods](operations/provider-ineligibility-period-retrieval.md)

### Business rules referencing this table
- None documented

### SQL referencing this table
- [SQL-008: Provider ineligibility period by ID](sql/SQL-008-saif-business-view-provider.md)
- [SQL-009: Provider ineligibility periods by location](sql/SQL-009-saif-business-view-provider.md)
---
## PROVIDER_LOCATION

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provider location demographic, contact, and classification rows. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, PROVIDER_SEQ_NUM, PROVIDER_TYPE_CODE |
| **Sequence** | N/A |
| **Related tables** | MCO_PROVIDER, PROVIDER, PROVIDER_ADDRESS, PROVIDER_DCBS_COST_CHARGE, PROVIDER_IDENTITY, PROVIDER_INELIG_PERIOD, PROVIDER_RELATIONSHIP, PROVIDER_SERVICE, PROVIDER_SERVICE_CONTRACT, PROVIDER_TYPE_CODE |
| **Business objects** | `clsProviderAddress`, `clsProviderLocation`, `clsProviderLocationCollection`, `clsProviderRelationshipCollection`, `clsProviderSearch` |

### Operations referencing this table
- [Retrieve provider addresses](operations/provider-address-retrieval.md)
- [Retrieve provider location](operations/provider-location-retrieval.md)
- [Retrieve provider locations by provider](operations/provider-location-retrieval.md)
- [Retrieve provider locations by type](operations/provider-location-retrieval.md)
- [Retrieve child provider relationships](operations/provider-relationship-retrieval.md)
- [Retrieve parent provider relationships](operations/provider-relationship-retrieval.md)
- [Search providers](operations/provider-search.md)

### Business rules referencing this table
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)

### SQL referencing this table
- [SQL-005: Provider address by location](sql/SQL-005-saif-business-view-provider.md)
- [SQL-006: Provider address collection by location](sql/SQL-006-saif-business-view-provider.md)
- [SQL-010: Provider location by ID](sql/SQL-010-saif-business-view-provider.md)
- [SQL-011: Provider locations by provider](sql/SQL-011-saif-business-view-provider.md)
- [SQL-012: Provider locations by type](sql/SQL-012-saif-business-view-provider.md)
- [SQL-013: Child provider relationships by location](sql/SQL-013-saif-business-view-provider.md)
- [SQL-014: Parent provider relationships by location](sql/SQL-014-saif-business-view-provider.md)
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
---
## PROVIDER_RELATIONSHIP

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Parent/child relationships between provider locations. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, PARENT_PROVIDER_LOC_SEQ_NUM, PROVIDER_RELATIONSHIP_CODE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsProviderRelationshipCollection` |

### Operations referencing this table
- [Retrieve child provider relationships](operations/provider-relationship-retrieval.md)
- [Retrieve parent provider relationships](operations/provider-relationship-retrieval.md)

### Business rules referencing this table
- None documented

### SQL referencing this table
- [SQL-013: Child provider relationships by location](sql/SQL-013-saif-business-view-provider.md)
- [SQL-014: Parent provider relationships by location](sql/SQL-014-saif-business-view-provider.md)
---
## PROVIDER_SERVICE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Service assignments for provider locations. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_LOCATION_SEQ_NUM, PROVIDER_SERVICE_CODE, PRIMARY_SERVICE_FLAG |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION, PROVIDER_SERVICE_CODE |
| **Business objects** | `clsProviderSearch`, `clsProviderServiceList` |

### Operations referencing this table
- [Search providers](operations/provider-search.md)
- [Retrieve provider services](operations/provider-location-ancillary-data.md)

### Business rules referencing this table
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)

### SQL referencing this table
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
- [SQL-017: Provider services by location](sql/SQL-017-saif-business-view-provider.md)
---
## PROVIDER_SERVICE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Reference descriptions and specialty mappings for provider service codes. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | CODE, CODE_DESCR, DCBS_PROVIDER_SPECIALTY_CODE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_SERVICE |
| **Business objects** | `clsProviderServiceList` |

### Operations referencing this table
- [Retrieve provider services](operations/provider-location-ancillary-data.md)

### Business rules referencing this table
- None documented

### SQL referencing this table
- [SQL-017: Provider services by location](sql/SQL-017-saif-business-view-provider.md)
---
## PROVIDER_SERVICE_CONTRACT

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provider-location service contracts. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROV_SERVICE_CONTRACT_SEQ_NUM, PROVIDER_LOCATION_SEQ_NUM, MCO_PLAN_ID |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsProviderServiceContractList` |

### Operations referencing this table
- [Retrieve provider service contracts](operations/provider-location-ancillary-data.md)

### Business rules referencing this table
- [BR-002: Provider service contract expiration window](business-rules.md#br-002-provider-service-contract-expiration-window)

### SQL referencing this table
- [SQL-016: Provider service contracts by location](sql/SQL-016-saif-business-view-provider.md)
---
## PROVIDER_TAX_ID

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provider tax-ID and registered-name rows. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | PROVIDER_SEQ_NUM, TAX_ID, REGISTERED_NAME |
| **Sequence** | N/A |
| **Related tables** | PROVIDER |
| **Business objects** | `clsProvider`, `clsProviderCollection`, `clsProviderSearch`, `clsProviderTaxIDCollection` |

### Operations referencing this table
- [Retrieve provider by ID](operations/provider-retrieval.md)
- [Retrieve provider by primary tax ID](operations/provider-retrieval.md)
- [Retrieve provider collection](operations/provider-retrieval.md)
- [Search providers](operations/provider-search.md)
- [Retrieve provider tax IDs](operations/provider-tax-id-retrieval.md)

### Business rules referencing this table
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)
- [BR-004: Provider tax ID retrieve-only access](business-rules.md#br-004-provider-tax-id-retrieve-only-access)

### SQL referencing this table
- [SQL-003: Provider by provider ID](sql/SQL-003-saif-business-view-provider.md)
- [SQL-004: Provider by primary tax ID](sql/SQL-004-saif-business-view-provider.md)
- [SQL-007: Provider collection by dynamic filter](sql/SQL-007-saif-business-view-provider.md)
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
- [SQL-018: Provider tax IDs by provider](sql/SQL-018-saif-business-view-provider.md)
---
## PROVIDER_TYPE_CODE

| Field | Value |
| --- | --- |
| **Database** | Oracle |
| **Schema/Link** | [unqualified]** |
| **Purpose** | Provider type reference-data rows. |
| **Access pattern** | direct SQL |
| **CRUD operations** | Read |
| **Key columns used** | CODE, CODE_DESCR, CLAIM_PROFILE_FLAG, DCBS_PROVIDER_TYPE_CODE |
| **Sequence** | N/A |
| **Related tables** | PROVIDER_LOCATION |
| **Business objects** | `clsProviderSearch`, `clsProviderType`, `clsProviderTypeCollection` |

### Operations referencing this table
- [Search providers](operations/provider-search.md)
- [Retrieve provider type](operations/provider-type-reference-data.md)
- [Retrieve provider type collection](operations/provider-type-reference-data.md)

### Business rules referencing this table
- [BR-001: Provider type read-only criteria](business-rules.md#br-001-provider-type-read-only-criteria)
- [BR-003: Provider search dynamic join filtering](business-rules.md#br-003-provider-search-dynamic-join-filtering)

### SQL referencing this table
- [SQL-015: Provider search by dynamic criteria](sql/SQL-015-saif-business-view-provider.md)
- [SQL-019: Provider type by code](sql/SQL-019-saif-business-view-provider.md)
- [SQL-020: Provider type catalog](sql/SQL-020-saif-business-view-provider.md)

## Table relationship diagram

The following diagram shows relationships between tables used by this library.

```mermaid
erDiagram
    PROVIDER ||--o{ PROVIDER_TAX_ID : "PRV.PRIMARY_TAX_ID = TAX.TAX_ID"
    PROVIDER ||--o{ PROVIDER_LOCATION : "PROVIDER_LOCATION.PROVIDER_SEQ_NUM = PROVIDER.PROVIDER_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : "pa.PROVIDER_LOCATION_SEQ_NUM = ppl.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_INELIG_PERIOD : "PROVIDER_INELIG_PERIOD.PROVIDER_LOCATION_SEQ_NUM = PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "pr.PROVIDER_LOCATION_SEQ_NUM = pl.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_RELATIONSHIP : "pr.PARENT_PROVIDER_LOC_SEQ_NUM = parentPL.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_TYPE_CODE : "PL.PROVIDER_TYPE_CODE = TYPE.CODE"
    PROVIDER_LOCATION ||--o{ PROVIDER_IDENTITY : "PL.PROVIDER_LOCATION_SEQ_NUM = ID.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER ||--o{ PROVIDER_TAX_ID : "PL.PROVIDER_SEQ_NUM = T.PROVIDER_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_SERVICE : "PL.PROVIDER_LOCATION_SEQ_NUM = SVC.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_SERVICE_CODE ||--o{ PROVIDER_SERVICE : "PROVIDER_SERVICE_CODE.CODE = PROVIDER_SERVICE.PROVIDER_SERVICE_CODE"
    PROVIDER_LOCATION ||--o{ MCO_PROVIDER : "PL.PROVIDER_LOCATION_SEQ_NUM = MP.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_SERVICE_CONTRACT : "PROVIDER_SERVICE_CONTRACT.PROVIDER_LOCATION_SEQ_NUM = PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM"
    PROVIDER_LOCATION ||--o{ PROVIDER_DCBS_COST_CHARGE : "PROVIDER_DCBS_COST_CHARGE.PROVIDER_LOCATION_SEQ_NUM = PROVIDER_LOCATION.PROVIDER_LOCATION_SEQ_NUM"
```

## 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)
- [SQL catalog](sql/index.md)
- [API reference](api/index.md)

> **Note:** Statements marked with `**` could not be confirmed; treat as unknown until verified.
## 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`