SQL-038: Insert prior coverage¶

Insert prior coverage in the context of clsPriorCoverage.

Classification¶

Field	Value
SQL ID	SQL-038
Operation type	Insert
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsPriorCoverage`
Criteria property	`InsertSQL`
Lifecycle method	`BeforeInsert / AfterInsert`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	bound from `PolicyNumber`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 555)
`:EffectiveDate`	Input	bound from `EffectiveDate`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 556)
`:ExpirationDate`	Input	bound from `m_ExpirationDate`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 559)
`:CarrierCode`	Input	bound from `CarrierCode`	5	Bound in `clsPriorCoverage.BeforeInsert` (line 557)
`:PriorPolicyNumber`	Input	bound from `m_PriorPolicyNumber`	20	Bound in `clsPriorCoverage.BeforeInsert` (line 560)
`:ERModRate`	Input	bound from `m_ERModRate`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 561)
`:AnnualPremiumAmount`	Input	bound from `m_AnnualPremiumAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 562)
`:AnnualPayrollAmount`	Input	bound from `m_AnnualPayrollAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 563)
`:DisablingClaimsAmount`	Input	bound from `m_DisablingClaimsAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 564)
`:NonDisablingClaimsAmount`	Input	bound from `m_NonDisablingClaimsAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 565)
`:ClaimsAmount`	Input	bound from `m_ClaimsAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 566)
`:DisablingClaimsCount`	Input	bound from `m_DisablingClaimsCount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 567)
`:NonDisablingClaimsCount`	Input	bound from `m_NonDisablingClaimsCount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 568)
`:ClaimsCount`	Input	bound from `m_ClaimsCount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 569)
`:LossRatio`	Input	bound from `m_LossRatio`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 570)
`:ClaimFrequency`	Input	bound from `m_ClaimFrequency`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 571)
`:ClaimValueDate`	Input	bound from `m_ClaimValueDate`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 572)
`:CreateDate`	Input	bound from `m_CreateDate`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 573)
`:CreateUser`	Input	bound from `m_CreateUser`	30	Bound in `clsPriorCoverage.BeforeInsert` (line 574)
`:UpdateDate`	Input	bound from `m_UpdateDate`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 575)
`:UpdateUser`	Input	bound from `m_UpdateUser`	30	Bound in `clsPriorCoverage.BeforeInsert` (line 576)
`:SourceCode`	Input	bound from `m_SourceCode`	5	Bound in `clsPriorCoverage.BeforeInsert` (line 577)
`:PricingIncludeFlag`	Input	bound from `PricingIncludeFlag`	1	Bound in `clsPriorCoverage.BeforeInsert` (line 558)
`:AdjustedClaimsAmount`	Input	bound from `m_AdjustedClaimsAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 578)
`:NonDisablingPaidAmount`	Input	bound from `m_NonDisablingPaidAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 579)
`:DisablingPaidAmount`	Input	bound from `m_DisablingPaidAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 580)
`:NonDisablingReimburseAmount`	Input	bound from `m_NonDisablingReimburseAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 581)
`:TimeLossDaysCount`	Input	bound from `m_TimeLossDaysCount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 582)
`:StandardPremiumAmount`	Input	bound from `m_StandardPremiumAmount`	-	Bound in `clsPriorCoverage.BeforeInsert` (line 583)

Tables¶

Table	Access	Columns used
PRIOR_COVERAGE	INSERT	See sample SQL

Sample SQL¶

INSERT INTO
  PRIOR_COVERAGE
  (
    POLICY_NUM,
    PRIOR_COV_EFF_DATE,
    PRIOR_COV_EXP_DATE,
    CARRIER_CODE,
    PRIOR_POLICY_NUMBER,
    EMOD_RATE,
    ANNUAL_PREMIUM_AMT,
    ANNUAL_PAYROLL_AMT,
    DISABLING_CLAIMS_AMT,
    NON_DISABLING_CLAIMS_AMT,
    CLAIMS_AMT,
    DISABLING_CLAIMS_COUNT,
    NON_DISABLING_CLAIMS_COUNT,
    CLAIMS_COUNT,
    LOSS_RATIO,
    CLAIM_FREQUENCY,
    CLAIM_VALUE_DATE,
    CREATE_DATE,
    CREATE_USER,
    UPDATE_DATE,
    UPDATE_USER,
    PRIOR_COV_SOURCE_CODE,
    PRICING_INCLUDE_FLAG,
    ADJUSTED_CLAIMS_AMT,
    NON_DISABLING_PAID_AMT,
    DISABLING_PAID_AMT,
    NON_DISABLING_REIMBURSE_AMT,
    TIME_LOSS_DAYS_COUNT,
    STANDARD_PREMIUM_AMT
  )
VALUES
  (
    :PolicyNumber,
    :EffectiveDate,
    :ExpirationDate,
    :CarrierCode,
    :PriorPolicyNumber,
    :ERModRate,
    :AnnualPremiumAmount,
    :AnnualPayrollAmount,
    :DisablingClaimsAmount,
    :NonDisablingClaimsAmount,
    :ClaimsAmount,
    :DisablingClaimsCount,
    :NonDisablingClaimsCount,
    :ClaimsCount,
    :LossRatio,
    :ClaimFrequency,
    :ClaimValueDate,
    :CreateDate,
    :CreateUser,
    :UpdateDate,
    :UpdateUser,
    :SourceCode,
    :PricingIncludeFlag,
    :AdjustedClaimsAmount,
    :NonDisablingPaidAmount,
    :DisablingPaidAmount,
    :NonDisablingReimburseAmount,
    :TimeLossDaysCount,
    :StandardPremiumAmount
  )

Business rules¶

BR-033: New sequence values for writable entities are obtained

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.Policy.Core\clsPriorCoverage.vb