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¶

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

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