SAIF.Business.EPay.USBank database tables

This page catalogs the Oracle tables accessed by SAIF.Business.EPay.USBank.

Table catalog

Table	Database	Schema/Link	CRUD	Purpose	Primary business object
DUAL	Oracle	Unqualified in library SQL	R	Supplies sequence NEXTVAL values for BOF key generation.	clsUSBankNonpayNotice, clsUSBankUser
US_BANK_NONPAY_NOTICE	Oracle	Unqualified in library SQL	C, R, U, D	Stores SAIF-side nonpayment notices correlated to policies and optional user rows.	clsUSBankNonpayNotice, clsUSBankNonpayNoticeCollection
US_BANK_USER	Oracle	Unqualified in library SQL	C, R, U, D	Stores SAIF-side US Bank user linkage data for policy and business-online identities.	clsUSBankUser, clsUSBankUserCollection

DUAL

Field	Value
Database	Oracle
Schema/Link	Unqualified in library SQL
Purpose	Supplies sequence values used during BOF Create() flows for users and notices.
Access pattern	Inline sequence SELECT
CRUD operations	Read
Key columns used	US_BANK_NONPAY_NOTICE_SEQ_NUM_NEXTVAL, US_BANK_USER_SEQ_NUM_NEXTVAL
Sequence	N/A
Related tables	US_BANK_NONPAY_NOTICE, US_BANK_USER
Business objects	clsUSBankNonpayNotice, clsUSBankUser

Operations referencing this table

• Register or update a US Bank user
• Persist and retrieve SAIF-side integration records

SQL referencing this table

• SQL-001: Select US Bank nonpay notice sequence
• SQL-002: Select US Bank user sequence

---

US_BANK_NONPAY_NOTICE

Field	Value
Database	Oracle
Schema/Link	Unqualified in library SQL
Purpose	Stores SAIF-side nonpayment notices received from the US Bank integration.
Access pattern	BOF criteria SQL and collection Load helper
CRUD operations	Create, Read, Update, Delete
Key columns used	US_BANK_NONPAY_NOTICE_SEQ_NUM, US_BANK_USER_SEQ_NUM, POLICY_NUM, ONLINE_PAYMENT_TYPE_CODE, BANKING_NETWORK_CODE, PAYMENT_AMT, NOTICE_DATE, EVENT_DESCR
Sequence	US_Bank_Nonpay_Notice_SEQ
Related tables	US_BANK_USER*
Business objects	clsUSBankNonpayNotice, clsUSBankNonpayNoticeCollection

Operations referencing this table

• Persist and retrieve SAIF-side integration records

Business rules referencing this table

• BR-006: Notice inserts must affect exactly one row
• BR-007: Notice updates must affect exactly one row
• BR-008: Notice deletes must affect exactly one row

SQL referencing this table

• SQL-003: Insert US Bank nonpay notice
• SQL-005: Retrieve US Bank nonpay notice by sequence
• SQL-006: Retrieve US Bank nonpay notices by policy
• SQL-010: Update US Bank nonpay notice
• SQL-012: Delete US Bank nonpay notice

---

US_BANK_USER

Field	Value
Database	Oracle
Schema/Link	Unqualified in library SQL
Purpose	Stores SAIF-side linkage between a policy, a business-online user ID, and the related US Bank profile.
Access pattern	BOF criteria SQL
CRUD operations	Create, Read, Update, Delete
Key columns used	US_BANK_USER_SEQ_NUM, POLICY_NUM, BUSINESS_ONLINE_USER, FIRST_NAME, LAST_NAME, TRANSFER_BANK_ACCOUNTS_FLAG
Sequence	US_Bank_User_SEQ
Related tables	US_BANK_NONPAY_NOTICE*
Business objects	clsUSBankUser, clsUSBankUserCollection

Operations referencing this table

• Register or update a US Bank user
• Persist and retrieve SAIF-side integration records

Business rules referencing this table

• BR-001: Business online user ID is required
• BR-002: Policy number is required
• BR-003: User inserts must affect exactly one row
• BR-004: User updates must affect exactly one row
• BR-005: User deletes must affect exactly one row
• BR-009: User lookup is case-insensitive

SQL referencing this table

• SQL-004: Insert US Bank user
• SQL-007: Retrieve US Bank user by sequence
• SQL-008: Retrieve US Bank user by policy and business-online user
• SQL-009: Retrieve US Bank users by policy
• SQL-011: Update US Bank user
• SQL-013: Delete US Bank user

Table relationship diagram

The following diagram shows the inferred relationship between the two persisted business tables.*

erDiagram
    US_BANK_USER ||--o{ US_BANK_NONPAY_NOTICE : "US_BANK_USER_SEQ_NUM"
    US_BANK_USER {
        NUMBER US_BANK_USER_SEQ_NUM PK
        NUMBER POLICY_NUM
        VARCHAR2 BUSINESS_ONLINE_USER
    }
    US_BANK_NONPAY_NOTICE {
        NUMBER US_BANK_NONPAY_NOTICE_SEQ_NUM PK
        NUMBER US_BANK_USER_SEQ_NUM FK
        NUMBER POLICY_NUM
    }

Related documentation

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

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts.

Sources

• Business\SAIF.Business.EPay.USBank\clsUSBankUser.vb
• Business\SAIF.Business.EPay.USBank\clsUSBankUserCollection.vb
• Business\SAIF.Business.EPay.USBank\clsUSBankNonpayNotice.vb
• Business\SAIF.Business.EPay.USBank\app.config