SQL-006: Criteria¶

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

Classification¶

Field	Value
SQL ID	SQL-006
Operation type	Create
Execution method	Inline
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`Criteria`
Criteria property	`insertsql`
Lifecycle method	`Criteria create`

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	CREATE	See sample SQL.

Sample SQL¶

Insert into US_LOSS_SUMMARY ( US_LOSS_SUMMARY_SEQ_NUM, CLAIM_ID, US_POLICY_UNIT_SEQ_NUM, REPORT_VALUATION_NUM, REPORT_TYPE_CODE, ADJUSTMENT_SEQ_NUM, ADJUSTMENT_TYPE_CODE, NCCI_INJURY_CODE, INCURRED_MEDICAL_AMOUNT, INCURRED_INDEMNITY_AMOUNT, PAID_MEDICAL_AMOUNT, PAID_INDEMNITY_AMOUNT, REIMBURSEMENT_AMOUNT, UPDATE_USER, UPDATE_DATE, UPDATE_NUM ) Values ( :LossSummarySeqNum, :ClaimID, :PolicyUnitSeqNum, :ReportValuationNumber, :ReportTypeCode, :AdjustmentSeqNum, :AdjustmentTypeCode, :NCCIInjuryCode, :IncurredMedicalAmount, :IncurredIndemnityAmount, :PaidMedicalAmount, :PaidIndemnityAmount, :ReimbursementAmount, :UpdateUser, :UpdateDate, :UpdateNumber)

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