---
title: "SQL-031: Criteria"
summary: Update statement for Criteria.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.Bill
reference_type: package
---

# SQL-031: Criteria

This document records the SQL used by `Criteria` in `SAIF.Business.Claim.Bill`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-031 |
| **Operation type** | Update |
| **Execution method** | Inline |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `Criteria` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:BillID` | Input | Number | N/A | Binds BillID from active calling code or Oracle signature. |
| `:ClaimID` | Input | Number | N/A | Binds ClaimID from active calling code or Oracle signature. |
| `:ProviderLocSeqNum` | Input | Number | N/A | Binds ProviderLocSeqNum from active calling code or Oracle signature. |
| `:TaxIDDisplayDescr` | Input | Number | N/A | Binds TaxIDDisplayDescr from active calling code or Oracle signature. |
| `:ProviderTypeCode` | Input | Number | N/A | Binds ProviderTypeCode from active calling code or Oracle signature. |
| `:WorkerID` | Input | Number | N/A | Binds WorkerID from active calling code or Oracle signature. |
| `:PayeeTypeCode` | Input | String | N/A | Binds PayeeTypeCode from active calling code or Oracle signature. |
| `:TransactionAmt` | Input | Number | N/A | Binds TransactionAmt from active calling code or Oracle signature. |
| `:WorkerPayReasonCode` | Input | String | N/A | Binds WorkerPayReasonCode from active calling code or Oracle signature. |
| `:SpecialHandlingCode` | Input | String | N/A | Binds SpecialHandlingCode from active calling code or Oracle signature. |
| `:IssueDate` | Input | Date | N/A | Binds IssueDate from active calling code or Oracle signature. |
| `:TransactionFromDate` | Input | Date | N/A | Binds TransactionFromDate from active calling code or Oracle signature. |
| `:TransactionThruDate` | Input | Date | N/A | Binds TransactionThruDate from active calling code or Oracle signature. |
| `:ChargeableCostFlag` | Input | String | N/A | Binds ChargeableCostFlag from active calling code or Oracle signature. |
| `:McoFeeFlag` | Input | String | N/A | Binds McoFeeFlag from active calling code or Oracle signature. |
| `:BillPaymentCategoryCode` | Input | String | N/A | Binds BillPaymentCategoryCode from active calling code or Oracle signature. |
| `:FederalDataFlag` | Input | String | N/A | Binds FederalDataFlag from active calling code or Oracle signature. |
| `:ApproverUser` | Input | String | N/A | Binds ApproverUser from active calling code or Oracle signature. |
| `:InitiatorUser` | Input | String | N/A | Binds InitiatorUser from active calling code or Oracle signature. |
| `:ProcessCode` | Input | String | N/A | Binds ProcessCode from active calling code or Oracle signature. |
| `:PrintEobFlag` | Input | String | N/A | Binds PrintEobFlag from active calling code or Oracle signature. |
| `:EbillFlag` | Input | String | N/A | Binds EbillFlag from active calling code or Oracle signature. |
| `:ProcessDate` | Input | Date | N/A | Binds ProcessDate from active calling code or Oracle signature. |
| `:MessageText` | Input | String | N/A | Binds MessageText from active calling code or Oracle signature. |
| `:UpdateUser` | Input | Date | N/A | Binds UpdateUser from active calling code or Oracle signature. |
| `:BillPaymentSeqNum` | Input | Number | N/A | Binds BillPaymentSeqNum from active calling code or Oracle signature. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [CBP_BILL_PAYMENT_REQUEST](../database-tables.md#cbp_bill_payment_request) | UPDATE | A, APPROVER_USER, B, BILL_ID, BILL_PAYMENT_CATEGORY_CODE, BILL_PAYMENT_SEQ_NUM, C, CBP_BILL_PAYMENT_REQUEST, CHARGEABLE_COST_FLAG, CLAIM_ID, D, E |

## Sample SQL

```sql
Update CBP_BILL_PAYMENT_REQUEST 
SET BILL_ID = :BillID, CLAIM_ID = :ClaimID, PROVIDER_LOC_SEQ_NUM = :ProviderLocSeqNum, TAX_ID_DISPLAY_DESCR = :TaxIDDisplayDescr, PROVIDER_TYPE_CODE = :ProviderTypeCode, WORKER_ID = :WorkerID, PAYEE_TYPE_CODE = :PayeeTypeCode, TRANSACTION_AMT = :TransactionAmt, WORKER_PAY_REASON_CODE = :WorkerPayReasonCode, SPECIAL_HANDLING_CODE = :SpecialHandlingCode, ISSUE_DATE = :IssueDate, TRANSACTION_FROM_DATE = :TransactionFromDate, TRANSACTION_THRU_DATE = :TransactionThruDate, CHARGEABLE_COST_FLAG = :ChargeableCostFlag, MCO_FEE_FLAG = :McoFeeFlag, BILL_PAYMENT_CATEGORY_CODE = :BillPaymentCategoryCode, FEDERAL_DATA_FLAG = :FederalDataFlag, APPROVER_USER = :ApproverUser, INITIATOR_USER = :InitiatorUser, PROCESS_CODE = :ProcessCode, PRINT_EOB_FLAG = :PrintEobFlag, EBILL_FLAG = :EbillFlag, PROCESS_DATE = :ProcessDate, UPDATE_DATE = SYSDATE, UPDATE_NUM = UPDATE_NUM + 1, MESSAGE_TEXT = :MessageText, UPDATE_USER = :UpdateUser 
WHERE CBP_BILL_PAYMENT_REQUEST.BILL_PAYMENT_SEQ_NUM = :BillPaymentSeqNum
```

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- `Business\SAIF.Business.Claim.Bill\clsCBPBillPaymentRequest.vb`