---
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.Core
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 |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `clsPolicyPeriodBase` |

## Purpose

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

## Procedures / Methods

### sp73111_get_wcis_std_premium

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

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

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `NUMBER` | — | Policy number whose WCIS standard premium is being resolved. |
| `in_pol_per_eff_date` | IN | `DATE` | — | Policy-period effective date used to find the latest premium-history set for the period. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-008 | WCIS standard premium is always taken from the **latest** premium-history set for the policy period | Always | Return `pk73059_prem_hist_summary.get_standard_premium(get_max_ph_set_id(policy, eff_date))` |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Retrieve standardised WCIS standard premium | Resolves the latest premium-history set for the period and returns its standard premium | `clsPolicyPeriodBase.GetWCISStandardPremium` (SQL-085), for WCIS-financial-system periods |

## Source Code

<details>
<summary>PL/SQL source</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
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb`