SQL-100: clsClaimTimelossCalculation

This statement supports clsClaimTimelossCalculation by executing a Update operation through inline.

Classification

Field	Value
SQL ID	SQL-100
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	clsClaimTimelossCalculation
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:AuditReviewerUser	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:AverageWageFlagCode	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:FridayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:MondayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:PaidWeekQuantity	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:SaturdayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:StatutoryWeeklyWageAmount	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:SundayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:ThursdayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:TotalPaidAmount	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:TuesdayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WageAmount	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WageEntryStatusTypeCode	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WagePeriodPayUnitCode	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WednesdayOffFlag	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WorkShiftHoursNum	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:CalculationNoteText	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:EarningsFrequencyCode	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:LegalOrderDate	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WageCalculationMethodCode	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:WageTypeCode	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:UpdateUser	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:FinalizedWageUser	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:FinalizedWageDate	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:ClaimID	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:TimelossCalculationSubNum	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.
:UpdateNum	Input	Unknown	—	Passed from clsClaimTimelossCalculation via BeforeUpdate.

Tables

Table	Access	Columns used
CL_CLAIM_TIMELOSS_CALCULATION	Update	Not enumerated directly in the stage findings.**

Sample SQL

Update CL_CLAIM_TIMELOSS_CALCULATION
SET
    AUDIT_REVIEWER_USER = :AuditReviewerUser,
    AVERAGE_WAGE_FLAG_CODE = :AverageWageFlagCode,
    CALCULATION_NOTE_TEXT = :CalculationNoteText,
    EARNINGS_FREQUENCY_CODE = :EarningsFrequencyCode,
    FRIDAY_OFF_FLAG = :FridayOffFlag,
    LEGAL_ORDER_DATE = :LegalOrderDate,
    MONDAY_OFF_FLAG = :MondayOffFlag,
    PAID_WEEK_QUANTITY = :PaidWeekQuantity,
    SATURDAY_OFF_FLAG = :SaturdayOffFlag,
    STATUTORY_WEEKLY_WAGE_AMOUNT = :StatutoryWeeklyWageAmount,
    SUNDAY_OFF_FLAG = :SundayOffFlag,
    THURSDAY_OFF_FLAG = :ThursdayOffFlag,
    TOTAL_PAID_AMOUNT = :TotalPaidAmount,
    TUESDAY_OFF_FLAG = :TuesdayOffFlag,
    UPDATE_DATE = SYSDATE,
    UPDATE_NUM = Update_Num + 1,
    UPDATE_USER = :UpdateUser,
    WAGE_AMOUNT = :WageAmount,
    WAGE_CALCULATION_METHOD_CODE = :WageCalculationMethodCode,
    WAGE_ENTRY_STATUS_TYPE_CODE = :WageEntryStatusTypeCode,
    WAGE_PERIOD_PAY_UNIT_CODE = :WagePeriodPayUnitCode,
    WAGE_TYPE_CODE = :WageTypeCode,
    WEDNESDAY_OFF_FLAG = :WednesdayOffFlag,
    WORK_SHIFT_HOURS_NUM = :WorkShiftHoursNum,
    FINALIZED_WAGE_USER = :FinalizedWageUser,
    FINALIZED_WAGE_DATE = :FinalizedWageDate
WHERE
    CL_CLAIM_TIMELOSS_CALCULATION.CLAIM_ID = :ClaimID AND
    CL_CLAIM_TIMELOSS_CALCULATION.TIMELOSS_CALCULATION_SUB_NUM = :TimelossCalculationSubNum AND
    CL_CLAIM_TIMELOSS_CALCULATION.UPDATE_NUM = :UpdateNum

Operations and processes

• clsClaimTimelossCalculation BeforeUpdate

Note: Statements marked with ** could not be confirmed; treat them as unknown until verified.

Sources

• Business/SAIF.Business.Claim.Payment/Wage and Job/clsClaimTimelossCalculation.vb