---
title: "SQL-101: Retrieve prior coverage collection"
summary: "Retrieve prior coverage collection"
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Core
reference_type: package
---

# SQL-101: Retrieve prior coverage collection

Retrieve prior coverage collection in the context of `clsPriorCoverageCollection`.

## Classification

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

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:PolicyNum` | Input | bound from `MyCriteria.PolicyNum` | - | Bound in `clsPriorCoverageCollection.BeforeRetrieve` (line 208) |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| [PRIOR_COVERAGE](../database-tables.md#prior_coverage) | SELECT | See sample SQL |

## Sample SQL

```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 = :PolicyNum
```

## Business rules
- [BR-033: New sequence values for writable entities are obtained](../business-rules.md#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\clsPriorCoverageCollection.vb`