---
title: "SAIF.Business.Policy.Core 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.Core
reference_type: package
---

# SAIF.Business.Policy.Core stored procedures

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

## Procedure catalog
| Package / Procedure | Schema | Type | Purpose | Calling business objects |
| --- | --- | --- | --- | --- |
| [`pk72195_renewal.sp72187_get_standard_prem`](pk72195-renewal-sp72187-get-standard-prem.md) | WCIS_DBA | Package function | Sums premium-summary difference amounts up to the experience-modification priority for one premium-history set | ``clsPolicyPeriod`` |
| [`pk72195_renewal.sp72190_calc_weighted_freq`](pk72195-renewal-sp72190-calc-weighted-freq.md) | WCIS_DBA | Package function (remote wrapper `@POLDB`) | Remote passthrough to POLDB for renewal weighted-frequency calculation | ``clsPolicyPeriod`` |
| [`pk72226_team_assignment.regional_office_yn`](pk72226-team-assignment-regional-office-yn.md) | WCIS_DBA | Package function | Applies four ordered tests (premium threshold, temp agency, FELA/Maritime jurisdiction, entity 50) to decide regional-office handling | ``WCISInquiry`` |
| [`pk72846_view_policy.sp73111_get_wcis_std_premium`](pk72846-view-policy-sp73111-get-wcis-std-premium.md) | WCIS_DBA | Package function | Resolves the latest premium-history set for the period and returns its standard premium | ``clsPolicyPeriodBase`` |
| [`pk72899_production_error.sp72900_post_production_error`](pk72899-production-error-sp72900-post-production-error.md) | WCIS_DBA | Package procedure (autonomous transaction) | Writes a module/error row in an autonomous transaction so the log survives caller rollback | ``clsWCISInterfacer`` |
| [`pk73057_billing_master.bm_report_schedule_flag_yn`](pk73057-billing-master-bm-report-schedule-flag-yn.md) | WCIS_DBA | Package function | Walks billing master → billing defaults → payment-plan type to read the payroll-report-schedule flag | ``clsPolicyPeriodBase`` |
| [`pk73057_billing_master.is_on_arrears_plan`](pk73057-billing-master-is-on-arrears-plan.md) | WCIS_DBA | Package function | Same join path; classifies the plan as arrears unless it generates instalments or prepayments | ``clsPolicyPeriodBase`` |
| [`pk73059_prem_hist_summary.determine_manual_premium`](pk73059-prem-hist-summary-determine-manual-premium.md) | WCIS_DBA | Package function (remote wrapper `@POLDB`) | Remote passthrough to POLDB for manual premium | ``WCISInquiry`` |
| [`pk73059_prem_hist_summary.get_6_digit_gov_class`](pk73059-prem-hist-summary-get-6-digit-gov-class.md) | WCIS_DBA | Package procedure (OUT parameter) | Picks the manual class with the greatest summed payroll in the latest premium-history set, excluding clerical/sales/drivers, with two fallback passes | ``clsPolicyPeriod`` |
| [`pk73190_quoteprint.Get_Billing_Master_Count`](pk73190-quoteprint-get-billing-master-count.md) | WCIS_DBA | Package function (remote wrapper `@POLDB`) | Remote count wrapper used to decide whether billing data exists for a quote | ``WCISInquiry`` |
| [`pk73190_quoteprint.Get_Premium_History_Count`](pk73190-quoteprint-get-premium-history-count.md) | WCIS_DBA | Package function (remote wrapper `@POLDB`) | Remote count wrapper used to decide whether premium history exists for a quote | ``WCISInquiry`` |
| [`pk73190_quoteprint.Get_Rating_Plan_Count`](pk73190-quoteprint-get-rating-plan-count.md) | WCIS_DBA | Package function (remote wrapper `@POLDB`) | Remote count wrapper used to decide whether rating plans exist for a quote | ``WCISInquiry`` |
| [`SP72347_INFO_PAGE_PRINTED_YN`](sp72347-info-page-printed-yn.md) | *(unqualified; standalone)* | Standalone function (wrapper for `sp72253_info_page_printed`) | Character wrapper over the boolean `sp72253_info_page_printed` | ``WCISInquiry`` |
| [`SP72658_GET_GOV_CLASS`](sp72658-get-gov-class.md) | *(unqualified; standalone)* | Standalone function (wrapper for `pk62030_rating.SP62022_Get_Gov_Class`) | Calls the rating package and returns only the governing class, discarding the minimum premium | ``clsPolicyPeriod`` |
| [`Sp72803_Edit_Prelim_Audit`](sp72803-edit-prelim-audit.md) | *(unqualified; standalone)* | Standalone procedure (remote wrapper `wcis_dba.…@PolDB`) | Remote edit that sets an `IN OUT` flag indicating whether a preliminary audit is required | ``WCISInquiry`` |
| [`sp72814_get_cont_cov_date`](sp72814-get-cont-cov-date.md) | *(unqualified; standalone)* | Standalone function | Finds the most recent break in the policy-period chain and in the explicit coverage-gap table, then picks the appropriate resumption date | ``WCISInquiry``, ``clsPolicy`` |
| [`SP73029_GET_NONWCIS_GOV_CLASS`](sp73029-get-nonwcis-gov-class.md) | *(unqualified; standalone)* | Standalone function | Same payroll-contest algorithm as the WCIS version but over legacy class-coverage tables and truncated to four digits | ``clsLegacyPolicyPeriod`` |
| [`sp73089_get_policy_bound_flag`](sp73089-get-policy-bound-flag.md) | *(unqualified; standalone)* | Standalone function (wrapper for `sp72325_chk_if_policy_bound`) | Character wrapper over the boolean `sp72325_chk_if_policy_bound` | ``clsPolicyPeriod`` |

## Related documentation
- [Index](../index.md)
- [Business rules](../business-rules.md)
- [Operations and processes](../operations-processes.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)
- [Configuration](../configuration.md)
- [API reference](../api/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
- `Business\SAIF.Business.Policy.Core\clsPolicy.vb`
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriod.vb`
- `Business\SAIF.Business.Policy.Core\clsPolicyPeriodBase.vb`
- `Business\SAIF.Business.Policy.Core\WCISInquiry.vb`
- `Business\SAIF.Business.Policy.Core\clsWCISInterfacer.vb`
- Oracle DBA_SOURCE for the referenced objects