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

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

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-011 |
| **Operation type** | Create |
| **Execution method** | Inline SQL |
| **Database** | Oracle |
| **Schema** | [unqualified]** |
| **Command type** | Text |
| **Business object** | `Criteria` |
| **Criteria property** | `InsertSQL` |
| **Lifecycle method** | `BeforeInsert` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:TimeCardID` | Input | Number | N/A | Binds TimeCardID from active calling code or Oracle signature. |
| `: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. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| `EAIP_PERIOD_TIMECARD` | Create | eaip_period_timecard_seq_num, 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 |

## Sample SQL

```sql
INSERT   INTO   eaip_period_timecard (
    eaip_period_timecard_seq_num,
    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
) VALUES (
    :TimeCardID,
    :PayPeriodID,
    :TimeCardDate,
    :IsDayIncluded,
    :TimeOneIn,
    :TimeOneOut,
    :TimeTwoIn,
    :TimeTwoOut,
    :ReportedHours,
    :ReportedMinutes,
    :CalculatedHours,
    :RegularPayRate,
    :OvertimePayRate,
    :OtherPayRate,
    :RegularHours,
    :OvertimeHours,
    :OtherHours,
    :RegularPayAmount,
    :OvertimePayAmount,
    :OtherPayAmount,
    :GrossWageAmount,
    :CreateUser,
    :CreateDate,
    :UpdateUser,
    :UpdateDate,
    :UpdateNum
)
```

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