SQL-021: Criteria

This SQL artifact supports Criteria by executing a update operation through Inline.

Classification

Field	Value
SQL ID	SQL-021
Operation type	Update
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	Criteria
Criteria property	updatesql
Lifecycle method	Criteria update

Parameters

Parameter	Direction	Type	Max length	Description
:LossSummarySeqNum	Input	Number	N/A	Source value LossSummarySeqNum
:ClaimID	Input	Number	N/A	Source value ClaimID
:PolicyUnitSeqNum	Input	Number	N/A	Source value PolicyUnitSeqNum
:ReportValuationNumber	Input	Number	N/A	Source value ReportValuationNumber
:ReportTypeCode	Input	String	5	Source value ReportTypeCode
:AdjustmentSeqNum	Input	Number	N/A	Source value AdjustmentSeqNum
:AdjustmentTypeCode	Input	String	5	Source value m_AdjustmentType
:NCCIInjuryCode	Input	String	5	Source value m_NCCIInjuryCode
:IncurredMedicalAmount	Input	Number	N/A	Source value TotalIncurredMedicalAmount
:IncurredIndemnityAmount	Input	Number	N/A	Source value TotalIncurredIndemnityAmount
:PaidMedicalAmount	Input	Number	N/A	Source value TotalPaidMedicalAmount
:PaidIndemnityAmount	Input	Number	N/A	Source value TotalPaidIndemnityAmount
:ReimbursementAmount	Input	Number	N/A	Source value ReimbursementAmount
:UpdateUser	Input	Date	30	Source value UpdateUser
:UpdateDate	Input	Date	N/A	Source value UpdateDate
:UpdateNumber	Input	Date	N/A	Source value UpdateNumber

Tables

Table	Access	Columns used
US_LOSS_SUMMARY	UPDATE	See sample SQL.

Sample SQL

Update US_LOSS_SUMMARY Set US_LOSS_SUMMARY_SEQ_NUM = :LossSummarySeqNum, CLAIM_ID = :ClaimID, US_POLICY_UNIT_SEQ_NUM = :PolicyUnitSeqNum, REPORT_VALUATION_NUM = :ReportValuationNumber, REPORT_TYPE_CODE = :ReportTypeCode, ADJUSTMENT_SEQ_NUM = :AdjustmentSeqNum, ADJUSTMENT_TYPE_CODE = :AdjustmentTypeCode, NCCI_INJURY_CODE = :NCCIInjuryCode, INCURRED_MEDICAL_AMOUNT = :IncurredMedicalAmount, INCURRED_INDEMNITY_AMOUNT = :IncurredIndemnityAmount, PAID_MEDICAL_AMOUNT = :PaidMedicalAmount, PAID_INDEMNITY_AMOUNT = :PaidIndemnityAmount, REIMBURSEMENT_AMOUNT = :ReimbursementAmount, UPDATE_USER = :UpdateUser, UPDATE_DATE = :UpdateDate, UPDATE_NUM = :UpdateNumber Where US_LOSS_SUMMARY.US_LOSS_SUMMARY_SEQ_NUM = :LossSummarySeqNum

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.UnitStat.Claim\Loss Summary\clsLossSummary.vb