---
title: "SQL-020: Pk82350 eft isbeneficiaryauthforeft"
summary: Returns the beneficiary EFT authorization sequence when an active authorization exists.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# 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](../database-tables.md#payment-authorization) | SELECT | `CUSTOMER_SECOND_ID`, `AUTHORIZATION_TYPE_CODE`, `AUTH_DATE`, `REVOKE_DATE`, `BANK_ACCOUNT_SEQ_NUM`, `PAYMENT_AUTHORIZATION_SEQ_NUM` |
| [BANK_ACCOUNT](../database-tables.md#bank-account) | JOIN | `BANK_ACCOUNT_SEQ_NUM`, `BANK_ACCOUNT_STATUS_CODE` |

## Sample SQL

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

## Operations and processes
- [Claim authorization and visibility checks](../operations/claim-information-and-authorization-support.md)
- [EFT authorization support](../operations/eft-authorization-support.md)

## Business rules
- [PROC-RULE-018: Beneficiary EFT authorizations must be effective, unreversed, and backed by an active bank account.](../business-rules.md#proc-rule-018-beneficiary-eft-authorizations-must-be-effective-unreversed-and-backed-by-an-active-bank-account)

## Sources
- `Business\SAIF.Business\ClaimServices.vb`