SQL-004: Insert US Bank user

Insert a new row into US_BANK_USER during BOF user persistence.

Classification

Field	Value
SQL ID	SQL-004
Operation type	Create
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	clsUSBankUser
Criteria property	InsertSQL
Lifecycle method	BeforeInsert

Parameters

Parameter	Direction	Type	Max length	Description
:FirstName	Input	clsSmartString / String	30	US Bank user first name.
:LastName	Input	clsSmartString / String	30	US Bank user last name.
:TransferBankAccountsFlag	Input	String	1	Y/N flag indicating whether bank accounts transfer to the profile.
:PolicyNum	Input	Decimal	N/A	SAIF policy identifier linked to the user.
:BusinessOnlineUser	Input	String	30	Business Online user ID stored with the US Bank user row.
:USBankUserSeqNum	Input	Decimal	N/A	Primary key value generated during Create().

Tables

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

Sample SQL

INSERT INTO US_BANK_USER (
    US_BANK_USER_SEQ_NUM,
    POLICY_NUM,
    BUSINESS_ONLINE_USER,
    FIRST_NAME,
    LAST_NAME,
    TRANSFER_BANK_ACCOUNTS_FLAG
) VALUES (
    :USBankUserSeqNum,
    :PolicyNum,
    :BusinessOnlineUser,
    :FirstName,
    :LastName,
    :TransferBankAccountsFlag
)

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
• BR-003: User inserts must affect exactly one row

Sources

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