SQL-009: Retrieve US Bank users by policy¶

Retrieve user rows for a policy-scoped collection.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNum`	Input	Decimal	N/A	Policy-scoped filter for the user collection.

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.POLICY_NUM = :PolicyNum

Operations and processes¶

Persist and retrieve SAIF-side integration records

Sources¶

Business\SAIF.Business.EPay.USBank\clsUSBankUserCollection.vb