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¶

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

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