SQL-018: clsClaimTimelossCalculation

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

Classification

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

Parameters

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

Tables

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

Sample SQL

Insert into CL_CLAIM_TIMELOSS_CALCULATION (
    AUDIT_REVIEWER_USER,
    AVERAGE_WAGE_FLAG_CODE,
    CALCULATION_NOTE_TEXT,
    CLAIM_ID,
    EARNINGS_FREQUENCY_CODE,
    FRIDAY_OFF_FLAG,
    LEGAL_ORDER_DATE,
    MONDAY_OFF_FLAG,
    PAID_WEEK_QUANTITY,
    SATURDAY_OFF_FLAG,
    STATUTORY_WEEKLY_WAGE_AMOUNT,
    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,
    WAGE_TYPE_CODE,
    WEDNESDAY_OFF_FLAG,
    WORK_SHIFT_HOURS_NUM,
    FINALIZED_WAGE_USER,
    FINALIZED_WAGE_DATE
) VALUES (
    :AuditReviewerUser,
    :AverageWageFlagCode,
    :CalculationNoteText,
    :ClaimID,
    :EarningsFrequencyCode,
    :FridayOffFlag,
    :LegalOrderDate,
    :MondayOffFlag,
    :PaidWeekQuantity,
    :SaturdayOffFlag,
    :StatutoryWeeklyWageAmount,
    :SundayOffFlag,
    :ThursdayOffFlag,
    :TimelossCalculationSubNum,
    :TotalPaidAmount,
    :TuesdayOffFlag,
    SYSDATE,
    0,
    :UpdateUser,
    :WageAmount,
    :WageCalculationMethodCode,
    :WageEntryStatusTypeCode,
    :WagePeriodPayUnitCode,
    :WageTypeCode,
    :WednesdayOffFlag,
    :WorkShiftHoursNum,
    :FinalizedWageUser,
    :FinalizedWageDate
)

Operations and processes

• clsClaimTimelossCalculation BeforeInsert

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