---
title: "SQL-031: 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-031: Criteria

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

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-031 |
| **Operation type** | Update |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **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. |
| `:TimeCardDate` | Input | Date | N/A | Binds TimeCardDate from active calling code or Oracle signature. |
| `:IsDayIncluded` | Input | String | N/A | Binds IsDayIncluded from active calling code or Oracle signature. |
| `:TimeOneIn` | Input | String | N/A | Binds TimeOneIn from active calling code or Oracle signature. |
| `:TimeOneOut` | Input | String | N/A | Binds TimeOneOut from active calling code or Oracle signature. |
| `:TimeTwoIn` | Input | String | N/A | Binds TimeTwoIn from active calling code or Oracle signature. |
| `:TimeTwoOut` | Input | String | N/A | Binds TimeTwoOut from active calling code or Oracle signature. |
| `:ReportedHours` | Input | Number | N/A | Binds ReportedHours from active calling code or Oracle signature. |
| `:ReportedMinutes` | Input | String | N/A | Binds ReportedMinutes from active calling code or Oracle signature. |
| `:CalculatedHours` | Input | Number | N/A | Binds CalculatedHours 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. |
| `: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. |
| `:TimeCardID` | Input | Number | N/A | Binds TimeCardID from active calling code or Oracle signature. |
| `:LastUpdateNum` | Input | Date | N/A | Binds LastUpdateNum from active calling code or Oracle signature. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| `EAIP_PERIOD_TIMECARD` | Update | EAIP_PAY_PERIOD_SEQ_NUM, TIMECARD_DATE, DAY_INCLUDED_FLAG, IN1_DATE, OUT1_DATE, IN2_DATE, OUT2_DATE, REPORTED_HOURS, REPORTED_MINUTES, CALCULATED_HOURS, REGULAR_PAY_RATE, OVERTIME_PAY_RATE, OTHER_PAY_RATE, REGULAR_HOURS, OVERTIME_HOURS, OTHER_HOURS, REGULAR_PAY_AMOUNT, OVERTIME_PAY_AMOUNT, OTHER_PAY_AMOUNT, GROSS_WAGE_AMOUNT, CREATE_USER, CREATE_DATE, UPDATE_USER, UPDATE_DATE, UPDATE_NUM, EAIP_PERIOD_TIMECARD_SEQ_NUM |

## Sample SQL

```sql
UPDATE eaip_period_timecard
SET
    eaip_pay_period_seq_num          = :PayPeriodID,
    timecard_date                    = :TimeCardDate,
    day_included_flag                = :IsDayIncluded,
    in1_date                         = :TimeOneIn,
    out1_date                        = :TimeOneOut,
    in2_date                         = :TimeTwoIn,
    out2_date                        = :TimeTwoOut,
    reported_hours                   = :ReportedHours,
    reported_minutes                 = :ReportedMinutes,
    calculated_hours                 = :CalculatedHours,
    regular_pay_rate                 = :RegularPayRate,
    overtime_pay_rate                = :OvertimePayRate,
    other_pay_rate                   = :OtherPayRate,
    regular_hours                    = :RegularHours,
    overtime_hours                   = :OvertimeHours,
    other_hours                      = :OtherHours,
    regular_pay_amount               = :RegularPayAmount,
    overtime_pay_amount              = :OvertimePayAmount,
    other_pay_amount                 = :OtherPayAmount,
    gross_wage_amount                = :GrossWageAmount,
    create_user                      = :CreateUser,
    create_date                      = :CreateDate,
    update_user                      = :UpdateUser,
    update_date                      = :UpdateDate,
    update_num                       = :UpdateNum
WHERE
    eaip_period_timecard_seq_num     = :TimeCardID AND
    update_num                       = :LastUpdateNum
```

## 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\clsPayPeriodTimeCard.vb`