---
title: "SQL-013: clsProviderEOB"
summary: Update statement for clsProviderEOB.
status: draft
owner: SAIF
last_reviewed: 2026-07-24
library: SAIF.Business.Provider.PaymentPreference
reference_type: package
---

# SQL-013: clsProviderEOB

UPDATE PROVIDER_EOB_INTERFACE.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-013 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | Unqualified in SQL text |
| **Command type** | Text |
| **Business object** | `clsProviderEOB` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:ProviderSeqNum` | Input | Decimal | N/A | Provider key in both SET and WHERE. |
| `:ProviderLocationSeqNum` | Input | Decimal | N/A | Provider-location key in both SET and WHERE. |
| `:ExtUserTypeSeqNum` | Input | clsSmartDecimal | N/A | External user type. |
| `:PaperlessEOBFlag` | Input | String | 5 | Current paperless preference. |
| `:DefaultPrimaryFlag` | Input | String | 5 | Current default-to-primary preference. |
| `:UpdateDate` | Input | Date | N/A | Audit timestamp. |
| `:UpdateUser` | Input | String | 30 | Audit user. |
| `:UpdateNum` | Input | Decimal | N/A | Optimistic-concurrency token required by WHERE UPDATE_NUM = :UpdateNum. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PROVIDER_EOB_INTERFACE](../database-tables.md#provider_eob_interface) | UPDATE | See sample SQL. |

## Sample SQL

```sql
UPDATE PROVIDER_EOB_INTERFACE
SET PROVIDER_SEQ_NUM = :ProviderSeqNum,
    PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum,
    EXT_USER_TYPE_SEQ_NUM = :ExtUserTypeSeqNum,
    PAPERLESS_EOB_FLAG = :PaperlessEOBFlag,
    DEFAULT_TO_PRIMARY_FLAG = :DefaultPrimaryFlag,
    UPDATE_DATE = :UpdateDate,
    UPDATE_NUM = UPDATE_NUM + 1,
    UPDATE_USER = :UpdateUser
WHERE PROVIDER_EOB_INTERFACE.PROVIDER_SEQ_NUM = :ProviderSeqNum
  AND PROVIDER_EOB_INTERFACE.PROVIDER_LOCATION_SEQ_NUM = :ProviderLocationSeqNum
  AND UPDATE_NUM = :UpdateNum
```

## Operations and processes
- [EOB preference management](../operations/eob-preference-management.md)

## Business rules
- [BR-04: EOB updates enforce optimistic concurrency.](../business-rules.md#br-04-update-contention-check-if-rowsaffected-1-after-update-dbcontentionerror-is-added-updatenum-must-match-for-the-where-clause-to-succeed)

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