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	BANK_ACCOUNT_SEQ sequence	BANK_ACCOUNT_SEQ	DUAL	clsBankAccount
SQL-002	CODE_NEXTVAL sequence (banking network)	CODE_NEXTVAL	DUAL	clsBankingNetworkCode
SQL-003	ENROLL_REQUEST_SEQ sequence	ENROLL_REQUEST_SEQ	DUAL	clsDebitCardEnrollmentRequest
SQL-004	output_control_seq sequence	output_control_seq	DUAL	clsOutputControl
SQL-005	payment_addenda_seq sequence	payment_addenda_seq	DUAL	clsPaymentAddenda
SQL-006	Payment_detail_seq sequence	Payment_detail_seq	DUAL	clsPaymentDetail
SQL-007	payment_event_seq sequence	payment_event_seq	DUAL	clsPaymentEvent
SQL-008	PAYMENT_RETURN_SEQ sequence	PAYMENT_RETURN_SEQ	DUAL	clsPaymentReturn

Create operations

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

Read operations

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

Update operations

SQL ID	Description	Type	Tables	Business object
SQL-077	Inline SQL update used by clsBankAccount	Inline SQL	BANK_ACCOUNT	clsBankAccount
SQL-078	Inline SQL update used by clsBankAccountTransfer	Inline SQL	BANK_ACCOUNT_TRANSFER	clsBankAccountTransfer
SQL-079	Inline SQL update used by clsBankingNetworkCode	Inline SQL	BANKING_NETWORK_CODE	clsBankingNetworkCode
SQL-080	Inline SQL update used by clsDebitCardEnrollmentRequest	Inline SQL	DEBIT_CARD_ENROLLMENT_REQUEST	clsDebitCardEnrollmentRequest
SQL-081	Inline SQL update used by clsEFTAuthorization	Inline SQL	PAYMENT_AUTHORIZATION	clsEFTAuthorization
SQL-082	Inline SQL update used by clsOutputControl	Inline SQL	OUTPUT_CONTROL	clsOutputControl
SQL-083	Inline SQL update used by clsPaymentAddenda	Inline SQL	PAYMENT_ADDENDA	clsPaymentAddenda
SQL-084	Inline SQL update used by clsPaymentAllocation	Inline SQL	PAYMENT_ALLOCATION	clsPaymentAllocation
SQL-085	Inline SQL update used by clsPaymentDetail	Inline SQL	PAYMENT_DETAIL	clsPaymentDetail
SQL-086	Inline SQL update used by clsPaymentReturn	Inline SQL	PAYMENT_RETURN	clsPaymentReturn
SQL-087	Inline SQL update used by clsSessionTransfer	Inline SQL	SESSION_TRANSFER	clsSessionTransfer

Delete operations

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

Related documentation

• Index
• Overview
• Architecture
• Dependencies
• Operations and processes
• Business rules
• Database tables
• API reference
• Configuration

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