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

# SAIF.Business.Provider.PaymentPreference SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-insert-provider-eob-interface.md) | INSERT PROVIDER_EOB_INTERFACE | Inline | [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface) | `clsProviderEOB` |
| [SQL-002](SQL-002-pk83548-provider-corr-hist-eft-corr-hist.md) | PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST | StoredProc | [PROVIDER_CORR_HIST](../database-tables.md#provider_corr_hist), [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id), [PROVIDER](../database-tables.md#provider), [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | `clsProviderEFT` |
| [SQL-003](SQL-003-insert-provider-eft-interface.md) | INSERT PROVIDER_EFT_INTERFACE | Inline | [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | `clsProviderEFT` |
## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-004](SQL-004-select-provider-bank-accounts-by-provider.md) | Inline read used by clsProviderBankAccountCollection | Inline | [BANK_ACCOUNT](../database-tables.md#bank_account), [PAYMENT_AUTHORIZATION](../database-tables.md#payment_authorization), [PROVIDER_LOCATION](../database-tables.md#provider_location) | `clsProviderBankAccountCollection` |
| [SQL-005](SQL-005-select-provider-eob-interface-by-provider-location.md) | Inline read used by clsProviderEOB | Inline | [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface), [EXT_USER_TYPE](../database-tables.md#ext_user_type), [EXT_USER](../database-tables.md#ext_user), [EMAIL_ADDRESS](../database-tables.md#email_address), [PERSON](../database-tables.md#person) | `clsProviderEOB` |
| [SQL-006](SQL-006-select-provider-eob-interface-by-location.md) | Inline read used by clsProviderEOB | Inline | [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface), [EXT_USER_TYPE](../database-tables.md#ext_user_type), [EXT_USER](../database-tables.md#ext_user), [EMAIL_ADDRESS](../database-tables.md#email_address), [PERSON](../database-tables.md#person) | `clsProviderEOB` |
| [SQL-007](SQL-007-select-provider-locations-with-eob-preference.md) | Inline read used by clsProviderEOBCollection | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface), [EXT_USER_TYPE](../database-tables.md#ext_user_type), [EXT_USER](../database-tables.md#ext_user), [EMAIL_ADDRESS](../database-tables.md#email_address), [PERSON](../database-tables.md#person) | `clsProviderEOBCollection` |
| [SQL-008](SQL-008-select-provider-eft-interface-by-provider-location.md) | Inline read used by clsProviderEFT | Inline | [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface), [EXT_USER_TYPE](../database-tables.md#ext_user_type), [EXT_USER](../database-tables.md#ext_user), [PERSON](../database-tables.md#person) | `clsProviderEFT` |
| [SQL-009](SQL-009-select-all-provider-eft-interface-rows.md) | Inline read used by clsProviderEFTCollection | Inline | [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | `clsProviderEFTCollection` |
| [SQL-010](SQL-010-select-provider-eft-interface-by-provider.md) | Inline read used by clsProviderEFTCollection | Inline | [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | `clsProviderEFTCollection` |
| [SQL-011](SQL-011-select-provider-eft-locations.md) | Inline read used by clsProviderEFTCollection | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface), [PROVIDER_ADDRESS](../database-tables.md#provider_address) | `clsProviderEFTCollection` |
| [SQL-012](SQL-012-select-provider-eft-locations-with-external-user-email.md) | Inline read used by clsProviderEFTCollection | Inline | [PROVIDER_LOCATION](../database-tables.md#provider_location), [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface), [EXT_USER_TYPE](../database-tables.md#ext_user_type), [EXT_USER](../database-tables.md#ext_user), [EMAIL_ADDRESS](../database-tables.md#email_address) | `clsProviderEFTCollection` |
## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-013](SQL-013-update-provider-eob-interface.md) | Inline update used by clsProviderEOB | Inline | [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface) | `clsProviderEOB` |
| [SQL-014](SQL-014-update-provider-eft-interface.md) | Inline update used by clsProviderEFT | Inline | [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | `clsProviderEFT` |
## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-015](SQL-015-delete-provider-eob-interface.md) | Inline delete used by clsProviderEOB | Inline | [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface) | `clsProviderEOB` |
| [SQL-016](SQL-016-delete-provider-eft-interface.md) | Inline delete used by clsProviderEFT | Inline | [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | `clsProviderEFT` |

## 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)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## Sources
- `Business\SAIF.Business.Provider.PaymentPreference\clsProviderEOB.vb`
- `Business\SAIF.Business.Provider.PaymentPreference\clsProviderEOBCollection.vb`
- `Business\SAIF.Business.Provider.PaymentPreference\clsProviderEFT.vb`
- `Business\SAIF.Business.Provider.PaymentPreference\clsProviderBankAccounts.vb`
- `Business\SAIF.Business.Provider.PaymentPreference\clsProviderEFT.vb`