---
title: "pk73059_prem_hist_summary.determine_manual_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: "pk73059_prem_hist_summary.determine_manual_premium"
source_type: "Package function (remote wrapper `@POLDB`)"
oracle_status: "found"
---

# pk73059_prem_hist_summary.determine_manual_premium

## Overview

| Field | Value |
| --- | --- |
| **Schema** | WCIS_DBA |
| **Type** | Package function (remote wrapper `@POLDB`) |
| **Database** | Oracle |
| **Calling libraries** | `SAIF.Business.Policy.Core` |
| **Calling classes** | `WCISInquiry` |

## Purpose

Remote passthrough to POLDB for manual premium

## Procedures / Methods

### determine_manual_premium

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

**Description:** Remote passthrough to POLDB for manual premium

#### Parameters

| Parameter | Direction | Type | Default | Description |
| --- | --- | --- | --- | --- |
| `in_policy_num` | IN | `policy.policy_num%TYPE` | — | Policy number whose manual premium is being determined. |
| `in_policy_period_eff_date` | IN | `policy_period.policy_period_eff_date%TYPE` | — | Policy-period effective date that scopes the premium-history lookup. |

## Business Rules

| Rule ID | Rule | Condition | Action |
| --- | --- | --- | --- |
| PROC-RULE-017 | Manual premium is not computed locally | Always | Delegate to `WCIS_DBA.PK73059_Prem_Hist_Summary.determine_manual_premium@POLDB`; the rule lives in the remote POLDB database - **not documentable from this repository** |

## Operations

| Operation | Description | Trigger |
| --- | --- | --- |
| Determine manual premium | Remote passthrough to POLDB for manual premium | `WCISInquiry.GetManualPremiumAmount` (SQL-110); also called internally by `regional_office_yn` |

## Source Code

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

```sql
FUNCTION determine_manual_premium(
      in_policy_num               IN policy.policy_num%TYPE
    , in_policy_period_eff_date   IN policy_period.policy_period_eff_date%TYPE)
      RETURN NUMBER
   IS

  BEGIN

     RETURN WCIS_DBA.PK73059_Prem_Hist_Summary.determine_manual_premium@POLDB(in_policy_num, in_policy_period_eff_date);

   END  determine_manual_premium;

   /********************************************************************
   | Procedure Title   : Get standard premium for a premium history set.
   | Name              : get_standard_premium
   | Prepared By       : carade
   | Created           : 12/09/2008
   | Modification History
   | ------------------------------------------------------------------
   |
   | Description :
   | Returns the standard premium from a premium history set for a type 1 or 3 set.
   *******************************************************************/
```

</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: pk73059_prem_hist_summary.determine_manual_premium
- `Business\SAIF.Business.Policy.Core\WCISInquiry.vb`