SQL-010: Update US Bank nonpay notice¶

Update an existing row in US_BANK_NONPAY_NOTICE.

Classification¶

Field	Value
SQL ID	SQL-010
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	`clsUSBankNonpayNotice`
Criteria property	`UpdateSQL`
Lifecycle method	`BeforeUpdate`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:USBankUserSeqNum`	Input	`clsSmartDecimal` / `Decimal`	N/A	Related US Bank user sequence number written back to the notice row.
`:PolicyNum`	Input	Decimal	N/A	SAIF policy identifier associated with the notice.
`:OnlinePaymentTypeCode`	Input	String	5	Nonpayment notice payment-type code.
`:PaymentAmt`	Input	Decimal	N/A	Updated payment amount.
`:NoticeDate`	Input	Date	N/A	Updated notice date.
`:EventDescr`	Input	String	65	Updated event description text.
`:BankingNetworkCode`	Input	`clsSmartString` / `String`	5	Updated banking-network code.
`:USBankNonpayNoticeSeqNum`	Input	Decimal	N/A	Primary key used in the `WHERE` clause.

Tables¶

Table	Access	Columns used
US_BANK_NONPAY_NOTICE	UPDATE	`US_BANK_USER_SEQ_NUM`, `POLICY_NUM`, `ONLINE_PAYMENT_TYPE_CODE`, `BANKING_NETWORK_CODE`, `PAYMENT_AMT`, `NOTICE_DATE`, `EVENT_DESCR`, `US_BANK_NONPAY_NOTICE_SEQ_NUM`

Sample SQL¶

UPDATE US_BANK_NONPAY_NOTICE
SET
    US_BANK_USER_SEQ_NUM = :USBankUserSeqNum,
    POLICY_NUM = :PolicyNum,
    ONLINE_PAYMENT_TYPE_CODE = :OnlinePaymentTypeCode,
    BANKING_NETWORK_CODE = :BankingNetworkCode,
    PAYMENT_AMT = :PaymentAmt,
    NOTICE_DATE = :NoticeDate,
    EVENT_DESCR = :EventDescr
WHERE US_BANK_NONPAY_NOTICE.US_BANK_NONPAY_NOTICE_SEQ_NUM = :USBankNonpayNoticeSeqNum

Operations and processes¶

Persist and retrieve SAIF-side integration records

Business rules¶

BR-007: Notice updates must affect exactly one row

Sources¶

Business\SAIF.Business.EPay.USBank\clsUSBankNonpayNotice.vb