---
title: "PK72846_VIEW_POLICY stored procedure documentation"
summary: Analysis of Oracle package/procedure including business rules and operations
status: draft
owner: SAIF.Core documentation team
last_reviewed: 2026-09-24
library: SAIF.Data.NHibernate
reference_type: package
source_schema: "WCIS_DBA"
source_name: "PK72846_VIEW_POLICY"
source_type: "PACKAGE"
retrieval_status: "found"
retrieval_command: "legends oracle query --name PK72846_VIEW_POLICY --output analysis/oracle-source/pk72846-view-policy.sql"
retrieval_date: "2026-09-24"
---


# PK72846_VIEW_POLICY

## Overview

| Field | Value |
| --- | --- |
| **Schema** | WCIS_DBA |
| **Type** | Package (function) (database object type: `PACKAGE`) |
| **Database** | Oracle (WCIS) |
| **Calling libraries** | `SAIF.Data.NHibernate` |
| **Calling classes** | PoliciesRepository |

## Purpose

This package implements: SP73111_GET_WCIS_STD_PREMIUM

> **Scope:** `PK72846_VIEW_POLICY` is a large package (34 members). Only the 1 member(s) actually called by SAIF.Data.NHibernate (`sp73111_get_wcis_std_premium`) are reproduced below, extracted from the Legends CLI retrieval's per-member `codeItems`; the full package specification/body is not reproduced in this document. This is a deliberate scoping decision for readability, not a retrieval gap — the full source is available at the retrieval path in Sources.

## Procedures / Methods

### sp73111_get_wcis_std_premium member

| Field | Value |
| --- | --- |
| **Returns** | scalar/function value* |
| **Called by** | SQL-035 (`PoliciesRepository.GetPolicyStandardPremium`) |

No parameters were extracted from the retrieved signature; refer to the Source Code section below*.

## Business Rules

Rules extracted from this procedure's logic:

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| [PROC-RULE-040](../business-rules.md#proc-rule-040-standard-premium-from-the-latest-premium-history-set) | Standard premium from the latest premium-history set | Policy + period effective date | RETURN pk73059_prem_hist_summary.get_standard_premium(get_max_ph_set_id(in_policy_num, in_pol_per_eff_date)) (pk73059 not retrieved**) |
| [PROC-RULE-041](../business-rules.md#proc-rule-041-shared-logic-with-bds) | Shared logic with BDS | Any change | Header comment: changes must be coordinated with BDS |

> These rules are documented in [business-rules.md](../business-rules.md).

## Operations

Operations and processes implemented in this procedure:

| Operation | Description | Trigger |
| --- | --- | --- |
| Get WCIS standard premium | Returns standard premium for a policy period | SQL-035 (`PoliciesRepository.GetPolicyStandardPremium`) |

> These operations are also listed in [operations-processes.md](../operations-processes.md).

## Source Code

<details>
<summary>sp73111_get_wcis_std_premium (function)</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: `WCIS_DBA.PK72846_VIEW_POLICY`
- Legends CLI query executed 2026-09-24: `legends oracle query --name PK72846_VIEW_POLICY --output analysis/oracle-source/pk72846-view-policy.sql`
- Calling code: `Data/SAIF.Data.NHibernate/Mappings/Policies/Policies.hbm.xml`
- Calling code: `Data/SAIF.Data.NHibernate/Repositories/PoliciesRepository.cs`