SQL-007: Retrieve US Bank user by sequence¶

Retrieve a single user row by sequence number.

Classification¶

Field	Value
SQL ID	SQL-007
Operation type	Read
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	`clsUSBankUser`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:USBankUserSeqNum`	Input	Decimal	N/A	Primary key lookup for a single user row.

Tables¶

Table	Access	Columns used
US_BANK_USER	SELECT	`US_BANK_USER_SEQ_NUM`, `POLICY_NUM`, `BUSINESS_ONLINE_USER`, `FIRST_NAME`, `LAST_NAME`, `TRANSFER_BANK_ACCOUNTS_FLAG`

Sample SQL¶

SELECT
    US_BANK_USER.US_BANK_USER_SEQ_NUM AS USBankUserSeqNum,
    US_BANK_USER.POLICY_NUM AS PolicyNum,
    US_BANK_USER.BUSINESS_ONLINE_USER AS BusinessOnlineUser,
    US_BANK_USER.FIRST_NAME AS FirstName,
    US_BANK_USER.LAST_NAME AS LastName,
    US_BANK_USER.TRANSFER_BANK_ACCOUNTS_FLAG AS TransferBankAccountsFlag
FROM US_BANK_USER
WHERE US_BANK_USER.US_BANK_USER_SEQ_NUM = :USBankUserSeqNum

Operations and processes¶

Persist and retrieve SAIF-side integration records

Sources¶

Business\SAIF.Business.EPay.USBank\clsUSBankUser.vb