---
title: "SQL-007: Policy header retrieval"
summary: Retrieve the policy header for a policy number.
status: draft
owner: SAIF Doc Gen
last_reviewed: 2026-07-31
library: SAIF.Business.View.Policy
reference_type: package
---

# SQL-007: Policy header retrieval

`clsPolicyData` uses this call to load the policy header — the identity, status, dates, and flags that every policy view starts from. It is the first database call in the retrieval chain and the object that all other reads in this library hang from.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-007 |
| **Operation type** | Read |
| **Execution method** | Stored procedure |
| **Database** | Oracle |
| **Schema** | `[unqualified]`** |
| **Command type** | StoredProcedure |
| **Business object** | `clsPolicyData` |
| **Criteria property** | `RetrieveSQL` |
| **Lifecycle method** | `BeforeRetrieve` / `AfterRetrieve` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:apolicynum` | Input | Decimal | not specified | Policy number for the header row. |
| `recordset` | Output (Cursor) | REF CURSOR | N/A | Single-row policy header result set. |

## Tables

No table is referenced directly in the .NET source. The tables read by the procedure body reside in the Oracle database and are described under [pk73094_policy_data](../procedures/pk73094_policy_data.md).

## Sample SQL

```sql
-- Stored procedure call (procedure body resides in the Oracle database - WCIS_DBA.pk73094_policy_data)
CALL pk73094_policy_data.getpolicy(
  apolicynum => :apolicynum,
  recordset  => :recordset)  -- REF CURSOR output
```

## Operations and processes

- [Retrieve policy header](../operations/retrieve-policy-header.md)

## Business rules

- [BR-009: A policy view requires a positive policy number](../business-rules.md#br-009-a-policy-view-requires-a-positive-policy-number)

> **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.View.Policy/clsPolicyData.vb`