SQL-002: Select US Bank user sequence

Retrieve the next Oracle sequence value used when a new clsUSBankUser object is created.

Classification

Field	Value
SQL ID	SQL-002
Operation type	Sequence
Execution method	Framework sequence helper with Oracle CreateSQL property present
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	clsUSBankUser
Criteria property	CreateSQL
Lifecycle method	Create

Tables

Table	Access	Columns used
DUAL	SELECT	US_BANK_USER_SEQ_NUM_NEXTVAL

Sample SQL

SELECT US_BANK_USER_SEQ_NUM_NEXTVAL FROM DUAL

Operations and processes

• Register or update a US Bank user
• Persist and retrieve SAIF-side integration records

Business rules

• BR-001: Business online user ID is required
• BR-002: Policy number is required

Sources

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