SQL-106: clsSecTimelossCalculation

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

Classification

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

Parameters

Parameter	Direction	Type	Max length	Description
:ClaimID	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:FridayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:MondayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:PaidWeekQuantity	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:SaturdayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:SecondaryEmployerName	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:SundayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:ThursdayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:TimelossCalculationSubNum	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:TotalPaidAmount	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:TuesdayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:WageAmount	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:WageEntryStatusTypeCode	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:WagePeriodPayUnitCode	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:WednesdayOffFlag	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:CalculationNoteText	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:EarningsFrequencyCode	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:WageCalculationMethodCode	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:WCDNum	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:UpdateNum	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.
:UpdateUser	Input	Unknown	—	Passed from clsSecTimelossCalculation via BeforeUpdate.

Tables

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

Sample SQL

Update CL_SEC_TIMELOSS_CALCULATION
SET
    CALCULATION_NOTE_TEXT = :CalculationNoteText,
    CLAIM_ID = :ClaimID,
    EARNINGS_FREQUENCY_CODE = :EarningsFrequencyCode,
    FRIDAY_OFF_FLAG = :FridayOffFlag,
    MONDAY_OFF_FLAG = :MondayOffFlag,
    PAID_WEEK_QUANTITY = :PaidWeekQuantity,
    SATURDAY_OFF_FLAG = :SaturdayOffFlag,
    SECONDARY_EMPLOYER_NAME = :SecondaryEmployerName,
    SUNDAY_OFF_FLAG = :SundayOffFlag,
    THURSDAY_OFF_FLAG = :ThursdayOffFlag,
    TIMELOSS_CALCULATION_SUB_NUM = :TimelossCalculationSubNum,
    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,
    WEDNESDAY_OFF_FLAG = :WednesdayOffFlag,
    WCD_NUM = :WCDNum
WHERE
    CL_SEC_TIMELOSS_CALCULATION.CLAIM_ID = :ClaimID AND
    CL_SEC_TIMELOSS_CALCULATION.TIMELOSS_CALCULATION_SUB_NUM = :TimelossCalculationSubNum AND
    CL_SEC_TIMELOSS_CALCULATION.UPDATE_NUM = :UpdateNum

Operations and processes

• clsSecTimelossCalculation BeforeUpdate

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

Sources

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