SAIF.Business.Provider.PaymentPreference database tables

This page catalogs database tables accessed by this library.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
BANK_ACCOUNT	Oracle	Unqualified in SQL text	R	Used by clsProviderBankAccountCollection for r operations.	clsProviderBankAccountCollection
EMAIL_ADDRESS	Oracle	Unqualified in SQL text	R	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection for r operations.	clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection
EXT_USER	Oracle	Unqualified in SQL text	R	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection for r operations.	clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection
EXT_USER_TYPE	Oracle	Unqualified in SQL text	R	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory for r operations.	clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory
PAYMENT_AUTHORIZATION	Oracle	Unqualified in SQL text	R	Used by clsProviderBankAccountCollection for r operations.	clsProviderBankAccountCollection
PERSON	Oracle	Unqualified in SQL text	R	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection for r operations.	clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection
PROVIDER	Oracle	Unqualified in SQL text	R	Used by clsProviderEFT.CreateHistory for r operations.	clsProviderEFT.CreateHistory
PROVIDER_ADDRESS	Oracle	Unqualified in SQL text	R	Used by clsProviderEFTCollection for r operations.	clsProviderEFTCollection
PROVIDER_CORR_HIST	Oracle	Unqualified in SQL text	C	Used by clsProviderEFT.CreateHistory for c operations.	clsProviderEFT.CreateHistory
PROVIDER_EFT_INTERFACE	Oracle	Unqualified in SQL text	CRUD	Used by clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory for c,r,u,d operations.	clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory
PROVIDER_EOB_INTERFACE	Oracle	Unqualified in SQL text	CRUD	Used by clsProviderEOB, clsProviderEOBCollection for c,r,u,d operations.	clsProviderEOB, clsProviderEOBCollection
PROVIDER_LOCATION	Oracle	Unqualified in SQL text	R	Used by clsProviderEOBCollection, clsProviderEFTCollection, clsProviderBankAccountCollection for r operations.	clsProviderEOBCollection, clsProviderEFTCollection, clsProviderBankAccountCollection
PROVIDER_TAX_ID	Oracle	Unqualified in SQL text	R	Used by clsProviderEFT.CreateHistory for r operations.	clsProviderEFT.CreateHistory

BANK_ACCOUNT

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderBankAccountCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderBankAccountCollection
Business objects	clsProviderBankAccountCollection

Operations referencing this table

• Provider bank account retrieval

Business rules referencing this table

• BR-14: Deleted bank accounts are excluded from provider bank-account retrieval.

SQL referencing this table

• SQL-004: SELECT provider bank accounts by provider

---

EMAIL_ADDRESS

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection
Business objects	clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection

Operations referencing this table

• EFT payment location assignment
• EOB preference management

Business rules referencing this table

• BR-09: Assigning EFT always queues customer email notification.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-005: SELECT PROVIDER_EOB_INTERFACE by provider/location
• SQL-006: SELECT PROVIDER_EOB_INTERFACE by location
• SQL-007: SELECT provider locations with EOB preference
• SQL-012: SELECT provider EFT locations with external-user email

---

EXT_USER

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection
Business objects	clsProviderEOB, clsProviderEOBCollection, clsProviderEFTCollection

Operations referencing this table

• EFT payment location assignment
• EFT record management
• EOB preference management

Business rules referencing this table

• BR-06: An EFT record is active only when today falls within the effective window.
• BR-07: LocationHasEFT requires direct deposit and non-revoked authorization.
• BR-09: Assigning EFT always queues customer email notification.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-005: SELECT PROVIDER_EOB_INTERFACE by provider/location
• SQL-006: SELECT PROVIDER_EOB_INTERFACE by location
• SQL-007: SELECT provider locations with EOB preference
• SQL-008: SELECT PROVIDER_EFT_INTERFACE by provider/location
• SQL-012: SELECT provider EFT locations with external-user email

---

EXT_USER_TYPE

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory
Business objects	clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory

Operations referencing this table

• EFT payment location assignment
• EFT record management
• EOB preference management

Business rules referencing this table

• BR-06: An EFT record is active only when today falls within the effective window.
• BR-07: LocationHasEFT requires direct deposit and non-revoked authorization.
• BR-09: Assigning EFT always queues customer email notification.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-005: SELECT PROVIDER_EOB_INTERFACE by provider/location
• SQL-006: SELECT PROVIDER_EOB_INTERFACE by location
• SQL-007: SELECT provider locations with EOB preference
• SQL-008: SELECT PROVIDER_EFT_INTERFACE by provider/location
• SQL-012: SELECT provider EFT locations with external-user email

---

PAYMENT_AUTHORIZATION

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderBankAccountCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderBankAccountCollection
Business objects	clsProviderBankAccountCollection

Operations referencing this table

• Provider bank account retrieval

Business rules referencing this table

