---
title: "SQL-019: Pk82350 eft isauthorizedforeft"
summary: Pk82350 eft isauthorizedforeft.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business
reference_type: package
---

# SQL-019: Pk82350 eft isauthorizedforeft

This document describes `SQL-019`, the pk82350 eft isauthorizedforeft statement or call used by `SAIF.Business`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-019 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `WCIS_DBA` |
| **Command type** | StoredProcedure |
| **Business object** | `ClaimServices` |
| **Criteria property** | `N/A` |
| **Lifecycle method** | `worker/person EFT auth overloads` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:inclaimnum` | Input | String | 8 | Optional claim-number overload parameter. |`r`n| `:inclaimid` | Input | Decimal | N/A | Optional claim-ID overload parameter. |`r`n| `:inpersonid` | Input | Decimal | N/A | Person identifier used to search authorizations. |`r`n| `:incustomertypecode` | Input | Varchar2 | 5 | Customer type code. |`r`n| `:inauthtypecode` | Input | Varchar2 | 5 | Authorization type code. |`r`n| `:indate` | Input | Date | N/A | Effective date used by the package. |`r`n| `:inIncludePending` | Input | Varchar2 | 5 | `TRUE` to include pending authorizations. |`r`n| `:PARMOUT` | ReturnValue | Number | N/A | Returned authorization sequence number or default package code. |## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PAYMENT_AUTHORIZATION](../database-tables.md#payment-authorization) | SELECT | `CUSTOMER_SECOND_ID`, `CUSTOMER_TYPE_CODE`, `AUTHORIZATION_TYPE_CODE`, `AUTH_DATE`, `REVOKE_DATE`, `BANK_ACCOUNT_SEQ_NUM`, `PAYMENT_AUTHORIZATION_SEQ_NUM` |`r`n| [BANK_ACCOUNT](../database-tables.md#bank-account) | JOIN | `BANK_ACCOUNT_SEQ_NUM`, `BANK_ACCOUNT_STATUS_CODE`, `PRENOTE_REQUIRED_FLAG`, `PRENOTE_SUCCESS_DATE` |

## Sample SQL

```sql
pk82350_eft.isauthorizedforeft(:inclaimid|:inclaimnum, :inpersonid?, :inauthtypecode, :indate, :PARMOUT)
```

## 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-016: Pending-inclusive authorization checks bypass bank-account status and prenote gating.](../business-rules.md#proc-rule-016-pending-inclusive-authorization-checks-bypass-bank-account-status-and-prenote-gating)
- [PROC-RULE-017: Non-pending authorization checks require an active bank account and successful prenote when prenote is required.](../business-rules.md#proc-rule-017-non-pending-authorization-checks-require-an-active-bank-account-and-successful-prenote-when-prenote-is-required)
- [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)
- [PROC-RULE-019: Provider EFT authorization checks use the same pending-versus-active gating as person authorization checks.](../business-rules.md#proc-rule-019-provider-eft-authorization-checks-use-the-same-pending-versus-active-gating-as-person-authorization-checks)
- [PROC-RULE-020: Active-authorization counts honor the same pending and prenote rules as sequence lookups.](../business-rules.md#proc-rule-020-active-authorization-counts-honor-the-same-pending-and-prenote-rules-as-sequence-lookups)
- [PROC-RULE-021: Only non-terminated debit card enrollments count as active enrollments.](../business-rules.md#proc-rule-021-only-non-terminated-debit-card-enrollments-count-as-active-enrollments)

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