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	INSERT PROVIDER_EOB_INTERFACE	Inline	PROVIDER_EOB_INTERFACE	`clsProviderEOB`
SQL-002	PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST	StoredProc	PROVIDER_CORR_HIST, PROVIDER_TAX_ID, PROVIDER, PROVIDER_EFT_INTERFACE	`clsProviderEFT`
SQL-003	INSERT PROVIDER_EFT_INTERFACE	Inline	PROVIDER_EFT_INTERFACE	`clsProviderEFT`
## Read operations

SQL ID	Description	Type	Tables	Business object
SQL-004	Inline read used by clsProviderBankAccountCollection	Inline	BANK_ACCOUNT, PAYMENT_AUTHORIZATION, PROVIDER_LOCATION	`clsProviderBankAccountCollection`
SQL-005	Inline read used by clsProviderEOB	Inline	PROVIDER_EOB_INTERFACE, EXT_USER_TYPE, EXT_USER, EMAIL_ADDRESS, PERSON	`clsProviderEOB`
SQL-006	Inline read used by clsProviderEOB	Inline	PROVIDER_EOB_INTERFACE, EXT_USER_TYPE, EXT_USER, EMAIL_ADDRESS, PERSON	`clsProviderEOB`
SQL-007	Inline read used by clsProviderEOBCollection	Inline	PROVIDER_LOCATION, PROVIDER_EOB_INTERFACE, EXT_USER_TYPE, EXT_USER, EMAIL_ADDRESS, PERSON	`clsProviderEOBCollection`
SQL-008	Inline read used by clsProviderEFT	Inline	PROVIDER_EFT_INTERFACE, EXT_USER_TYPE, EXT_USER, PERSON	`clsProviderEFT`
SQL-009	Inline read used by clsProviderEFTCollection	Inline	PROVIDER_EFT_INTERFACE	`clsProviderEFTCollection`
SQL-010	Inline read used by clsProviderEFTCollection	Inline	PROVIDER_EFT_INTERFACE	`clsProviderEFTCollection`
SQL-011	Inline read used by clsProviderEFTCollection	Inline	PROVIDER_LOCATION, PROVIDER_EFT_INTERFACE, PROVIDER_ADDRESS	`clsProviderEFTCollection`
SQL-012	Inline read used by clsProviderEFTCollection	Inline	PROVIDER_LOCATION, PROVIDER_EFT_INTERFACE, EXT_USER_TYPE, EXT_USER, EMAIL_ADDRESS	`clsProviderEFTCollection`
## Update operations

SQL ID	Description	Type	Tables	Business object
SQL-013	Inline update used by clsProviderEOB	Inline	PROVIDER_EOB_INTERFACE	`clsProviderEOB`
SQL-014	Inline update used by clsProviderEFT	Inline	PROVIDER_EFT_INTERFACE	`clsProviderEFT`
## Delete operations

SQL ID	Description	Type	Tables	Business object
SQL-015	Inline delete used by clsProviderEOB	Inline	PROVIDER_EOB_INTERFACE	`clsProviderEOB`
SQL-016	Inline delete used by clsProviderEFT	Inline	PROVIDER_EFT_INTERFACE	`clsProviderEFT`