• BR-14: Deleted bank accounts are excluded from provider bank-account retrieval.

SQL referencing this table

• SQL-004: SELECT provider bank accounts by provider

---

PERSON

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection
Business objects	clsProviderEOB, clsProviderEOBCollection, clsProviderEFT, clsProviderEFTCollection

Operations referencing this table

• EFT record management
• EOB preference management

Business rules referencing this table

• BR-06: An EFT record is active only when today falls within the effective window.
• BR-07: LocationHasEFT requires direct deposit and non-revoked authorization.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-005: SELECT PROVIDER_EOB_INTERFACE by provider/location
• SQL-006: SELECT PROVIDER_EOB_INTERFACE by location
• SQL-007: SELECT provider locations with EOB preference
• SQL-008: SELECT PROVIDER_EFT_INTERFACE by provider/location

---

PROVIDER

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEFT.CreateHistory for r operations.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEFT.CreateHistory
Business objects	clsProviderEFT.CreateHistory

Operations referencing this table

• EFT payment location assignment
• EFT record management
• EOB preference management
• Provider EFT collection retrieval
• EFT correspondence history
• Provider bank account retrieval

Business rules referencing this table

• BR-01: PaperlessEOBFlag is set to Y only when ExtUserTypeSeqNum is populated.
• BR-02: DefaultPrimaryFlag is initialized to N on new EOB creation.
• BR-03: EOB insert must affect exactly one row.
• BR-04: EOB updates enforce optimistic concurrency.
• BR-05: EOB deletes must affect exactly one row.
• BR-06: An EFT record is active only when today falls within the effective window.
• BR-07: LocationHasEFT requires direct deposit and non-revoked authorization.
• BR-08: Replacing active EFT authorization revokes the existing authorization first.
• BR-09: Assigning EFT always queues customer email notification.
• BR-10: Unassigning EFT expires the record and revokes authorization.
• BR-11: External user type selection depends on expiry and admin context.
• BR-12: EFT insert must succeed before child payment preference save.
• BR-13: EFT update increments update number only on success.
• BR-14: Deleted bank accounts are excluded from provider bank-account retrieval.
• BR-15: EFT location retrieval requires an active physical address.
• BR-16: EFT updates default missing effective dates to today.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-001: INSERT PROVIDER_EOB_INTERFACE
• SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST
• SQL-003: INSERT PROVIDER_EFT_INTERFACE
• SQL-004: SELECT provider bank accounts by provider
• SQL-005: SELECT PROVIDER_EOB_INTERFACE by provider/location
• SQL-006: SELECT PROVIDER_EOB_INTERFACE by location
• SQL-007: SELECT provider locations with EOB preference
• SQL-008: SELECT PROVIDER_EFT_INTERFACE by provider/location
• SQL-009: SELECT all PROVIDER_EFT_INTERFACE rows
• SQL-010: SELECT PROVIDER_EFT_INTERFACE by provider
• SQL-011: SELECT provider EFT locations
• SQL-012: SELECT provider EFT locations with external-user email
• SQL-013: UPDATE PROVIDER_EOB_INTERFACE
• SQL-014: UPDATE PROVIDER_EFT_INTERFACE
• SQL-015: DELETE PROVIDER_EOB_INTERFACE
• SQL-016: DELETE PROVIDER_EFT_INTERFACE

---

PROVIDER_ADDRESS

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEFTCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEFTCollection
Business objects	clsProviderEFTCollection

Operations referencing this table

• Provider EFT collection retrieval

Business rules referencing this table

• BR-15: EFT location retrieval requires an active physical address.

SQL referencing this table

• SQL-011: SELECT provider EFT locations

---

PROVIDER_CORR_HIST

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEFT.CreateHistory for c operations.
Access pattern	Stored procedure
CRUD operations	C
Key columns used	See related SQL documents for column-level references.
Sequence	PROVIDER_CORR_HIST_SEQ
Related tables	clsProviderEFT.CreateHistory
Business objects	clsProviderEFT.CreateHistory

Operations referencing this table

• EFT correspondence history

SQL referencing this table

• SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST

---

PROVIDER_EFT_INTERFACE

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory for c,r,u,d operations.
Access pattern	Direct SQL
CRUD operations	C,R,U,D
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory
Business objects	clsProviderEFT, clsProviderEFTCollection, clsProviderEFT.CreateHistory

Operations referencing this table

• EFT payment location assignment
• EFT record management
• Provider EFT collection retrieval
• EFT correspondence history

Business rules referencing this table

• BR-06: An EFT record is active only when today falls within the effective window.
• BR-07: LocationHasEFT requires direct deposit and non-revoked authorization.
• BR-08: Replacing active EFT authorization revokes the existing authorization first.
• BR-09: Assigning EFT always queues customer email notification.
• BR-10: Unassigning EFT expires the record and revokes authorization.
• BR-11: External user type selection depends on expiry and admin context.
• BR-12: EFT insert must succeed before child payment preference save.
• BR-13: EFT update increments update number only on success.
• BR-15: EFT location retrieval requires an active physical address.
• BR-16: EFT updates default missing effective dates to today.

