SQL-013: Delete US Bank user

Delete a row from US_BANK_USER by primary key.

Classification

Field	Value
SQL ID	SQL-013
Operation type	Delete
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	clsUSBankUser
Criteria property	DeleteSQL
Lifecycle method	BeforeDelete

Parameters

Parameter	Direction	Type	Max length	Description
:USBankUserSeqNum	Input	Decimal	N/A	Primary key for user deletion.

Tables

Table	Access	Columns used
US_BANK_USER	DELETE	US_BANK_USER_SEQ_NUM

Sample SQL

DELETE US_BANK_USER
WHERE US_BANK_USER.US_BANK_USER_SEQ_NUM = :USBankUserSeqNum

Operations and processes

• Persist and retrieve SAIF-side integration records

Business rules

• BR-005: User deletes must affect exactly one row

Sources

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