---
title: "pk72195_renewal.sp72187_get_standard_prem 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: "WCIS_DBA"
source_name: "pk72195_renewal.sp72187_get_standard_prem"
source_type: "Package function"
oracle_status: "found"
---

# pk72195_renewal.sp72187_get_standard_prem

## Overview

| Field | Value |
| --- | --- |
| **Schema** | WCIS_DBA |
| **Type** | Package function |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `clsPolicyPeriod` |

## Purpose

Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set

## Procedures / Methods

### sp72187_get_standard_prem

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

**Description:** Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `VARCHAR2` | — | Policy number whose premium-history set is being evaluated for standard premium. |
| `in_set_id` | IN | `NUMBER` | — | Premium-history set identifier whose `prem_summary_diff_amount` rows are summed. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-001 | Standard premium is the sum of premium-summary differences up to and including the experience-modification priority | `PREM_HIST_PREM_SUMMARY.prem_hist_set_id = in_set_id` **and** `priority_num <= (select priority_num from PREM_RATING_RULE_PRIORITY where PREM_ADJUSTMENT_TYPE_CODE = 'MOD' and rating_rule_master_id = PREM_HIST_PREM_SUMMARY.rating_rule_master_id)` | Return `SUM(prem_summary_diff_amount)`; adjustments priced *after* the MOD rule are excluded |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Compute WCIS standard premium for a premium-history set | Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set | `clsPolicyPeriod.GetStandardPremium` (SQL-080), after resolving the max set id via `PolicyInformation.MaxPremiumHistorySetId` |

## Source Code

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

```sql
FUNCTION sp72187_get_standard_prem (
      in_policy_num IN VARCHAR2,
      in_set_id IN NUMBER
      )
      RETURN NUMBER
   IS

      v_standard_prem               NUMBER;

   BEGIN

      SELECT SUM (prem_summary_diff_amount)
        INTO v_standard_prem
        FROM PREM_HIST_PREM_SUMMARY
       WHERE prem_hist_set_id = in_set_id
         AND priority_num <=
                ( SELECT priority_num
                    FROM PREM_RATING_RULE_PRIORITY
                   WHERE PREM_ADJUSTMENT_TYPE_CODE = 'MOD'
                     AND rating_rule_master_id =
                            PREM_HIST_PREM_SUMMARY.rating_rule_master_id);

      RETURN  (v_standard_prem);

   END sp72187_get_standard_prem;



   /********************************************************
      * Procedure Title   :
      * Name              : sp72190_calc_weighted_freq
      * Called by         :
      * Prepared By       : Brian Cottings/Clay Andrews
      * Created           : 09/01/98
      * Modification History
      * --------------------------------------------------------
      *
      *********************************************************/
```

</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: pk72195_renewal.sp72187_get_standard_prem
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb`