---
title: "pk72846_view_policy.sp73111_get_wcis_std_premium 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.Audit.Premium
reference_type: package
source_schema: "`WCIS_DBA`"
source_name: "pk72846_view_policy.sp73111_get_wcis_std_premium"
source_type: "Package function"
oracle_status: "found"
---

# pk72846_view_policy.sp73111_get_wcis_std_premium

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Type** | Package function |
| **Database** | Oracle / WCIS |
| **Calling libraries** | `SAIF.Business.Policy.Audit.Premium` |
| **Calling classes** | `clsAuditPolicyPeriod` |

## Purpose

Resolves the newest premium-history set for the policy period and returns its standard premium

## Procedures / Methods

### sp73111_get_wcis_std_premium

| Field | Value |
| --- | --- |
| **Returns** | See Oracle signature / caller behavior |
| **Called by** | `GetCurrentStandardPremium` (SQL-040) |

**Description:** Resolves the newest premium-history set for the policy period and returns its standard premium

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-037 | Standard premium always comes from the *maximum* premium-history set for the policy period | Always | `RETURN pk73059_prem_hist_summary.get_standard_premium(pk73059_prem_hist_summary.get_max_ph_set_id(in_policy_num, in_pol_per_eff_date))` |
| PROC-RULE-038 | The algorithm is duplicated in BDS and must be changed in lockstep | Header comment: "THIS LOGIC IS ALSO USED IN BDS. IF YOU CHANGE THIS YOU MUST CORRODINATE WITH THE BDS TEAM." | Any change requires BDS-team coordination |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Get the WCIS standard premium | Resolves the newest premium-history set for the policy period and returns its standard premium | `clsAuditPolicyPeriod.GetCurrentStandardPremium` (SQL-040); OP-009 |

## Source Code

<details>
<summary>PL/SQL package or method excerpt</summary>

```sql

   FUNCTION sp73111_get_wcis_std_premium
/****************************************************************
*Procedure Title  : Get WCIS Standard Premium
*Name             : SP73111_GET_WCIS_STD_PREMIUM
*Called by        : Business Online
*****************************************************************
* Description: This procedure gets the Standardized Standard Premium
*               based on the 9/8/07 New Standard Premium Project.
*
*               THIS LOGIC IS ALSO USED IN BDS.  IF YOU CHANGE THIS
*               YOU MUST CORRODINATE WITH THE BDS TEAM.
*
*               It gets the max premium history set for the policy
*               and policy period passed in.  It uses the Prem_Summary
*               view to define the correct set.
*
* Maintenance Log:
*   Name            CSR        Date     Description
* John Frey                 09/08/2007  Initial Release
******************************************************************/
   (
      in_policy_num         IN   NUMBER,
      in_pol_per_eff_date   IN   DATE
   )
      RETURN NUMBER
   IS
   BEGIN
      RETURN pk73059_prem_hist_summary.get_standard_premium(
                     pk73059_prem_hist_summary.get_max_ph_set_id(in_policy_num,in_pol_per_eff_date));
   END sp73111_get_wcis_std_premium;

/* Formatted on 4/23/2020 4:26:52 PM (QP5 v5.256.13226.35510) */
```

</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: pk72846_view_policy.sp73111_get_wcis_std_premium
- Calling code: ``analysis\oracle-source\pk72846_view_policy.sql`; `clsAuditPolicyPeriod.vb`