---
title: "SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST"
summary: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Provider.PaymentPreference
reference_type: package
---

# SQL-002: PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST

PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-002 |
| **Operation type** | Create |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `WCIS_DBA` |
| **Command type** | StoredProcedure |
| **Business object** | `clsProviderEFT` |
| **Criteria property** | `N/A — direct proc call` |
| **Lifecycle method** | `CreateHistory` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:in_PROVIDER_LOCATION_SEQ_NUM` | Input | PROVIDER_EFT_INTERFACE.PROVIDER_LOCATION_SEQ_NUM%TYPE | N/A | Provider location copied into history row. |
| `:in_PROVIDER_SEQ_NUM` | Input | PROVIDER_EFT_INTERFACE.PROVIDER_SEQ_NUM%TYPE | N/A | Provider identifier used for both history insert and TIN-address lookup. |
| `:in_EXT_USER_TYPE_SEQ_NUM` | Input | PROVIDER_EFT_INTERFACE.EXT_USER_TYPE_SEQ_NUM%TYPE | N/A | External user type copied into history row. |
| `:in_CORRESPONDENCE_DATE` | Input | PROVIDER_EFT_INTERFACE.UPDATE_DATE%TYPE | N/A | History correspondence date supplied by clsProviderEFT.UpdateDate. |
| `:in_EFF_DATE` | Input | PROVIDER_EFT_INTERFACE.EFF_DATE%TYPE | N/A | EFT effective date passed to FETCH_TIN_ADDRESS and inserted into history. |
| `:in_EXP_DATE` | Input | PROVIDER_EFT_INTERFACE.EXP_DATE%TYPE | N/A | EFT expiration date; caller forces DB null with ModifyParmValue when empty. |
| `:in_UPDATE_USER` | Input | PROVIDER_EFT_INTERFACE.UPDATE_USER%TYPE | N/A | User stored in PROVIDER_CORR_HIST.CREATE_USER. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PROVIDER_CORR_HIST](../database-tables.md#provider_corr_hist) | CREATE | See sample SQL. |
| [PROVIDER_TAX_ID](../database-tables.md#provider_tax_id) | CREATE | See sample SQL. |
| [PROVIDER](../database-tables.md#provider) | CREATE | See sample SQL. |
| [PROVIDER_EFT_INTERFACE](../database-tables.md#provider_eft_interface) | TYPE reference | See sample SQL. |

## Sample SQL

```sql
BEGIN
    PK83548_PROVIDER_CORR_HIST.EFT_CORR_HIST(
        in_PROVIDER_LOCATION_SEQ_NUM => :in_PROVIDER_LOCATION_SEQ_NUM,
        in_PROVIDER_SEQ_NUM => :in_PROVIDER_SEQ_NUM,
        in_EXT_USER_TYPE_SEQ_NUM => :in_EXT_USER_TYPE_SEQ_NUM,
        in_CORRESPONDENCE_DATE => :in_CORRESPONDENCE_DATE,
        in_EFF_DATE => :in_EFF_DATE,
        in_EXP_DATE => :in_EXP_DATE,
        in_UPDATE_USER => :in_UPDATE_USER
    );
END;
```

## Operations and processes
- [EFT correspondence history](../operations/eft-correspondence-history.md)

## Sources
- `Business\SAIF.Business.Provider.PaymentPreference\clsProviderEFT.vb`