---
title: SAIF.Business.Policy.Premium stored procedures
summary: Oracle stored procedures and packages referenced by this library.
status: draft
owner: Technical Writer
last_reviewed: 2026-07-31
library: SAIF.Business.Policy.Premium
reference_type: package
---

# SAIF.Business.Policy.Premium stored procedures

This page catalogs Oracle stored procedures and PL/SQL packages invoked by this library.

## Procedure catalog

| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`pk72195_renewal`](pk72195-renewal.md) | WCIS_DBA | Package | Given a premium history set's total MAN-type premium adjustment, recompute what that manual premium would be under a different rate tier, using the ratio of the two tiers' rate factors. | clsPremiumSet (GetRecalcModifiedPremiumOnSpecifiedTier) |
| [`pk73059_prem_hist_summary`](pk73059-prem-hist-summary.md) | WCIS_DBA | Package | Sum the reported (flagged) payroll for a class coverage line across its adjusted-rate-class detail rows. | clsClassCoverage (inline call in GetRetreiveSql) |
| [`sp72652_get_saifplus`](sp72652-get-saifplus.md) | WCIS_DBA | Procedure (thin wrapper) | Oracle helper logic referenced by this library. | clsPremiumSummaryAdjustment (GetSAIFPlusInfo) |
| [`sp72151_determine_ncci_stat`](sp72151-determine-ncci-stat.md) | WCIS_DBA | Function | Oracle helper logic referenced by this library. | clsPremiumSummaryAdjustment (GetStatClassNumber) |

## Related documentation
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources
- `Business\SAIF.Business.Policy.Premium\clsPremiumSet.vb`
- `Business\SAIF.Business.Policy.Premium\clsClassCoverage.vb`
- `Business\SAIF.Business.Policy.Premium\clsPremiumSummaryAdjustment.vb`
- Oracle DBA_SOURCE for the referenced objects