SQL-013: clsEFTAuthorization insert

Inserts a new payee EFT authorization/consent record into PAYMENT_AUTHORIZATION with 33 parameters covering customer identity, bank account reference, prenote tracking, IAT fields, and revocation status.

Classification

Field	Value
SQL ID	SQL-013
Operation type	Create
Execution method	Inline SQL
Database	Oracle*
Schema	[unqualified]**
Command type	Text
Business object	clsEFTAuthorization
Criteria property	InsertSQL
Lifecycle method	BeforeInsert / AfterInsert

Parameters

Parameter	Direction	Type	Max length	Description
:AuthorizationTypeCode	Input	String	5	Binds AuthorizationTypeCode*
:EnrollRequestSeqNum	Input	Decimal	—	Binds EnrollRequestSeqNum*
:AuthDate	Input	Date	—	Binds AuthDate*
:BankAccountSeqNum	Input	Decimal	—	Binds BankAccountSeqNum*
:CreateDate	Input	Date	—	Binds CreateDate*
:CreateIPAddr	Input	String	30	Binds CreateIPAddr*
:CreateUser	Input	String	30	Binds CreateUser*
:CustomerContactEmailAddr	Input	String	100	Binds CustomerContactEmailAddr*
:CustomerContactName	Input	String	50	Binds CustomerContactName*
:CustomerContactPhoneNum	Input	String	23	Binds CustomerContactPhoneNum*
:CustomerEmailNotificationFlag	Input	String	1	Binds CustomerEmailNotificationFlag*
:CustomerID	Input	String	20	Binds CustomerID*
:CustomerSecondID	Input	String	20	Binds CustomerSecondID*
:CustomerTypeCode	Input	String	5	Binds CustomerTypeCode*
:IATFlag	Input	String	1	Binds IATFlag*
:IATCity	Input	String	35	Binds IATCity*
:IATStreetAddress	Input	String	35	Binds IATStreetAddress*
:IATStateProvince	Input	String	35	Binds IATStateProvince*
:IATPostalCode	Input	String	20	Binds IATPostalCode*
:IATCountryCode	Input	String	5	Binds IATCountryCode*
:PaymentAuthorizationSeqNum	Input	Decimal	—	Binds PaymentAuthorizationSeqNum*
:PaymentDayOFMonthNum	Input	Decimal	—	Binds PaymentDayOFMonthNum*
:PaymentSourceSystemCode	Input	String	5	Binds PaymentSourceSystemCode*
:PrenoteFailDate	Input	Date	—	Binds PrenoteFailDate*
:PrenoteRequiredFlag	Input	String	1	Binds PrenoteRequiredFlag*
:PrenoteSuccessDate	Input	Date	—	Binds PrenoteSuccessDate*
:RevokeReasonCode	Input	String	5	Binds RevokeReasonCode*
:RevokeDate	Input	Date	—	Binds RevokeDate*
:UpdateDate	Input	Date	—	Binds UpdateDate*
:UpdateIPAddr	Input	String	30	Binds UpdateIPAddr*
:UpdateUser	Input	String	30	Binds UpdateUser*
:AutoPayConfirmationNum	Input	String	25	Binds AutoPayConfirmationNum*

Tables

Table	Access	Columns used
PAYMENT_AUTHORIZATION	INSERT	AUTHORIZATION_TYPE_CODE, ENROLL_REQUEST_SEQ_NUM, AUTH_DATE, BANK_ACCOUNT_SEQ_NUM, CUSTOMER_ID, CUSTOMER_TYPE_CODE, PAYMENT_SOURCE_SYSTEM_CODE, PRENOTE_REQUIRED_FLAG, REVOKE_REASON_CODE, AUTO_PAY_CONFIRMATION_NUM, IAT_FLAG, and more

Sample SQL

Insert into PAYMENT_AUTHORIZATION (
  AUTHORIZATION_TYPE_CODE, ENROLL_REQUEST_SEQ_NUM, AUTH_AGREEMENT_VERSION, AUTH_DATE,
  BANK_ACCOUNT_SEQ_NUM, CREATE_DATE, CREATE_IP_ADDR, CREATE_USER,
  CUSTOMER_CONTACT_EMAIL_ADDR, CUSTOMER_CONTACT_NAME, CUSTOMER_CONTACT_PHONE_NUM,
  CUSTOMER_ID, Customer_Second_ID, CUSTOMER_TYPE_CODE, EMAIL_NOTIFICATION_FLAG,
  IAT_FLAG, IAT_CITY, IAT_STREET_ADDRESS, IAT_STATE_PROVINCE, IAT_POSTAL_CODE,
  IAT_COUNTRY_CODE, PAYMENT_AUTHORIZATION_SEQ_NUM, PAYMENT_DAY_OF_MONTH_NUM,
  PAYMENT_SOURCE_SYSTEM_CODE, PRENOTE_FAIL_DATE, PRENOTE_REQUIRED_FLAG,
  PRENOTE_SUCCESS_DATE, REVOKE_REASON_CODE, REVOKE_DATE,
  UPDATE_DATE, UPDATE_IP_ADDR, UPDATE_USER, AUTO_PAY_CONFIRMATION_NUM
)
Values (
  :AuthorizationTypeCode, :EnrollRequestSeqNum, :AuthAgreementVersion, :AuthDate,
  :BankAccountSeqNum, :CreateDate, :CreateIPAddr, :CreateUser,
  :CustomerContactEmailAddr, :CustomerContactName, :CustomerContactPhoneNum,
  :CustomerID, :CustomerSecondID, :CustomerTypeCode, :CustomerEmailNotificationFlag,
  :IATFlag, :IATCity, :IATStreetAddress, :IATStateProvince, :IATPostalCode,
  :IATCountryCode, :PaymentAuthorizationSeqNum, :PaymentDayOFMonthNum,
  :PaymentSourceSystemCode, :PrenoteFailDate, :PrenoteRequiredFlag,
  :PrenoteSuccessDate, :RevokeReasonCode, :RevokeDate,
  :UpdateDate, :UpdateIPAddr, :UpdateUser, :AutoPayConfirmationNum
)

Row-count check: If RowsAffected <> 1 Then Me.AddErrorMessage("InsertError", "Insert Failed") End If

Operations and processes

• EFT authorization / consent*

Business rules

• BR-EFT-01: EFT authorization gates electronic payment eligibility
• BR-EFT-05: Insert/update operations require exactly one affected row*

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

• Business\SAIF.Business.Payment.EFT\clsEFTAuthorization.vb