SQL referencing this table

• SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST
• SQL-003: INSERT PROVIDER_EFT_INTERFACE
• SQL-008: SELECT PROVIDER_EFT_INTERFACE by provider/location
• SQL-009: SELECT all PROVIDER_EFT_INTERFACE rows
• SQL-010: SELECT PROVIDER_EFT_INTERFACE by provider
• SQL-011: SELECT provider EFT locations
• SQL-012: SELECT provider EFT locations with external-user email
• SQL-014: UPDATE PROVIDER_EFT_INTERFACE
• SQL-016: DELETE PROVIDER_EFT_INTERFACE

---

PROVIDER_EOB_INTERFACE

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEOB, clsProviderEOBCollection for c,r,u,d operations.
Access pattern	Direct SQL
CRUD operations	C,R,U,D
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEOB, clsProviderEOBCollection
Business objects	clsProviderEOB, clsProviderEOBCollection

Operations referencing this table

• EOB preference management

Business rules referencing this table

• BR-01: PaperlessEOBFlag is set to Y only when ExtUserTypeSeqNum is populated.
• BR-02: DefaultPrimaryFlag is initialized to N on new EOB creation.
• BR-03: EOB insert must affect exactly one row.
• BR-04: EOB updates enforce optimistic concurrency.
• BR-05: EOB deletes must affect exactly one row.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-001: INSERT PROVIDER_EOB_INTERFACE
• SQL-005: SELECT PROVIDER_EOB_INTERFACE by provider/location
• SQL-006: SELECT PROVIDER_EOB_INTERFACE by location
• SQL-007: SELECT provider locations with EOB preference
• SQL-013: UPDATE PROVIDER_EOB_INTERFACE
• SQL-015: DELETE PROVIDER_EOB_INTERFACE

---

PROVIDER_LOCATION

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEOBCollection, clsProviderEFTCollection, clsProviderBankAccountCollection for r operations.
Access pattern	Direct SQL
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEOBCollection, clsProviderEFTCollection, clsProviderBankAccountCollection
Business objects	clsProviderEOBCollection, clsProviderEFTCollection, clsProviderBankAccountCollection

Operations referencing this table

• EFT payment location assignment
• Provider EFT collection retrieval
• EOB preference management
• Provider bank account retrieval

Business rules referencing this table

• BR-09: Assigning EFT always queues customer email notification.
• BR-14: Deleted bank accounts are excluded from provider bank-account retrieval.
• BR-15: EFT location retrieval requires an active physical address.
• BR-17: Blank EOB user names display as Paper EOB.

SQL referencing this table

• SQL-004: SELECT provider bank accounts by provider
• SQL-007: SELECT provider locations with EOB preference
• SQL-011: SELECT provider EFT locations
• SQL-012: SELECT provider EFT locations with external-user email

---

PROVIDER_TAX_ID

Field	Value
Database	Oracle
Schema/Link	Unqualified in SQL text
Purpose	Used by clsProviderEFT.CreateHistory for r operations.
Access pattern	Stored procedure
CRUD operations	R
Key columns used	See related SQL documents for column-level references.
Sequence	N/A
Related tables	clsProviderEFT.CreateHistory
Business objects	clsProviderEFT.CreateHistory

Operations referencing this table

• EFT correspondence history

SQL referencing this table

• SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST

---

Table relationship diagram

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

erDiagram
    PROVIDER_LOCATION ||--o{ PROVIDER_EOB_INTERFACE : has
    EXT_USER_TYPE ||--o{ PROVIDER_EOB_INTERFACE : assigned_to
    EXT_USER ||--o{ EXT_USER_TYPE : groups
    EMAIL_ADDRESS ||--o{ EXT_USER : uses
    PERSON ||--o{ EXT_USER : identifies
    EXT_USER_TYPE ||--o{ PROVIDER_EFT_INTERFACE : assigned_to
    PROVIDER_LOCATION ||--o{ PROVIDER_EFT_INTERFACE : has
    PROVIDER_LOCATION ||--o{ PROVIDER_ADDRESS : has
    BANK_ACCOUNT ||--o{ PAYMENT_AUTHORIZATION : authorizes
    PROVIDER_LOCATION ||--o{ PAYMENT_AUTHORIZATION : applies_to
    PROVIDER ||--o{ PROVIDER_TAX_ID : primary_tax_id
    PROVIDER_CORR_HIST }o--|| PROVIDER_LOCATION : records
    PROVIDER_CORR_HIST }o--|| PROVIDER : records
    PROVIDER_CORR_HIST }o--|| EXT_USER_TYPE : references

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• SQL catalog
• Procedures
• API reference
• Configuration

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