---
title: "SP72658_GET_GOV_CLASS stored procedure documentation"
summary: "Analysis of Oracle package/procedure including business rules and operations."
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Core
reference_type: package
source_schema: "*(unqualified; standalone)*"
source_name: "SP72658_GET_GOV_CLASS"
source_type: "Standalone function (wrapper for `pk62030_rating.SP62022_Get_Gov_Class`)"
oracle_status: "found"
---

# SP72658_GET_GOV_CLASS

## Overview

| Field | Value |
| --- | --- |
| **Schema** | *(unqualified; standalone)* |
| **Type** | Standalone function (wrapper for `pk62030_rating.SP62022_Get_Gov_Class`) |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `clsPolicyPeriod` |

## Purpose

Calls the rating package and returns only the governing class, discarding the minimum premium

## Procedures / Methods

### SP72658_GET_GOV_CLASS

| Field | Value |
| --- | --- |
| **Returns** | See PL/SQL source below. |
| **Called by** | `clsPolicyPeriod` |

**Description:** Calls the rating package and returns only the governing class, discarding the minimum premium

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number whose governing class is being returned. |
| `in_pol_per_eff_date` | IN | `DATE` | — | Policy-period effective date used to select the governing class row. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-025 | The WCIS governing class is delegated to the rating package; the minimum premium it also returns is discarded | Always | Call `pk62030_rating.SP62022_Get_Gov_Class(policy, eff_date, v_dummy_1, v_gov_class)` and return only `v_gov_class` |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Retrieve the WCIS governing class | Calls the rating package and returns only the governing class, discarding the minimum premium | `clsPolicyPeriod.GetGoverningClass` (SQL-079) |

## Source Code

<details>
<summary>PL/SQL source</summary>

```sql
FUNCTION SP72658_GET_GOV_CLASS
/****************************************************************
*Procedure Title  : Get Governing Class
*Name             : SP72658_GET_GOV_CLASS
*Called by        : Premium Audit (PowerBuilder)
*****************************************************************
* Description:	Enables PowerBuilder to call a stored procedure
*               in the Oracle package to get the governing class
*               for a policy period.
* Maintenance Log:
*   Name            CSR        Date     Description
* Lance Petersen            07/08/2002  Initial Release
*
* carade                    12/07/2009  Trackit project 1626 (variable minimum)
* Renamed sp62022 and removed minimum premium as an out variable.

******************************************************************/
  (in_policy_num        IN      NUMBER,
   in_pol_per_eff_date  IN      DATE)

RETURN VARCHAR2
IS

  v_dummy_1 NUMBER;
  v_dummy_2 NUMBER;
  v_gov_class VARCHAR(6);

BEGIN

   pk62030_rating.SP62022_Get_Gov_Class
             (in_policy_num,
              in_pol_per_eff_date,
              v_dummy_1,
              v_gov_class);

  RETURN v_gov_class;

END  ;
```

</details>

## Related Documentation
- [Procedure catalog](index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)

> **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
- Oracle DBA_SOURCE: SP72658_GET_GOV_CLASS
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb`