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

# SAIF.Business.EPay.USBank SQL catalog

This page indexes the inline Oracle SQL statements identified in the database-analysis findings for `SAIF.Business.EPay.USBank`.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-003](SQL-003-insert-us-bank-nonpay-notice.md) | Inserts a new nonpayment-notice row. | Inline | US_BANK_NONPAY_NOTICE | `clsUSBankNonpayNotice` |
| [SQL-004](SQL-004-insert-us-bank-user.md) | Inserts a new user row. | Inline | US_BANK_USER | `clsUSBankUser` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-005](SQL-005-retrieve-us-bank-nonpay-notice-by-sequence.md) | Retrieves one nonpayment notice by primary key. | Inline | US_BANK_NONPAY_NOTICE | `clsUSBankNonpayNotice` |
| [SQL-006](SQL-006-retrieve-us-bank-nonpay-notices-by-policy.md) | Retrieves nonpayment notices by policy number. | Inline | US_BANK_NONPAY_NOTICE | `clsUSBankNonpayNoticeCollection` |
| [SQL-007](SQL-007-retrieve-us-bank-user-by-sequence.md) | Retrieves one user row by primary key. | Inline | US_BANK_USER | `clsUSBankUser` |
| [SQL-008](SQL-008-retrieve-us-bank-user-by-policy-and-business-online-user.md) | Retrieves one user row by policy number and business-online user ID. | Inline | US_BANK_USER | `clsUSBankUser` |
| [SQL-009](SQL-009-retrieve-us-bank-users-by-policy.md) | Retrieves user rows by policy number. | Inline | US_BANK_USER | `clsUSBankUserCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-010](SQL-010-update-us-bank-nonpay-notice.md) | Updates an existing nonpayment-notice row. | Inline | US_BANK_NONPAY_NOTICE | `clsUSBankNonpayNotice` |
| [SQL-011](SQL-011-update-us-bank-user.md) | Updates an existing user row. | Inline | US_BANK_USER | `clsUSBankUser` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-012](SQL-012-delete-us-bank-nonpay-notice.md) | Deletes a nonpayment-notice row. | Inline | US_BANK_NONPAY_NOTICE | `clsUSBankNonpayNotice` |
| [SQL-013](SQL-013-delete-us-bank-user.md) | Deletes a user row. | Inline | US_BANK_USER | `clsUSBankUser` |

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-select-us-bank-nonpay-notice-sequence.md) | Selects the next notice sequence value. | `US_Bank_Nonpay_Notice_SEQ` | DUAL | `clsUSBankNonpayNotice` |
| [SQL-002](SQL-002-select-us-bank-user-sequence.md) | Selects the next user sequence value. | `US_Bank_User_SEQ` | DUAL | `clsUSBankUser` |

## 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)
- [Security and authorization](../security-authorization.md)
- [API reference](../api/index.md)
- [Configuration](../configuration.md)

## 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`