SQL-025: clsSecTimelossCalculation¶

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

Classification¶

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

Parameters¶

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

Tables¶

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

Sample SQL¶

Insert into CL_SEC_TIMELOSS_CALCULATION (
    CALCULATION_NOTE_TEXT,
    CLAIM_ID,
    EARNINGS_FREQUENCY_CODE,
    FRIDAY_OFF_FLAG,
    MONDAY_OFF_FLAG,
    PAID_WEEK_QUANTITY,
    SATURDAY_OFF_FLAG,
    SECONDARY_EMPLOYER_NAME,
    SUNDAY_OFF_FLAG,
    THURSDAY_OFF_FLAG,
    TIMELOSS_CALCULATION_SUB_NUM,
    TOTAL_PAID_AMOUNT,
    TUESDAY_OFF_FLAG,
    UPDATE_DATE,
    UPDATE_NUM,
    UPDATE_USER,
    WAGE_AMOUNT,
    WAGE_CALCULATION_METHOD_CODE,
    WAGE_ENTRY_STATUS_TYPE_CODE,
    WAGE_PERIOD_PAY_UNIT_CODE,
    WEDNESDAY_OFF_FLAG,
    WCD_Num
) VALUES (
    :CalculationNoteText,
    :ClaimID,
    :EarningsFrequencyCode,
    :FridayOffFlag,
    :MondayOffFlag,
    :PaidWeekQuantity,
    :SaturdayOffFlag,
    :SecondaryEmployerName,
    :SundayOffFlag,
    :ThursdayOffFlag,
    :TimelossCalculationSubNum,
    :TotalPaidAmount,
    :TuesdayOffFlag,
    SYSDATE,
    0,
    :UpdateUser,
    :WageAmount,
    :WageCalculationMethodCode,
    :WageEntryStatusTypeCode,
    :WagePeriodPayUnitCode,
    :WednesdayOffFlag,
    :WCDNum
)

Operations and processes¶

clsSecTimelossCalculation BeforeInsert

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