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

# SQL-010: Criteria

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

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-010 |
| **Operation type** | Create |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | StoredProcedure |
| **Business object** | `Criteria` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert` |

## 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. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| `EAIP_PAY_PERIOD*` | Create* | 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* |

## Sample SQL

```sql

pk82500_eaip.eaip_pay_period_insert(: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)

-- Procedure body resides in Oracle.

```

## Operations and processes

- [Criteria create](../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`