---
title: "SQL-030: Criteria"
summary: Update statement for Criteria.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-28
library: SAIF.Business.Claim.EAIP
reference_type: package
---

# SQL-030: Criteria

This statement supports `Criteria` by executing a Update operation through storedproc.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-030 |
| **Operation type** | Update |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | StoredProcedure |
| **Business object** | `Criteria` |
| **Criteria property** | `UpdateSQL` |
| **Lifecycle method** | `BeforeUpdate` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:PayPeriodID` | Input | Number | N/A | Binds PayPeriodID from active calling code or Oracle signature. |
| `:ExpenseID` | Input | Number | N/A | Binds ExpenseID from active calling code or Oracle signature. |
| `:EffectiveDate` | Input | Date | N/A | Binds EffectiveDate from active calling code or Oracle signature. |
| `:ExpirationDate` | Input | Date | N/A | Binds ExpirationDate from active calling code or Oracle signature. |
| `:RegularPayRate` | Input | String | N/A | Binds RegularPayRate from active calling code or Oracle signature. |
| `:OvertimePayRate` | Input | String | N/A | Binds OvertimePayRate from active calling code or Oracle signature. |
| `:OtherPayRate` | Input | String | N/A | Binds OtherPayRate from active calling code or Oracle signature. |
| `:RegularHours` | Input | Number | N/A | Binds RegularHours from active calling code or Oracle signature. |
| `:OvertimeHours` | Input | Number | N/A | Binds OvertimeHours from active calling code or Oracle signature. |
| `:OtherHours` | Input | Number | N/A | Binds OtherHours from active calling code or Oracle signature. |
| `:RegularPayAmount` | Input | Number | N/A | Binds RegularPayAmount from active calling code or Oracle signature. |
| `:OvertimePayAmount` | Input | Number | N/A | Binds OvertimePayAmount from active calling code or Oracle signature. |
| `:OtherPayAmount` | Input | Number | N/A | Binds OtherPayAmount from active calling code or Oracle signature. |
| `:GrossWageAmount` | Input | Number | N/A | Binds GrossWageAmount from active calling code or Oracle signature. |
| `:WorkerWageAmount` | Input | Number | N/A | Binds WorkerWageAmount from active calling code or Oracle signature. |
| `:UnitCode` | Input | String | N/A | Binds UnitCode from active calling code or Oracle signature. |
| `:PotentialUnitQuantity` | Input | String | N/A | Binds PotentialUnitQuantity from active calling code or Oracle signature. |
| `:AveragePayRate` | Input | String | N/A | Binds AveragePayRate from active calling code or Oracle signature. |
| `:ActualUnitQuantity` | Input | String | N/A | Binds ActualUnitQuantity from active calling code or Oracle signature. |
| `:PayPeriodDays` | Input | Number | N/A | Binds PayPeriodDays from active calling code or Oracle signature. |
| `:CreateUser` | Input | String | N/A | Binds CreateUser from active calling code or Oracle signature. |
| `:CreateDate` | Input | Date | N/A | Binds CreateDate from active calling code or Oracle signature. |
| `:UpdateUser` | Input | Date | N/A | Binds UpdateUser from active calling code or Oracle signature. |
| `:UpdateDate` | Input | Date | N/A | Binds UpdateDate from active calling code or Oracle signature. |
| `:UpdateNum` | Input | Date | N/A | Binds UpdateNum from active calling code or Oracle signature. |
| `:LastUpdateNum` | Input | Date | N/A | Binds LastUpdateNum from active calling code or Oracle signature. |
| `:PayPeriodID` | Input | Number | N/A | Binds PayPeriodID from active calling code or Oracle signature. |
| `:LastUpdateNum` | Input | Date | N/A | Binds LastUpdateNum from active calling code or Oracle signature. |
| `:recordset` | Output | REF CURSOR | N/A | Binds recordset from active calling code or Oracle signature. |
| `:ExpenseTypeCode` | Input | String | N/A | Binds ExpenseTypeCode from active calling code or Oracle signature. |
| `:recordset` | Output | REF CURSOR | N/A | Binds recordset from active calling code or Oracle signature. |
| `:ReimbursementID` | Input | Number | N/A | Binds ReimbursementID from active calling code or Oracle signature. |
| `:ExpenseTypeCode` | Input | String | N/A | Binds ExpenseTypeCode from active calling code or Oracle signature. |
| `:DisablingAmount` | Input | Number | N/A | Binds DisablingAmount from active calling code or Oracle signature. |
| `:NonDisablingAmount` | Input | Number | N/A | Binds NonDisablingAmount from active calling code or Oracle signature. |
| `:TotalAmount` | Input | Number | N/A | Binds TotalAmount from active calling code or Oracle signature. |
| `:CreateUser` | Input | String | N/A | Binds CreateUser from active calling code or Oracle signature. |
| `:CreateDate` | Input | Date | N/A | Binds CreateDate from active calling code or Oracle signature. |
| `:UpdateUser` | Input | Date | N/A | Binds UpdateUser from active calling code or Oracle signature. |
| `:UpdateDate` | Input | Date | N/A | Binds UpdateDate from active calling code or Oracle signature. |
| `:UpdateNum` | Input | Date | N/A | Binds UpdateNum from active calling code or Oracle signature. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| `EAIP_PAY_PERIOD*` | Update* | PayPeriodID, ExpenseID, EffectiveDate, ExpirationDate, RegularPayRate, OvertimePayRate, OtherPayRate, RegularHours, OvertimeHours, OtherHours, RegularPayAmount, OvertimePayAmount, OtherPayAmount, GrossWageAmount, WorkerWageAmount, UnitCode, PotentialUnitQuantity, AveragePayRate, ActualUnitQuantity, PayPeriodDays, CreateUser, CreateDate, UpdateUser, UpdateDate, UpdateNum, LastUpdateNum, PayPeriodID, LastUpdateNum, recordset, ExpenseTypeCode, recordset, ReimbursementID, ExpenseTypeCode, DisablingAmount, NonDisablingAmount, TotalAmount, CreateUser, CreateDate, UpdateUser, UpdateDate, UpdateNum* |

## Sample SQL

```sql

pk82500_eaip.eaip_pay_period_update(:PayPeriodID, :ExpenseID, :EffectiveDate, :ExpirationDate, :RegularPayRate, :OvertimePayRate, :OtherPayRate, :RegularHours, :OvertimeHours, :OtherHours, :RegularPayAmount, :OvertimePayAmount, :OtherPayAmount, :GrossWageAmount, :WorkerWageAmount, :UnitCode, :PotentialUnitQuantity, :AveragePayRate, :ActualUnitQuantity, :PayPeriodDays, :CreateUser, :CreateDate, :UpdateUser, :UpdateDate, :UpdateNum, :LastUpdateNum, :PayPeriodID, :LastUpdateNum, :recordset, :ExpenseTypeCode, :recordset, :ReimbursementID, :ExpenseTypeCode, :DisablingAmount, :NonDisablingAmount, :TotalAmount, :CreateUser, :CreateDate, :UpdateUser, :UpdateDate, :UpdateNum)

-- Procedure body resides in Oracle.

```

## Operations and processes

- [Criteria update](../operations/wage-subsidy-worksheet.md)

> **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.EAIP\Period\clsPayPeriod.vb`