---
title: "SQL-019: Resolve manual class and filing through stored procedure"
summary: Resolve manual class and filing through stored procedure
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Rating
reference_type: package
---

# SQL-019: Resolve manual class and filing through stored procedure

This document records the SQL used by `clsManualClassBase` in `SAIF.Business.Policy.Rating`.

## Classification

| Field | Value |
| --- | --- |
| **SQL ID** | SQL-019 |
| **Operation type** | Read |
| **Execution method** | Application method — stored procedure |
| **Database** | Oracle |
| **Schema** | N/A |
| **Command type** | StoredProcedure |
| **Business object** | `clsManualClassBase` |
| **Criteria property** | `N/A — non-Criteria method` |
| **Lifecycle method** | `GetManualClassBaseKey` |

## Parameters

| Parameter | Direction | Type | Max length | Description |
| --- | --- | --- | --- | --- |
| `:io_class_num` | Input | Not specified | not specified | Bound parameter. |
| `:in_class_eff_date` | Input | Not specified | not specified | Bound parameter. |
| `:in_ard` | Input | Not specified | not specified | Bound parameter. |
| `:in_risk_type_code` | Input | Not specified | not specified | Bound parameter. |
| `:in_policy_period_eff_date` | Input | Not specified | not specified | Bound parameter. |
| `:in_policy_period_exp_date` | Input | Not specified | not specified | Bound parameter. |
| `:in_ard_extension_flag` | Input | Not specified | not specified | Bound parameter. |
| `:io_rate` | Input | Not specified | not specified | Bound parameter. |
| `:io_descr` | Input | Not specified | not specified | Bound parameter. |
| `:io_rate_file_seq` | Input | Not specified | not specified | Bound parameter. |
| `:io_exposure_base` | Input | Not specified | not specified | Bound parameter. |

## Tables

| Table | Access | Columns used |
| --- | --- | --- |
| N/A | N/A | N/A |

## Sample SQL

```sql
pk73059_prem_hist_summary.sp62005_retrieve_rate(
  :io_class_num,
  :in_class_eff_date,
  :in_ard,
  :in_risk_type_code,
  :in_policy_period_eff_date,
  :in_policy_period_exp_date,
  :in_ard_extension_flag,
  :io_rate,
  :io_descr,
  :io_rate_file_seq,
  :io_exposure_base
)
```

## Operations and processes
- [Resolve a manual class key (rate lookup)](../operations/resolve-a-manual-class-key-rate-lookup.md)

## Business rules
- [BR-013](../business-rules.md#br-013-the-rate-file-sequence-number-returned-by-the-rate-retrieval-procedure-is-applied-only-when-it-is-not-dbnull)
- [BR-014](../business-rules.md#br-014-the-rate-retrieval-procedure-may-return-a-replaced-manual-class-number-when-the-returned-class-number-is-not-dbnull-it-overwrites-the-callers-value)

## Sources
- `Business\SAIF.Business.Policy.Rating\clsManualClassBase.vb:1225-1268`