SQL-020: Pk82350 eft isbeneficiaryauthforeft

This Oracle function checks whether a beneficiary has an effective, unreversed EFT authorization backed by an active bank account and returns the matching authorization sequence number.

Classification

Field	Value
SQL ID	SQL-020
Operation type	Read
Execution method	Stored procedure
Database	Oracle
Schema	WCIS_DBA
Command type	StoredProcedure
Business object	ClaimServices
Criteria property	N/A
Lifecycle method	HasActiveBeneEFTAuth

Parameters

Parameter	Direction	Type	Max length	Description
:inbeneid	Input	Number	N/A	Beneficiary identifier used to search payment authorizations.
:inauthtypecode	Input	Varchar2	5	EFT authorization type code passed from ClaimServices (CLDD).
:PARMOUT	ReturnValue	Number	N/A	Returned payment authorization sequence number, or the package default when no row matches.

Tables

Table	Access	Columns used
PAYMENT_AUTHORIZATION	SELECT	CUSTOMER_SECOND_ID, AUTHORIZATION_TYPE_CODE, AUTH_DATE, REVOKE_DATE, BANK_ACCOUNT_SEQ_NUM, PAYMENT_AUTHORIZATION_SEQ_NUM
BANK_ACCOUNT	JOIN	BANK_ACCOUNT_SEQ_NUM, BANK_ACCOUNT_STATUS_CODE

Sample SQL

-- ClaimServices.HasActiveBeneEFTAuth
BEGIN
  :PARMOUT := pk82350_eft.isbeneficiaryauthforeft(
    :inbeneid,
    :inauthtypecode
  );
END;

Operations and processes

• Claim authorization and visibility checks
• EFT authorization support

Business rules

• PROC-RULE-018: Beneficiary EFT authorizations must be effective, unreversed, and backed by an active bank account.

Sources

• Business\SAIF.Business\ClaimServices.vb