---
title: SAIF.Business.Payment.EFT 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.Payment.EFT
reference_type: package
---

# SAIF.Business.Payment.EFT SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type. The library contains 97 SQL IDs targeting Oracle.

## Sequence operations

| SQL ID | Description | Sequence | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-saif-business-payment-eft.md) | BANK_ACCOUNT_SEQ sequence | `BANK_ACCOUNT_SEQ` | DUAL | `clsBankAccount` |
| [SQL-002](SQL-002-saif-business-payment-eft.md) | CODE_NEXTVAL sequence (banking network) | `CODE_NEXTVAL` | DUAL | `clsBankingNetworkCode` |
| [SQL-003](SQL-003-saif-business-payment-eft.md) | ENROLL_REQUEST_SEQ sequence | `ENROLL_REQUEST_SEQ` | DUAL | `clsDebitCardEnrollmentRequest` |
| [SQL-004](SQL-004-saif-business-payment-eft.md) | output_control_seq sequence | `output_control_seq` | DUAL | `clsOutputControl` |
| [SQL-005](SQL-005-saif-business-payment-eft.md) | payment_addenda_seq sequence | `payment_addenda_seq` | DUAL | `clsPaymentAddenda` |
| [SQL-006](SQL-006-saif-business-payment-eft.md) | Payment_detail_seq sequence | `Payment_detail_seq` | DUAL | `clsPaymentDetail` |
| [SQL-007](SQL-007-saif-business-payment-eft.md) | payment_event_seq sequence | `payment_event_seq` | DUAL | `clsPaymentEvent` |
| [SQL-008](SQL-008-saif-business-payment-eft.md) | PAYMENT_RETURN_SEQ sequence | `PAYMENT_RETURN_SEQ` | DUAL | `clsPaymentReturn` |

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-009](SQL-009-saif-business-payment-eft.md) | Insert bank account record | Inline SQL | BANK_ACCOUNT | `clsBankAccount` |
| [SQL-010](SQL-010-saif-business-payment-eft.md) | Insert bank account transfer link | Inline SQL | BANK_ACCOUNT_TRANSFER | `clsBankAccountTransfer` |
| [SQL-011](SQL-011-saif-business-payment-eft.md) | Insert banking network code | Inline SQL | BANKING_NETWORK_CODE | `clsBankingNetworkCode` |
| [SQL-012](SQL-012-saif-business-payment-eft.md) | Insert debit card enrollment request | Inline SQL | DEBIT_CARD_ENROLLMENT_REQUEST | `clsDebitCardEnrollmentRequest` |
| [SQL-013](SQL-013-saif-business-payment-eft.md) | Insert EFT authorization record | Inline SQL | PAYMENT_AUTHORIZATION | `clsEFTAuthorization` |
| [SQL-014](SQL-014-saif-business-payment-eft.md) | Insert output control record | Inline SQL | OUTPUT_CONTROL | `clsOutputControl` |
| [SQL-015](SQL-015-saif-business-payment-eft.md) | Insert payment addenda record | Inline SQL | PAYMENT_ADDENDA | `clsPaymentAddenda` |
| [SQL-016](SQL-016-saif-business-payment-eft.md) | Insert payment allocation record | Inline SQL | PAYMENT_ALLOCATION | `clsPaymentAllocation` |
| [SQL-017](SQL-017-saif-business-payment-eft.md) | Insert payment authorization session transfer | Inline SQL | PAYMENT_AUTH_SESSION_TRANSFER | `clsPaymentAuthorizationSessionTransfer` |
| [SQL-018](SQL-018-saif-business-payment-eft.md) | Insert payment detail record | Inline SQL | PAYMENT_DETAIL | `clsPaymentDetail` |
| [SQL-019](SQL-019-saif-business-payment-eft.md) | Insert payment event record | Inline SQL | PAYMENT_EVENT | `clsPaymentEvent` |
| [SQL-020](SQL-020-saif-business-payment-eft.md) | Insert payment return record | Inline SQL | PAYMENT_RETURN | `clsPaymentReturn` |
| [SQL-021](SQL-021-saif-business-payment-eft.md) | Insert session transfer record | Inline SQL | SESSION_TRANSFER | `clsSessionTransfer` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-022](SQL-022-saif-business-payment-eft.md) | Retrieve ACH file ID by code | Inline SQL | ACH_FILE_ID | `clsAchFileID` |
| [SQL-023](SQL-023-saif-business-payment-eft.md) | Retrieve all ACH file IDs | Inline SQL | ACH_FILE_ID | `clsAchFileIDCollection` |
| [SQL-024](SQL-024-saif-business-payment-eft.md) | Retrieve ACH standard entry class code | Inline SQL | ACH_STANDARD_ENTRY_CLASS_CODE | `clsAchStandardEntryClassCode` |
| [SQL-025](SQL-025-saif-business-payment-eft.md) | Retrieve addenda type code by code | Inline SQL | ADDENDA_TYPE_CODE | `clsAddendaTypeCode` |
| [SQL-026](SQL-026-saif-business-payment-eft.md) | Retrieve all addenda type codes | Inline SQL | ADDENDA_TYPE_CODE | `clsAddendaTypeCodeCollection` |
| [SQL-027](SQL-027-saif-business-payment-eft.md) | Retrieve authorization type code by code | Inline SQL | AUTHORIZATION_TYPE_CODE | `clsAuthorizationTypeCode` |
| [SQL-028](SQL-028-saif-business-payment-eft.md) | Retrieve all authorization type codes | Inline SQL | AUTHORIZATION_TYPE_CODE | `clsAuthorizationTypeCodeCollection` |
| [SQL-029](SQL-029-saif-business-payment-eft.md) | Retrieve balance type code by code | Inline SQL | BALANCE_TYPE_CODE | `clsBalanceTypeCode` |
| [SQL-030](SQL-030-saif-business-payment-eft.md) | Retrieve bank account by ID | Inline SQL | BANK_ACCOUNT | `clsBankAccount` |
| [SQL-031](SQL-031-saif-business-payment-eft.md) | Retrieve bank accounts by create user | Inline SQL | BANK_ACCOUNT | `clsBankAccountCollection` |
| [SQL-032](SQL-032-saif-business-payment-eft.md) | Retrieve bank account data source code | Inline SQL | BANK_ACCOUNT_DATA_SOURCE_CODE | `clsBankAccountDataSourceCode` |
| [SQL-033](SQL-033-saif-business-payment-eft.md) | Retrieve all bank account data source codes | Inline SQL | BANK_ACCOUNT_DATA_SOURCE_CODE | `clsBankAccountDataSourceCodeCollection` |
| [SQL-034](SQL-034-saif-business-payment-eft.md) | Retrieve bank account status code | Inline SQL | BANK_ACCOUNT_STATUS_CODE | `clsBankAccountStatusCode` |
| [SQL-035](SQL-035-saif-business-payment-eft.md) | Retrieve all bank account status codes | Inline SQL | BANK_ACCOUNT_STATUS_CODE | `clsBankAccountStatusCodeCollection` |
| [SQL-036](SQL-036-saif-business-payment-eft.md) | Retrieve bank account transfer | Inline SQL | BANK_ACCOUNT_TRANSFER | `clsBankAccountTransfer` |
| [SQL-037](SQL-037-saif-business-payment-eft.md) | Retrieve bank account type code | Inline SQL | BANK_ACCOUNT_TYPE_CODE | `clsBankAccountTypeCode` |
| [SQL-038](SQL-038-saif-business-payment-eft.md) | Retrieve all bank account type codes | Inline SQL | BANK_ACCOUNT_TYPE_CODE | `clsBankAccountTypeCodeCollection` |
| [SQL-039](SQL-039-saif-business-payment-eft.md) | Retrieve banking network code | Inline SQL | BANKING_NETWORK_CODE | `clsBankingNetworkCode` |
| [SQL-040](SQL-040-saif-business-payment-eft.md) | Retrieve all banking network codes | Inline SQL | BANKING_NETWORK_CODE | `clsBankingNetworkCodeCollection` |
| [SQL-041](SQL-041-saif-business-payment-eft.md) | Retrieve customer type code | Inline SQL | CUSTOMER_TYPE_CODE | `clsCustomerTypeCode` |
| [SQL-042](SQL-042-saif-business-payment-eft.md) | Retrieve all customer type codes | Inline SQL | CUSTOMER_TYPE_CODE | `clsCustomerTypeCodeCollection` |
| [SQL-043](SQL-043-saif-business-payment-eft.md) | Retrieve debit card enrollment request | Inline SQL | DEBIT_CARD_ENROLLMENT_REQUEST | `clsDebitCardEnrollmentRequest` |
| [SQL-044](SQL-044-saif-business-payment-eft.md) | Retrieve debit card enrollment requests by cardholder | Inline SQL | DEBIT_CARD_ENROLLMENT_REQUEST | `clsDebitCardEnrollmentRequestCollection` |
| [SQL-045](SQL-045-saif-business-payment-eft.md) | Retrieve EFT authorization (inline variants A/B; stored proc variant C) | Mixed (Inline SQL / Stored procedure) | PAYMENT_AUTHORIZATION, AUTHORIZATION_TYPE_CODE, REVOKE_REASON_CODE | `clsEFTAuthorization` |
| [SQL-046](SQL-046-saif-business-payment-eft.md) | Retrieve EFT authorization collection with dynamic WHERE | Inline SQL | PAYMENT_AUTHORIZATION, AUTHORIZATION_TYPE_CODE, REVOKE_REASON_CODE, PAYMENT_OWNER.PAYMENT_DETAIL | `clsEFTAuthorizationCollection` |
| [SQL-047](SQL-047-saif-business-payment-eft.md) | Retrieve enroll status code | Inline SQL | ENROLL_STATUS_CODE | `clsEnrollStatusCode` |
| [SQL-048](SQL-048-saif-business-payment-eft.md) | Retrieve all enroll status codes | Inline SQL | ENROLL_STATUS_CODE | `clsEnrollStatusCodeCollection` |
| [SQL-049](SQL-049-saif-business-payment-eft.md) | Retrieve online payment type code | Inline SQL | ONLINE_PAYMENT_TYPE_CODE | `clsOnlinePaymentTypeCode` |
| [SQL-050](SQL-050-saif-business-payment-eft.md) | Retrieve all online payment type codes | Inline SQL | ONLINE_PAYMENT_TYPE_CODE | `clsOnlinePaymentTypeCodeCollection` |
| [SQL-051](SQL-051-saif-business-payment-eft.md) | Retrieve output control by seq num | Inline SQL | OUTPUT_CONTROL | `clsOutputControl` |
| [SQL-052](SQL-052-saif-business-payment-eft.md) | Retrieve output control records by print date | Inline SQL | OUTPUT_CONTROL | `clsOutputControlCollection` |
| [SQL-053](SQL-053-saif-business-payment-eft.md) | Retrieve output document code | Inline SQL | OUTPUT_DOCUMENT_CODE | `clsOutputDocumentCode` |
| [SQL-054](SQL-054-saif-business-payment-eft.md) | Retrieve all output document codes | Inline SQL | OUTPUT_DOCUMENT_CODE | `clsOutputDocumentCodeCollection` |
| [SQL-055](SQL-055-saif-business-payment-eft.md) | Retrieve payment addenda by seq num | Inline SQL | PAYMENT_ADDENDA | `clsPaymentAddenda` |
| [SQL-056](SQL-056-saif-business-payment-eft.md) | Retrieve payment addenda by payment detail | Inline SQL | PAYMENT_ADDENDA | `clsPaymentAddendaCollection` |
| [SQL-057](SQL-057-saif-business-payment-eft.md) | Retrieve payment allocations by session transfer | Inline SQL | PAYMENT_ALLOCATION | `clsPaymentAllocationCollection` |
| [SQL-058](SQL-058-saif-business-payment-eft.md) | Retrieve payment authorization session transfer | Inline SQL | PAYMENT_AUTH_SESSION_TRANSFER | `clsPaymentAuthorizationSessionTransfer` |
| [SQL-059](SQL-059-saif-business-payment-eft.md) | Retrieve payment detail by seq num | Inline SQL | PAYMENT_DETAIL, PAYMENT_AUTHORIZATION, AUTHORIZATION_TYPE_CODE | `clsPaymentDetail` |
| [SQL-060](SQL-060-saif-business-payment-eft.md) | Retrieve payment event by seq num | Inline SQL | PAYMENT_EVENT, PAYMENT_EVENT_CODE, PAYMENT_RETURN_REASON_CODE | `clsPaymentEvent` |
| [SQL-061](SQL-061-saif-business-payment-eft.md) | Retrieve payment event code | Inline SQL | PAYMENT_EVENT_CODE | `clsPaymentEventCode` |
| [SQL-062](SQL-062-saif-business-payment-eft.md) | Retrieve all payment event codes | Inline SQL | PAYMENT_EVENT_CODE | `clsPaymentEventCodeCollection` |
| [SQL-063](SQL-063-saif-business-payment-eft.md) | Retrieve payment events by payment detail | Inline SQL | PAYMENT_EVENT, PAYMENT_EVENT_CODE, PAYMENT_RETURN_REASON_CODE | `clsPaymentEventCollection` |
| [SQL-064](SQL-064-saif-business-payment-eft.md) | Retrieve payment return by seq num | Inline SQL | PAYMENT_OWNER.PAYMENT_RETURN + joins | `clsPaymentReturn` |
| [SQL-065](SQL-065-saif-business-payment-eft.md) | Retrieve payment returns by culture code | Inline SQL | PAYMENT_OWNER.PAYMENT_RETURN + joins | `clsPaymentReturnCollection` |
| [SQL-066](SQL-066-saif-business-payment-eft.md) | Retrieve payment return reason code | Inline SQL | PAYMENT_RETURN_REASON_CODE, PAYMENT_RETURN_REASON_GCODE | `clsPaymentReturnReasonCode` |
| [SQL-067](SQL-067-saif-business-payment-eft.md) | Retrieve all payment return reason codes | Inline SQL | PAYMENT_RETURN_REASON_CODE, PAYMENT_RETURN_REASON_GCODE | `clsPaymentReturnReasonCodeCollection` |
| [SQL-068](SQL-068-saif-business-payment-eft.md) | Retrieve payment source system code | Inline SQL | PAYMENT_SOURCE_SYSTEM_CODE | `clsPaymentSourceSystemCode` |
| [SQL-069](SQL-069-saif-business-payment-eft.md) | Retrieve all payment source system codes | Inline SQL | PAYMENT_SOURCE_SYSTEM_CODE | `clsPaymentSourceSystemCodeCollection` |
| [SQL-070](SQL-070-saif-business-payment-eft.md) | Retrieve return status code | Inline SQL | RETURN_STATUS_CODE | `clsReturnStatusCode` |
| [SQL-071](SQL-071-saif-business-payment-eft.md) | Retrieve all return status codes | Inline SQL | RETURN_STATUS_CODE | `clsReturnStatusCodeCollection` |
| [SQL-072](SQL-072-saif-business-payment-eft.md) | Retrieve return type code | Inline SQL | RETURN_TYPE_CODE | `clsReturnTypeCode` |
| [SQL-073](SQL-073-saif-business-payment-eft.md) | Retrieve all return type codes | Inline SQL | RETURN_TYPE_CODE | `clsReturnTypeCodeCollection` |
| [SQL-074](SQL-074-saif-business-payment-eft.md) | Retrieve revoke reason code (PAYMENT_OWNER schema) | Inline SQL | PAYMENT_OWNER.REVOKE_REASON_CODE | `clsRevokeReasonCode` |
| [SQL-075](SQL-075-saif-business-payment-eft.md) | Retrieve all revoke reason codes (PAYMENT_OWNER schema) | Inline SQL | PAYMENT_OWNER.REVOKE_REASON_CODE | `clsRevokeReasonCodeCollection` |
| [SQL-076](SQL-076-saif-business-payment-eft.md) | Retrieve session transfer (multiple variants) | Inline SQL | SESSION_TRANSFER | `clsSessionTransfer` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-077](SQL-077-saif-business-payment-eft.md) | Inline SQL update used by clsBankAccount | Inline SQL | BANK_ACCOUNT | `clsBankAccount` |
| [SQL-078](SQL-078-saif-business-payment-eft.md) | Inline SQL update used by clsBankAccountTransfer | Inline SQL | BANK_ACCOUNT_TRANSFER | `clsBankAccountTransfer` |
| [SQL-079](SQL-079-saif-business-payment-eft.md) | Inline SQL update used by clsBankingNetworkCode | Inline SQL | BANKING_NETWORK_CODE | `clsBankingNetworkCode` |
| [SQL-080](SQL-080-saif-business-payment-eft.md) | Inline SQL update used by clsDebitCardEnrollmentRequest | Inline SQL | DEBIT_CARD_ENROLLMENT_REQUEST | `clsDebitCardEnrollmentRequest` |
| [SQL-081](SQL-081-saif-business-payment-eft.md) | Inline SQL update used by clsEFTAuthorization | Inline SQL | PAYMENT_AUTHORIZATION | `clsEFTAuthorization` |
| [SQL-082](SQL-082-saif-business-payment-eft.md) | Inline SQL update used by clsOutputControl | Inline SQL | OUTPUT_CONTROL | `clsOutputControl` |
| [SQL-083](SQL-083-saif-business-payment-eft.md) | Inline SQL update used by clsPaymentAddenda | Inline SQL | PAYMENT_ADDENDA | `clsPaymentAddenda` |
| [SQL-084](SQL-084-saif-business-payment-eft.md) | Inline SQL update used by clsPaymentAllocation | Inline SQL | PAYMENT_ALLOCATION | `clsPaymentAllocation` |
| [SQL-085](SQL-085-saif-business-payment-eft.md) | Inline SQL update used by clsPaymentDetail | Inline SQL | PAYMENT_DETAIL | `clsPaymentDetail` |
| [SQL-086](SQL-086-saif-business-payment-eft.md) | Inline SQL update used by clsPaymentReturn | Inline SQL | PAYMENT_RETURN | `clsPaymentReturn` |
| [SQL-087](SQL-087-saif-business-payment-eft.md) | Inline SQL update used by clsSessionTransfer | Inline SQL | SESSION_TRANSFER | `clsSessionTransfer` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-088](SQL-088-saif-business-payment-eft.md) | Soft-delete bank account (set status to DELETED) | Inline SQL | BANK_ACCOUNT | `clsBankAccount` |
| [SQL-089](SQL-089-saif-business-payment-eft.md) | Inline SQL delete used by clsBankAccountTransfer | Inline SQL | BANK_ACCOUNT_TRANSFER | `clsBankAccountTransfer` |
| [SQL-090](SQL-090-saif-business-payment-eft.md) | Inline SQL delete used by clsBankingNetworkCode | Inline SQL | BANKING_NETWORK_CODE | `clsBankingNetworkCode` |
| [SQL-091](SQL-091-saif-business-payment-eft.md) | Inline SQL delete used by clsDebitCardEnrollmentRequest | Inline SQL | DEBIT_CARD_ENROLLMENT_REQUEST | `clsDebitCardEnrollmentRequest` |
| [SQL-092](SQL-092-saif-business-payment-eft.md) | Inline SQL delete used by clsEFTAuthorization | Inline SQL | PAYMENT_AUTHORIZATION | `clsEFTAuthorization` |
| [SQL-093](SQL-093-saif-business-payment-eft.md) | Inline SQL delete used by clsOutputControl | Inline SQL | OUTPUT_CONTROL | `clsOutputControl` |
| [SQL-094](SQL-094-saif-business-payment-eft.md) | Inline SQL delete used by clsPaymentAddenda | Inline SQL | PAYMENT_ADDENDA | `clsPaymentAddenda` |
| [SQL-095](SQL-095-saif-business-payment-eft.md) | Inline SQL delete used by clsPaymentAllocation | Inline SQL | PAYMENT_ALLOCATION | `clsPaymentAllocation` |
| [SQL-096](SQL-096-saif-business-payment-eft.md) | Inline SQL delete used by clsPaymentDetail | Inline SQL | PAYMENT_DETAIL | `clsPaymentDetail` |
| [SQL-097](SQL-097-saif-business-payment-eft.md) | Inline SQL delete used by clsSessionTransfer | Inline SQL | SESSION_TRANSFER | `clsSessionTransfer` |

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

## Sources
- `Business\SAIF.Business.Payment.EFT\clsBankAccount.vb`
- `Business\SAIF.Business.Payment.EFT\clsEFTAuthorization.vb`
- `Business\SAIF.Business.Payment.EFT\clsDebitCardEnrollmentRequest.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentDetail.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentAllocation.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentAddenda.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentReturn.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentEvent.vb`
- `Business\SAIF.Business.Payment.EFT\clsSessionTransfer.vb`
- `Business\SAIF.Business.Payment.EFT\clsOutputControl.vb`
- `Business\SAIF.Business.Payment.EFT\clsAchFileID.vb`
- `Business\SAIF.Business.Payment.EFT\clsBankingNetworkCode.vb`
- `Business\SAIF.Business.Payment.EFT\clsBankAccountTransfer.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentAuthorizationSessionTransfer.vb`
- `Business\SAIF.Business.Payment.EFT\clsRevokeReasonCode.vb`
- `Business\SAIF.Business.Payment.EFT\clsPaymentReturnReasonCode.vb`