SQL-100: Retrieve prior coverage¶

Retrieve prior coverage in the context of clsPriorCoverage.

Classification¶

Field	Value
SQL ID	SQL-100
Operation type	Read
Execution method	IDataRequest.SQLStatement (CommandType.Text)
Database	Oracle
Schema	[unqualified]**
Command type	Text
Business object	`clsPriorCoverage`
Criteria property	`RetrieveSQL`
Lifecycle method	`BeforeRetrieve / AfterRetrieve`

Parameters¶

Parameter	Direction	Type	Max length	Description
`:PolicyNumber`	Input	bound from `MyCriteria.PolicyNumber`	-	Bound in `clsPriorCoverage.BeforeRetrieve` (line 611)
`:EffectiveDate`	Input	bound from `MyCriteria.EffectiveDate`	-	Bound in `clsPriorCoverage.BeforeRetrieve` (line 612)

Tables¶

Table	Access	Columns used
PRIOR_COVERAGE	SELECT	See sample SQL

Sample SQL¶

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

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