SQL-058: clsPaymentAuthorizationSessionTransfer retrieve (2 variants)

Retrieves a payment authorization to session transfer link record from PAYMENT_AUTH_SESSION_TRANSFER. Supports two look-up approaches.

Classification

Field	Value
SQL ID	SQL-058
Operation type	Read
Execution method	Inline SQL
Database	Oracle*
Schema	[unqualified]**
Command type	Text
Business object	clsPaymentAuthorizationSessionTransfer
Criteria property	RetrieveSQL
Lifecycle method	BeforeRetrieve / AfterRetrieve

Parameters

Parameter	Direction	Type	Max length	Description
:PaymentAuthorizationId\	Input	Decimal	—	Binds \MyCriteria.PaymentAuthorizationId*
:DueDate\	Input	Date	—	Binds \MyCriteria.DueDate*

Tables

Table	Access	Columns used
PAYMENT_AUTH_SESSION_TRANSFER	Read	DUE_DATE, PAYMENT_AUTHORIZATION_SEQ_NUM, SESSION_TRANSFER_SEQ_NUM

Sample SQL

Variant 1 — retrieve most recent session transfer for an authorization:

Select DUE_DATE as DueDate,
  PAYMENT_AUTHORIZATION_SEQ_NUM as PaymentAuthorizationId,
  SESSION_TRANSFER_SEQ_NUM as SessionTransferId
From PAYMENT_AUTH_SESSION_TRANSFER P
Where PAYMENT_AUTHORIZATION_SEQ_NUM = :PaymentAuthorizationId
  and SESSION_TRANSFER_SEQ_NUM = (
    select MAX(SESSION_TRANSFER_SEQ_NUM)
    from PAYMENT_AUTH_SESSION_TRANSFER
    where PAYMENT_AUTHORIZATION_SEQ_NUM = P.PAYMENT_AUTHORIZATION_SEQ_NUM
  )

Variant 2 — retrieve by authorization and due date:

Select DUE_DATE as DueDate,
  PAYMENT_AUTHORIZATION_SEQ_NUM as PaymentAuthorizationId,
  SESSION_TRANSFER_SEQ_NUM as SessionTransferId
From PAYMENT_AUTH_SESSION_TRANSFER P
Where PAYMENT_AUTHORIZATION_SEQ_NUM = :PaymentAuthorizationId
  and DUE_DATE = :DueDate

Operations and processes

• Payment detail and allocation*

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\clsPaymentAuthorizationSessionTransfer.vb