SQL-076: clsSessionTransfer retrieve (3 variants)¶

Retrieves a session transfer record from SESSION_TRANSFER. Supports three look-up approaches.

Classification¶

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

Parameters¶

Parameter	Direction	Type	Max length	Description
:SeqNum\	Input	Decimal	—	Binds \MyCriteria.SeqNum*

Tables¶

Table	Access	Columns used
SESSION_TRANSFER	Read	All columns
PAYMENT_AUTH_SESSION_TRANSFER	Read (join, Variant 3)	AUTOPAY_AUTHORIZATION_SEQ_NUM, AUTOPAY_DATE, SESSION_TRANSFER_SEQ_NUM

Sample SQL¶

Variant 1 — by session transfer sequence number:

Select SESSION_TRANSFER.SESSION_TRANSFER_SEQ_NUM as SessionTransferSeqNum,
  SESSION_TRANSFER.POLICY_NUM as PolicyNum,
  SESSION_TRANSFER.US_BANK_USER_SEQ_NUM as USBankUserSeqNum,
  SESSION_TRANSFER.PAYMENT_DETAIL_SEQ_NUM as PaymentDetailSeqNum
From SESSION_TRANSFER
Where SESSION_TRANSFER.SESSION_TRANSFER_SEQ_NUM = :SeqNum

Variant 2 — by payment detail sequence number:

Select SESSION_TRANSFER.SESSION_TRANSFER_SEQ_NUM as SessionTransferSeqNum,
  SESSION_TRANSFER.POLICY_NUM as PolicyNum,
  SESSION_TRANSFER.US_BANK_USER_SEQ_NUM as USBankUserSeqNum,
  SESSION_TRANSFER.PAYMENT_DETAIL_SEQ_NUM as PaymentDetailSeqNum
From SESSION_TRANSFER
Where SESSION_TRANSFER.PAYMENT_DETAIL_SEQ_NUM = :SeqNum

Variant 3 — by auto-pay authorization and date:

Select SESSION_TRANSFER.SESSION_TRANSFER_SEQ_NUM as SessionTransferSeqNum,
  SESSION_TRANSFER.POLICY_NUM as PolicyNum,
  SESSION_TRANSFER.US_BANK_USER_SEQ_NUM as USBankUserSeqNum,
  SESSION_TRANSFER.PAYMENT_DETAIL_SEQ_NUM as PaymentDetailSeqNum
From PAYMENT_AUTH_SESSION_TRANSFER
  JOIN SESSION_TRANSFER
    on PAYMENT_AUTH_SESSION_TRANSFER.SESSION_TRANSFER_SEQ_NUM = SESSION_TRANSFER.SESSION_TRANSFER_SEQ_NUM
WHERE PAYMENT_AUTH_SESSION_TRANSFER.AUTOPAY_AUTHORIZATION_SEQ_NUM = :inAuthorizationSeqNum
  AND PAYMENT_AUTH_SESSION_TRANSFER.AUTOPAY_DATE = :inDate

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