SQL-003: Insert US Bank nonpay notice¶

Insert a new row into US_BANK_NONPAY_NOTICE during BOF notice persistence.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
`:USBankNonpayNoticeSeqNum`	Input	Decimal	N/A	Primary key value generated during `Create()`.
`:USBankUserSeqNum`	Input	`clsSmartDecimal` / `Decimal`	N/A	Optional related US Bank user sequence number stored with the notice.
`:PolicyNum`	Input	Decimal	N/A	SAIF policy identifier associated with the notice.
`:OnlinePaymentTypeCode`	Input	String	5	Nonpayment notice payment-type code.
`:BankingNetworkCode`	Input	`clsSmartString` / `String`	5	Optional banking-network code captured with the notice.
`:PaymentAmt`	Input	Decimal	N/A	Payment amount referenced by the notice.
`:NoticeDate`	Input	Date	N/A	Notice effective date.
`:EventDescr`	Input	String	65	Event description text from the notice payload.

Tables¶

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

Sample SQL¶

INSERT INTO US_BANK_NONPAY_NOTICE (
    US_BANK_NONPAY_NOTICE_SEQ_NUM,
    US_BANK_USER_SEQ_NUM,
    POLICY_NUM,
    ONLINE_PAYMENT_TYPE_CODE,
    BANKING_NETWORK_CODE,
    PAYMENT_AMT,
    NOTICE_DATE,
    EVENT_DESCR
) VALUES (
    :USBankNonpayNoticeSeqNum,
    :USBankUserSeqNum,
    :PolicyNum,
    :OnlinePaymentTypeCode,
    :BankingNetworkCode,
    :PaymentAmt,
    :NoticeDate,
    :EventDescr
)

Operations and processes¶

Persist and retrieve SAIF-side integration records

Business rules¶

BR-006: Notice inserts must affect exactly one row

Sources¶

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